Method of relation data base applications automatic upgrade

An automatic upgrade and database technology, applied in special data processing applications, electrical digital data processing, instruments, etc., can solve the problems of time-consuming, labor-intensive, errors, and inability to completely correct upgrades, and achieve the effect of avoiding information disconnection

Inactive Publication Date: 2008-05-21
ZTE CORP
View PDF0 Cites 46 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

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

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Method of relation data base applications automatic upgrade
  • Method of relation data base applications automatic upgrade
  • Method of relation data base applications automatic upgrade

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0041] In order to make the above objects, advantages and features of the present invention more clear, the following will be described in detail in conjunction with the examples. However, the following examples and drawings are not intended to limit the scope of the present invention.

[0042] What the present invention realizes is a method for automatically upgrading relational database applications. It is a user database system developed based on a commercial relational database system, that is, the upgrade object is not the commercial database system itself, but the content of the user database.

[0043] figure 1Shown is a schematic diagram of the overall structure of the relational database of the present invention set on a server. As shown in the figure, a relational database 10 is set on the server 1, here a single-user database system is taken as an example, but not limited thereto. Wherein, the specific composition structure includes: a database automatic upgrade s...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

Abstract

The invention discloses a method for automatically upgrading a relational database application, comprising the following steps: creating a target version database structure; a database automatic upgrading system scanning and analyzing the source version database structure to obtain the source version database structure information; and automatically upgrading the database The system scans and analyzes the target version database structure to obtain the target version database structure information; compares and analyzes the source and target version database structure information to generate an upgrade strategy; executes the upgrade according to the upgrade strategy. The present invention automatically generates an upgrade strategy by automatically analyzing and upgrading the database structure of the source version and the target version, which truly and completely reflects the database information of the source version and the target version, and avoids the possibility of the upgrade tool and The information of the on-site version is disconnected, and the database upgrade and rollback between any versions can be completed conveniently and flexibly.

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...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
IPC IPC(8): G06F17/30
Inventor 钟卫东
Owner ZTE CORP
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products