The Design And Implementation Of Stress Testing Ststem For Databases Of Deferent Structures

With the arrival of big data era,everyone has become the producer and consumer of data.The relational databases can not satisfy the storage and manangement of such large-scale data.As a result,major manufacturers have launched different NoSQL products.HBase is one of the famous NoSQL databases,which has wide support both in research and production.However,NoSQL can not replace relational databases.Their separate and combined usage provides a solid guarantee for servers'data.Before choosing one database and putting it into production,stress testing of databases of deferent structures is the guarantee of stable and efficient function of database.This paper designs and implements a stress testing system for databases of deferent structures.The databases of deferent structures here refer to NoSQL databases including HBase and relational databases including Oracle,MySQL,PostgreSQL and DM7.The testing system can unify many database access interfaces and execute different types of test.This paper gets the performance characteristics of different databases by executeing contrast testing with the stress testing system.The results accord with the consensus of the industry and verify the availability of the testing system.This paper also evaluates the performance characteristics of multi-database by collaborative testing using stress testing system.Firstly,this paper introduces the background of SQL database and NoSQL database and their related testing work,and puts forward the research content of this paper in view of the shortcomings of these tests.Secondly,according to the requirement analysis of the stress testing system,This paper analyses what the testing system needs to meet the user's requirements.Then,according to the requirement analysis,the overall structure of the system was made to design the front-end and backend's function and structure,which defines the framework of the system.According to the overall design of the system,this paper divides the testing system into several modules and introduces the functions and implementation of each module in detail.Finally,through unit testing,integration testing,system testing and benchmarking testing of various databases,it is verified that the stress testing system for databases of deferent structures meets the requirements of requirement analysis.