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

Method and device for automatically maintaining dynamic database script

A dynamic script and automatic maintenance technology, which is applied in database design/maintenance, database update, structured data retrieval, etc., can solve the problems of repeated field increase, time-consuming, construction failure, etc., to avoid manual maintenance and improve R&D efficiency , The effect of reducing labor maintenance costs

Pending Publication Date: 2021-01-05
BEIJING UNISOUND INFORMATION TECH +1
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

For example, fields are added in the upgrade script, but not in the full script; when fields are added in the full script, repeated increases occur, resulting in failure to build
[0008] (2) The step of adding manual inspection can guarantee the quality, but it consumes more man-hours

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 and device for automatically maintaining dynamic database script
  • Method and device for automatically maintaining dynamic database script
  • Method and device for automatically maintaining dynamic database script

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0037] The application will be further described in detail below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described here are only used to explain related inventions, rather than to limit the invention. It should also be noted that, for the convenience of description, only the parts related to the related invention are shown in the drawings.

[0038] It should be noted that, in the case of no conflict, the embodiments in the present application and the features in the embodiments can be combined with each other. The present application will be described in detail below with reference to the accompanying drawings and embodiments.

[0039] The present invention provides a method for avoiding manual maintenance of dynamic database scripts, specifically, figure 1 It is a schematic flow chart of the method for automatic maintenance of dynamic database scripts provided by the embodiment of the present inven...

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 method and a device for automatically maintaining a dynamic database script. The method comprises the following steps of: checking whether a current incremental script versionis consistent with a version recorder or not; wherein the incremental script comprises fixed service table upgrading information and dynamic service table upgrading information; if not, calculating an interval version and judging whether dynamic script upgrading exists or not; if not, executing the sql script; if so, preprocessing the dynamic script and executing the sql script; and modifying therecord in the version recorder after the gradual upgrading is successful. By means of the method, manual maintenance of the dynamic database scripts can be avoided, the function of automatically maintaining the database scripts is achieved, and the research and development efficiency is improved.

Description

technical field [0001] One or more embodiments of the present invention relate to the technical field of computer databases, in particular to a method and device for automatic maintenance of dynamic database scripts. Background technique [0002] This section is intended to provide a background or context for implementations of the invention that are recited in the claims. The descriptions herein are not admitted to be prior art by inclusion in this section. With the development of computer technology, database technology has also been developed. For a server, the database is a part of the server. The database is used to store various types of data. When the data is wrong, the data needs to be modified and maintained to ensure the normal operation of the server. In addition, for server version changes or business types Replacement may also require modification and maintenance of data in the database. In traditional technologies, database scripts can be used to modify data...

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/21G06F16/23
CPCG06F16/219G06F16/23
Inventor 刘连峰
Owner BEIJING UNISOUND INFORMATION TECH
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

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com