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

Database data synchronization method and device and storage medium

A data synchronization and database technology, applied in the database field, can solve the problems that Proxy cannot handle, block client transaction requests, etc., and achieve the effect of improving reliability

Active Publication Date: 2021-06-18
金篆信科有限责任公司
View PDF8 Cites 7 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

The disadvantage of the above synchronization method is that if the distributed database and the stand-alone database feed back different response results after receiving the request, the Proxy cannot handle it, and may even block the client's transaction request

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
  • Database data synchronization method and device and storage medium
  • Database data synchronization method and device and storage medium
  • Database data synchronization method and device and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0035] In order to make the purpose, technical solution and advantages of the present application clearer, the present application will be further described in detail below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described here are only used to explain the present application, not to limit the present application.

[0036] It should be understood that in the description of the embodiments of the present application, multiple (or multiple) means more than two, greater than, less than, exceeding, etc. are understood as not including the original number, and above, below, within, etc. are understood as including the original number. If there is a description of "first", "second", etc., it is only for the purpose of distinguishing technical features, and cannot be understood as indicating or implying relative importance or implicitly indicating the number of indicated technical features or implicitly indic...

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 database data synchronization method and device and a storage medium, and the method comprises the steps: receiving a transaction submission request message sent by a client under the condition that transaction response results fed back by a plurality of data nodes are successful, and writing a global transaction ID into a transaction processing table; sending the transaction submission request message to the plurality of data nodes; receiving transaction submission results fed back by the plurality of data nodes; and under the condition that transaction submission results fed back by the plurality of data nodes are all successful, applying for releasing the global transaction ID from a global transaction manager. According to the method, data synchronization between the distributed database and the stand-alone database in the heterogeneous database system can be realized, and the problem of inconsistency caused by sending requests to the two databases at the same time is solved by adopting a way of unidirectional synchronization and binding whether the transaction information to be processed is successfully submitted or not with the transaction, and the reliability of data synchronization is greatly improved.

Description

technical field [0001] The present application relates to the technical field of databases, in particular to a database data synchronization method, device and storage medium. Background technique [0002] A heterogeneous database system is a collection of related multiple database systems, such as a collection of distributed database systems and stand-alone database systems. In a data synchronization scenario of a heterogeneous database system, it is necessary to synchronize client data to a distributed database and a stand-alone database. An existing data synchronization method that can be applied to this scenario is to set up a proxy (Proxy) between the client and the database. The Proxy receives the transaction data of the client, and the Proxy rewrites the transaction data so that it can be distributed by the distributed database accordingly. And the structured language executed by the stand-alone database, and the corresponding structured language is sent to the distr...

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/27G06F9/46
CPCG06F16/27G06F9/466G06F16/275G06F16/273G06F16/2379
Inventor 宦家佳
Owner 金篆信科有限责任公司
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