Not logged in.
Quick Search - Contribution
Contribution Details
Type | Journal Article |
Scope | Discipline-based scholarship |
Title | SODA: Generating SQL for business users |
Organization Unit | |
Authors |
|
Item Subtype | Original Work |
Refereed | Yes |
Status | Published in final form |
Language |
|
Journal Title | Proceedings of the VLDB Endowment |
Publisher | Association for Computing Machinery |
Geographical Reach | international |
ISSN | 2150-8097 |
Volume | 5 |
Number | 10 |
Page Range | 932 - 943 |
Date | 2012 |
Abstract Text | The purpose of data warehouses is to enable business analysts tomake better decisions. Over the years the technology has maturedand data warehouses have become extremely successful. Asa consequence, more and more data has been added to the datawarehouses 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 apoor match for non tech-savvy business analysts who need answersto ad-hoc queries that were not anticipated.This paper describes the design, implementation, and experienceof the SODA system (Search over DAta Warehouse). SODAbridges the gap between the business needs of analysts and thetechnical complexity of current data warehouses. SODA enables aGoogle-like search experience for data warehouses by taking keywordqueries of business users and automatically generating executableSQL. The key idea is to use a graph pattern matching algorithmthat uses the metadata model of the data warehouse. Ourresults with real data from a global player in the financial servicesindustry show that SODA produces queries with high precision andrecall, and makes it much easier for business users to interactivelyexplore highly-complex data warehouses. |
Related URLs | |
Digital Object Identifier | 10.14778/2336664.2336667 |
Other Identification Number | merlin-id:7863 |
Export |
BibTeX
EP3 XML (ZORA) |