Unlock instant, AI-driven research and patent intelligence for your innovation.

Upgrading script generation method and device for multi-version database and electronic equipment

A technology for upgrading scripts and generating devices, applied in the field of databases

Pending Publication Date: 2022-01-07
HUNDSUN TECH
View PDF0 Cites 4 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] The embodiment of the present application proposes an upgrade script generation method for a multi-version database. By screening the upgrade script corresponding to the version upgrade request in the pre-built upgrade script template, it reduces the need for manual comparison of database information in the existing database upgrade process. Defects, improved database upgrade efficiency

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
  • Upgrading script generation method and device for multi-version database and electronic equipment
  • Upgrading script generation method and device for multi-version database and electronic equipment
  • Upgrading script generation method and device for multi-version database and electronic equipment

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 2

[0100] According to the second aspect of the embodiment of the present disclosure, the upgrade script generation device 2 for the multi-version database proposed by the embodiment of the present application, such as figure 2 shown, including:

[0101] An information acquisition unit 21, configured to acquire maintenance records for the multi-version database, and analyze the maintenance records to obtain modification information for different versions of the multi-version database;

[0102] A template construction unit 22, configured to construct upgrade script templates corresponding to different databases according to the modification information;

[0103] The request parsing unit 23 is configured to obtain a version upgrade request for the target database issued by the user, and parse the version upgrade request to obtain the target database type and the upgrade version range;

[0104] The script construction unit 24 is configured to select an upgrade script template corr...

Embodiment 3

[0143] According to a third aspect of the embodiments of the present disclosure, this embodiment provides an electronic device, including:

[0144] processor; and

[0145] a memory for storing executable instructions of the processor;

[0146] Wherein, the processor is configured to execute the steps of the method for generating an upgrade script for a multi-version database by executing the executable instruction.

[0147] According to the fourth aspect of the embodiments of the present disclosure, this embodiment provides a computer-readable storage medium, on which a computer program is stored, and the computer program is executed by a processor for the steps of the method for generating an upgrade script for a multi-version database .

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 embodiment of the invention provides an upgrading script generation method and device for a multi-version database and electronic equipment, and the method comprises the steps: obtaining a maintenance record for the multi-version database, and analyzing the maintenance record to obtain modification information of different version databases in the multi-version database; constructing upgrading script templates corresponding to different databases according to the modification information; obtaining a version upgrading request sent by a user for a target database, and analyzing the version upgrading request to obtain a target database type and an upgrading version interval; and selecting an upgrading script template corresponding to the to-be-targeted database type from the constructed upgrading script templates, and screening and sorting the upgrading script templates in combination with the obtained upgrading version interval to obtain an upgrading script corresponding to the version upgrading request. By screening the upgrading script corresponding to the version upgrading request in the pre-constructed upgrading script template, the defect that database information needs to be compared manually in the existing database upgrading process is reduced, and the database upgrading efficiency is improved.

Description

technical field [0001] The present application relates to the field of databases, in particular to an upgrade script generation method, device and electronic equipment for multi-version databases. Background technique [0002] After the database system goes online, with business changes, there will be multiple versions of a system at the same time, and the same system will be deployed in different database systems. When the system upgrade involves changes in the database structure, the current There is a solution to generate upgrade scripts through manual maintenance or simple SQL comparison. If many versions are involved, the existing solution will inevitably bring a lot of similar repetitive work, and the version upgrade is solidified. Generally, it can only be upgraded from the lower version to the upper level, and there is no freedom. Select version upgrade, for example, when the system has versions V1.0, V2.0, V3.0, V4.0, V5.0, if you want to freely choose version upgra...

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
Patent Type & Authority Applications(China)
IPC IPC(8): G06F16/21G06F8/71G06F8/65
CPCG06F16/219G06F8/65G06F8/71
Inventor 秦元
Owner HUNDSUN TECH