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.00013358173
Overall Rank: 864 | 94.22%
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,214	Query From Examples: An Iterative, Data-Driven Approach to Query Construction	2015	VLDB	0.00011490045
1,217	SODA: Generating SQL for Business Users	2012	VLDB	0.00011464151
2,543	SQLShare: Results from a Multi-Year SQL-as-a-Service Experiment	2016	SIGMOD	8.2993351e-05
2,645	Auto-Suggest: Learning-to-Recommend Data Preparation Steps Using Data Science Notebooks	2020	SIGMOD	8.1641056e-05
3,016	Gestural Query Specification	2014	VLDB	7.7360586e-05
3,503	Example-Driven Query Intent Discovery: Abductive Reasoning using Semantic Similarity	2019	VLDB	7.2305074e-05
4,061	Database-Agnostic Workload Management	2019	CIDR	6.8129772e-05
4,398	Meet Charles, big data query advisor	2013	CIDR	6.6065445e-05
4,519	Automating Exploratory Data Analysis via Machine Learning: An Overview	2020	SIGMOD	6.551459e-05
5,058	Mining Precision Interfaces From Query Logs	2019	SIGMOD	6.2817535e-05
5,160	Facilitating SQL Query Composition and Analysis	2020	SIGMOD	6.2354336e-05
5,168	Querying Without Keyboards	2013	CIDR	6.2335584e-05
6,182	Guided Exploration of User Groups	2020	VLDB	5.8423254e-05
6,955	REACT: Context-Sensitive Recommendations for Data Analysis	2016	SIGMOD	5.6193552e-05
7,162	Sibyl: Forecasting Time-Evolving Query Workloads	2024	SIGMOD	5.5798063e-05
7,802	Auto-Formula: Recommend Formulas in Spreadsheets using Contrastive Learning for Table Representations	2024	SIGMOD	5.4336348e-05
8,295	NOAH: Interactive Spreadsheet Exploration with Dynamic Hierarchical Overviews	2021	VLDB	5.344057e-05
8,375	FEDEX: An Explainability Framework for Data Exploration Steps	2022	VLDB	5.3280107e-05
8,663	Query Log Compression for Workload Analytics	2019	VLDB	5.2779628e-05
10,057	The Data Interaction Game	2018	SIGMOD	5.0766855e-05
10,209	Towards Autonomous, Hands-Free Data Exploration	2020	CIDR	5.0491152e-05
12,018	PyExplore: Query Recommendations for Data Exploration without Query Logs	2021	SIGMOD	4.9605343e-05
12,307	Constraint-based Explanation and Repair of Filter-based Transformations	2018	VLDB	4.9605343e-05
12,346	A Declarative Query Processing System for Nowcasting	2017	VLDB	4.9605343e-05
12,488	Big Data Research: Will Industry Solve all the Problems?	2015	VLDB	4.9605343e-05
12,588	The Power of Data Use Management in Action	2013	SIGMOD	4.9605343e-05
12,621	Fast Cartography for Data Explorers	2013	VLDB	4.9605343e-05
12,661	Auto-Completion Learning for XML	2012	SIGMOD	4.9605343e-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
321	Making Database Systems Usable	2007	SIGMOD	0.00021093212
1,312	Assisted Querying using Instant-Response Interfaces	2007	SIGMOD	0.00011061014
1,559	Summarizing Relational Databases	2009	VLDB	0.00010220719
1,897	Probabilistic Ranking of Database Query Results	2004	VLDB	9.3988624e-05
2,232	Effective Phrase Prediction	2007	VLDB	8.7867154e-05

Semantically Similar Papers

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