Database Benchmarking for Supporting Real-Time Interactive Querying of Large Data
Database Benchmarking for Supporting Real-Time Interactive Querying of Large Data
复制标题
DOI：
10.1145/3318464.3389732
复制
发表时间：
2020-05
期刊：
影响因子：
--
通讯作者：
L. Battle;P. Eichmann;M. Angelini;T. Catarci;G. Santucci;Yukun Zheng;Carsten Binnig;Jean-Daniel Fekete;Dominik Moritz
中科院分区：
文献类型：
--
作者：
L. Battle;P. Eichmann;M. Angelini;T. Catarci;G. Santucci;Yukun Zheng;Carsten Binnig;Jean-Daniel Fekete;Dominik Moritz
在本文中，我们提出了一个新的基准测试，以验证数据库系统对于交互式可视化工作负载的适用性。尽管存在在交互式数据探索工作负载上评估数据库系统的建议，但没有一个依赖于数据库基准测试的真实用户痕迹。为此，我们的长期目标是收集代表具有不同探索特征的工作负载的用户痕迹。在本文中，我们提出了一个最初的基准测试，该基准专注于“ CrossFilter”式应用程序，该应用程序是数据探索的流行交互类型，并且是测试数据库系统性能的特别苛刻的情况。 We make our benchmark materials, including input datasets, interaction sequences, corresponding SQL queries, and analysis code, freely available as a community resource, to foster further research in this area: https://osf.io/9xerb/?view_only=81de1a3f99d04529b6b173a3bd5b4d23 。
In this paper, we present a new benchmark to validate the suitability of database systems for interactive visualization workloads. While there exist proposals for evaluating database systems on interactive data exploration workloads, none rely on real user traces for database benchmarking. To this end, our long term goal is to collect user traces that represent workloads with different exploration characteristics. In this paper, we present an initial benchmark that focuses on "crossfilter"-style applications, which are a popular interaction type for data exploration and a particularly demanding scenario for testing database system performance. We make our benchmark materials, including input datasets, interaction sequences, corresponding SQL queries, and analysis code, freely available as a community resource, to foster further research in this area: https://osf.io/9xerb/?view_only=81de1a3f99d04529b6b173a3bd5b4d23.