Data-thirsty business analysts need SODA: search over data warehouse

Authors:
Lukas Blunschi;Claudio Jossen;Donald Kossmann;Magdalini Mori;Kurt Stockinger
Affiliations:
ETH Zurich, Zurich, Switzerland;Credit Suisse AG, Zurich, Switzerland;ETH Zurich, Zurich, Switzerland;Credit Suisse AG, Zurich, Switzerland;Credit Suisse AG, Zurich, Switzerland
Venue:
Proceedings of the 20th ACM international conference on Information and knowledge management
Year:
2011

Citing 6
Cited 1

Keyword Searching and Browsing in Databases using BANKS

ICDE '02 Proceedings of the 18th International Conference on Data Engineering
Indexing Relational Database Content Offline for Efficient Keyword-Based Search

IDEAS '05 Proceedings of the 9th International Database Engineering & Application Symposium
Spark: top-k keyword query in relational databases

Proceedings of the 2007 ACM SIGMOD international conference on Management of data
BLINKS: ranked keyword searches on graphs

Proceedings of the 2007 ACM SIGMOD international conference on Management of data
Discover: keyword search in relational databases

VLDB '02 Proceedings of the 28th international conference on Very Large Data Bases
Keyword search over relational databases: a metadata approach

Proceedings of the 2011 ACM SIGMOD International Conference on Management of data

SODA: generating SQL for business users

Proceedings of the VLDB Endowment

Quantified Score

Hi-index	0.00

Visualization

Abstract

Querying large data warehouses is very hard for non-tech savvy business users. Deep technical knowledge of both SQL as well as the schema of the database is required in order to build correct queries and to come up with new business insights. In this paper we introduce a novel system called SODA (Search Over DAta Warehouse) that bridges the gap between the business world and the IT world by enabling extended keyword search in a data warehouse. SODA uses metadata information, DBpedia entries as well as base data to generate SQL to allow intuitive exploration of the data. The process of query classification, query graph generation and SQL generation is visualized to provide the analysts with information on how the query results are produced. Experiments with real data of a global financial institution comprising around 300 tables showed promising results.