{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,10,6]],"date-time":"2026-10-06T01:03:39Z","timestamp":1791248619108,"version":"4.1.0"},"reference-count":26,"publisher":"Association for Computing Machinery (ACM)","issue":"1","content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["Proc. VLDB Endow."],"published-print":{"date-parts":[[2010,10]]},"abstract":"<jats:p>In this paper, we present SnipSuggest, a system that provides on-the-go, context-aware assistance in the SQL composition process. SnipSuggest aims to help the increasing population of non-expert database users, who need to perform complex analysis on their large-scale datasets, but have difficulty writing SQL queries. As a user types a query, SnipSuggest recommends possible additions to various clauses in the query using relevant snippets collected from a log of past queries. SnipSuggest's current capabilities include suggesting tables, views, and table-valued functions in the FROM clause, columns in the SELECT clause, predicates in the WHERE clause, columns in the GROUP BY clause, aggregates, and some support for sub-queries. SnipSuggest adjusts its recommendations according to the context: as the user writes more of the query, it is able to provide more accurate suggestions.<\/jats:p>\n          <jats:p>We evaluate SnipSuggest over two query logs: one from an undergraduate database class and another from the Sloan Digital Sky Survey database. We show that SnipSuggest is able to recommend useful snippets with up to 93.7% average precision, at interactive speed. We also show that SnipSuggest outperforms na\u00efve approaches, such as recommending popular snippets.<\/jats:p>","DOI":"10.14778\/1880172.1880175","type":"journal-article","created":{"date-parts":[[2014,6,24]],"date-time":"2014-06-24T12:17:57Z","timestamp":1403612277000},"page":"22-33","source":"Crossref","is-referenced-by-count":89,"title":["SnipSuggest"],"prefix":"10.14778","volume":"4","author":[{"given":"Nodira","family":"Khoussainova","sequence":"first","affiliation":[{"name":"University of Washington, Seattle, WA"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"YongChul","family":"Kwon","sequence":"additional","affiliation":[{"name":"University of Washington, Seattle, WA"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Magdalena","family":"Balazinska","sequence":"additional","affiliation":[{"name":"University of Washington, Seattle, WA"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Dan","family":"Suciu","sequence":"additional","affiliation":[{"name":"University of Washington, Seattle, WA"}],"role":[{"vocabulary":"crossref","role":"author"}]}],"member":"320","published-online":{"date-parts":[[2010,10]]},"reference":[{"key":"e_1_2_1_1_1","unstructured":"SkyServer. http:\/\/cas.sdss.org\/dr6\/en\/.  SkyServer. http:\/\/cas.sdss.org\/dr6\/en\/."},{"key":"e_1_2_1_2_1","unstructured":"Aqua Data Studio. http:\/\/www.aquafold.com\/.  Aqua Data Studio. http:\/\/www.aquafold.com\/."},{"key":"e_1_2_1_3_1","volume-title":"Modern Information Retrieval","author":"Baeza-Yates R.","year":"1999","unstructured":"R. Baeza-Yates and B. Riberio-Neto . Modern Information Retrieval . Addison-Wesley Longman Publishing , Boston, MA , 1999 . R. Baeza-Yates and B. Riberio-Neto. Modern Information Retrieval. Addison-Wesley Longman Publishing, Boston, MA, 1999."},{"key":"e_1_2_1_4_1","unstructured":"BaseNow. About SQL Query Builder. www.basenow.com\/help\/About_SQL_Query_Builder.asp.  BaseNow. About SQL Query Builder. www.basenow.com\/help\/About_SQL_Query_Builder.asp."},{"key":"e_1_2_1_5_1","doi-asserted-by":"publisher","DOI":"10.1145\/792550.792552"},{"key":"e_1_2_1_6_1","doi-asserted-by":"publisher","DOI":"10.1145\/108844.108874"},{"issue":"2","key":"e_1_2_1_7_1","first-page":"215","article-title":"Visual query systems for databases: A survey. J. of Visual Languages &amp;","volume":"8","author":"Catarci T.","year":"1997","unstructured":"T. Catarci , M. F. Costabile , S. Levialdi , and C. Batini . Visual query systems for databases: A survey. J. of Visual Languages &amp; Computing , 8 ( 2 ): 215 -- 260 , 1997 . T. Catarci, M. F. Costabile, S. Levialdi, and C. Batini. Visual query systems for databases: A survey. J. of Visual Languages &amp; Computing, 8(2):215--260, 1997.","journal-title":"Computing"},{"key":"e_1_2_1_8_1","doi-asserted-by":"publisher","DOI":"10.1007\/978-3-642-02279-1_2"},{"key":"e_1_2_1_9_1","doi-asserted-by":"publisher","DOI":"10.5555\/1316689.1316766"},{"key":"e_1_2_1_10_1","doi-asserted-by":"publisher","DOI":"10.1145\/1458082.1458143"},{"key":"e_1_2_1_11_1","volume-title":"IJCAI","author":"Downey D.","year":"2007","unstructured":"D. Downey , S. T. Dumais , and E. Horvitz . Models of searching and browsing: Languages, studies, and application . In IJCAI , 2007 . D. Downey, S. T. Dumais, and E. Horvitz. Models of searching and browsing: Languages, studies, and application. In IJCAI, 2007."},{"key":"e_1_2_1_12_1","doi-asserted-by":"publisher","DOI":"10.1145\/285055.285059"},{"key":"e_1_2_1_13_1","unstructured":"UCSC Genome Browser. http:\/\/genome.ucsc.edu\/.  UCSC Genome Browser. http:\/\/genome.ucsc.edu\/."},{"key":"e_1_2_1_14_1","volume-title":"SQL Is Dead","author":"Howe B.","year":"2010","unstructured":"B. Howe and G. Cole . SQL Is Dead ; Long Live SQL: Lightweight Query Services for Ad Hoc Research Data. In Microsoft eScience Workshop , 2010 . B. Howe and G. Cole. SQL Is Dead; Long Live SQL: Lightweight Query Services for Ad Hoc Research Data. In Microsoft eScience Workshop, 2010."},{"key":"e_1_2_1_15_1","unstructured":"IBM. Cognos software. http:\/\/cognos.com\/.  IBM. Cognos software. http:\/\/cognos.com\/."},{"key":"e_1_2_1_16_1","doi-asserted-by":"publisher","DOI":"10.1145\/1247480.1247483"},{"key":"e_1_2_1_17_1","volume-title":"Proc. of the 26th ICDE Conf.","author":"Koutrika G.","unstructured":"G. Koutrika , A. Simitsis , and Y. Ioannidis . Explaining structured queries in natural language . In Proc. of the 26th ICDE Conf. G. Koutrika, A. Simitsis, and Y. Ioannidis. Explaining structured queries in natural language. In Proc. of the 26th ICDE Conf."},{"key":"e_1_2_1_18_1","doi-asserted-by":"publisher","DOI":"10.5555\/317328.317340"},{"key":"e_1_2_1_19_1","unstructured":"MicroStrategy 9. Microstrategy. http:\/\/www.microstrategy.com.  MicroStrategy 9. Microstrategy. http:\/\/www.microstrategy.com."},{"key":"e_1_2_1_20_1","doi-asserted-by":"publisher","DOI":"10.1145\/1247480.1247640"},{"key":"e_1_2_1_21_1","first-page":"219","volume-title":"Proc. VLDB","author":"Nandi A.","year":"2007","unstructured":"A. Nandi and H. V. Jagadish . Effective phrase prediction . In Proc. VLDB , pages 219 -- 230 , 2007 . A. Nandi and H. V. Jagadish. Effective phrase prediction. In Proc. VLDB, pages 219--230, 2007."},{"key":"e_1_2_1_22_1","unstructured":"Sloan Digital Sky Survey. http:\/\/www.sdss.org\/.  Sloan Digital Sky Survey. http:\/\/www.sdss.org\/."},{"key":"e_1_2_1_23_1","volume-title":"Skyserver traffic report - the first five years","author":"Singh V.","year":"2006","unstructured":"V. Singh , J. Gray , and A. T. A. S. Szalay . Skyserver traffic report - the first five years , 2006 . V. Singh, J. Gray, and A. T. A. S. Szalay. Skyserver traffic report - the first five years, 2006."},{"key":"e_1_2_1_24_1","volume-title":"Nature","author":"Szalay A.","year":"2006","unstructured":"A. Szalay and J. Gray . Science in an exponential world . Nature , March 23 2006 . A. Szalay and J. Gray. Science in an exponential world. Nature, March 23 2006."},{"key":"e_1_2_1_25_1","unstructured":"University of Washington eScience Institute. www.escience.washington.edu.  University of Washington eScience Institute. www.escience.washington.edu."},{"key":"e_1_2_1_26_1","doi-asserted-by":"publisher","DOI":"10.14778\/1687627.1687699"}],"container-title":["Proceedings of the VLDB Endowment"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.14778\/1880172.1880175","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2022,12,28]],"date-time":"2022-12-28T09:20:18Z","timestamp":1672219218000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.14778\/1880172.1880175"}},"subtitle":["context-aware autocompletion for SQL"],"short-title":[],"issued":{"date-parts":[[2010,10]]},"references-count":26,"journal-issue":{"issue":"1","published-print":{"date-parts":[[2010,10]]}},"alternative-id":["10.14778\/1880172.1880175"],"URL":"https:\/\/doi.org\/10.14778\/1880172.1880175","relation":{},"ISSN":["2150-8097"],"issn-type":[{"value":"2150-8097","type":"print"}],"subject":[],"published":{"date-parts":[[2010,10]]}}}