Research And Development Of Test System Based TPC-DS

Relational database management systems which regards as the underlying software has been developed very mature, which is responsible for permanent storage of user data, provides a strong protection for data consistency, integrity, and persistence and so on. As a basis for application software, database is the cornerstone in the computer field and fundamental. Both a small mini-applications in a mobile phone and a large on-line shopping system needs the support of a database, the accuracy and correctness of the data in database plays a very important role in system performance and processing capabilities.Transaction Processing Performance Council-TPC (Transaction Processing Performance Council) is responsible for providing database system benchmark test specification and provides a metrics database of various indicators, including processing capacity, throughput, and cost and so on.TPC-H is the Transaction Processing Performance Council released a widely accepted and recognized industry test model, a new generation of decision support systems TPC-DS test on the basis of its evolved business model is designed to provide large-scale reference and evaluation. Use TPC-DS test results produced by standard analysis can be found in the current database system problems, the average performance of the system as well as system bottlenecks have a more in-depth understanding of the system developers and users to provide effective decision support.This paper carefully studied TPC-DS testing process and other information, the system will be implemented to determine the function of the various needs of a clear system for the design of the overall architecture of the test system ready. Analysis TPC-DS model testing standards and testing processes, the system model is divided into update, query, business, data and other models. Test systems must have load testing capabilities include system functional testing, system testing, and system power parallel processing ability tests, not only that, the test system in order to achieve access to test data and provide test results and other functions, need to have persistence function test results and test results calculation functions. In addition, in order to shield the difference different databases, test systems need good support existing types of database to facilitate better use of testers testing system to obtain test results.System implementation is divided into three parts, including the configuration file writing, procedure testing, and testing to achieve four major characteristics of the database (ACID-Atomicity, Consistency, Isolation and Durability). Configuration file contains various documents for processing and configuration in order to be compatible with all kinds of different databases. Testing Procedure Implementation includes load testing, power testing and database parallel processing testing; database test section includes four characteristics of the database ACID properties.