SODA: Generating SQL for Business Users

Summary: Keyword-driven SQL for data warehouses via graph-pattern matching on warehouse metadata. Bridges business analysts and complex schemas; generates executable SQL from natural-like queries, enabling exploration with high precision/recall. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 10720
Venue: VLDB
Year: 2012
Pagerank: 0.0001163751
Overall Rank: 1,214 | 91.68%
DOI: 10.14778/2350229.2350265

Incoming Non-self Citations Over Time

Authors

1. Lukas Blunschi (ETH Zurich)
2. Claudio Jossen (Credit Suisse AG)
3. Donald Kossmann (ETH Zurich)
4. Magdalini Mori (Credit Suisse AG)
5. Kurt Stockinger (Credit Suisse AG)

BibTeX Citation

@article{blunschi_vldb12,
        title = {{SODA: Generating SQL for Business Users}},
        author = {Blunschi, Lukas and Jossen, Claudio and Kossmann, Donald and Mori, Magdalini and Stockinger, Kurt},
        journal = {PVLDB},
        series = {{VLDB} '12},
        volume = {5},
        number = {10},
        pages = {932--943},
        doi = {10.14778/2350229.2350265},
        url = {https://doi.org/10.14778/2350229.2350265},
        year = {2012}
}

Incoming Citations (Sorted by Pagerank)

Showing 12 of 12 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
179	Constructing an Interactive Natural Language Interface for Relational Databases	2015	VLDB	0.00026838277
459	ATHENA: An Ontology-Driven System for Natural Language Querying over Relational Data Stores	2016	VLDB	0.00018101318
555	NaLIR: An Interactive Natural Language Interface for Querying Relational Databases	2014	SIGMOD	0.00016568053
1,262	Discovering Queries based on Example Tuples	2014	SIGMOD	0.00011427456
1,313	Reverse Engineering Complex Join Queries	2013	SIGMOD	0.00011186284
2,039	ScienceBenchmark: A Complex Real-World Benchmark for Evaluating Natural Language to SQL Systems	2024	VLDB	9.2721259e-05
2,079	DBPal: A Fully Pluggable NL2SQL Training Pipeline	2020	SIGMOD	9.2060425e-05
5,078	State of the Art and Open Challenges in Natural Language Interfaces to Data	2020	SIGMOD	6.3728705e-05
5,174	An In-Depth Benchmarking of Text-to-SQL Systems	2021	SIGMOD	6.3337874e-05
11,737	DBTagger: Multi-Task Learning for Keyword Mapping in NLIDBs Using Bi-Directional Recurrent Neural Networks	2021	VLDB	5.093636e-05
11,773	Analysis of Database Search Systems with THOR	2020	SIGMOD	5.093636e-05
11,785	An Ontology-Based Conversation System for Knowledge Bases	2020	SIGMOD	5.093636e-05

Outgoing Citations (Sorted by Pagerank)

Showing 9 of 9 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Rank	Cited Paper	Year	Venue	Pagerank
37	DISCOVER: Keyword Search in Relational Databases	2002	VLDB	0.00048017193
272	BLINKS: Ranked Keyword Searches on Graphs	2007	SIGMOD	0.00022695855
748	Effective Keyword Search in Relational Databases	2006	SIGMOD	0.00014381224
846	SnipSuggest: Context-Aware Autocompletion for SQL	2011	VLDB	0.00013658824
1,182	SQAK: Doing More with Keywords	2008	SIGMOD	0.00011778765
1,532	Summarizing Relational Databases	2009	VLDB	0.00010472227
1,555	Keyword Search in Databases: The Power of RDBMS	2009	SIGMOD	0.00010370683
1,719	The SDSS SkyServer - Public Access to the Sloan Digital Sky Survey Data	2002	SIGMOD	9.9268286e-05
3,651	Keyword Search over Relational Databases: A Metadata Approach	2011	SIGMOD	7.2249652e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	10,997	The HANA Native Query Engine for Lakehouse Systems	2025	VLDB
2	6,862	DBease: Making Databases User-friendly and Easily Accessible	2011	CIDR
3	13,718	CoDA: Interactive Cluster Based Concept Discovery	2010	VLDB
4	8,629	Efficacious Data Cube Exploration by Semantic Summarization and Compression	2003	VLDB
5	12,221	Mirror mirror on the wall, which query's fairest of them all?	2013	CIDR
6	12,586	SEDA: A System for Search, Exploration, Discovery, and Analysis of XML Data	2008	VLDB
7	12,734	Service Oriented Database Architecture: App Server-Lite?	2005	SIGMOD
8	2,784	Towards Keyword-Driven Analytical Processing	2007	SIGMOD
9	9,476	SODA: A Set of Fast Oblivious Algorithms in Distributed Secure Data Analytics	2023	VLDB
10	8,757	Search Driven Analysis of Heterogeneous XML Data	2009	CIDR