Method and device for managing database changes

A management method and database technology, applied in the field of database change management methods and devices, to achieve the effects of avoiding omissions, avoiding omissions and writing errors, and improving efficiency and quality

Active Publication Date: 2013-02-13
ALIBABA GRP HLDG LTD
View PDF4 Cites 28 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0007] This application provides a database change management method and device to solve the problems existing in manual management

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 managing database changes
  • Method and device for managing database changes
  • Method and device for managing database changes

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0039] In order to make the above objects, features and advantages of the present application more obvious and comprehensible, the present application will be further described in detail below in conjunction with the accompanying drawings and specific implementation methods.

[0040] This application implements the management of database changes through database snapshots. This application first saves the snapshot of the database data, and realizes the management of the snapshot data; then, after completing the adjustment of the database design in the development (or testing) stage, according to the comparison between the snapshot and the development (or testing) database data, calculate and find out The differences between the two; and then automatically generate DDL and DML statements based on these differences.

[0041] The content of the present application will be described in detail below through examples.

[0042] refer to figure 2 , is a flow chart of a database cha...

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 managing database changes, and aims to solve the problems of manual management. The method comprises the following steps of: snapshotting raw data in a database to obtain snapshot data; snapshotting the changed data of the database to obtain the latest snapshot data; comparing the latest snapshot data with the snapshot data obtained last time to obtain a comparison result, and if the comparison result shows that the latest snapshot data are inconsistent with the snapshot data obtained last time, storing the latest snapshot data instead of the snapshot data obtained last time; and automatically generating a database statement according to the comparison result. Data description language (DDL) and data manipulation language (DML) statements of the database can be generated automatically, efficiently and accurately, the omissions of the database changes in research and development processes in the last publishing link are avoided, and the efficiency and quality of a publishing process are effectively improved.

Description

technical field [0001] The present application relates to database technology, in particular to a database change management method and device. Background technique [0002] In the process of software development, database change management is very important. refer to figure 1 , is a schematic diagram of the research and development process in the prior art. The entire R&D process is basically divided into three stages: development, testing, and launch. Each stage involves the operation and management of the database, as follows: [0003] In the development stage, first organize the DDL (Data Description Language, Data Definition Language) and DML (Data Manipulation Language, Data Manipulation Language) statements according to the "System Design Document", and manually record the DDL and DML statements, and then execute them in the development library The DDL and DML statements. After the execution is completed, judge whether the database design has been adjusted. If it ...

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): G06F17/30
Inventor 殷诗章
Owner ALIBABA GRP HLDG 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