DBScholar

Back to papers

PilotScope: Steering Databases with Machine Learning Drivers

Summary: PilotScope is middleware for deploying AI4DB algorithms, separating ML-centric AI4DB drivers from engine-specific database interactors. This abstraction lowers integration cost and enables portable, cross-database benchmarking of tuning and optimization techniques. (summarized by gpt-5.6-luna on Jul 24 2026)

Paper ID
h55157da4d1966a28
Venue
VLDB
Year
2024
Pagerank
6.0090633e-05
Overall Rank
5,713 | 61.71%
DOI
10.14778/3641204.3641209
PDF
Download (CC BY-NC-ND 4.0)

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@article{zhu_vldb24,
        title = {{PilotScope: Steering Databases with Machine Learning Drivers}},
        author = {Zhu, Rong and Weng, Lianggui and Wei, Wenqing and Wu, Di and Peng, Jiazhen and Wang, Yifan and Ding, Bolin and Lian, Defu and Zheng, Bolong and Zhou, Jingren},
        journal = {PVLDB},
        series = {{VLDB} '24},
        volume = {17},
        number = {5},
        pages = {980--993},
        doi = {10.14778/3641204.3641209},
        url = {https://doi.org/10.14778/3641204.3641209},
        year = {2024}
}

Incoming Citations (Sorted by Pagerank)

Showing 12 of 12 citing papers.

Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 50 of 51 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
30 SCOPE: Easy and Efficient Parallel Processing of Massive Data Sets 2008 VLDB 0.00050364918
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
84 Learned Cardinalities: Estimating Correlated Joins with Deep Learning 2019 CIDR 0.00035920657
98 LEO - DB2's LEarning Optimizer 2001 VLDB 0.00034050614
142 Neo: A Learned Query Optimizer 2019 VLDB 0.00029114937
149 Efficient Mid-Query Re-Optimization of Sub-Optimal Query Execution Plans 1998 SIGMOD 0.00028910892
151 An Efficient, Cost-Driven Index Selection Tool for Microsoft SQL Server 1997 VLDB 0.00028611216
309 An End-to-End Automatic Cloud Database Tuning System Using Deep Reinforcement Learning 2019 SIGMOD 0.0002143249
320 DeepDB: Learn from Data, not from Queries! 2020 VLDB 0.00021128745
355 Bao: Making Learned Query Optimization Practical 2021 SIGMOD 0.00020146245
427 ALEX: An Updatable Adaptive Learned Index 2020 SIGMOD 0.00018429918
471 Robust Query Processing through Progressive Optimization 2004 SIGMOD 0.00017691682
508 NeuroCard: One Cardinality Estimator for All Tables 2021 VLDB 0.00017108973
756 Automatic Physical Database Tuning: A Relaxation-based Approach 2005 SIGMOD 0.00014209974
774 FITing-Tree: A Data-aware Index Structure 2019 SIGMOD 0.00014063511
881 Dynamic Programming Strikes Back 2008 SIGMOD 0.0001324243
983 Cardinality Estimation in DBMS: A Comprehensive Benchmark Evaluation 2022 VLDB 0.00012677179
1,064 Are We Ready For Learned Cardinality Estimation? 2021 VLDB 0.00012181459
1,175 Balsa: Learning a Query Optimizer Without Expert Demonstrations 2022 SIGMOD 0.00011630532
1,261 Sampling-Based Query Re-Optimization 2016 SIGMOD 0.00011289724
1,282 AI Meets AI: Leveraging Query Executions to Improve Index Recommendations 2019 SIGMOD 0.00011197535
1,400 Magic mirror in my hand, which is the best in the land? An Experimental Evaluation of Index Selection Algorithms 2020 VLDB 0.00010759064
1,609 SkinnerDB: Regret-Bounded Query Evaluation via Reinforcement Learning 2019 SIGMOD 0.0001007196
1,771 Diagnosing Root Causes of Intermittent Slow Queries in Cloud Databases 2020 VLDB 9.6775181e-05
1,823 CoPhy: A Scalable, Portable, and Interactive Index Advisor for Large Workloads 2011 VLDB 9.5457638e-05
2,009 FLAT: Fast, Lightweight and Accurate Method for Cardinality Estimation 2021 VLDB 9.1813272e-05
2,190 Lero: A Learning-to-Rank Query Optimizer 2023 VLDB 8.8848923e-05
2,523 Learned Cardinality Estimation: A Design Space Exploration and A Comparative Evaluation 2022 VLDB 8.3316032e-05
2,696 Cost-based or Learning-based? A Hybrid Query Optimizer for Query Plan Selection 2022 VLDB 8.1068354e-05
2,768 Query Performance Prediction for Concurrent Queries using Graph Embedding 2020 VLDB 8.0199086e-05
2,779 Facilitating Database Tuning with Hyper-Parameter Optimization: A Comprehensive Experimental Evaluation 2022 VLDB 8.0085666e-05
2,828 Cost Models for Big Data Query Processing: Learning, Retrofitting, and Our Findings 2020 SIGMOD 7.9476509e-05
2,913 AI Meets Database: AI4DB and DB4AI 2021 SIGMOD 7.855786e-05
3,057 LlamaTune: Sample-Efficient DBMS Configuration Tuning 2022 VLDB 7.6865211e-05
3,344 The Composable Data Management System Manifesto 2023 VLDB 7.3834228e-05
3,550 Computation Reuse in Analytics Job Service at Microsoft 2018 SIGMOD 7.1895215e-05
3,575 Make Your Database System Dream of Electric Sheep: Towards Self-Driving Operation 2021 VLDB 7.1769215e-05
3,687 openGauss: An Autonomous Database System 2021 VLDB 7.0797286e-05
3,951 Deploying a Steered Query Optimizer in Production at Microsoft 2022 SIGMOD 6.8884038e-05
3,959 MB2: Decomposed Behavior Modeling for Self-Driving Database Management Systems 2021 SIGMOD 6.8804723e-05
3,967 Efficient Deep Learning Pipelines for Accurate Cost Estimations Over Large Scale Query Workload 2021 SIGMOD 6.8772718e-05
4,247 LEON: A New Framework for ML-Aided Query Optimization 2023 VLDB 6.6920059e-05
4,683 AutoSteer: Learned Query Optimization for Any SQL Database 2023 VLDB 6.4545989e-05
5,126 Steering Query Optimizers: A Practical Take on Big Data Workloads 2021 SIGMOD 6.2493606e-05
5,453 Eraser: Eliminating Performance Regression on Learned Query Optimizer 2024 VLDB 6.1077838e-05
6,816 ROX: Run-time Optimization of XQueries 2009 SIGMOD 5.6593309e-05
7,446 Learning to be a Statistician: Learned Estimator for Number of Distinct Values 2022 VLDB 5.5113049e-05
7,715 Tastes Great! Less Filling! High Performance and Accurate Training Data Collection for Self-Driving Database Management Systems 2022 SIGMOD 5.4556951e-05
Previous Page 1 / 2 Next

Semantically Similar Papers