Unlock instant, AI-driven research and patent intelligence for your innovation.

DDL operation synchronization method and device and electronic equipment

A technology of operation synchronization and operation instructions, which is applied in database design/maintenance, special data processing applications, structured data retrieval, etc., and can solve problems such as repeated DDL operations

Pending Publication Date: 2021-12-24
BEIJING KINGSOFT CLOUD NETWORK TECH CO LTD
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] The purpose of the embodiments of the present invention is to provide a DDL operation synchronization method, device and electronic equipment to solve the problem that the same DDL operations of multiple sub-tables belonging to the same data table in the distributed database will be synchronized to the centralized database respectively. of the data table, the problem caused by the duplication of DDL operations

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
  • DDL operation synchronization method and device and electronic equipment
  • DDL operation synchronization method and device and electronic equipment
  • DDL operation synchronization method and device and electronic equipment

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0048] The following will clearly and completely describe the technical solutions in the embodiments of the present invention with reference to the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are only some, not all, embodiments of the present invention. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art based on the present application belong to the protection scope of the present invention.

[0049] After the sub-tables stored in each database instance of the distributed database are migrated to the centralized database, each sub-table can still be stored in each database instance. Moreover, users can perform DDL (Data Definition Language) operations on these sub-tables, and synchronize the DDL operations to corresponding data tables in the centralized database. In related technologies, during the synchronization process of DDL operations, the sam...

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 embodiment of the invention provides a DDL operation synchronization method and device and electronic equipment, and relates to the technical field of data migration. The method comprises the steps of traversing each database instance of a distributed database, and when each database instance is traversed, obtaining a first log record for a target sub-table in the database instance; detecting whether a target record matched with the first log record exists in a log file for storing a second log record of the target data table; if yes, traversing the next database instance; and if the target record does not exist, adding the target record in the log file, executing the target DDL operation for the target data table, and traversing the next database instance. Compared with the prior art, by applying the scheme provided by the embodiment of the invention, the problem that the same DDL operation of a plurality of sub-tables belonging to the same data table in the distributed database can be synchronized to the data table in the centralized database respectively, so that the DDL operation is repeated can be solved.

Description

technical field [0001] The invention relates to the technical field of data migration, in particular to a DDL operation synchronization method, device and electronic equipment. Background technique [0002] In the process of traditional data migration, two-way migration between distributed database and centralized database is usually involved. After migrating each sub-table stored in each database instance of the distributed database to the centralized database, each Various subtables can still be stored in the database instance. Moreover, users can perform DDL (Data Definition Language) operations on these sub-tables, and synchronize the DDL operations to corresponding data tables in the centralized database. [0003] Wherein, the so-called DDL operation refers to the operation of changing the structure of the data table, for example, deleting a column in the data table, adding a column in the data table, modifying a column in the data table, deleting a table, and the like...

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/27
CPCG06F16/214G06F16/27
Inventor 张健
Owner BEIJING KINGSOFT CLOUD NETWORK TECH CO LTD