SnipSuggest: Context-Aware Autocompletion for SQL

Summary: SnipSuggest offers interactive, clause-aware SQL autocompletion by retrieving query snippets from logs and refining recommendations as context accumulates. It supports diverse clauses and subqueries, achieving up to 93.7% precision and outperforming popularity-based baselines. (summarized by gpt-5.6-luna on Jul 24 2026)

Paper ID: hdeae0788089aa825
Venue: VLDB
Year: 2011
Pagerank: 0.0001339689
Overall Rank: 862 | 94.21%
DOI: 10.14778/1880172.1880175

Incoming Non-self Citations Over Time

Authors

1. Nodira Khoussainova (University of Washington)
2. YongChul Kwon (University of Washington)
3. Magdalena Balazinska (University of Washington)
4. Dan Suciu (University of Washington)

BibTeX Citation

@article{khoussainova_vldb11,
        title = {{SnipSuggest: Context-Aware Autocompletion for SQL}},
        author = {Khoussainova, Nodira and Kwon, YongChul and Balazinska, Magdalena and Suciu, Dan},
        journal = {PVLDB},
        series = {{VLDB} '11},
        volume = {4},
        number = {1},
        pages = {22},
        doi = {10.14778/1880172.1880175},
        url = {https://doi.org/10.14778/1880172.1880175},
        year = {2011}
}

Incoming Citations (Sorted by Pagerank)

Showing 28 of 28 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
1,211	Query From Examples: An Iterative, Data-Driven Approach to Query Construction	2015	VLDB	0.00011522028
1,221	SODA: Generating SQL for Business Users	2012	VLDB	0.00011469979
2,549	SQLShare: Results from a Multi-Year SQL-as-a-Service Experiment	2016	SIGMOD	8.3096391e-05
2,642	Auto-Suggest: Learning-to-Recommend Data Preparation Steps Using Data Science Notebooks	2020	SIGMOD	8.1751637e-05
3,005	Gestural Query Specification	2014	VLDB	7.7609244e-05
3,504	Example-Driven Query Intent Discovery: Abductive Reasoning using Semantic Similarity	2019	VLDB	7.2483123e-05
4,059	Database-Agnostic Workload Management	2019	CIDR	6.8226757e-05
4,372	Meet Charles, big data query advisor	2013	CIDR	6.6284134e-05
4,499	Automating Exploratory Data Analysis via Machine Learning: An Overview	2020	SIGMOD	6.5731941e-05
5,033	Mining Precision Interfaces From Query Logs	2019	SIGMOD	6.3025938e-05
5,159	Facilitating SQL Query Composition and Analysis	2020	SIGMOD	6.2464819e-05
5,169	Querying Without Keyboards	2013	CIDR	6.243071e-05
6,165	Guided Exploration of User Groups	2020	VLDB	5.8617079e-05
6,935	REACT: Context-Sensitive Recommendations for Data Analysis	2016	SIGMOD	5.6379979e-05
7,160	Sibyl: Forecasting Time-Evolving Query Workloads	2024	SIGMOD	5.5945786e-05
7,819	Auto-Formula: Recommend Formulas in Spreadsheets using Contrastive Learning for Table Representations	2024	SIGMOD	5.4460313e-05
8,279	NOAH: Interactive Spreadsheet Exploration with Dynamic Hierarchical Overviews	2021	VLDB	5.3617864e-05
8,360	FEDEX: An Explainability Framework for Data Exploration Steps	2022	VLDB	5.3456868e-05
8,644	Query Log Compression for Workload Analytics	2019	VLDB	5.295468e-05
10,021	The Data Interaction Game	2018	SIGMOD	5.0935279e-05
10,175	Towards Autonomous, Hands-Free Data Exploration	2020	CIDR	5.0658661e-05
11,974	PyExplore: Query Recommendations for Data Exploration without Query Logs	2021	SIGMOD	4.9769913e-05
12,264	Constraint-based Explanation and Repair of Filter-based Transformations	2018	VLDB	4.9769913e-05
12,303	A Declarative Query Processing System for Nowcasting	2017	VLDB	4.9769913e-05
12,445	Big Data Research: Will Industry Solve all the Problems?	2015	VLDB	4.9769913e-05
12,545	The Power of Data Use Management in Action	2013	SIGMOD	4.9769913e-05
12,578	Fast Cartography for Data Explorers	2013	VLDB	4.9769913e-05
12,618	Auto-Completion Learning for XML	2012	SIGMOD	4.9769913e-05

Outgoing Citations (Sorted by Pagerank)

Showing 5 of 5 cited papers.

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

Rank	Cited Paper	Year	Venue	Pagerank
319	Making Database Systems Usable	2007	SIGMOD	0.00021155013
1,311	Assisted Querying using Instant-Response Interfaces	2007	SIGMOD	0.00011061025
1,558	Summarizing Relational Databases	2009	VLDB	0.00010252433
1,887	Probabilistic Ranking of Database Query Results	2004	VLDB	9.4295364e-05
2,215	Effective Phrase Prediction	2007	VLDB	8.8154455e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	7,710	ReStore - Neural Data Completion for Relational Databases	2021	SIGMOD
2	5,523	PATSQL: Efficient Synthesis of SQL Queries from Example Tables with Quick Inference of Projected Columns	2021	VLDB
3	1,356	CatSQL: Towards Real World Natural Language to SQL Applications	2023	VLDB
4	7,597	AutoG: A Visual Query Autocompletion Framework for Graph Databases	2016	VLDB
5	7,012	SnapToQuery: Providing Interactive Feedback during Exploratory Query Specification	2015	VLDB
6	4,708	PreQR: Pre-training Representation for SQL Understanding	2022	SIGMOD
7	2,467	Few-shot Text-to-SQL Translation using Structure and Content Prompt Learning	2023	SIGMOD
8	4,274	Automatic Example Queries for Ad Hoc Databases	2011	SIGMOD
9	5,159	Facilitating SQL Query Composition and Analysis	2020	SIGMOD
10	9,551	SQuID: Semantic Similarity-Aware Query Intent Discovery	2018	SIGMOD