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: h7cff0de652e6de4c
Venue: VLDB
Year: 2012
Pagerank: 0.00011464151
Overall Rank: 1,217 | 91.85%
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
178	Constructing an Interactive Natural Language Interface for Relational Databases	2015	VLDB	0.00026568976
430	ATHENA: An Ontology-Driven System for Natural Language Querying over Relational Data Stores	2016	VLDB	0.00018415668
523	NaLIR: An Interactive Natural Language Interface for Querying Relational Databases	2014	SIGMOD	0.0001689006
1,275	Discovering Queries based on Example Tuples	2014	SIGMOD	0.00011213614
1,353	Reverse Engineering Complex Join Queries	2013	SIGMOD	0.00010913748
1,852	ScienceBenchmark: A Complex Real-World Benchmark for Evaluating Natural Language to SQL Systems	2024	VLDB	9.4935131e-05
1,999	DBPal: A Fully Pluggable NL2SQL Training Pipeline	2020	SIGMOD	9.2108564e-05
5,111	An In-Depth Benchmarking of Text-to-SQL Systems	2021	SIGMOD	6.2579636e-05
5,143	State of the Art and Open Challenges in Natural Language Interfaces to Data	2020	SIGMOD	6.2414745e-05
12,090	DBTagger: Multi-Task Learning for Keyword Mapping in NLIDBs Using Bi-Directional Recurrent Neural Networks	2021	VLDB	4.9605343e-05
12,125	Analysis of Database Search Systems with THOR	2020	SIGMOD	4.9605343e-05
12,137	An Ontology-Based Conversation System for Knowledge Bases	2020	SIGMOD	4.9605343e-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
38	DISCOVER: Keyword Search in Relational Databases	2002	VLDB	0.00047300197
272	BLINKS: Ranked Keyword Searches on Graphs	2007	SIGMOD	0.00022559588
777	Effective Keyword Search in Relational Databases	2006	SIGMOD	0.00014059304
864	SnipSuggest: Context-Aware Autocompletion for SQL	2011	VLDB	0.00013358173
1,177	SQAK: Doing More with Keywords	2008	SIGMOD	0.00011610316
1,505	Keyword Search in Databases: The Power of RDBMS	2009	SIGMOD	0.00010424285
1,559	Summarizing Relational Databases	2009	VLDB	0.00010220719
1,749	The SDSS SkyServer - Public Access to the Sloan Digital Sky Survey Data	2002	SIGMOD	9.7167373e-05
3,730	Keyword Search over Relational Databases: A Metadata Approach	2011	SIGMOD	7.0448398e-05

Semantically Similar Papers

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