Database inspection and maintenance method

Abstract

The invention relates to a database inspection and maintenance method. The database inspection and maintenance method comprises the following steps: step 1: establishing a database version, obtaining the newest version database structure, forming database structure script syntax, and storing database structure information; step 2: defining a basic list, obtaining the basic data of the newest version, forming basic data syntax, and storing the basic data; step 3: obtaining a database structure and the basic data of a database to be compared or a database of the history version; and step 4: comparing the database structure with the basic data to form a difference report and produce upgrade syntax. According to the database inspection and maintenance method, the changing situation of database environment can be inspected at any time, and corresponding version files can be formed. According to the database inspection and maintenance method, the automatic inspection on the user database and the rapid upgrading can be realized, and the automatic upgrade of software of a database system can be used. The universal database inspection and maintenance method provided by the invention has the advantages that the applicability is wide, the workload of the manual maintenance on the database and the possibility of making mistakes can be reduced, and also the error ratio of the manual operation is reduced.

Description

technical field [0001] The invention relates to the field of database inspection and maintenance, in particular to a database inspection and maintenance method. Background technique [0002] In the field of computer applications, according to the needs of the application, it is often required to perform irregular maintenance and upgrades on the database in use. For example, in the software development process, as the software version changes, there will be constant changes in the database structure, and the released software will need to be updated in the maintenance process as the customer's needs change during the use of the released software. Changes or upgrades may also lead to inconsistent database structure versions of different customers due to the continuous changes in the functions of the software itself. To upgrade without affecting the customer's use, it is necessary to form a difference report of the database structure and basic data, which can automatically gen...

AI Technical Summary

Problems solved by technology

[0004] First of all, in the process of system design and development, it is generally adopted to maintain the physical model of the database, which maintains a complete data structure, but in the specific development process, it may be necessary to change the data structure repeatedly, and it is necessary to accurately record the syntax of the change. In the design and development environment of multi-person collaboration, if the configuration and management are not strict, it is easy to have missing records or some mistakes, which are difficult to find, resulting in inconsistencies between the model library and the development library

[0005] Secondly, the customer database check and upgrade method of the application system generally needs to establish different database versions and the upgrade syntax of adjacent versions, and then use the version change to obtain a set of upgrade syntax when upgrading, which needs to be processed one by one from the lower version to the higher version The upgrade syntax of each version is inefficient, and the database version information that needs to be provided must be complete. Once the customer’s database changes for some reason, it will directly lead to upgrade failure or user data loss.

[0006] Third, in the process of development or actual user use, technicians may have changed the basic data. This behavior is difficult to supervise and can only be strictly managed without an effective inspection mechanism.

Images