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

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

[0166] Example 1: The data table "The third quarter table" is a data table based on the changes of the data table "August statistical table". Therefore, the data table "The third quarter table" is related to the data table "August statistical table". In application, if a target database stores the data table "August Statistical Table", it is usually also stored in the data table "August Statistical Table" related to the data table "third quarter table". Therefore, the target database needs to be synchronized The data table "August statistical table" and the data table "the third quarter table" are related, and the embodiment of the present invention divides the data table "August statistical table" and the data table "the third quarter table" into data change events All data in the same event queue can be quickly sent to the target server connected to the target database with the data table "August Statistical Table" and the data table "Q3 Table" that need to be synchronized , ...

Example

[0167] Example 2: Define that when inserting and modifying the data table "Operation Table", the field inserted in the data table "Operation Table" must be a 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 the field into the data table "Background Service Table" first, and then add the data The table "operation table" is inserted into this field. At this time, the data table "Background Service Table" is related to the data table "Operation Table". In actual applications, the data table "Background Service Table" and the data table "Operation Table" should also be put into an event queue to facilitate the target When the database synchronizes records, the sequence of operations on the data table "Background Service Table" first and then on the data table "Operation Table" is ma...

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 Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap