Method and device for altering table in database

A database and data technology, applied in the database field, can solve problems such as increasing the difficulty of data governance and maintenance, reducing the rate of version release, table inconsistency, etc., achieving the effects of reducing the difficulty of data governance and maintenance, strong scalability, and improving accuracy

Active Publication Date: 2022-04-29
INDUSTRIAL AND COMMERCIAL BANK OF CHINA
View PDF6 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] However, with the exponential growth of data, when the amount of table change data is huge, manually generating and submitting table change files will reduce the release rate of the version, and when the table is modified in the development environment or test environment, but the table change file is omitted, It will cause inconsistency between the actual deployment environment and the development environment table, causing data errors and increasing the difficulty of subsequent data governance and maintenance

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 altering table in database
  • Method and device for altering table in database
  • Method and device for altering table in database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0058]In order to make the purpose, technical solutions and advantages of the embodiments of the present invention clearer, 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 embodiments It is a part of embodiments of the present invention, but not all embodiments. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts belong to the protection scope of the present invention.

[0059] The present invention provides an embodiment of a method for changing a table in a database, see figure 1 , the change method of the table in the database specifically includes the following content:

[0060] S101: Obtain a change instruction for the target table in the database, where the change instruction includes corresponding chan...

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 present invention provides a method and device for changing a table in a database. The method includes: obtaining a change instruction for a target table in the database, the change instruction includes corresponding change information; using preset DDL grammar rules, and based on the Generate a DDL script for the target table in the database and the corresponding change information; automatically call and execute the DDL script to change the target table in the database. The invention can convert the change information of the table into a DDL script, realize the change of the table, improve the accuracy of the table change, and the table change operation is simple, the usability is high, and the scalability is strong; automatic retrieval and execution DDL scripts can avoid the missed submission of table change files, further ensure the consistency of each environment table, and reduce the difficulty of data governance and maintenance.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to a method and device for changing tables in a database. Background technique [0002] With the continuous development of the Internet and information technology, the release frequency of application software versions is getting faster and faster. The project corresponding to each version of application software contains multiple sub-applications, and each sub-application calls several databases. Each database contains The database instance (dbname), database owner (dbowner), tables, and data stored procedures. The version release of the application software is actually to package all the changed tables, data storage procedures, codes and other programs under the current version into a version package, use the push tool to push the code to the version library, and deploy the version library to realize the version change. [0003] At present, to change the table of the database c...

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 Patents(China)
IPC IPC(8): G06F16/22G06F16/2455
CPCG06F16/2282G06F16/24564
Inventor 陈光柳温建波郑培龙吴宏招
Owner INDUSTRIAL AND COMMERCIAL BANK OF CHINA
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