Design And Implementation Of Performance Test Tool For Enterprise Database Server

With the advent of the Internet age,the information technology develops rapidly.The world's various industries have gradually stepped into high technology.The attendant problem is the sharp increase in the amount of data processed on the day.As the main carrier of data processing,database and server is the key to the normal operation of the enterprise and the main bottlenecks of the enterprise application performance.Therefore,how to evaluate the database server performance objectively and accurately is particularly important.TPC-E and TPC-H are database-based test standards proposed by the Transaction Performance Committee.TPC-E and TPC-H standards evaluate the OLTP and OLAP system performance respectively.And the two standards have been widely recognized within the industry.According to the above analysis,this paper completes the design and implementation of enterprise-class database server performance evaluation tool based on TPC-E and TPC-H standards.The system based on C/S mode is developed by C++ and C# language and it strictly complies with official standards.This paper deeply analyzes the TPC-H and TPC-E standard business model,database model,test process and test indicators and divides the functional modules strictly.On the basis of the standard,this paper introduces the architecture of the system and the realization of each module in detail.In addition,in order to prevent testers obtaining false high performance indicators by modifying the database security level,this system realizes the atomicity,consistency and isolation attributes verification of the database based on the TPC-H standard.Finally in the experiment section,this paper introduces the experimental process parameters and analyzes the experimental results to verify that the system tool meets the requirements of the test standards and its stability and reliability.And the tool generates log files and the final test report to achieve the full record of the test process.It can comprehensively test the server performance truly and reliably.