TPC BENCHMARKTM H

1 TPC BENCHMARKTM H. (Decision Support). Standard Specification Revision Transaction Processing Performance Council (TPC). Presidio of San Francisco Building 572B Ruger St. (surface). Box 29920 (mail). San Francisco, CA 94129-0920. Voice:415-561-6272. Fax:415-561-6120. Email: 1993 - 2017 Transaction Processing Performance Council TPC BENCHMARKTM H Standard Specification Revision Page 1. Acknowledgments The TPC acknowledges the work and contributions of the TPC-D subcommittee member companies in developing version 2 of the TPC-D specification which formed the basis for TPC-H version 1.

2 The subcommittee included representatives from Compaq, Data General, Dell, EMC, HP, IBM, Informix, Microsoft, NCR, Oracle, Sequent, SGI, Sun, Sybase, and Unisys. The TPC also acknowledges the contribution of Jack Stephens, consultant to the TPC-D subcommittee, for his work on the benchmark specification and DBGEN development. TPC Membership (as of April 2017). Full Members Associate Members TPC BENCHMARKTM H Standard Specification Revision Page 2. Document History Date version Description 26 February 1999 Draft Mail ballot draft for Standard Specification 24 June 1999 Revision First minor revision of the Specification 25 April 2002 Revision Clarification about Primary Keys 12 July 2002 Revision Additions for EOL of hardware in 15 July 2002 Revision Mail ballot draft 3 year maintenance pricing 14 August 2003 Revision Adding scale factors 30TB and 100TB.

3 29 June 2005 Revision Adding Pricing Specification 11 August 2005 Revision Changing pricing precision to cents and processor definition 23 June 2006 Revision Adding reference data set and audit requirements to verify populated database, effect of update data and qgen substitution parameters. Scale factors larger than 10,000 are required to use this version . 10 July 2006 Revision dbgen bug fixes in parallel data generation, updates to reference data set/qualification output, modified audit rules and updated executive summary example.

4 26 October 2006 Revision Added Clause about software license pricing, removed Clause about 8 hour log requirement and updated executive summary example in Appendix E. 14 June 2006 Revision Editorial correction in Clause Clarification of Clause 28 February 2008 Revision Change substr into substring in Clause , update of membership list, TPC address and copyright statement 17 April 2008 Revision Incorporate BUG fix 595 of qgen 11 September Revision Add wording to allow substitutions in Clause Modify clauses , 2008 , and to refer to pricing specification.

5 Update TPC. member companies. 17 September Revision Add Clause to require wording for memory-to-scale factor 2009 ratio in ES. Removed references to RAID and added data redundancy to Clauses , , , , and Editorial corrections. Update TPC member companies. 11 February 2010 Revision Adapted necessary modifications required by Energy Specification. Modified Clause 8 to require electronic version of FDR. Added vendor specific INCLDUES into dbgen/qgen. Modified Clause and Updated TPC member companies. Included editorial changes from FogBugz 217, 218, 219.

6 TPC BENCHMARKTM H Standard Specification Revision Page 3. 29 April 2010 Revision Added clause to the auditor check list (power off SUT as part of durability testing). Added comment after clause (precision). Modified clause points 2 and 3 to clarify ACID testing. Clarification of rounding with a new definitions section 10: Clarification of partitioning by date (clause ). Require query output to be put into the supporting file archive (clause ). 25 June 2010 Revision Fixed numerous bad cross references and editorial edits (fogbugz 243.)

7 & 245). Clarify primary and foreign keys as constraints and add them to the global definitions section. Fix bugs 252 by simplifying the description of string lengths generated by dbgen. Clarify references to the refresh stream for bug 254. Added requirement to split electronic Supporting Files Archive into 3 separate zip files for ease of download. 11 November 2010 Revision Clarified the procedure to follow if problems with DBGen or QGen are found (Fogbugz 259). Reorganized the query definitions to show only a sample output row and reorganized the clause numbering.

8 Regenerated the answer set files for easier comparison and to correct errors (fogbugz 293). Added an auditor checklist item to validate the qualification results (fogbugz 302). Fixed a distribution issue in DBGen (software only) (fogbugz 301), which necessitated new references data and answer set files. Restored column L_TAX to the description for table Lineitem in Clause (fogbugz 358). Fixed a bad clause reference in clause that was targeting and should be (Fogbugz 360). 11 February 2011 Revision Editorial fix of clause references (Fogbugz 370).

9 Update membership list and table of icons (Fogbugz 391). Augment Clause about precision of query output (Fogbugz 359). Editorial clarification in Clause (Fogbugz 421). Replace/update Executive Summary examples in Appendix E (Fogbugz 253). Clarify/update requirements relating to data generation and loading phases in Clause (Fogbugz 419). 7 April 2011 Revision Increment point- version number to align with DBGEN release. No editorial change. 16 June 2011 Revision Align definition of database population (for S_NAME, P_MFGR, P_BRAND, C_NAME and O_CLERK) with DBGen (Fogbugz 463, 464 and 465).

10 18 November 2011 Revision Correct description of Q19 to match SQL. Revise sample Executive Summary. 13 April 2012 Revision Correction for FogBugz entry 536: change bullet 5 in Clause from L_RECEIPTDATE = O_ORDERDATE + random value [1 .. 30] to L_RECEIPTDATE = L_SHIPDATE + random value [1 .. 30]. FogBugz 279: Mandate disclosure of user documentation 7 February 2013 Revision FogBugz 512: Define GUI and requirements around disclosure in Clause FogBugz 604: Reference wrong in FogBugz 606: DBgen bug - removing separators FogBugz 613: Code fix for Q4 wrong substitution parameter 20 June 2013 Revision generation.