Data synchronization method and system

A data synchronization and database technology, applied in the direction of electronic digital data processing, structured data retrieval, special data processing applications, etc., can solve the problems of not supporting heterogeneous database synchronization and low efficiency, so as to improve synchronization efficiency and reduce synchronization overhead , to achieve the effect of support

Active Publication Date: 2018-06-01
TRAVELSKY
View PDF8 Cites 6 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] The present invention provides a data synchronization method, system and equipment to at least solve the problems in the related art that the database synchronization technology has low efficiency in the field of remote synchronization or does not support the synchronization of heterogeneous databases

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
  • Data synchronization method and system
  • Data synchronization method and system
  • Data synchronization method and system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0025] Hereinafter, the present invention will be described in detail with reference to the drawings and examples. It should be noted that, in the case of no conflict, the embodiments in the present application and the features in the embodiments can be combined with each other. It should be noted that the terms "first" and "second" in the description and claims of the present invention and the above drawings are used to distinguish similar objects, but not necessarily used to describe a specific sequence or sequence.

[0026] In this embodiment, a data synchronization method is provided, figure 1 is a flowchart of a data synchronization method according to an embodiment of the present invention, such as figure 1 As shown, the process includes the following steps:

[0027] Step S101, the first database system obtains the SQL statement sent by the application program to the second database system;

[0028] Step S102, the first database system executes the database operation ...

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 provides a data synchronization method and system. The method comprises the steps that a first database system acquires an SQL statement sent by an application program to a second database system; the first database system executes database operation corresponding to the SQL statement; and according to state records of database operation executed by the first database system and thesecond database system, the first database system performs database operation on a first database thereof, so that the first database is consistent with a second database of the second database system. Through the data synchronization method and system, the problem that in the prior art, a database synchronization technology has low efficiency in the remote synchronization field or does not support synchronization of heterogeneous databases is solved, database synchronization efficiency is improved, database synchronization expenditure is lowered, and support of the heterogeneous databases isrealized.

Description

technical field [0001] The invention relates to the field of database synchronization, in particular to a data synchronization method and system. Background technique [0002] In the information age, data is growing in a blowout manner. For this reason, many Internet and financial companies have established multiple cross-regional data centers. And if most data centers are only used as disaster recovery, it is a waste. Therefore, many enterprises are exploring the construction of data centers in the remote multi-active mode, that is, remote data centers not only have disaster recovery capabilities, but also have the function of business distribution to undertake production tasks. The key to realizing multi-active in different places lies in the efficiency of database synchronization. [0003] The database synchronization method in the related art is based on the incremental log of the database. For example, the Oracle Streams cluster series uses advanced queue technology ...

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): G06F17/30
CPCG06F16/27
Inventor 彭明田丁建立王尧曹卫东周冬雪周原
Owner TRAVELSKY
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products