Database verification method and device

Abstract

The invention discloses a database check method and apparatus, and belongs to the technical field of the internet. The method comprises the steps of converting a target database to obtain a benchmarkdatabase supported by a relational database management system MySQL; running a sample structured query language (SQL) in the target database to obtain a first running result, and running the sample SQL in the benchmark database to obtain a second running result; copying the first running result to the benchmark database; detecting whether the first running result and the second running result areconsistent or not in the benchmark database; and if a detection result is that the first running result and the second running result are consistent, determining that the check of the target databasesucceeds. The problem of relatively low check efficiency of the target database when relatively numerous sample SQLs exist in the prior art is solved; and the effects of quickly determining a check result of the sample SQL in the benchmark database and improving the check efficiency of the target database are achieved.

Description

technical field [0001] The embodiment of the present invention relates to the technical field of databases, in particular to a method and device for verifying a database. Background technique [0002] In the prior art, secondary development of the Pgxc (an open source distributed database system) database is required due to business requirements, and in order to ensure the reliability of the target database after secondary development, the target database needs to be verified. [0003] The existing database verification method includes: the server runs sample SQL in the target database, and detects whether the running result is consistent with the pre-stored running result; if the detection result is consistent, it is determined that the verification of the target database is successful. Wherein, the pre-stored operation result refers to the operation result of the sample SQL manually verified by the verification personnel and then stored to the server. [0004] However, wi...

AI Technical Summary

Problems solved by technology

[0004] However, with the continuous expansion of database functions, the number of sample SQLs that need to be used is increasing. Therefore, in the prior art, checkers need to manually check a large number of SQLs, and the efficiency of checking the target database is low.

At the same time, when the amount of data in the target database is relatively large, the running result of a sample SQL may have multiple rows. The result of the operation, the above scheme will not be realized

Images