Cross-version supporting database upgrading method and device

A database and cross-version technology, applied in the direction of program control devices, electrical digital data processing, special data processing applications, etc., can solve problems such as large framework and unsuitable for small applications

Inactive Publication Date: 2017-11-17
ZHENGZHOU YUNHAI INFORMATION TECH CO LTD
View PDF5 Cites 4 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] At present, there are some mature development frameworks on the market that provide a very complete database upgrade solution. Developers can easily solve the problem of database upgrade as long as they develop according to the rules. However, these frameworks are generally large and not suitable for small applications.

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
  • Cross-version supporting database upgrading method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0026] In order to make the purpose, technical solution and advantages of the present invention clearer, the technical solution of the present invention will be further described in detail below in conjunction with the accompanying drawings. It should be noted that, in the case of no conflict, the embodiments of the present application and the features in the embodiments can be combined with each other arbitrarily.

[0027] The inventor of the present application proposes to use the SQL language as the scripting language for upgrading the database. These statements are arranged in the order of version numbers (for example, the order of version numbers from low to high). What the program needs to control is which SQLs need to be executed and which ones do not need to be executed. In order to realize the upgrade of the database.

[0028] Based on the above ideas, this embodiment proposes a database upgrade method that supports cross-versions, which mainly includes the following ...

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 cross-version supporting database upgrading method and device, and relates to a program upgrading technology. The cross-version supporting database upgrading method includes the steps that a structured query language (SQL) folder is established at an appointed position, wherein the SQL folder is used for orderly storing SQL files corresponding to database upgrades of different versions of an application program; an upgrading record chart for recording successfully executed SQL files is established in a database of the application program; when the application program is upgraded, SQL files corresponding to a database upgrade during a current application program upgrade are added into the SQL folder; when the application program is started after being upgraded, all the SQL files in the SQL folder are traversed, all the successfully executed SQL files are queried out from the upgrading record chart in the database, and SQL files which are not executed yet are obtained through comparison; the SQL files which are not executed yet are sequentially read according to sequences to execute operations.

Description

technical field [0001] The invention relates to program upgrading technology, in particular to a database upgrading scheme supporting cross-version. Background technique [0002] Program upgrade is a problem that all developers must face, which also includes file upgrade and database upgrade. For database upgrade, it is more troublesome to deal with. Unlike file upgrade, you can directly delete old files and add new files, because the existing data in the old database needs to be preserved. [0003] At present, there are some mature development frameworks on the market that provide a very complete database upgrade solution. Developers can easily solve the problem of database upgrade as long as they develop according to the rules. However, these frameworks are generally large and not suitable for small applications. It is urgent to find a database upgrade solution for lightweight applications that not only preserves old data while upgrading, but also supports cross-version u...

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/30G06F9/445
Inventor 张德波
Owner ZHENGZHOU YUNHAI INFORMATION TECH CO LTD
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

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap