Method and device for managing database changes

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 lates...

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
1. Verfasser: YIN SHIZHANG
Format: Patent
Sprache:chi ; eng
Schlagworte:
Online-Zugang:Volltext bestellen
Tags: Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
Beschreibung
Zusammenfassung: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