QueryBooster: Improving SQL Performance Using Middleware Services for Human-Centered Query Rewriting
Qiushi Bai, Sadeem Alsudais, Chen Li

TL;DR
QueryBooster is a middleware system that enables users to express and generate SQL query rewriting rules using an intuitive language, significantly enhancing query performance through human-centered customization.
Contribution
It introduces a middleware architecture with VarSQL, a rule language, and an automatic rule generalization method, allowing flexible, user-driven SQL query rewriting.
Findings
User study confirms VarSQL's expressiveness.
Experiments show improved query performance.
Rule suggestion framework is effective.
Abstract
SQL query performance is critical in database applications, and query rewriting is a technique that transforms an original query into an equivalent query with a better performance. In a wide range of database-supported systems, there is a unique problem where both the application and database layer are black boxes, and the developers need to use their knowledge about the data and domain to rewrite queries sent from the application to the database for better performance. Unfortunately, existing solutions do not give the users enough freedom to express their rewriting needs. To address this problem, we propose QueryBooster, a novel middleware-based service architecture for human-centered query rewriting, where users can use its expressive and easy-to-use rule language (called VarSQL) to formulate rewriting rules based on their needs. It also allows users to express rewriting intentions by…
Peer Reviews
No public reviews on file for this paper yet. If you reviewed it on a platform where reviews are public (OpenReview, ICLR, NeurIPS, ICML), you can paste yours below so the community can read it here.
Code & Models
Videos
No videos yet. Explain this paper in a talk, walkthrough, or lecture? Add one.
Taxonomy
TopicsAdvanced Database Systems and Queries · Distributed systems and fault tolerance · Scientific Computing and Data Management
