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"”.
-
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 …
-
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.
-
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 …
-
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 …
-
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 …
-
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 …
-
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 …