9.1.0 Performance Test

Purpose

As a cloud-based data warehouse designed for OLAP applications, GaussDB(DWS) supports real-time processing and can handle petabytes of data with high concurrency. It provides two billing options: pay-per-use and yearly/monthly.

We plan to conduct a performance test on the Huawei Cloud infrastructure, using the TPC-H and TPC-DS benchmarking standards. This test will compare the performance of GaussDB(DWS) 9.1.0 and 8.3.0 versions, with the same hardware configurations and data scales. Moreover, the SSB-Flat benchmarking standard was utilized to compare the performance of GaussDB(DWS) 9.1.0 and the open source OLAP product, ClickHouse. The performance test will be conducted in November 2024.

TPC-H

TPC-H is developed and released by the Transaction Processing Performance Council to evaluate the analysis and query capabilities of databases. TPC-H queries include eight data tables and 22 complex SQL queries. Most queries include multiple joins, subqueries, and GROUP BY statements.

TPC-DS

Created by the Transaction Processing Performance Council, TPC-DS is a benchmark for decision support system tests and is used to measure the analytical performance of big data products. The TPC-DS query contains 24 tables and 99 query test statements.

SSB

The SSB is a benchmark test method for evaluating database system performance, which is widely used in academia and industry. It can compare the performance of different data warehouses in processing star model queries, helping database administrators and decision makers select the most suitable database system. The star schema model in SSB can be flattened and turned into a wide table, following the practices of the OLAP industry. This can also be modified into a single table testing benchmark called SSB Flat.