DBAuditor, which is a DBMS performance measurement program, is required for the TTA. Each DBMS that vendors brought is
monitored and tested by this program which measures factors as query per hour, disk i/o usage,
memory usage and process usage with the generated data based on TPC-H. Actually, the requirement
of this program is in four parts. First, data and query based on TCP-H should be generated automatically.
Second, each activity and DBMS's status should be tested and monitored. Third, performance measurement
report should be generated automatically in various required formats such as excel file, doc file and so on.
Fourth, performance measurement project should be managed by this tool.
TPC-C provides a conceptual model for the benchmark; underlying components are typical of any OLTP system. Workload consists of five transaction types. Five OLTP transactions are as follows:
- New-order: enter a new order from a customer
- Payment: update customer balance to reflect a payment
- Delivery: deliver orders (done as a batch transaction)
- Order-status: retrieve status of customer's most recent order
- Stock-level: monitor warehouse inventory
The TPC Benchmark¢âH (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 illustrated decision support systems that examine large
volumes of data, execute queries with a high degree of complexity, and
give answers to critical business questions.
The client of the project is an internal department in TTA
Last Updated: 12/19/2006