Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Database upgrading method and system

A database and upgrade script technology, applied in the database field, can solve the problems of inability to ensure the upgrade accuracy, high labor cost, low database upgrade efficiency, etc., and achieve the effect of saving labor, simple structure, and wide application prospects.

Pending Publication Date: 2020-10-02
SUZHOU LANGCHAO INTELLIGENT TECH CO LTD
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, manpower is often required to write upgrade scripts or modify existing upgrade scripts every time the database needs to be upgraded, especially for online upgrades, which often requires a lot of manpower to ensure that the scripts are correct and the upgrade is correct, and the labor cost is relatively high. The efficiency is relatively low, and the accuracy of the upgrade cannot be guaranteed

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
  • Database upgrading method and system
  • Database upgrading method and system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0053] In order to enable those skilled in the art to better understand the technical solutions in the present invention, the technical solutions in the embodiments of the present invention will be clearly and completely described below in conjunction with the drawings in the embodiments of the present invention. Obviously, the described The embodiments are only some of the embodiments of the present invention, not all of them. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts shall fall within the protection scope of the present invention.

[0054] figure 1 It is a schematic flowchart of a database upgrading method according to an embodiment of the present invention.

[0055] like figure 1 As shown, the database upgrading method 100 includes:

[0056] Step 110, scanning the preset target configuration file, generating a database upgrade script, a database key business te...

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 provides a database upgrading method and system, and the method comprises the steps: s1, scanning a preset target configuration file, and generating a database upgrading script, a database key business testing script and a rollback script; s2, running the database upgrading script to upgrade the target database, and executing the step s3 after the running is successful; s3, executingthe database key business test script, and testing the key business of the target data if the test succeeds, determining that the target database is successfully upgraded, and ending the upgrading; and if the test fails, outputting a corresponding test report and executing the rollback script to recover the target database, and continuing to execute the step s1 after the target configurationfile is modified until the key business test of the target database succeeds. The database upgrading system corresponds to the database upgrading method. The method and the device are used for improving the database upgrading efficiency and accuracy.

Description

technical field [0001] The invention relates to the field of databases, in particular to a database upgrading method and system. Background technique [0002] In the project, with the continuous update of the product version, the upgrade of the database is often encountered. [0003] For normal database upgrades, it is necessary to write database upgrade scripts and perform upgrades by executing the written upgrade scripts. However, manpower is often required to write upgrade scripts or modify existing upgrade scripts every time the database needs to be upgraded, especially for online upgrades, which often requires a lot of manpower to ensure that the scripts are correct and the upgrade is correct, and the labor cost is relatively high. The efficiency is relatively low, and the accuracy of the upgrade cannot be guaranteed. [0004] Therefore, the present invention provides a database upgrading method and system for solving the above problems. Contents of the invention ...

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): G06F8/65G06F16/21
CPCG06F8/65G06F16/21Y02D10/00
Inventor 马聪谢鹏
Owner SUZHOU LANGCHAO INTELLIGENT TECH CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products