Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

A Synchronous Method for Querying and Creating Table Operations

A technology of query tables and query items, which is applied in the direction of database distribution/replication, structured data retrieval, etc., can solve the problems of large delay, long time-consuming query and table creation operation synchronization, etc., to slow down the synchronization speed and reduce the synchronization delay Effect

Active Publication Date: 2020-12-08
WUHAN DAMENG DATABASE
View PDF6 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] The purpose of the present invention is to overcome the above-mentioned technical deficiencies, provide a synchronization method for query and table building operations, and solve the technical problems of long time-consuming and large delays in query and table building operation synchronization in the prior art

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
  • A Synchronous Method for Querying and Creating Table Operations

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0014] Such as figure 1 As shown, Embodiment 1 of the present invention provides a synchronization method for querying and creating tables, including the following steps:

[0015] Step S1, capture the query and table creation operation of the source database, and extract the query and table creation SQL statement of the query and table creation operation;

[0016] Step S2, judging whether the SQL statement for querying and creating a table meets the condition for synchronizing with the SQL statement, and if so, go to step S3;

[0017] Step S3, sending the SQL statement for querying and building a table to the target database for synchronization, the source database continues to track the transaction log flow of the SQL statement for querying and building a table, and directly inserts the INSERT operation log related to the operation of querying and building a table Discard, and notify the target database to end the synchronization process of the SQL statement for querying and...

Embodiment 2

[0058] Embodiment 2 of the present invention provides a computer storage medium on which a computer program is stored. When the computer program is executed by a processor, the method for synchronizing query and table creation operations provided by any of the above embodiments is implemented.

[0059] The computer storage medium provided by the present invention is based on the above-mentioned synchronization method for query and table creation operations. Therefore, the technical effects of the above-mentioned synchronization method for query and table creation operations are also provided by computer storage media, and will not be repeated here.

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 discloses a synchronization method for querying table building operation, which comprises the following steps of S1 capturing the query table building operation of a source end database,and extracting a query table building SQL statement of the query table building operation; S2 judging whether the query table building SQL statement meets the condition of synchronizing with the SQLstatement or not, and if yes, going to the step S3; S3 sending the query table building SQL statement to a target end database for synchronization, enabling the source end database to continue to track the thing log flow of the query table building SQL statement; and directly discarding the INSERT operation log related to the query table building operation, and notifying the target end database toend the synchronization process of the query table building SQL statement when a submitted log in the thing log stream is captured. According to the synchronization method for the querying table building operation, the synchronization time consumption of the query table building operation can be effectively reduced.

Description

technical field [0001] The invention relates to the technical field of synchronization of query and table building operations in database synchronization, in particular to a synchronization method for query and table building operations. Background technique [0002] In the software-based database data replication technology, the real-time data synchronization technology based on the analysis of log files has the characteristics of small impact on the source database, support for heterogeneous system replication, and readable and writable replication system standby machine, which is widely used in emergency disaster recovery. , multi-business centers, real-time heterogeneous resource integration, data migration and rolling upgrade, data warehouse architecture improvement and other scenarios are widely used. [0003] Real-time data synchronization based on analysis of log files. The main technical principle is that in the source database, the data synchronization process read...

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 Patents(China)
IPC IPC(8): G06F16/27
Inventor 孙峰付铨余院兰
Owner WUHAN DAMENG DATABASE
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

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

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