CH2: A Hybrid Operational/Analytical Processing Benchmark for NoSQL
CH2: A Hybrid Operational/Analytical Processing Benchmark for NoSQL
复制标题
CH2：NoSQL 的混合操作/分析处理基准
DOI：
10.1007/978-3-030-94437-7_5
复制
发表时间：
2022
期刊：
影响因子：
--
通讯作者：
Westmann, T.
中科院分区：
文献类型：
--
作者：
Carey, M.;Lychagin, D.;Muralikrishna, M.;Sarawathy, V;Westmann, T.
具有混合数据管理支持的数据库系统（称为HTAP或HOAP体系结构）越来越受欢迎。它们首次出现在关系领域，并于2011年提出了CH- benchmark （CH）来评估此类关系系统。今天，人们发现NoSQL数据库系统在新的应用程序中得到越来越多的采用。在本文中，我们介绍了CH2，一个以CH为起点创建的新基准，旨在评估文档数据管理领域的混合数据平台。与CH一样，CH2借鉴并扩展了TPC-C和TPC-H。与CH的不同之处包括面向文档的模式、创建类似TPC-H的历史记录的数据生成模式，以及更符合TPC-H的CH查询的“重做”。本文详细介绍了我们在CH中发现的缺点，CH2的设计，以及在Couchbase Server 7.0（其查询和分析服务为NoSQL数据提供HOAP支持）上运行CH2的初步结果。结果提供了对Couchbase Server 7.0的性能隔离和水平可伸缩性属性的深入了解，并展示了CH2在评估此类平台时的有效性。
Database systems with hybrid data management support, referred to as HTAP or HOAP architectures, are gaining popularity. These first appeared in the relational world, and the CH-benCHmark (CH) was proposed in 2011 to evaluate such relational systems. Today, one finds NoSQL database systems gaining adoption for new applications. In this paper we present CH2, a new benchmark – created with CH as its starting point – aimed at evaluating hybrid data platforms in the document data management world. Like CH, CH2 borrows from and extends both TPC-C and TPC-H. Differences from CH include a document-oriented schema, a data generation scheme that creates a TPC-H-like history, and a “do over” of the CH queries that is more in line with TPC-H. This paper details shortcomings that we uncovered in CH, the design of CH2, and preliminary results from running CH2 against Couchbase Server 7.0 (whose Query and Analytics services provide HOAP support for NoSQL data). The results provide insight into the performance isolation and horizontal scalability properties of Couchbase Server 7.0 as well as demonstrating the efficacy of CH2 for evaluating such platforms.