DBScholar

Back to papers

AI Meets AI: Leveraging Query Executions to Improve Index Recommendations

Summary: Replaces optimizer-cost plan comparison in index tuning with an ML classifier predicting cheaper plans across configs. Integrates with advanced tuners, delivering up to 5x fewer errors on benchmarks and real workloads, reducing cost regressions. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
hc46501f01faf95e4
Venue
SIGMOD
Year
2019
Pagerank
0.00011197535
Overall Rank
1,282 | 91.41%
DOI
10.1145/3299869.3324957

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@inproceedings{ding_sigmod19,
        title = {{AI Meets AI: Leveraging Query Executions to Improve Index Recommendations}},
        author = {Ding, Bailu and Das, Sudipto and Marcus, Ryan and Wu, Wentao and Chaudhuri, Surajit and Narasayya, Vivek R.},
        series = {{SIGMOD} '19},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/3299869.3324957},
        url = {https://dl.acm.org/doi/10.1145/3299869.3324957},
        year = {2019}
}

Incoming Citations (Sorted by Pagerank)

Showing 9 of 59 citing papers.

Previous Page 2 / 2 Next

Outgoing Citations (Sorted by Pagerank)

Showing 34 of 34 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Rank Cited Paper Year Venue Pagerank
15 How Good Are Query Optimizers, Really? 2016 VLDB 0.00061463175
40 The Case for Learned Index Structures 2018 SIGMOD 0.00046249672
74 Automatic Database Management System Tuning Through Large-scale Machine Learning 2017 SIGMOD 0.00037164008
98 LEO - DB2's LEarning Optimizer 2001 VLDB 0.00034050614
122 Schism: a Workload-Driven Approach to Database Replication and Partitioning 2010 VLDB 0.00030701814
151 An Efficient, Cost-Driven Index Selection Tool for Microsoft SQL Server 1997 VLDB 0.00028611216
189 DB2 Design Advisor: Integrated Automatic Physical Database Design 2004 VLDB 0.00025846085
196 Integrating Vertical and Horizontal Partitioning into Automated Physical Database Design 2004 SIGMOD 0.00025581936
224 Self-Driving Database Management Systems 2017 CIDR 0.00023973185
234 Adaptive Selectivity Estimation Using Query Feedback 1994 SIGMOD 0.00023726296
243 Automating Physical Database Design in a Parallel Database 2002 SIGMOD 0.00023296011
253 Database Cracking 2007 CIDR 0.00023037921
259 An Overview of Query Optimization in Relational Systems 1998 PODS 0.00022881075
380 AutoAdmin "What-if" Index Analysis Utility 1998 SIGMOD 0.00019530546
493 Database Tuning Advisor for Microsoft SQL Server 2005 2004 VLDB 0.0001735831
496 Adaptive Self-Tuning Memory in DB2 2006 VLDB 0.00017347275
532 Automatic SQL Tuning in Oracle 10g 2004 VLDB 0.0001681305
628 Performance Prediction for Concurrent Database Workloads 2011 SIGMOD 0.00015421836
676 Robust Estimation of Resource Consumption for SQL Queries using Statistical Techniques 2012 VLDB 0.00014838681
775 Self-tuning Database Technology and Information Services: from Wishful Thinking to Viable Engineering 2002 VLDB 0.00014062388
1,188 Bridging the Archipelago between Row-Stores and Column-Stores for Hybrid Workloads 2016 SIGMOD 0.00011580449
1,261 Sampling-Based Query Re-Optimization 2016 SIGMOD 0.00011289724
1,383 H2O: A Hands-free Adaptive Store 2014 SIGMOD 0.00010826996
1,517 Automatically Indexing Millions of Databases in Microsoft Azure SQL Database 2019 SIGMOD 0.00010385462
1,611 The Data Calculator*: Data Structure Design and Cost Synthesis from First Principles and Learned Cost Models 2018 SIGMOD 0.00010066379
1,823 CoPhy: A Scalable, Portable, and Interactive Index Advisor for Large Workloads 2011 VLDB 9.5457638e-05
1,846 Merging What's Cracked, Cracking What's Merged: Adaptive Indexing in Main-Memory Column-Stores 2011 VLDB 9.5057831e-05
2,423 Goal-Oriented Buffer Management Revisited* 1996 SIGMOD 8.4781834e-05
2,784 Automatic Physical Design Tuning: Workload as a Sequence 2006 SIGMOD 8.0021123e-05
2,888 Query Optimizers: Time to Rethink the Contract? 2009 SIGMOD 7.8895201e-05
3,606 Access Path Selection in Main-Memory Optimized Data Systems: Should I Scan or Should I Probe? 2017 SIGMOD 7.1528863e-05
4,701 Columnstore and B+ tree – Are Hybrid Physical Designs Important? 2018 SIGMOD 6.44638e-05
5,490 A Pay-As-You-Go Framework for Query Execution Feedback 2008 VLDB 6.0970166e-05
7,094 Plan Stitch: Harnessing the Best of Many Plans 2018 VLDB 5.5863735e-05
Previous Page 1 / 1 Next

Semantically Similar Papers