Project Description

The TPC Benchmark (TPC-H) is a decision support benchmark. It consists of a suite of business oriented ad-hoc queries and concurrent data modifications. The queries and the data populating the database have been chosen to have broad industry-wide relevance. This benchmark illustrates decision support systems that examine large volumes of data, execute queries with a high degree of complexity, and give answers to critical business questions.

TTA(Telecommunications Technology Association) wants to have a tool to satisfy the requirements that the TPC-H standard provides. Furthermore, the tool should be able to accept not only the schema defined by TPC-H, but also various kinds of DB schemas that testers will define.

The performance metric reported by the tool is the Query-per-Hour Performance Metric (QphH@Size), which reflects multiple aspects of the capability of the system to process queries. These aspects include the selected database size against which the queries are executed, the query processing power when queries are submitted by a single stream, and the query throughput when queries are submitted by multiple concurrent users. In addition, the status of system resources usage is reported: CPU usage, memory usage, and disk I/O.