Global ETD Search

Search theses and dissertations gathered from participating repositories worldwide. Every result links back to the library that holds it. No account is needed.

Results

Showing 1 to 7 of 7 for “"query rewrite"”.

  1. Galo: guided automated learning for query workload re-optimization

    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 …

    uoit Repository record for Galo: guided automated learning for query workload re-optimization (opens in a new tab)

  2. Guiding Expert Database Tuning with Explainable AI

    … configuration parameter adjustment, and query rewrite. We demonstrate the ability of GEX to capture and communicate optimizer behaviour through experimental evaluation in these tasks using the TPC-DS benchmark and IBM Db2.

    york Repository record for Guiding Expert Database Tuning with Explainable AI (opens in a new tab)

  3. Expressive And Scalable Event Stream Processing

    … an expressive event algebra and a set of novel query optimization techniques. Second, we describe a rule-based Multi-Query Optimization framework, which generalizes Cayuga, unifies large-scale stream processing and event processing, and provides a platform for integrating future query rewrite …

    cornell Repository record for Expressive And Scalable Event Stream Processing (opens in a new tab)

  4. DQN-Guided Rule-Class Selection for Search-Based Query Rewriting

    Query rewrite transforms a SQL query into a semantically equivalent form expected to execute more efficiently. Search-based rewriters such as LearnedRewrite organize alternative rewrite orders as a policy tree and explore it with Monte Carlo Tree Search. In the publicly released LearnedRewrite …

    ottawa-retro Repository record for DQN-Guided Rule-Class Selection for Search-Based Query Rewriting (opens in a new tab)

  5. Automatic Scaling Iterative Computations

    … as iterative spatial joins and distributing this query plan into a cluster of machines. We use various query optimization techniques such as query rewrite and indexing to boost the singlemachine performance of the program. More importantly, we leverage the spatial locality properties of the …

    cornell Repository record for Automatic Scaling Iterative Computations (opens in a new tab)

  6. Understanding and Improving Database-Backed Applications

    … based on how the application tier consumes the query result; and 2) CONSTROPT, a query rewrite optimizer that performs query optimization by leveraging the data constraint inferred from the application code. On the application tier, I present 3) QURO, a query reorder compiler that changes the …

    washington Repository record for Understanding and Improving Database-Backed Applications (opens in a new tab)

  7. Conjunctive Queries with Negations: Bridging Theory and Practice

    Antijoin, given its significant expressive power, has numerous applications in relational data analytics. Notwithstanding its importance, there remains great research potential in antijoin processing. In practical database systems, existing techniques to process antijoins are still considered …

    waterloo Repository record for Conjunctive Queries with Negations: Bridging Theory and Practice (opens in a new tab)