Database version control system and method

A version control and database technology, applied in the database field, can solve the problems of untraceable change responsible person, unpredictable database, no database version control, etc.

Inactive Publication Date: 2020-10-30
INSPUR SUZHOU INTELLIGENT TECH CO LTD
View PDF0 Cites 1 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

The database corresponding to the source code update usually needs to be modified frequently, but there is no version control for the database level at present, and the teamwork of multiple people in the database cannot be completed. If the private connection database is changed, the data before the change cannot be found, and the responsibility for the change cannot be tracked. People, changing time points, and specific operations on the database will cause unpredictable risks to the database

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

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0039] This embodiment provides a database version control system, including: a database initialization module, a user authority control module, a change log monitoring module, a version comparison module, a production change management module, a database, and a version library;

[0040] The database initialization module is used to connect to the database and load it into the version control system; connect to the database and load it into the version control system; input the database IP address, user name, password, and database instance name to connect to the database. After the connection is completed, read all the information of the database, including sql script, table structure, stored procedure, object dependency, permission, etc.; bring it into the scope of version control to form the base version of this database change.

[0041] The user authority control module is used to control the authority of the operation and maintenance personnel responsible for database main...

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 version control system and method. The database version control system comprises a database initialization module, a user permission control module, a change log monitoring module, a version comparison module, a production change management module, a database and a version library; according to the database version control system and method provided by the invention, version control of the database is realized, tracking of a change log of the database is facilitated, cooperative operation of multiple persons on the database is realized, and modification tracing of the database is facilitated.

Description

technical field [0001] The invention belongs to the technical field of databases, and in particular relates to a database version control system and method. Background technique [0002] During the system development process, each development team member relies on a different data environment for development. When an overall database is finally formed, version control tools are needed to assist in the integration of database versions. Version control tools are often used to control the source code, so that the code base is included in the scope of version changes, and the source can be traced. The database corresponding to the source code update usually needs to be modified frequently, but there is no version control for the database level at present, and the teamwork of multiple people in the database cannot be completed. If the private connection database is changed, the data before the change cannot be found, and the responsibility for the change cannot be tracked. Peopl...

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): G06F8/71G06F16/21
CPCG06F8/71G06F16/21
Inventor 亓颖
Owner INSPUR SUZHOU INTELLIGENT 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