SODA: Generating SQL for Business Users
Lukas Blunschi, Claudio Jossen, Donald Kossman, Magdalini Mori, Kurt, Stockinger

TL;DR
SODA provides a system that allows business users to generate SQL queries from keyword searches, simplifying interaction with complex data warehouses and improving accessibility for non-technical users.
Contribution
This paper introduces SODA, a novel system that uses graph pattern matching to translate keyword queries into executable SQL, enhancing data warehouse usability for business analysts.
Findings
High precision and recall in query generation
Improved ease of data exploration for business users
Effective handling of complex data warehouse schemas
Abstract
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. 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…
Peer Reviews
No public reviews on file for this paper yet. If you reviewed it on a platform where reviews are public (OpenReview, ICLR, NeurIPS, ICML), you can paste yours below so the community can read it here.
Videos
No videos yet. Explain this paper in a talk, walkthrough, or lecture? Add one.
Taxonomy
TopicsAdvanced Database Systems and Queries · Semantic Web and Ontologies · Data Quality and Management
