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.00011469979
Overall Rank: 1,221 | 91.80%
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
180	Constructing an Interactive Natural Language Interface for Relational Databases	2015	VLDB	0.00026541021
439	ATHENA: An Ontology-Driven System for Natural Language Querying over Relational Data Stores	2016	VLDB	0.00018253425
536	NaLIR: An Interactive Natural Language Interface for Querying Relational Databases	2014	SIGMOD	0.00016774383
1,273	Discovering Queries based on Example Tuples	2014	SIGMOD	0.00011243661
1,345	Reverse Engineering Complex Join Queries	2013	SIGMOD	0.00010948072
1,867	ScienceBenchmark: A Complex Real-World Benchmark for Evaluating Natural Language to SQL Systems	2024	VLDB	9.4771545e-05
2,014	DBPal: A Fully Pluggable NL2SQL Training Pipeline	2020	SIGMOD	9.185301e-05
5,123	State of the Art and Open Challenges in Natural Language Interfaces to Data	2020	SIGMOD	6.2621573e-05
5,156	An In-Depth Benchmarking of Text-to-SQL Systems	2021	SIGMOD	6.2475361e-05
12,046	DBTagger: Multi-Task Learning for Keyword Mapping in NLIDBs Using Bi-Directional Recurrent Neural Networks	2021	VLDB	4.9769913e-05
12,081	Analysis of Database Search Systems with THOR	2020	SIGMOD	4.9769913e-05
12,093	An Ontology-Based Conversation System for Knowledge Bases	2020	SIGMOD	4.9769913e-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.00047373961
270	BLINKS: Ranked Keyword Searches on Graphs	2007	SIGMOD	0.00022588961
770	Effective Keyword Search in Relational Databases	2006	SIGMOD	0.00014099513
862	SnipSuggest: Context-Aware Autocompletion for SQL	2011	VLDB	0.0001339689
1,183	SQAK: Doing More with Keywords	2008	SIGMOD	0.0001161406
1,501	Keyword Search in Databases: The Power of RDBMS	2009	SIGMOD	0.00010456517
1,558	Summarizing Relational Databases	2009	VLDB	0.00010252433
1,741	The SDSS SkyServer - Public Access to the Sloan Digital Sky Survey Data	2002	SIGMOD	9.7438815e-05
3,730	Keyword Search over Relational Databases: A Metadata Approach	2011	SIGMOD	7.0663712e-05

Semantically Similar Papers

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