Design And Implementation Of Performance Test Tool Based On TPC-DS

With the development of database technology and the deepening of enterprise information system applications,Decision Support System(DSS)plays a more prominent role in the enterprise decision-making process.As a key component of the database management system(Database Management System,referred to as DBMS)affects the availability of DSS.TPC-DS is a database testing benchmark for decision support systems organized by the Transaction Processing Performance Committee.It simulates real data warehouse scenarios and a series of data operations.It is mainly used to test the online analytical processing capabilities of a database and can also be used as a mass data source.Statistical analysis,report generation,and data mining can evaluate database performance fairly and effectively,and it has been widely recognized by the industry.This paper analyzes the TPC-DS benchmark business model,data model,query and user model,data maintenance model,test execution rules,metrics,and related toolkit usage methods based on the benchmark document,performs system requirements analysis,and completes the design and implementation of database performance testing tools.The test tool is based on C/S mode,using C# programming language for development,facing Windows system,complying with TPC-DS specification,adopting a modular approach to design system module functions,providing load test,power test and throughput test The three core functions and auxiliary functions such as query verification,performance calculation,and logs management provide a convenient and reliable system for TPC-DS-based testing.Finally,test each module of the system by designing test cases to ensure the reliability and integrity of the system functions,so that the system meets various functions defined in the requirements analysis stage.Subsequently,MySQL,Oracle,Hive,and Hbase were tested and the test results were compared and analyzed by setting different parameters to verify the practicability and accuracy of the test tools.The database performance can be reliably tested comprehensively.The test system is based on the TPC-DS benchmark,which is highly innovative and has great application value in the field of benchmarking.