Database version iteration method and device

Abstract

The invention discloses a database version iteration method and device, and the method comprises the steps: obtaining database updating information, and generating a database updating SQL statement; inputting the SQL statement updated by the database into a language conversion relationship library, and outputting the SQL statement updated by the database of the target language type; wherein the language conversion relationship library is established according to conversion relationships among SQL statements of multiple language types; version iteration is conducted on the database of the target language type according to the updated SQL statement of the database of the target language type and the existing SQL statement of the database of the target language type, the workload of businesspersonnel can be reduced, and the database version iteration efficiency and accuracy are improved.

Description

technical field [0001] The invention relates to the technical field of data processing, in particular to a database version iteration method and device. Background technique [0002] At present, many software systems or internal systems developed by enterprises or software development companies have this situation: the system uses the same set of core codes to realize business logic or product functions, but due to different customers, different operating environments or other conditions. Different databases, for example: customer A uses Oracle database, customer B uses Mysql database, customer C uses Sqlserver database, etc. Then each customer applies different databases in different deployment environments through different configuration layers. [0003] In view of the above situation, there will be a problem of unified management and update of the SQL statements of different databases. The prior art is to manually maintain the SQL statements of multiple types of databases...

AI Technical Summary

Problems solved by technology

[0003] In view of the above situation, there will be a problem of unified management and update of the SQL statements of different databases. The prior art is to manually maintain the SQL statements of multiple types of databases. Since the programming languages ​​used by different types of databases are different, Each database needs to manually write a set of corresponding SQL statements. When the database version is iterated, it is necessary to manually write SQL statements in multiple languages. After writing, it is necessary to check whether all the scripts are correct, which makes the workload larger. High requirements on the ability of business personnel, prone to errors, resulting in low efficiency and accuracy of database version iteration

[0004] For the above problems, no effective solution has been proposed

Images