Database testing method and system

Abstract

The present invention discloses a database testing method and a system, and belongs to the technical field of databases. The method comprises: setting a corresponding test script and a test scenario according to an externally input test request, and performing simulation to generate corresponding multiple pieces of test data; in a software database system, testing the test data by applying the test script according to the test scenario to run a database test process associated with the test request; monitoring the database test process and acquiring a plurality of test indices; by using a preset policy and according to a preset standard parameter associated with the test indices, performing a screening process on the test indices and outputting a screening result; and optimizing the software database system according to the screening result, and then exiting. The system comprises an acquiring unit, a configuration unit, a testing unit, a monitoring unit, a screening unit and a processing unit. The beneficial effect of the technical scheme is that: error reasons of a database are found and analyzed, thereby facilitating error location and performance optimization.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to a database testing method and system. Background technique [0002] Various platform software, system software, and various application software used by people in daily life need to be continuously improved and updated in adapting to data services in order to meet the continuous improvement needs of users, that is, to continuously update versions. However, in the process of updating the version, it is very likely that the storage structure of the background database will change (such as adding, deleting, modifying data, etc.), and data redundancy will occur, which will lead to the decline in the performance of the front-end software in terms of database support, such as The operating response speed of the software becomes slower, the stability of the software operation becomes worse, and the security performance of the software decreases. [0003] In the prior art, the perform...

AI Technical Summary

Problems solved by technology

However, in the process of updating the version, it is very likely that the storage structure of the background database will change (such as adding, deleting, modifying data, etc.), and data redundancy will occur, which will lead to the decline in the performance of the front-end software in terms of database support, such as The operating response speed of the software becomes slower, the stability of the software operation becomes worse, and the safety performance of the software decreases, etc.

[0003] In the prior art, the performance problems caused by the software database are usually tested and analyzed by some test tools, but the existing test tools cannot test the specific reasons that actually cause the software to decline in performance in terms of database support , so testers can only spend a lot of time and energy on the overall optimization of the software database instead of targeted optimization, resulting in waste of labor costs and prolongation of database optimization time

Images