Database Benchmark Performance Test Tool Research And Achieving Based On TPC-C Standard

With the develomp of our country's information construction, as an important part of our country's information infrastructure, Database system become more and more important and database products with independent intellectual property rights become more and more rich. In the < The domestically produced database management system evaluates program > of China software evaluation center, the TPC-C performance test standard of TPC organization should be used.TPC-C benchmark is published by TPC (Transaction Processing Council). The TPC is a non-profit corporation founded to define transaction processing and database benchmarks and to disseminate objective, verifiable TPC performance data to the industry. TPC-C benchmark is an OLTP (on-line transaction processing) benchmark.In this paper, we briefly summarize the TPC-C benchmark and focuse on the techniques of the basic test method of TPC-C. We also study the related techniques: java database connection pooling, java multithreading, java socket programming and realize the automative test software-TpccLoader with java language. At last, we introduce emphasely the desigen thinking and relizesed method and the system construct of TpccLoader. The mainly key technologies and my researches are followed:1. The abstraction of system data object and the design of class level structures and class relationship ensure the accuracy of the software; make software easy to promote and to maintain.2. This paper research based on TPC-C test model. On the foundation of discussed detailedly in the TPC-C benchmarks performance standard, we introduce and analyze TPC-C essential method and procedure, and give the TPC-C test basic index, and realize the automotive test software-TpccLoader.3. The system TpccLoader use B/S construction based on the Model-View-Controller pattern.Each module or object is encapsulated in the class to make system more opentive, securitive and crossplatformly.4. The design of the system TpccLoader use master/slave module based on TCP/IP protocol. The master is responsible for the senting all kinds of test control orders, the slave is responsible for receiving the orders to carry out or respond statistical information requst.5. The simultaneous access of the same data by multiple users, The database connection pooling technique is used to optimize for management of database connection, the TpccLoder should be send messager to make threading (each user) to be synchronization and use message queue to make threading to be carry out...