Facilitating SQL Query Composition and Analysis

Summary: Predicts pre-execution query properties to accelerate SQL tuning without DB statistics or execution plans. Data-driven neural models trained on large query workloads estimate answer size, runtime, and error class, empirically outperforming statistics- and plan-based baselines. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 5877
Venue: SIGMOD
Year: 2020
Pagerank: 6.3534526e-05
Overall Rank: 5,132 | 64.80%
DOI: 10.1145/3318464.3380602

Incoming Non-self Citations Over Time

Authors

1. Zainab Zolaktaf (University of British Columbia)
2. Mostafa Milani (University of British Columbia)
3. Rachel Pottinger (University of British Columbia)

BibTeX Citation

@inproceedings{zolaktaf_sigmod20,
        title = {{Facilitating SQL Query Composition and Analysis}},
        author = {Zolaktaf, Zainab and Milani, Mostafa and Pottinger, Rachel},
        series = {{SIGMOD} '20},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/3318464.3380602},
        url = {https://dl.acm.org/doi/10.1145/3318464.3380602},
        year = {2020}
}

Incoming Citations (Sorted by Pagerank)

Showing 6 of 6 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
3,116	ResTune: Resource Oriented Tuning Boosted by Meta-Learning for Cloud Databases	2021	SIGMOD	7.7390737e-05
3,953	Efficient Deep Learning Pipelines for Accurate Cost Estimations Over Large Scale Query Workload	2021	SIGMOD	6.996368e-05
4,011	Towards Dynamic and Safe Configuration Tuning for Cloud Databases	2022	SIGMOD	6.959982e-05
4,398	Real-time Workload Pattern Analysis for Large-scale Cloud Databases	2023	VLDB	6.7248611e-05
8,846	Workload Insights From The Snowflake Data Cloud: What Do Production Analytic Queries Really Look Like?	2025	VLDB	5.3580184e-05
9,283	Intelligent Automated Workload Analysis for Database Replatforming	2022	SIGMOD	5.2925877e-05

Outgoing Citations (Sorted by Pagerank)

Showing 14 of 14 cited papers.

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

Rank	Cited Paper	Year	Venue	Pagerank
18	How Good Are Query Optimizers, Really?	2016	VLDB	0.00059284255
114	Executing SQL over Encrypted Data in the Database-Service-Provider Model	2002	SIGMOD	0.00032363776
179	Constructing an Interactive Natural Language Interface for Relational Databases	2015	VLDB	0.00026838277
314	Making Database Systems Usable	2007	SIGMOD	0.00021574636
682	Robust Estimation of Resource Consumption for SQL Queries using Statistical Techniques	2012	VLDB	0.00015014887
846	SnipSuggest: Context-Aware Autocompletion for SQL	2011	VLDB	0.00013658824
1,262	Discovering Queries based on Example Tuples	2014	SIGMOD	0.00011427456
1,266	Compressing SQL Workloads	2002	SIGMOD	0.00011412078
1,279	AI Meets AI: Leveraging Query Executions to Improve Index Recommendations	2019	SIGMOD	0.00011361878
1,719	The SDSS SkyServer - Public Access to the Sloan Digital Sky Survey Data	2002	SIGMOD	9.9268286e-05
2,592	SQLShare: Results from a Multi-Year SQL-as-a-Service Experiment	2016	SIGMOD	8.3657526e-05
2,677	Explore-by-Example: An Automatic Query Steering Framework for Interactive Data Exploration	2014	SIGMOD	8.2682753e-05
3,651	Keyword Search over Relational Databases: A Metadata Approach	2011	SIGMOD	7.2249652e-05
4,053	Database-Agnostic Workload Management	2019	CIDR	6.9355341e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	2,812	Query Performance Prediction for Concurrent Queries using Graph Embedding	2020	VLDB
2	5,394	Leveraging Query Logs and Machine Learning for Parametric Query Optimization	2022	VLDB
3	4,671	PreQR: Pre-training Representation for SQL Understanding	2022	SIGMOD
4	295	Accelerating Machine Learning Inference with Probabilistic Predicates	2018	SIGMOD
5	9,353	On Efficient Approximate Queries over Machine Learning Models	2023	VLDB
6	11,361	Predicting Query Execution time for JIT Compiled Database Engines	2023	CIDR
7	3,482	Towards Predicting Query Execution Time for Concurrent and Dynamic Database Workloads	2013	VLDB
8	5,073	Database Workload Characterization with Query Plan Encoders	2022	VLDB
9	11,845	Query-Driven Learning for Next Generation Predictive Modeling & Analytics	2019	SIGMOD
10	563	Plan-Structured Deep Neural Network Models for Query Performance Prediction	2019	VLDB