A query is an ordered set of one or more valid SQL statements resulting from applying the required parameter substitutions to a given query template.
The order of the SQL statements is defined in the query template.
The mechanism used to submit queries to the SUT and to measure their execution time is called a driver.
They model long running and multi-part queries where the DBA can assume that the data processing system is quiescent for queries during any particular period
The users and queries modeled by the benchmark exhibit the following characteristics:
Each query is described by the following components:
Comment:
Query class are divided by the schema.
Queries accessing the ad-hoc part constitute the ad-hoc query set while the queries accessing the reporting part are considered the reporting queries.
Notes:
TPC-DS has defined four broad classes of queries that characterize most decision support queries: