Supercharge Your Innovation With Domain-Expert AI Agents!

DDL synchronization method and device for PostgreSQL database, equipment and medium

A data synchronization and database technology, applied in the computer field, can solve problems such as inability to directly support DDL incremental data synchronization

Pending Publication Date: 2021-01-15
北京人大金仓信息技术股份有限公司
View PDF0 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

As a result, third-party data synchronization tools cannot directly support DDL incremental data synchronization of the PostgreSQL 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
  • DDL synchronization method and device for PostgreSQL database, equipment and medium
  • DDL synchronization method and device for PostgreSQL database, equipment and medium
  • DDL synchronization method and device for PostgreSQL database, equipment and medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0058] In order to more clearly understand the above objects, features and advantages of the present disclosure, the solutions of the present disclosure will be further described in detail below. It should be noted that, in the case of no conflict, the embodiments of the present disclosure and the features in the embodiments can be combined with each other.

[0059] In the following description, many specific details are set forth in order to fully understand the present disclosure, but the present disclosure can also be implemented in other ways than described here; obviously, the embodiments in the description are only some of the embodiments of the present disclosure, and Not all examples.

[0060] The DDL synchronization method of the PostgreSQL database provided by the embodiment of the present disclosure is applicable to the data synchronization process between at least two databases whose source database is a PostgreSQL database, and the type of the target database is n...

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 discloses a DDL synchronization method and device for a PostgreSQL database, equipment and a medium. The method comprises the steps of creating an auxiliary table in asource end PostgreSQL database and using for recording DDL statements generated in the database; capturing an executed DDL statement and a DDL valid path based on an event trigger mechanism of a source PostgreSQL database, and inserting the DDL statement and the DDL valid path into an auxiliary table to generate log information of a corresponding DML operation; converting the DML operation into aDDL statement or a DML statement based on whether an operation object of the DML operation in the log information is an auxiliary table or not, and packaging the converted DDL statement or DML statement into a corresponding synchronization object; and sending the synchronization object to a target end data synchronization service to complete DDL synchronization of the PostgreSQL database. The event trigger mechanism based on the PostgreSQL database at the source end is achieved, DDL statements executed in the database are automatically captured and converted into DML operation through INSERT operation to be stored in a log, the DDL operation is indirectly recorded in the PostgreSQL database, and therefore the PostgreSQL database has the DDL synchronization function.

Description

technical field [0001] The present disclosure relates to the field of computer technology, and in particular to a DDL synchronization method, device, device and medium of a PostgreSQL database. Background technique [0002] In the field of database synchronization, it is a common real-time replication technology to achieve real-time data synchronization by analyzing database logs to obtain incremental data. This technology parses the online log or archived log of the source database through the source-side data synchronization service to obtain data additions, deletions and changes (that is, incremental data); then, the source-side data synchronization service converts these changes into data synchronization services in units of transactions The specific internal message format of the source-end data synchronization service is sent to the target-end data synchronization service through the private transmission protocol of the source-end data synchronization service; finally,...

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
IPC IPC(8): G06F16/27G06F16/23G06F16/28
CPCG06F16/27G06F16/2358G06F16/284
Inventor 王凯龙
Owner 北京人大金仓信息技术股份有限公司
Features
  • R&D
  • Intellectual Property
  • Life Sciences
  • Materials
  • Tech Scout
Why Patsnap Eureka
  • Unparalleled Data Quality
  • Higher Quality Content
  • 60% Fewer Hallucinations
Social media
Patsnap Eureka Blog
Learn More

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2025 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com