Research And Development Of Testing System Based On Next Generation Of Decision Support Test Benchmark

TPC-DS is the next generation of decision support systems benchmark developed bythe TPC organization, in order to replace TPC-H. Researching the test model of TPC-DSBenchmark, designing and implementing the test system that follows the benchmark,using the system to test databases and analyzing test results contribute to find the databaseproblems in decision support and make it easy to improve the database system.On the base of researching and analyzing the business model, data model, querymodel, data maintain model and the testing process of TPC-DS benchmark, the needs ofthe system are cleared and the functions distinct that the system should have. As a result,the overall structure of the system functions was designed. The system not only providesthe three main functions: load test, power test, throughput test, but also is able to managerconnection, calculate results and make the process, test the ACID properties and results oftest persistence. The use of scripts and configuration files allows the system has goodversatility, so the system is able to test different database.In accordance with the framework of overall system design, this article describes theimplementation of the system in three aspects, namely, configuration files, programsdesign and testing of the ACID properties. The first part described the function andconfiguration rules of the files that the system needs. The second part introduces theimplementation of load test, power test and throughput test from the view of programmingand the thought and process of each function detailed. The system archives load test byusing scripts. After parsing the query file into a single SQL, power test begins to execute.Throughput test simulates concurrent queries and update by using multi-thread technology.Last part describes the way to realize the ACID properties test and provides detailedtesting process and results description for each property.The DM7was chosen as the test database. By comparing the execution results indifferent configurations and concurrent conditions, the system availability is proved.