Database synchronization method, device and equipment

A database and data technology, applied in the field of data processing, can solve problems such as inconsistency and multi-time synchronization of data, and achieve the effects of ensuring data consistency, improving synchronization efficiency, and improving efficiency

Pending Publication Date: 2021-03-02
深圳市明源云科技有限公司
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

At present, the relevant solution is to synchronize the full amount of data in the source database to the target database regularly, which can ensure data consistency, but with the increase of data, it will take a lot of time to perform full synchronization each time; or in the On the basis of a full synchronization, only incremental synchr...

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

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0061] The technical solution in this application will be described below with reference to the accompanying drawings. Apparently, the described embodiments are only some of the embodiments of this application, not all of them.

[0062] In the following description, specific details such as specific system structures and technologies are presented for the purpose of illustration rather than limitation, so as to thoroughly understand the embodiments of the present application. It will be apparent, however, to one skilled in the art that the present application may be practiced in other embodiments without these specific details. In other instances, detailed descriptions of well-known systems, devices, circuits, and methods are omitted so as not to obscure the description of the present application with unnecessary detail.

[0063] The term "comprising" herein indicates the presence of described features, integers, steps, operations, elements and / or components, but does not exc...

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 database synchronization method, device and equipment, and the method comprises the steps: obtaining a first synchronization time point and a second synchronization time point, the first synchronization time point being the synchronization time point of a source data table in a source database, and the second synchronization time point being the synchronization time pointof a target data table in a target database; determining a synchronization time difference value, wherein the synchronization time difference value is the difference between the first synchronizationtime point and the second synchronization time point; and according to the synchronization time difference value, synchronizing the source data table to the target data table in a full-amount synchronization or incremental synchronization mode. According to the method, the source data table is synchronized to the target data table by flexibly selecting a full-amount synchronization or incrementalsynchronization mode through different synchronization time differences, so that the synchronization efficiency can be improved on the premise of ensuring that the data in the target data table is consistent with the data in the source data table.

Description

technical field [0001] The present application relates to the technical field of data processing, and in particular to a database synchronization method, device and equipment. Background technique [0002] With the development of network applications and the accumulation of more and more data, a single database can no longer adapt to the storage and management of explosively growing data. In the ERP application field, with the diversified development of business, the amount of data increases and the types are complex. In order to facilitate data management, developers split the database according to the business subsystem, and split a database into multiple databases. . After the database is split, the joint table query cannot be implemented across databases, so the data in one database needs to be synchronized to other databases that need to use its data. [0003] The two commonly used synchronization methods for databases are full synchronization and incremental synchron...

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): G06F16/27
CPCG06F16/273
Inventor 熊力
Owner 深圳市明源云科技有限公司
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