Fetching the paper…
Reading the bibliography…
Query rewriting is an effective technique for refining poorly written queries before they reach the query optimizer.
Rule-based query optimization in extensible database systems
Goetz Graefe. 1987 · 1987
Earlier work this paper cites.
Improved unnesting algorithms for join aggregate SQL queries. In VLDB , Vol. 92. Citeseer, 91–102
M Muralikrishna et al · 1992
Earlier work this paper cites.
Extensible/rule based query rewrite optimization in Starburst
Hamid Pirahesh, Joseph M Hellerstein, and Waqar Hasan. 1992 · 1992
Earlier work this paper cites.
Cost-based optimization for magic: Algebra and implementation. In Proceedings of the 1996 ACM SIGMOD international conference on Management of data . 435–446
Praveen Seshadri, Joseph M Hellerstein, Hamid Pirahesh, TY Cliff Leung, Raghu Ramakrishnan, Divesh Srivastava, Peter J Stuckey, and S Sudarshan. 1996 · 1996
Earlier work this paper cites.
Query optimization by predicate move-around
Alon Yitzchak Levy and Inderpal Singh Mumick. 1997 · 1997
Earlier work this paper cites.
Cost-based query transformation in Oracle. In VLDB , Vol. 6. 1026–1036
Rafi Ahmed, Allison Lee, Andrew Witkowski, Dinesh Das, Hong Su, Mohamed Zait, and Thierry Cruanes. 2006 · 2006
Earlier work this paper cites.
What is bigquery?. In Proceedings of the 19th International Database Engineering & Applications Symposium . 202–203
Sérgio Fernandes and Jorge Bernardino. 2015 · 2015
Earlier work this paper cites.
How good are query optimizers, really?
Viktor Leis, Andrey Gubichev, Atanas Mirchev, Peter Boncz, Alfons Kemper, and Thomas Neumann. 2015 · 2015
Earlier work this paper cites.
The snowflake elastic data warehouse. In Proceedings of the 2016 International Conference on Management of Data . 215–226
Benoit Dageville, Thierry Cruanes, Marcin Zukowski, Vadim Antonov, Artin Avanes, Jon Bock, Jonathan Claybaugh, Daniel Engovatov, Martin Hentschel, Jiansheng Huang, et al · 2016
Earlier work this paper cites.
Apache calcite: A foundational framework for optimized query processing over heterogeneous data sources. In Proceedings of the 2018 International Conference on Management of Data . 221–230
Edmon Begoli, Jesús Camacho-Rodríguez, Julian Hyde, Michael J Mior, and Daniel Lemire. 2018 · 2018
Earlier work this paper cites.
Selecting subexpressions to materialize at datacenter scale
Alekh Jindal, Konstantinos Karanasos, Sriram Rao, and Hiren Patel. 2018 · 2018
Earlier work this paper cites.
Incorporating super-operators in big-data query optimizers
Jyoti Leeka and Kaushik Rajan. 2019 · 2019
Earlier work this paper cites.
Generalized { \{ Sub-Query } \} Fusion for Eliminating Redundant { \{ I/O } \} from { \{ Big-Data } \} Queries. In 14th USENIX Symposium on Operating Systems Design and Implementation (OSDI 20) . 209–224
Partho Sarthi, Kaushik Rajan, Akash Lal, Abhishek Modi, Prakhar Jain, Mo Liu, Ashit Gosalia, and Saurabh Kalikar. 2020 · 2020
Earlier work this paper cites.
New query optimization techniques in the spark engine of azure synapse
Abhishek Modi, Kaushik Rajan, Srinivas Thimmaiah, Prakhar Jain, Swinky Mann, Ayushi Agarwal, Ajith Shetty, Shahid K I, Ashit Gosalia, and Partho Sarthi. 2021 · 2021
Earlier work this paper cites.
A learned query rewrite system using monte carlo tree search
Xuanhe Zhou, Guoliang Li, Chengliang Chai, and Jianhua Feng. 2021 · 2021
Cited alongside, same era.
Computation reuse via fusion in Amazon Athena. In 2022 IEEE 38th International Conference on Data Engineering (ICDE) . IEEE, 1610–1620
Nicolas Bruno, Johnny Debrodt, Chujun Song, and Wei Zheng. 2022 · 2022
Cited alongside, same era.
Can foundation models wrangle your data?
Avanika Narayan, Ines Chami, Laurel Orr, Simran Arora, and Christopher Ré. 2022 · 2022
Cited alongside, same era.
Annotating columns with pre-trained language models. In Proceedings of the 2022 International Conference on Management of Data . 1493–1503
Yoshihiko Suhara, Jinfeng Li, Yuliang Li, Dan Zhang, Çağatay Demiralp, Chen Chen, and Wang-Chiew Tan. 2022 · 2022
Cited alongside, same era.
DB-BERT: a Database Tuning Tool that" Reads the Manual". In Proceedings of the 2022 international conference on management of data . 190–203
DB-GPT: Large Language Model Meets Database
Guoliang Li Xuanhe Zhou, Zhaoyan Sun. 2023 · 2023
Later among the works it cites.
Llm-sql-solver: Can llms determine SQL equivalence?
Fuheng Zhao, Lawrence Lim, Ishtiyaque Ahmad, Divyakant Agrawal, and Amr El Abbadi. 2023 · 2023
Later among the works it cites.
D-bot: Database diagnosis system using large language models
Xuanhe Zhou, Guoliang Li, Zhaoyan Sun, Zhiyuan Liu, Weize Chen, Jianming Wu, Jiesi Liu, Ruohang Feng, and Guoyang Zeng. 2023 · 2023
Later among the works it cites.
LLM-R2: A Large Language Model Enhanced Rule-based Rewrite System for Boosting Query Efficiency
Zhaodonghui Li, Haitao Yuan, Huiming Wang, Gao Cong, and Lidong Bing. 2024 · 2024
Closest in time.
alphaXiv searches the wider corpus for related work and actual follow-ups.
alphaXiv is searching for related work…
Immanuel Trummer. 2022 · 2022
Cited alongside, same era.
Wetune: Automatic discovery and verification of query rewrite rules. In Proceedings of the 2022 International Conference on Management of Data . 94–107
Zhaoguo Wang, Zhou Zhou, Yicun Yang, Haoran Ding, Gansen Hu, Ding Ding, Chuzhe Tang, Haibo Chen, and Jinyang Li. 2022 · 2022
Cited alongside, same era.
Proving Query Equivalence Using Linear Integer Arithmetic
Haoran Ding, Zhaoguo Wang, Yicun Yang, Dexin Zhang, Zhenglin Xu, Haibo Chen, Ruzica Piskac, and Jinyang Li. 2023 · 2023
Cited alongside, same era.
SlabCity: Whole-Query Optimization Using Program Synthesis
Rui Dong, Jie Liu, Yuxuan Zhu, Cong Yan, Barzan Mozafari, and Xinyu Wang. 2023 · 2023
Cited alongside, same era.
CatSQL: Towards Real World Natural Language to SQL Applications
Han Fu, Chang Liu, Bin Wu, Feifei Li, Jian Tan, and Jianling Sun. 2023 · 2023
Cited alongside, same era.
Text-to-SQL Empowered by Large Language Models: A Benchmark Evaluation. CoRR abs/2308.15363 (2023)
Dawei Gao, Haibin Wang, Yaliang Li, Xiuyu Sun, Yichen Qian, Bolin Ding, and Jingren Zhou. 2023 · 2023
Cited alongside, same era.
A survey on deep learning approaches for text-to-SQL
George Katsogiannis-Meimarakis and Georgia Koutrika. 2023 · 2023
Cited alongside, same era.
Can llm already serve as a database interface? a big bench for large-scale database grounded text-to-sqls
Jinyang Li, Binyuan Hui, Ge Qu, Jiaxi Yang, Binhua Li, Bowen Li, Bailin Wang, Bowen Qin, Ruiying Geng, Nan Huo, et al · 2023
Cited alongside, same era.
Weizheng Lu, Jiaming Zhang, Jing Zhang, and Yueguo Chen. 2024 · 2024
Closest in time.
Schema matching with large language models: an experimental study (2024)
Marcel Parciak, Brecht Vandevoort, Frank Neven, Liesbet M Peeters, and Stijn Vansummeren. [n. d.] · 2024
Closest in time.
Din-sql: Decomposed in-context learning of text-to-sql with self-correction
Mohammadreza Pourreza and Davood Rafiei. 2024 · 2024
Closest in time.
R-bot: An llm-based query rewrite system
Zhaoyan Sun, Xuanhe Zhou, and Guoliang Li. 2024 · 2024
Closest in time.
D-Bot: Database Diagnosis System using Large Language Models
Xuanhe Zhou, Guoliang Li, Zhaoyan Sun, Zhiyuan Liu, Weize Chen, Jianming Wu, Jiesi Liu, Ruohang Feng, and Guoyang Zeng. 2024 · 2024
Closest in time.
Sriram Dharwada, Himanshu Devrani, Jayant Haritsa, and Harish Doraiswamy. 2025a · 2025
Closest in time.
SQLStorm: Taking Database Benchmarking into the LLM Era
Tobias Schmidt, Viktor Leis, Peter Boncz, and Thomas Neumann. 2025 · 2025
Closest in time.
QUITE: A Query Rewrite System Beyond Rules with LLM Agents
Yuyang Song, Hanxu Yan, Jiale Lao, Yibo Wang, Yufei Li, Yuanchun Zhou, Jianguo Wang, and Mingjie Tang. 2025 · 2025
Closest in time.
Text-to-SQL Domain Adaptation via Human-LLM Collaborative Data Annotation. In Proceedings of the 30th International Conference on Intelligent User Interfaces . 1398–1425
Yuan Tian, Daniel Lee, Fei Wu, Tung Mai, Kun Qian, Siddhartha Sahai, Tianyi Zhang, and Yunyao Li. 2025 · 2025
Closest in time.