TPC BENCHMARK (TM) H
Описание файла
PDF-файл из архива "TPC BENCHMARK (TM) H", который расположен в категории "". Всё это находится в предмете "структурное проектирование автоматизированных систем обработки информации и управления" из 10 семестр (2 семестр магистратуры), которые можно найти в файловом архиве МГТУ им. Н.Э.Баумана. Не смотря на прямую связь этого архива с МГТУ им. Н.Э.Баумана, его также можно найти и в других разделах. Архив можно найти в разделе "книги и методические указания", в предмете "структурное проектирование автоматизированных систем обработки информации и управления" в общих файлах.
Просмотр PDF-файла онлайн
Текст из PDF
TPC BENCHMARKTM H(Decision Support)Standard SpecificationRevision 2.17.1Transaction Processing Performance Council (TPC)Presidio of San FranciscoBuilding 572B Ruger St. (surface)P.O. Box 29920 (mail)San Francisco, CA 94129-0920Voice:415-561-6272Fax:415-561-6120Email: webmaster@tpc.org© 1993 - 2014 Transaction Processing Performance CouncilTPC BenchmarkTM H Standard Specification Revision 2.17.1Page 1AcknowledgmentsThe TPC acknowledges the work and contributions of the TPC-D subcommittee member companies in developingVersion 2 of the TPC-D specification which formed the basis for TPC-H Version 1. The subcommittee includedrepresentatives 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 theTPC-D subcommittee, for his work on the benchmark specification and DBGEN development.TPC Membership(as of June 2013)Full MembersAssociate MembersTPC BenchmarkTM H Standard Specification Revision 2.17.1Page 2Document HistoryDateVersionDescription26 February 1999Draft 1.0.0Mail ballot draft for Standard Specification24 June 1999Revision 1.1.0First minor revision of the Specification25 April 2002Revision 1.4.0Clarification about Primary Keys12 July 2002Revision 1.5.0Additions for EOL of hardware in 8.615 July 2002Revision 2.0.0Mail ballot draft 3 year maintenance pricing14 August 2003Revision 2.1.0Adding scale factors 30TB and 100TB29 June 2005Revision 2.2.0Adding Pricing Specification 1.0.011 August 2005Revision 2.3.0Changing pricing precision to cents and processor definition23 June 2006Revision 2.4.0Adding reference data set and audit requirements to verify populateddatabase, effect of update data and qgen substitution parameters.Scale factors larger than 10,000 are required to use this version.10 July 2006Revision 2.5.0dbgen bug fixes in parallel data generation, updates to reference dataset/qualification output, modified audit rules and updated executivesummary example.26 October 2006Revision 2.6.0Added Clause 7.2.3.1 about software license pricing, removed Clause7.1.3.3 about 8 hour log requirement and updated executive summaryexample in Appendix E14 June 2006Revision 2.6.1Editorial correction in Clause 2.1.3.3.
Clarification of Clause 9.2.4.528 February 2008Revision 2.6.2Change substr into substring in Clause 2.25.2, update of membershiplist, TPC address and copyright statement17 April 2008Revision 2.7.0Incorporate BUG fix 595 of qgen11 September2008Revision 2.8.0Add wording to allow substitutions in Clause 7.2. Modify clauses 5.4,5.4.6, 8.4.2.2 and 9.2.6.1 to refer to pricing specification. Update TPCmember companies.17 September2009Revision 2.9.0Add Clause 8.3.5.10 to require wording for memory-to-scale factorratio in ES.
Removed references to RAID and added data redundancyto Clauses 3.1.4, 4.3.2, 4.3.6, 8.3.5.4, and 8.4.2.4. Editorialcorrections. Update TPC member companies.11 February 2010Revision 2.10.0Adapted necessary modifications required by Energy Specification.Modified Clause 8 to require electronic version of FDR.
Added vendorspecific INCLDUES into dbgen/qgen. Modified Clause 1.5.4 and2.13.3. Updated TPC member companies. Included editorial changesfrom FogBugz 217, 218, 219.TPC BenchmarkTM H Standard Specification Revision 2.17.1Page 329 April 2010Revision 2.11.0Added clause 9.2.3.3 to the auditor check list (power off SUT as partof durability testing). Added comment after clause 2.1.3.5 (precision).Modified clause 3.5.4 points 2 and 3 to clarify ACID testing.Clarification of rounding with a new definitions section 10:Clarification of partitioning by date (clause 1.5.4).
Require queryoutput to be put into the supporting file archive (clause 8.3.4.3 ).25 June 2010Revision 2.12.0Fixed numerous bad cross references and editorial edits (fogbugz 243& 245). Clarify primary and foreign keys as constraints and add themto the global definitions section. Fix bugs 252 by simplifying thedescription of string lengths generated by dbgen. Clarify references tothe refresh stream for bug 254. Added requirement to split electronicSupporting Files Archive into 3 separate zip files for ease ofdownload.11 November 2010Revision 2.13.0Clarified the procedure to follow if problems with DBGen or QGenare found (Fogbugz 259). Reorganized the query definitions to showonly a sample output row and reorganized the clause numbering.Regenerated the answer set files for easier comparison and to correcterrors (fogbugz 293).
Added an auditor checklist item to validate thequalification results (fogbugz 302). Fixed a distribution issue inDBGen (software only) (fogbugz 301), which necessitated newreferences data and answer set files. Restored column L_TAX to thedescription for table Lineitem in Clause 1.4.1 (fogbugz 358). Fixed abad clause reference in clause 9.1.4 that was targeting 1.5.7 and shouldbe 1.5.6 (Fogbugz 360).11 February 2011Revision 2.14.0Editorial fix of clause references (Fogbugz 370). Update membershiplist and table of icons (Fogbugz 391). Augment Clause 2.1.3.5 aboutprecision of query output (Fogbugz 359). Editorial clarification inClause 1.4.2 (Fogbugz 421).
Replace/update Executive Summaryexamples in Appendix E (Fogbugz 253). Clarify/update requirementsrelating to data generation and loading phases in Clause 4.3 (Fogbugz419).7 April 2011Revision 2.14.1Increment point-version number to align with DBGEN release. Noeditorial change.16 June 2011Revision 2.14.2Align definition of database population (for S_NAME, P_MFGR,P_BRAND, C_NAME and O_CLERK) with DBGen (Fogbugz 463,464 and 465)18 November 2011Revision 2.14.3Correct description of Q19 to match SQL. Revise sample ExecutiveSummary.13 April 2012Revision 2.14.4Correction for FogBugz entry 536: change bullet 5 in Clause 4.2.3from L_RECEIPTDATE = O_ORDERDATE + random value [1 ..30] to L_RECEIPTDATE = L_SHIPDATE + random value [1 .. 30].7 February 2013Revision 2.15.020 June 2013Revision 2.16.0FogBugz 279: Mandate disclosure of user documentationFogBugz 512: Define GUI and requirements around disclosure inClause 8.3FogBugz 604: Reference wrong in 2.5.3.1FogBugz 606: DBgen bug - removing separatorsFogBugz 613: Code fix for Q4 wrong substitution parametergeneration.FogBugz 614: Code fix for Q22 wrong substitution parametergeneration.TPC BenchmarkTM H Standard Specification Revision 2.17.1Page 424 April 2014Revision 2.17.013 November 2014Revision 2.17.1Replaced incorrect answer set with verified correct answer set.Allowed truncation of specific query answers to reduce supporting filesize.Corrected bad references in clauses 2.6.2 and 2.7.2, as noted inFogBugz items 669 and 855.TPC Benchmark™, TPC-H, QppH, QthH, and QphH are trademarks of the Transaction Processing PerformanceCouncil.All parties are granted permission to copy and distribute to any party without fee all or part of this material providedthat: 1) copying and distribution is done for the primary purpose of disseminating TPC material; 2) the TPCcopyright notice, the title of the publication, and its date appear, and notice is given that copying is by permission ofthe Transaction Processing Performance Council.Parties wishing to copy and distribute TPC materials other than for the purposes outlined above (including incorporating TPC material in a nonTPC document, specification or report), must secure the TPC's written permission.TPC BenchmarkTM H Standard Specification Revision 2.17.1Page 5Table of Contents0: INTRODUCTION .................................................................................................................................................................
80.10.20.3PREAMBLE .................................................................................................................................................................... 8GENERAL IMPLEMENTATION GUIDELINES .................................................................................................................... 9GENERAL MEASUREMENT GUIDELINES ...................................................................................................................... 101: LOGICAL DATABASE DESIGN .....................................................................................................................................
111.11.21.31.41.51.6BUSINESS AND APPLICATION ENVIRONMENT ............................................................................................................. 11DATABASE ENTITIES, RELATIONSHIPS, AND CHARACTERISTICS ................................................................................. 13DATATYPE DEFINITIONS ............................................................................................................................................. 14TABLE LAYOUTS......................................................................................................................................................... 14IMPLEMENTATION RULES ...........................................................................................................................................
