TPC-DS - Query Template

> (Data|State) Management and Processing > (Data Type|Data Structure) > (Relation|Table) - Tabular data > Relation - Database Benchmark > TPC - DS

1 - About

A query template is translated by dsqgen into fully functional SQL, which is known as executable query text (EQT).

The query templates are primarily phrased in compliance with SQL1999 core (with OLAP amendments).

Advertising

3 - Definition

A template includes the following, non-standard additions:

  • They are annotated, where necessary, to specify the number of rows to be returned
  • They include substitution tags that, in conjunction with dsqgen, allow a single template to generate a large number of syntactically distinct queries, which are functionally equivalent

4 - Location

See tpcds_home\query_templates/*.tpl