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: 10443
Venue: VLDB
Year: 2011
Pagerank: 0.00013658824
Overall Rank: 846 | 94.20%
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,192	Query From Examples: An Iterative, Data-Driven Approach to Query Construction	2015	VLDB	0.00011740132
1,214	SODA: Generating SQL for Business Users	2012	VLDB	0.0001163751
2,592	SQLShare: Results from a Multi-Year SQL-as-a-Service Experiment	2016	SIGMOD	8.3657526e-05
2,744	Auto-Suggest: Learning-to-Recommend Data Preparation Steps Using Data Science Notebooks	2020	SIGMOD	8.1781662e-05
2,946	Gestural Query Specification	2014	VLDB	7.93259e-05
3,677	Example-Driven Query Intent Discovery: Abductive Reasoning using Semantic Similarity	2019	VLDB	7.2076465e-05
4,053	Database-Agnostic Workload Management	2019	CIDR	6.9355341e-05
4,295	Meet Charles, big data query advisor	2013	CIDR	6.7780208e-05
4,395	Automating Exploratory Data Analysis via Machine Learning: An Overview	2020	SIGMOD	6.7271323e-05
4,904	Mining Precision Interfaces From Query Logs	2019	SIGMOD	6.4503063e-05
5,084	Querying Without Keyboards	2013	CIDR	6.3692734e-05
5,132	Facilitating SQL Query Composition and Analysis	2020	SIGMOD	6.3534526e-05
6,039	Guided Exploration of User Groups	2020	VLDB	5.9990875e-05
6,799	REACT: Context-Sensitive Recommendations for Data Analysis	2016	SIGMOD	5.7701345e-05
7,580	Sibyl: Forecasting Time-Evolving Query Workloads	2024	SIGMOD	5.5925285e-05
8,184	FEDEX: An Explainability Framework for Data Exploration Steps	2022	VLDB	5.4709725e-05
8,511	NOAH: Interactive Spreadsheet Exploration with Dynamic Hierarchical Overviews	2021	VLDB	5.4119882e-05
8,583	Query Log Compression for Workload Analytics	2019	VLDB	5.4079618e-05
8,797	Auto-Formula: Recommend Formulas in Spreadsheets using Contrastive Learning for Table Representations	2024	SIGMOD	5.3702298e-05
9,832	The Data Interaction Game	2018	SIGMOD	5.2124469e-05
9,977	Towards Autonomous, Hands-Free Data Exploration	2020	CIDR	5.1845938e-05
11,661	PyExplore: Query Recommendations for Data Exploration without Query Logs	2021	SIGMOD	5.093636e-05
11,960	Constraint-based Explanation and Repair of Filter-based Transformations	2018	VLDB	5.093636e-05
12,000	A Declarative Query Processing System for Nowcasting	2017	VLDB	5.093636e-05
12,147	Big Data Research: Will Industry Solve all the Problems?	2015	VLDB	5.093636e-05
12,248	The Power of Data Use Management in Action	2013	SIGMOD	5.093636e-05
12,281	Fast Cartography for Data Explorers	2013	VLDB	5.093636e-05
12,321	Auto-Completion Learning for XML	2012	SIGMOD	5.093636e-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
314	Making Database Systems Usable	2007	SIGMOD	0.00021574636
1,305	Assisted Querying using Instant-Response Interfaces	2007	SIGMOD	0.00011235196
1,532	Summarizing Relational Databases	2009	VLDB	0.00010472227
1,844	Probabilistic Ranking of Database Query Results	2004	VLDB	9.6314187e-05
2,176	Effective Phrase Prediction	2007	VLDB	9.0172465e-05

Semantically Similar Papers

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