• Login
    View Item 
    •   eScholar Home
    • Faculty of Science
    • Master Theses & Projects
    • View Item
    •   eScholar Home
    • Faculty of Science
    • Master Theses & Projects
    • View Item
    JavaScript is disabled for your browser. Some features of this site may not work without it.

    Galo: guided automated learning for query workload re-optimization

    Thumbnail
    View/Open
    Fetter_Damasio_Guilherme.pdf (1.021Mb)
    Date
    2018-12-01
    Author
    Fetter Damasio, Guilherme
    Metadata
    Show full item record
    Abstract
    Traditional query optimization techniques often fail when logical subtleties in business queries and schemas circumvent them. Query performance problem determination is typically performed manually in consultation with experts through the analysis of query execution plans (QEPs). Galo, a novel graph-based system, is presented in this work. Galo's knowledge base is built on RDF and SPARQL, W3C graph database standards, which is well suited for manipulating and querying over SQL query plans, which are graphs themselves. Galo acts as a third-tier of optimization, after query rewrite and cost-based optimization, as a query-plan rewrite. Galo's knowledge base is also an invaluable tool for database experts to debug query performance issues by tracking to known issues/solutions and refine optimizer with new and better tuned techniques by the development team. An experimental study of the effectiveness of the developed techniques is demonstrated over a synthetic query workload.
    URI
    https://hdl.handle.net/10155/1002
    Collections
    • Electronic Theses and Dissertations [1336]
    • Master Theses & Projects [294]

    DSpace software copyright © 2002-2016  DuraSpace
    Contact Us | Send Feedback
    Theme by 
    Atmire NV
     

     

    Browse

    All of eScholarCommunities & CollectionsBy Issue DateAuthorsTitlesSubjectsThis CollectionBy Issue DateAuthorsTitlesSubjects

    My Account

    LoginRegister

    DSpace software copyright © 2002-2016  DuraSpace
    Contact Us | Send Feedback
    Theme by 
    Atmire NV