TPC BENCHMARK (TM) H (779138), страница 2

Просмтор этого файла доступен только зарегистрированным пользователям. Но у нас супер быстрая регистрация: достаточно только электронной почты!

Текст из файла (страница 2)

19DATA ACCESS TRANSPARENCY REQUIREMENTS ........................................................................................................ 212: QUERIES AND REFRESH FUNCTIONS ....................................................................................................................... 222.12.22.32.42.52.62.712.8GENERAL REQUIREMENTS AND DEFINITIONS FOR QUERIES ........................................................................................ 22QUERY COMPLIANCE ..................................................................................................................................................

25QUERY VALIDATION ................................................................................................................................................... 28QUERY DEFINITIONS ................................................................................................................................................... 29GENERAL REQUIREMENTS FOR REFRESH FUNCTIONS ................................................................................................. 68NEW SALES REFRESH FUNCTION (RF1) ...................................................................................................................... 68OLD SALES REFRESH FUNCTION (RF2).......................................................................................................................

69DATABASE EVOLUTION PROCESS ............................................................................................................................... 693: THE ACID PROPERTIES ................................................................................................................................................. 703.23.33.43.5ATOMICITY REQUIREMENTS ....................................................................................................................................... 72CONSISTENCY REQUIREMENTS ...................................................................................................................................

72ISOLATION REQUIREMENTS ........................................................................................................................................ 73DURABILITY REQUIREMENTS...................................................................................................................................... 764: SCALING AND DATABASE POPULATION ................................................................................................................. 794.14.24.3DATABASE DEFINITION AND SCALING ........................................................................................................................ 79DBGEN AND DATABASE POPULATION.......................................................................................................................

80DATABASE LOAD TIME ............................................................................................................................................... 895: PERFORMANCE METRICS AND EXECUTION RULES ........................................................................................... 925.15.25.35.4DEFINITION OF TERMS ................................................................................................................................................ 92CONFIGURATION RULES ............................................................................................................................................. 92EXECUTION RULES .....................................................................................................................................................

94METRICS ..................................................................................................................................................................... 986: SUT AND DRIVER IMPLEMENTATION .................................................................................................................... 1016.16.26.3MODELS OF TESTED CONFIGURATIONS .................................................................................................................... 101SYSTEM UNDER TEST (SUT) DEFINITION ................................................................................................................. 101DRIVER DEFINITION ..................................................................................................................................................

1027: PRICING ............................................................................................................................................................................ 1047.17.2PRICED SYSTEM ........................................................................................................................................................ 104ALLOWABLE SUBSTITUTIONS ................................................................................................................................... 1068: FULL DISCLOSURE ....................................................................................................................................................... 1078.18.28.38.4REPORTING REQUIREMENTS ..................................................................................................................................... 107FORMAT GUIDELINES ...............................................................................................................................................

107FULL DISCLOSURE REPORT CONTENTS AND SUPPORTING FILES ARCHIVE ............................................................... 107EXECUTIVE SUMMARY ............................................................................................................................................. 114TPC BenchmarkTM H Standard Specification Revision 2.17.1Page 68.58.6AVAILABILITY OF THE FULL DISCLOSURE REPORT AND SUPPORTING FILES ARCHIVE .............................................

118REVISIONS TO THE FULL DISCLOSURE REPORT AND SUPPORTING FILES ARCHIVE ................................................... 1189: AUDIT ................................................................................................................................................................................ 1199.19.2GENERAL RULES ....................................................................................................................................................... 119AUDITOR'S CHECK LIST ............................................................................................................................................

11910: GLOBAL DEFINITIONS............................................................................................................................................... 123APPENDIX A:ORDERED SETS .................................................................................................................................... 124APPENDIX B:APPROVED QUERY VARIANTS ........................................................................................................ 125APPENDIX C:QUERY VALIDATION..........................................................................................................................

129APPENDIX D:DATA AND QUERY GENERATION PROGRAMS .......................................................................... 130APPENDIX E:SAMPLE EXECUTIVE SUMMARY.................................................................................................... 131APPENDIX F:REFERENCE DATA SET ...................................................................................................................... 136TPC BenchmarkTM H Standard Specification Revision 2.17.1Page 70: INTRODUCTION0.1PreambleThe TPC Benchmark™H (TPC-H) is a decision support benchmark. It consists of a suite of business oriented ad-hocqueries and concurrent data modifications. The queries and the data populating the database have been chosen tohave broad industry-wide relevance while maintaining a sufficient degree of ease of implementation.

Thisbenchmark illustrates decision support systems thatExamine large volumes of data;Execute queries with a high degree of complexity;Give answers to critical business questions.TPC-H evaluates the performance of various decision support systems by the execution of sets of queries against astandard database under controlled conditions.

The TPC-H queries:Give answers to real-world business questions;Simulate generated ad-hoc queries (e.g., via a point and click GUI interface);Are far more complex than most OLTP transactions;Include a rich breadth of operators and selectivity constraints;Generate intensive activity on the part of the database server component of the system under test;Are executed against a database complying to specific population and scaling requirements;Are implemented with constraints derived from staying closely synchronized with an on-line productiondatabase.The TPC-H operations are modeled as follows:The database is continuously available 24 hours a day, 7 days a week, for ad-hoc queries from multiple endusers and data modifications against all tables, except possibly during infrequent (e.g., once a month)maintenance sessions;The TPC-H database tracks, possibly with some delay, the state of the OLTP database through on-goingrefresh functions which batch together a number of modifications impacting some part of the decisionsupport database;Due to the world-wide nature of the business data stored in the TPC-H database, the queries and the refreshfunctions may be executed against the database at any time, especially in relation to each other.

Характеристики

Список файлов книги