TPC-E Benchmark Database Performance Testing Tool

With the rapid development of computer application technology,the process of intelligent technology in various industries is also constantly going on.The changeable data use scenarios and the increasing data processing capacity make the requirements of enterprises on the database also increase.The online-transaction-process(OLTP)performance requirement of database is also one of the key factors in selecting database.Therefore,it is very important to design and implement a test tool that can enable users to evaluate the performance of database system according to their business requirements.This paper analyzes the research status of various TPC-E benchmark related testing tools at home and abroad,summarizes their shortcomings,and designs and implements a database performance testing tool with cross-platform characteristics,monitoring indexes and graphics based on TPC-E benchmark.This test tool includes the graphical control side,the load request client side and the server side,strictly complies with the TPC-E official benchmark specification,and is developed in C++ language.Through the in-depth analysis of the characteristics of OLTP application and the TPCE benchmark model,it is implemented in a modular way.The overall architecture design and each module of the testing tool are introduced in detail.On the basis of in-depth understanding of the benchmark,the transaction management and load generation are further designed and implemented.In the aspect of transaction management,two transaction response processing models,synchronous and asynchronous,are set up,and transaction invocation realization frame is implemented by stored procedure and sending statement respectively,on the one hand to ensure the test tool performance,on the other hand can support different database testing.In terms of load generation,three control strategies are set up: constant pressure model,linear growth model and dynamic pressure change model.Through transaction management and load control,users can make different performance test plans according to their own needs.Next,the paper uses the realized performance testing tool to carry out testing experiments,and applies the same parameters to do multiple groups of different tests,verifies the feasibility of different functions of each module of the testing tool,and finally analyzes the test results.