DBT-3 Test

DBT-3
DBT-3 test consists of the Load test followed by the Performance Test

Load Test
The Load test begins with the creation of the database tables and includes all the activity required to bring the database to the stage immediately before the Performance test

Performance Test
The Performance test includes one execution of Power test and one execution of Throughput test.

Power Test
The Power test is desinged to measure the raw query execution power. It starts with refresh function 1(inserts), followed by one query stream and refresh function 2(deletes). There is one active user connected to the database during the test.

Throughput Test
The Throughput test is desinged to measure the ability of the system to process the most queries in multi-user envirnment. Multiple query streams and refresh streams are executed simultaneously

Query Stream
Query stream is a sequential execution of a set of the twenty-two queries submitted by a single user

Refresh Stream
Refresh Stream is the sequential execution of an integral number of pairs of refresh functions

Refresh Function 1
Refresh Function 1 adds new sales information to the database.

Refresh Function 2
Refresh Function 2 removes old sales information from the database.

Queries
There are twenty-two queries designed to answer questions representing complex business analysis applications

Query Porcessing Power
The results of the power test are used to compute DBT-3 Query Porcessing Power at the chosen database size. The unit of the power@size is 'queries per hour'. The higher the Query Processing Power, the better the performance.

Throughput Numerical Quantity
The results of the throughput test are used to compute DBT-3 Througput at the chosen database size. The units of throughput@size is 'queries per hour'. The higher the Throughput Numerical Quantity, the better the performance.

Composite
The numerical quantities DBT-3 Power and Throughtput are combined to form the DBT-3 composite-query-per-hour performance metrics. The units of throughput@size is 'queries per hour'. The higher the Composite number, the better the performance.