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.00013402933
Overall Rank: 861 | 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,211	Query From Examples: An Iterative, Data-Driven Approach to Query Construction	2015	VLDB	0.00011524858
1,221	SODA: Generating SQL for Business Users	2012	VLDB	0.00011473702
2,550	SQLShare: Results from a Multi-Year SQL-as-a-Service Experiment	2016	SIGMOD	8.3121033e-05
2,641	Auto-Suggest: Learning-to-Recommend Data Preparation Steps Using Data Science Notebooks	2020	SIGMOD	8.1787073e-05
3,003	Gestural Query Specification	2014	VLDB	7.7645915e-05
3,504	Example-Driven Query Intent Discovery: Abductive Reasoning using Semantic Similarity	2019	VLDB	7.2516839e-05
4,059	Database-Agnostic Workload Management	2019	CIDR	6.8251711e-05
4,368	Meet Charles, big data query advisor	2013	CIDR	6.6315458e-05
4,497	Automating Exploratory Data Analysis via Machine Learning: An Overview	2020	SIGMOD	6.5763072e-05
5,031	Mining Precision Interfaces From Query Logs	2019	SIGMOD	6.3055788e-05
5,158	Facilitating SQL Query Composition and Analysis	2020	SIGMOD	6.2492918e-05
5,168	Querying Without Keyboards	2013	CIDR	6.2460238e-05
6,162	Guided Exploration of User Groups	2020	VLDB	5.8644841e-05
6,933	REACT: Context-Sensitive Recommendations for Data Analysis	2016	SIGMOD	5.6406682e-05
7,157	Sibyl: Forecasting Time-Evolving Query Workloads	2024	SIGMOD	5.5972283e-05
7,812	Auto-Formula: Recommend Formulas in Spreadsheets using Contrastive Learning for Table Representations	2024	SIGMOD	5.4486106e-05
8,272	NOAH: Interactive Spreadsheet Exploration with Dynamic Hierarchical Overviews	2021	VLDB	5.3643259e-05
8,355	FEDEX: An Explainability Framework for Data Exploration Steps	2022	VLDB	5.3482186e-05
8,638	Query Log Compression for Workload Analytics	2019	VLDB	5.2978746e-05
10,016	The Data Interaction Game	2018	SIGMOD	5.0959403e-05
10,171	Towards Autonomous, Hands-Free Data Exploration	2020	CIDR	5.0682654e-05
11,968	PyExplore: Query Recommendations for Data Exploration without Query Logs	2021	SIGMOD	4.9793485e-05
12,258	Constraint-based Explanation and Repair of Filter-based Transformations	2018	VLDB	4.9793485e-05
12,297	A Declarative Query Processing System for Nowcasting	2017	VLDB	4.9793485e-05
12,439	Big Data Research: Will Industry Solve all the Problems?	2015	VLDB	4.9793485e-05
12,539	The Power of Data Use Management in Action	2013	SIGMOD	4.9793485e-05
12,572	Fast Cartography for Data Explorers	2013	VLDB	4.9793485e-05
12,612	Auto-Completion Learning for XML	2012	SIGMOD	4.9793485e-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.00021164857
1,311	Assisted Querying using Instant-Response Interfaces	2007	SIGMOD	0.00011065979
1,558	Summarizing Relational Databases	2009	VLDB	0.00010257165
1,886	Probabilistic Ranking of Database Query Results	2004	VLDB	9.4339749e-05
2,214	Effective Phrase Prediction	2007	VLDB	8.8195986e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	7,704	ReStore - Neural Data Completion for Relational Databases	2021	SIGMOD
2	5,520	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,590	AutoG: A Visual Query Autocompletion Framework for Graph Databases	2016	VLDB
5	7,011	SnapToQuery: Providing Interactive Feedback during Exploratory Query Specification	2015	VLDB
6	4,707	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,273	Automatic Example Queries for Ad Hoc Databases	2011	SIGMOD
9	5,158	Facilitating SQL Query Composition and Analysis	2020	SIGMOD
10	9,550	SQuID: Semantic Similarity-Aware Query Intent Discovery	2018	SIGMOD