Method of relation data base applications automatic upgrade

Abstract

The invention discloses an automatic upgrade method applied to the relational data base, which comprises the following steps: the data base structure of an objective version is created; the data base structure of the source version is scanned and analyzed by the automatic upgrade system of the data base, so as to obtain the data base structure information of the source version; the data base structure of the objective version is scanned and analyzed by the automatic upgrade system of the data base, so as to obtain the data base structure information of the objective version; the data base structure information of the source version and the objective version is compared and analyzed to generate an upgrade strategy automatically; the upgrade is executed according to the upgrade strategy. The data base information of the source version and the objective version is factually and completely reflected through automatically analyzing and upgrading the data base structure of the source version and the objective version and automatically generating the upgrade strategy, thus the information disjunction between an upgrade tool and a field version likely caused by the subjective surmise of customizing and compiling upgrade tool is avoided, and the upgrade and the rolling back of the data base between the arbitrary versions can be conveniently and flexibly completed.

Description

technical field [0001] The invention relates to an upgrading method, in particular to an automatic upgrading method for a relational database application. Background technique [0002] In order to meet the current needs of various business development and operation management, equipment or software product suppliers have developed various business software based on commercial database software such as MS SQL, Oracle, and Sybase. The main form is to use commercial database software to create database entities occupying a certain storage space, a series of relational data tables, and possibly database elements such as stored procedures and triggers. However, due to the continuous emergence of new business and new requirements, the growth of business volume, the fault repair and function enhancement of software versions, frequent upgrades to the business database system will occur. The upgrade of the database mainly includes the addition and deletion of tables, the change of t...

AI Technical Summary

Problems solved by technology

[0003] 1. It is not possible to judge from the user database system itself whether the database structure has been modified between the two versions. It can only be judged according to the version number of the version which database structure has been modified in the version. This judgment will inevitably lead to errors

For example, some modifications to the database fail to reflect the changes in the version number, resulting in different database structures (possibly very small) corresponding to the same version number. At this time, the database upgrade tool customized according to the version number cannot be completely updated. upgrade correctly

It is possible that at the product operation site, the user has made some modifications, or the technical support personnel have made some changes on site. At this time, the customized database upgrade tool cannot perceive these on-site changes;

[0004] 2. In theory, there will be more than one version conversions during the version upgrade. In this way, relying on different version numbers to customize the version upgrade tool will make the maintenance workload of the data upgrade tool increase with the version number increased sharply

Since the upgrade tool itself cannot recognize the internal database structure of different versions, the reverse rollback also needs to be customized for different versions, which is time-consuming and laborious

Images