arXivDaily arXiv每日学术速递 周一至周五更新
arXiv 1207.0134cs.DB
收藏

SODA:为业务用户生成SQL

SODA: Generating SQL for Business Users

Lukas Blunschi, Claudio Jossen, Donald Kossman, Magdalini Mori, Kurt Stockinger

摘要:

数据仓库的目的是使业务分析师能够做出更好的决策。多年来,技术已经成熟,数据仓库已经非常成功。因此,越来越多的数据被添加到数据仓库中,并且它们的模式变得越来越复杂。这些系统仍然工作得很好,以生成预先录制的报告。然而,由于它们目前的复杂性,它们往往不适合那些不精通技术的业务分析师,因为他们需要对没有预料到的特定查询的答案。本文介绍了SODA系统(Search over数据仓库)的设计、实现和经验。SODA弥合了分析师的业务需求与当前数据仓库的技术复杂性之间的差距。SODA通过获取业务用户的关键字查询并自动生成可执行的SQL,为数据仓库提供类似Google的搜索体验。其关键思想是使用一种图形模式匹配算法,该算法使用数据仓库的元数据模型。我们的研究结果表明,SODA产生的查询具有很高的精度和召回率,并使业务用户更容易交互式地探索高度复杂的数据仓库。

英文摘要:

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 automatically generating executable SQL. The key idea is to use a graph pattern matching algorithm that uses the metadata model of the data warehouse. Our results with real data from a global player in the financial services industry show that SODA produces queries with high precision and recall, and makes it much easier for business users to interactively explore highly-complex data warehouses.

机构、总结、中文摘要均由AI分析而来,可能存在错误,请以论文正文为准。

↑