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: 5815
Venue: SIGMOD
Year: 2020
Pagerank: 5.4885366e-05
Overall Rank: 5,473 | 61.93%
DOI: 10.1145/3318464.3380602

Incoming Non-self Citations Over Time

Authors

Incoming Citations (Sorted by Pagerank)

Showing 6 of 6 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
3,429	Real-time Workload Pattern Analysis for Large-scale Cloud Databases	2023	VLDB	7.1010535e-05
3,522	ResTune: Resource Oriented Tuning Boosted by Meta-Learning for Cloud Databases	2021	SIGMOD	7.0096727e-05
4,804	Efficient Deep Learning Pipelines for Accurate Cost Estimations Over Large Scale Query Workload	2021	SIGMOD	5.910467e-05
4,842	Towards Dynamic and Safe Configuration Tuning for Cloud Databases	2022	SIGMOD	5.8826802e-05
8,884	Workload Insights From The Snowflake Data Cloud: What Do Production Analytic Queries Really Look Like?	2025	VLDB	4.4283999e-05
9,203	Intelligent Automated Workload Analysis for Database Replatforming	2022	SIGMOD	4.3740313e-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
71	How Good Are Query Optimizers, Really?	2016	VLDB	0.00059038975
118	Executing SQL over Encrypted Data in the Database-Service-Provider Model	2002	SIGMOD	0.00045685662
206	Constructing an Interactive Natural Language Interface for Relational Databases	2015	VLDB	0.00034667032
257	Making Database Systems Usable	2007	SIGMOD	0.00030223397
1,009	SnipSuggest: Context-Aware Autocompletion for SQL	2011	VLDB	0.00014653644
1,019	Robust Estimation of Resource Consumption for SQL Queries using Statistical Techniques	2012	VLDB	0.00014625603
1,443	Compressing SQL Workloads	2002	SIGMOD	0.00011947004
1,509	Discovering Queries based on Example Tuples	2014	SIGMOD	0.00011612727
1,591	The SDSS SkyServer - Public Access to the Sloan Digital Sky Survey Data	2002	SIGMOD	0.00011226338
1,855	AI Meets AI: Leveraging Query Executions to Improve Index Recommendations	2019	SIGMOD	0.00010315245
2,965	SQLShare: Results from a Multi-Year SQL-as-a-Service Experiment	2016	SIGMOD	7.8059273e-05
3,070	Explore-by-Example: An Automatic Query Steering Framework for Interactive Data Exploration	2014	SIGMOD	7.6137064e-05
3,758	Keyword Search over Relational Databases: A Metadata Approach	2011	SIGMOD	6.7824746e-05
4,549	Database-Agnostic Workload Management	2019	CIDR	6.0926728e-05

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
3,580	Query Performance Prediction for Concurrent Queries using Graph Embedding	2020	VLDB	6.9500996e-05
6,667	Leveraging Query Logs and Machine Learning for Parametric Query Optimization	2022	VLDB	4.9688874e-05
4,661	PreQR: Pre-training Representation for SQL Understanding	2022	SIGMOD	6.0137947e-05
329	Accelerating Machine Learning Inference with Probabilistic Predicates	2018	SIGMOD	0.00027249545
9,351	On Efficient Approximate Queries over Machine Learning Models	2023	VLDB	4.3524472e-05
11,155	Predicting Query Execution time for JIT Compiled Database Engines	2023	CIDR	4.1945683e-05
4,088	Towards Predicting Query Execution Time for Concurrent and Dynamic Database Workloads	2013	VLDB	6.4603918e-05
5,637	Database Workload Characterization with Query Plan Encoders	2022	VLDB	5.3979505e-05
11,650	Query-Driven Learning for Next Generation Predictive Modeling & Analytics	2019	SIGMOD	4.1945683e-05
884	Plan-Structured Deep Neural Network Models for Query Performance Prediction	2019	VLDB	0.00015654004