Sigma Worksheet:OLAP的交互式构造
Sigma Worksheet: Interactive Construction of OLAP Queries
摘要:
新一代云数据仓库(CDW)将大量数据和计算能力更接近企业用户。直接访问仓库数据,交互式分析和大规模探索数据的能力可以使用户能够改善他们的决策周期。然而,CDW中用于分析数据的现有工具要么局限于临时转换,要么难以用于企业中最大的用户群--业务用户。在这里,我们介绍了西格玛,一个新的交互式系统,使用户能够轻松地执行特设的可视化分析的数据在CDW的规模。为此,Sigma Siemens提供了一个可访问的电子表格式界面,通过直接操作进行数据分析。Sigma SQL基于SQL的多功能性和表现力,通过用户在这个熟悉的界面上的交互动态地构造匹配的SQL查询。Sigma XSLT直接在CDW上执行构造查询,利用了新一代CDW的优越特性,包括可伸缩性。为了评估Sigma的可扩展性,我们首先通过两个现实生活中的用例,队列分析和会话化来展示它的表现力。然后,我们使用TPC-H基准测试的一组实验来衡量的性能的查询生成的查询。结果表明,我们编译的SQL查询的性能是可比的基准的参考查询。最后,为了评估西格玛咨询在部署中的有用性,我们通过一个100人的调查,然后是一个半结构化的访谈研究与70名参与者的反馈。我们发现,Sigma SDK更易于使用和学习,提高了用户的生产力。我们的研究结果还表明,西格玛咨询公司可以通过在数据分析的各个步骤为用户提供指导,进一步改善用户体验。
英文摘要:
The new generation of cloud data warehouses (CDWs) brings large amounts of data and compute power closer to users in enterprises. The ability to directly access the warehouse data, interactively analyze and explore it at scale can empower users to improve their decision making cycles. However, existing tools for analyzing data in CDWs are either limited in ad-hoc transformations or difficult to use for business users, the largest user segment in enterprises. Here we introduce Sigma Worksheet, a new interactive system that enables users to easily perform ad-hoc visual analysis of data in CDWs at scale. For this, Sigma Worksheet provides an accessible spreadsheet-like interface for data analysis through direct manipulation. Sigma Worksheet dynamically constructs matching SQL queries from user interactions on this familiar interface, building on the versatility and expressivity of SQL. Sigma Worksheet executes constructed queries directly on CDWs, leveraging the superior characteristics of the new generation CDWs, including scalability. To evaluate Sigma Worksheet, we first demonstrate its expressivity through two real life use cases, cohort analysis and sessionization. We then measure the performance of the Worksheet generated queries with a set of experiments using the TPC-H benchmark. Results show the performance of our compiled SQL queries is comparable to that of the reference queries of the benchmark. Finally, to assess the usefulness of Sigma Worksheet in deployment, we elicit feedback through a 100-person survey followed by a semi-structured interview study with 70 participants. We find that Sigma Worksheet is easier to use and learn, improving the productivity of users. Our findings also suggest Sigma Worksheet can further improve user experience by providing guidance to users at various steps of data analysis.
机构、总结、中文摘要均由AI分析而来,可能存在错误,请以论文正文为准。