Large-scale transaction load generation and database isolation level correctness verification system and method

Abstract

The present invention provides a large-scale transaction load generation and database isolation level correctness verification system, including: a random database schema generator, a test database generator, a random transaction load generator, a test load executor, and a log analyzer; wherein, The random database pattern generator and the test database generator serve the generation of the random test database; the random test database generation includes: the generation of the database pattern and the generation of the database instance; the random transaction load generator and the The test load executor is responsible for generating and loading random test loads; the log analyzer provides a correctness analysis report by detecting anomalies and abnormalities and verifying the correctness of the read result set. Based on the above system, the present invention also proposes a large-scale transaction load generation and correctness verification method of database isolation level.

Description

technical field [0001] The invention belongs to the technical field of computers and relates to a large-scale transaction load generation and database isolation level correctness verification system and method. Background technique [0002] As an important basic software, the database management system is widely used in key applications in the fields of finance, communication, and e-commerce. In recent years, the rapid development of the Internet has spawned a large number of new applications. Driven by new applications, database systems have developed rapidly. At the beginning of this century, NoSQL databases emerged, and now NewSQL databases are playing an increasingly important role. At present, there are more than 300 well-known database systems [1]. In addition, with the development of new hardware, there are more choices in the design of database systems, and the system architecture is constantly being refactored. The rapid iterative new system brings new challenges...

AI Technical Summary

Problems solved by technology

However, for transactional workloads, there is currently no relevant test case automation generation technology

Manually constructing transactional loads or using OLTP to evaluate benchmark loads is the current main testing method, and these loads are relatively limited, so the database system is not sufficient for testing transactional loads, especially for high-concurrency and high-conflict transactions load

The automatic generation technology of transaction load and the correctness verification of the isolation level of the database system under high-pressure and high-conflict transaction load are important parts of the database quality management system, but there is no relevant supporting technology yet

[0008] Problems in the prior art: The quality management of the database system is a systematic software engineering problem, including product requirements analysis, technical framework selection, iterative model and testing, etc.

The automatic generation of analytical load test cases has good academic research work and engineering practice, but the automatic generation of transactional load test cases is rarely done because of its high difficulty

Images