{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,3,20]],"date-time":"2026-03-20T16:19:25Z","timestamp":1774023565226,"version":"3.50.1"},"reference-count":24,"publisher":"Association for Computing Machinery (ACM)","issue":"10","content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["Proc. VLDB Endow."],"published-print":{"date-parts":[[2012,6]]},"abstract":"<jats:p>The purpose of data warehouses is to enable business analysts to make better decisions. Over the years the technology has matured and data warehouses have become extremely successful. As a consequence, more and more data has been added to the data warehouses and their schemas have become increasingly complex. These systems still work great in order to generate pre-canned reports. However, with their current complexity, they tend to be a poor match for non tech-savvy business analysts who need answers to ad-hoc queries that were not anticipated.<\/jats:p>\n          <jats:p>This paper describes the design, implementation, and experience of the SODA system (Search over DAta Warehouse). SODA bridges the gap between the business needs of analysts and the technical complexity of current data warehouses. SODA enables a Google-like search experience for data warehouses by taking keyword queries of business users and automatically generating executable SQL. The key idea is to use a graph pattern matching algorithm that uses the metadata model of the data warehouse. Our results with real data from a global player in the financial services industry show that SODA produces queries with high precision and recall, and makes it much easier for business users to interactively explore highly-complex data warehouses.<\/jats:p>","DOI":"10.14778\/2336664.2336667","type":"journal-article","created":{"date-parts":[[2014,6,24]],"date-time":"2014-06-24T12:17:57Z","timestamp":1403612277000},"page":"932-943","source":"Crossref","is-referenced-by-count":49,"title":["SODA"],"prefix":"10.14778","volume":"5","author":[{"given":"Lukas","family":"Blunschi","sequence":"first","affiliation":[{"name":"ETH Zurich, Switzerland"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Claudio","family":"Jossen","sequence":"additional","affiliation":[{"name":"Credit Suisse AG, Switzerland"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Donald","family":"Kossmann","sequence":"additional","affiliation":[{"name":"ETH Zurich, Switzerland"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Magdalini","family":"Mori","sequence":"additional","affiliation":[{"name":"Credit Suisse AG, Switzerland"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Kurt","family":"Stockinger","sequence":"additional","affiliation":[{"name":"Credit Suisse AG, Switzerland"}],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"320","published-online":{"date-parts":[[2012,6]]},"reference":[{"key":"e_1_2_1_1_1","doi-asserted-by":"publisher","DOI":"10.5555\/876875.879013"},{"key":"e_1_2_1_2_1","doi-asserted-by":"publisher","DOI":"10.1145\/1989323.1989383"},{"key":"e_1_2_1_3_1","doi-asserted-by":"publisher","DOI":"10.5555\/876875.879034"},{"key":"e_1_2_1_4_1","doi-asserted-by":"publisher","DOI":"10.1145\/2063576.2064009"},{"key":"e_1_2_1_5_1","unstructured":"G. Brunner and K. Stockinger. Data Warehouse Historization Concept. Credit Suisse internal architecture document 2008.  G. Brunner and K. Stockinger. Data Warehouse Historization Concept. Credit Suisse internal architecture document 2008."},{"key":"e_1_2_1_6_1","doi-asserted-by":"publisher","DOI":"10.1145\/1557670.1557682"},{"key":"e_1_2_1_7_1","first-page":"240","volume-title":"DEXA (2)","author":"Demidova E.","year":"2010"},{"key":"e_1_2_1_8_1","unstructured":"A. Geppert L. Baumgartner and D. Jonscher. The Data Warehouse Reference Architecture. Credit Suisse internal architecture document 2008.  A. Geppert L. Baumgartner and D. Jonscher. The Data Warehouse Reference Architecture. Credit Suisse internal architecture document 2008."},{"key":"e_1_2_1_9_1","doi-asserted-by":"publisher","DOI":"10.1145\/1247480.1247516"},{"key":"e_1_2_1_10_1","first-page":"670","volume-title":"VLDB","author":"Hristidis V.","year":"2002"},{"key":"e_1_2_1_11_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICDE.2012.41"},{"issue":"1","key":"e_1_2_1_12_1","first-page":"22","volume":"4","author":"Khoussainova N.","year":"2010","journal-title":"SnipSuggest: Context-Aware Autocompletion for SQL. PVLDB"},{"key":"e_1_2_1_13_1","volume-title":"John Wiley","author":"Kimball R.","year":"1996"},{"key":"e_1_2_1_14_1","doi-asserted-by":"publisher","DOI":"10.1145\/1292609.1292620"},{"key":"e_1_2_1_15_1","doi-asserted-by":"publisher","DOI":"10.1145\/1142473.1142536"},{"key":"e_1_2_1_16_1","doi-asserted-by":"publisher","DOI":"10.1007\/s11280-011-0128-2"},{"key":"e_1_2_1_17_1","doi-asserted-by":"publisher","DOI":"10.5555\/645340.650236"},{"key":"e_1_2_1_18_1","doi-asserted-by":"publisher","DOI":"10.1145\/1559845.1559917"},{"key":"e_1_2_1_19_1","doi-asserted-by":"publisher","DOI":"10.1007\/s00778-007-0075-9"},{"key":"e_1_2_1_20_1","unstructured":"R. T. Snodgrass. Developing Time-Oriented Database Applications in SQL. Morgan Kaufmann 1999.   R. T. Snodgrass. Developing Time-Oriented Database Applications in SQL . Morgan Kaufmann 1999."},{"key":"e_1_2_1_21_1","unstructured":"http:\/\/www.w3.org\/TR\/rdf-sparql-query\/. SPARQL Query Language for RDF.  http:\/\/www.w3.org\/TR\/rdf-sparql-query\/. SPARQL Query Language for RDF."},{"key":"e_1_2_1_22_1","doi-asserted-by":"publisher","DOI":"10.1145\/564691.564758"},{"key":"e_1_2_1_23_1","doi-asserted-by":"publisher","DOI":"10.1145\/1376616.1376705"},{"issue":"1","key":"e_1_2_1_24_1","first-page":"634","volume":"2","author":"Yang X.","year":"2009","journal-title":"Summarizing Relational Database. PVLDB"}],"container-title":["Proceedings of the VLDB Endowment"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.14778\/2336664.2336667","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2022,12,28]],"date-time":"2022-12-28T10:45:23Z","timestamp":1672224323000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.14778\/2336664.2336667"}},"subtitle":["generating SQL for business users"],"short-title":[],"issued":{"date-parts":[[2012,6]]},"references-count":24,"journal-issue":{"issue":"10","published-print":{"date-parts":[[2012,6]]}},"alternative-id":["10.14778\/2336664.2336667"],"URL":"https:\/\/doi.org\/10.14778\/2336664.2336667","relation":{},"ISSN":["2150-8097"],"issn-type":[{"value":"2150-8097","type":"print"}],"subject":[],"published":{"date-parts":[[2012,6]]}}}