实例介绍
【实例简介】
【实例截图】
【实例截图】
【核心代码】
Table of Contents 0 PREAMBLE........................................................................................................................................................................ 7 0.1 INTRODUCTION.............................................................................................................................................................. 7 0.2 GENERAL IMPLEMENTATION GUIDELINES..................................................................................................................... 7 0.3 GENERAL MEASUREMENT GUIDELINES......................................................................................................................... 8 0.4 WORKLOAD INDEPENDENCE ......................................................................................................................................... 8 0.5 ASSOCIATED MATERIALS .............................................................................................................................................. 9 1 BUSINESS AND BENCHMARK MODEL ................................................................................................................... 11 1.1 OVERVIEW................................................................................................................................................................... 11 1.2 BUSINESS MODEL........................................................................................................................................................ 12 1.3 DATA MODEL AND DATA ACCESS ASSUMPTIONS....................................................................................................... 13 1.4 QUERY AND USER MODEL ASSUMPTIONS ................................................................................................................... 13 1.5 DATA MAINTENANCE ASSUMPTIONS .......................................................................................................................... 15 2 LOGICAL DATABASE DESIGN .................................................................................................................................. 17 2.1 SCHEMA OVERVIEW .................................................................................................................................................... 17 2.2 COLUMN DEFINITIONS................................................................................................................................................. 17 2.3 FACT TABLE DEFINITIONS........................................................................................................................................... 18 2.4 DIMENSION TABLE DEFINITIONS................................................................................................................................. 24 2.5 IMPLEMENTATION REQUIREMENTS ............................................................................................................................. 31 2.6 DATA ACCESS TRANSPARENCY REQUIREMENTS......................................................................................................... 34 3 SCALING AND DATABASE POPULATION .............................................................................................................. 36 3.1 SCALING MODEL ......................................................................................................................................................... 36 3.2 TEST DATABASE SCALING........................................................................................................................................... 36 3.3 QUALIFICATION DATABASE SCALING ......................................................................................................................... 37 3.4 DSDGEN AND DATABASE POPULATION........................................................................................................................ 38 3.5 DATA VALIDATION...................................................................................................................................................... 38 4 QUERY OVERVIEW ...................................................................................................................................................... 39 4.1 GENERAL REQUIREMENTS AND DEFINITIONS FOR QUERIES........................................................................................ 39 4.2 QUERY MODIFICATION METHODS............................................................................................................................... 40 4.3 SUBSTITUTION PARAMETER GENERATION .................................................................................................................. 45 5 DATA MAINTENANCE ................................................................................................................................................. 46 5.1 IMPLEMENTATION REQUIREMENTS AND DEFINITIONS ................................................................................................ 46 5.2 REFRESH DATA ........................................................................................................................................................... 47 5.3 DATA MAINTENANCE FUNCTIONS............................................................................................................................... 49 6 DATA PERSISTENCY PROPERTIES ......................................................................................................................... 69 6.1 THE ACID PROPERTIES ............................................................................................................................................... 69 6.2 ATOMICITY REQUIREMENTS........................................................................................................................................ 70 6.3 CONSISTENCY REQUIREMENTS.................................................................................................................................... 70 6.4 ISOLATION REQUIREMENTS ......................................................................................................................................... 71 6.5 DURABILITY REQUIREMENTS ...................................................................................................................................... 75 7 PERFORMANCE METRICS AND EXECUTION RULES........................................................................................ 78 7.1 DEFINITION OF TERMS................................................................................................................................................. 78 7.2 CONFIGURATION RULES .............................................................................................................................................. 78 TPC Benchmark™ DS - Standard Specification, Version 1.3.1 Page 6 of 156 7.3 QUERY VALIDATION ................................................................................................................................................... 80 7.4 EXECUTION RULES ...................................................................................................................................................... 81 7.5 OUTPUT DATA............................................................................................................................................................. 87 7.6 METRICS...................................................................................................................................................................... 87 8 SUT AND DRIVER IMPLEMENTATION................................................................................................................... 90 8.1 MODELS OF TESTED CONFIGURATIONS ....................................................................................................................... 90 8.2 SYSTEM UNDER TEST (SUT) DEFINITION ................................................................................................................... 90 8.3 DRIVER DEFINITION .................................................................................................................................................... 92 9 PRICING........................................................................................................................................................................... 93 9.1 PRICED SYSTEM........................................................................................................................................................... 93 9.2 ALLOWABLE SUBSTITUTION........................................................................................................................................ 95 10 FULL DISCLOSURE................................................................................................................................................... 96 10.1 REPORTING REQUIREMENTS........................................................................................................................................ 96 10.2 FORMAT GUIDELINES .................................................................................................................................................. 96 10.3 FULL DISCLOSURE REPORT CONTENTS ....................................................................................................................... 96 10.4 EXECUTIVE SUMMARY .............................................................................................................................................. 101 10.5 AVAILABILITY OF THE FULL DISCLOSURE REPORT ................................................................................................... 104 10.6 REVISIONS TO THE FULL DISCLOSURE REPORT ......................................................................................................... 104 10.7 DERIVED RESULTS .................................................................................................................................................... 104 10.8 SUPPORTING FILES INDEX TABLE.............................................................................................................................. 105 10.9 SUPPORTING FILES .................................................................................................................................................... 106 11 AUDIT ......................................................................................................................................................................... 108 11.1 GENERAL RULES ....................................................................................................................................................... 108 11.2 AUDITOR'S CHECK LIST............................................................................................................................................. 108 11.3 CLAUSE 4 RELATED ITEMS ........................................................................................................................................ 109 11.4 CLAUSE 5 RELATED ITEMS ........................................................................................................................................ 110 11.5 CLAUSE 6 RELATED ITEMS ........................................................................................................................................ 110 11.6 CLAUSE 7 RELATED ITEMS ........................................................................................................................................ 110 11.7 CLAUSE 8 RELATED ITEMS ........................................................................................................................................ 110 11.8 CLAUSE 9 RELATED ITEMS ........................................................................................................................................ 111 11.9 CLAUSE 10 RELATED ITEMS ...................................................................................................................................... 111
好例子网口号：伸出你的我的手 — 分享！
小贴士
感谢您为本站写下的评论，您的评论对其它用户来说具有重要的参考价值，所以请认真填写。
- 类似“顶”、“沙发”之类没有营养的文字，对勤劳贡献的楼主来说是令人沮丧的反馈信息。
- 相信您也不想看到一排文字/表情墙，所以请不要反馈意义不大的重复字符，也请尽量不要纯表情的回复。
- 提问之前请再仔细看一遍楼主的说明，或许是您遗漏了。
- 请勿到处挖坑绊人、招贴广告。既占空间让人厌烦，又没人会搭理，于人于己都无利。
关于好例子网
本站旨在为广大IT学习爱好者提供一个非营利性互相学习交流分享平台。本站所有资源都可以被免费获取学习研究。本站资源来自网友分享，对搜索内容的合法性不具有预见性、识别性、控制性，仅供学习研究，请务必在下载后24小时内给予删除，不得用于其他任何用途，否则后果自负。基于互联网的特殊性，平台无法对用户传输的作品、信息、内容的权属或合法性、安全性、合规性、真实性、科学性、完整权、有效性等进行实质审查；无论平台是否已进行审查，用户均应自行承担因其传输的作品、信息、内容而可能或已经产生的侵权或权属纠纷等法律责任。本站所有资源不代表本站的观点或立场，基于网友分享，根据中国法律《信息网络传播权保护条例》第二十二与二十三条之规定，若资源存在侵权或相关问题请联系本站客服人员，点此联系我们。关于更多版权及免责申明参见 版权及免责申明
网友评论
我要评论