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

Database synchronization method and device

A data synchronization and database technology, applied in the database field, can solve the problems of heavy workload and low efficiency of manual operation, so as to improve efficiency, realize automatic control, and avoid low efficiency

Active Publication Date: 2015-07-29
UNION MOBILE PAY
View PDF2 Cites 23 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] In the above solution, when the number of newly added target databases is large and the content of the data tables to be synchronized is large, the workload is heavy and the efficiency of manual operation is low

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

Examples

Experimental program
Comparison scheme
Effect test

example 1

[0166] Example 1, the data table "Third Quarter Table" is a data table based on the changes in the data table "August Statistical Table", so the data table "Third Quarter Table" is associated with the data table "August Statistical Table". In the application, if a target database stores the data table "August Statistical Table", it is usually stored in the data table "Third Quarter Table" related to the data table "August Statistical Table". Therefore, the target database needs to be synchronized There is an associated data table "statistical table for August" and a data table "third quarter table", and the embodiment of the present invention makes the data change event corresponding to the data table "statistical table for August" and the data table "third quarter table" They are all placed in the same event queue, and all the data of the data table "August statistics table" and data table "third quarter table" that need to be synchronized by the target database can be quickly...

example 2

[0167] Example 2: When it is defined to insert and modify the data table "operation table", the field inserted into the data table "operation table" must be the field with the same content in the data table "background service table". In some cases, when you need to insert a field that does not exist in the current data table "Background Service Table" into the data table "Operation Table", you need to insert this field into the data table "Background Service Table" first, and then modify the data The table "Action Table" inserts this field. At this time, the data table "Background Service Table" is related to the data table "Operation Table". When the database is synchronously recording, keep the order of operating the data table "Background Service Table" first and then operating the data table "Operation Table". If the data change events of the data table "Background Service Table" and the data table "Operation Table" are placed in two event queues, the target database may...

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 relates to the technical field of databases, in particular to a database synchronization method and a database synchronization device, which are used for improving the initialization efficiency in a data synchronization process of a target database. According to the database synchronization method and the database synchronization device, a total data request message is sent to a source snapshotting server by a target server, determined total data information is sent to the target server by the source snapshotting server, so that a total data snapshotting document is obtained by the target server according to the total data information, and the total data snapshotting document is led into the target database, and thus, the initialization process of the target database is finished, thereby realizing automatic initialization control in the data synchronization process of the target database and improving the initialization efficiency in the data synchronization process of the target database.

Description

technical field [0001] The embodiment of the present invention relates to the technical field of databases, in particular to a database synchronization method and device. Background technique [0002] E-commerce is becoming more and more popular, and the data volume of real-time transaction systems is also increasing day by day. However, the processing capacity of a single database is limited. Therefore, it is necessary to establish multiple target databases based on the source database according to business or function, so as to reduce the access pressure on the source database. When a data table in the source database changes, it is necessary to ensure that the data table in the target database concerned with the data table changes consistently with the data table in the source database. Therefore, a synchronization device is needed to realize the synchronization between the target database and the source database. Synchronization of data between source databases. [0003...

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): G06F17/30
Inventor 张斌刘胜
Owner UNION MOBILE PAY
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