Database systems with hybrid data management support, referred to as HTAP or HOAP architectures, have gained popularity for performing near-real-time data analytics. Such systems first emerged in the relational world, and the CH-benCHmark (CH) was proposed in 2011 to evaluate such relational systems. A decade later, with NoSQL database systems gaining traction for new application development, we proposed a first document-oriented variant of CH – called CH2 – that was aimed at evaluating hybrid data platforms in the document database space. Here, we introduce CH2++, a major revision of CH2 that is significantly more suitable for evaluating systems that support JSON analytics. Like CH and CH2, this new CH2++ benchmark borrows from and extends both TPC-C and TPC-H. Differences from CH2 include a much more document-oriented schema, the inclusion of additional fields to exercise analytical systems’ column-oriented features, and a corresponding JSON “do over” of the CH2 queries. The paper also includes preliminary performance isolation and scaling results from running CH2++ against Capella Operational and Capella Columnar, which are Couchbase’s DBaaS cloud service offerings. The results highlight the value of CH2++ for evaluating JSON-targeted HOAP and HTAP platforms.

错误:搜索内容不能为空,请输入英文关键词
错误:关键词超出字数限制,请精简
高级检索

CH2++: New HOAP for Benchmarking JSON Data Analytics

  • M. J. Carey,
  • V. Sarathy,
  • D. Nagy,
  • B.-C. Wang,
  • K. Murthy,
  • M. Muralikrishna,
  • P. Gupta,
  • T. Westmann

摘要

Database systems with hybrid data management support, referred to as HTAP or HOAP architectures, have gained popularity for performing near-real-time data analytics. Such systems first emerged in the relational world, and the CH-benCHmark (CH) was proposed in 2011 to evaluate such relational systems. A decade later, with NoSQL database systems gaining traction for new application development, we proposed a first document-oriented variant of CH – called CH2 – that was aimed at evaluating hybrid data platforms in the document database space. Here, we introduce CH2++, a major revision of CH2 that is significantly more suitable for evaluating systems that support JSON analytics. Like CH and CH2, this new CH2++ benchmark borrows from and extends both TPC-C and TPC-H. Differences from CH2 include a much more document-oriented schema, the inclusion of additional fields to exercise analytical systems’ column-oriented features, and a corresponding JSON “do over” of the CH2 queries. The paper also includes preliminary performance isolation and scaling results from running CH2++ against Capella Operational and Capella Columnar, which are Couchbase’s DBaaS cloud service offerings. The results highlight the value of CH2++ for evaluating JSON-targeted HOAP and HTAP platforms.