Unlock instant, AI-driven research and patent intelligence for your innovation.

A data synchronization method, device and equipment

A data synchronization and data technology, which is applied in the field of data processing, can solve the problems of high requirements on the attributes of the database itself and the inability to achieve database data synchronization.

Active Publication Date: 2021-11-09
北京信安世纪科技股份有限公司
View PDF7 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] Existing data synchronization methods are generally only suitable for data synchronization between databases of the same type and version. It can be concluded that the existing data synchronization methods of databases have high requirements for the attributes of the database itself, and cannot achieve data synchronization between different types of databases. data synchronization

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

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0082] Before executing the data synchronization method provided by the present invention, a timestamp field and a synchronization state field are added in each database table included in the database, the timestamp field is used to represent the writing time of each piece of data in the database table, and the The synchronization status field is used to represent whether each piece of data in the database table has been synchronized;

[0083] Specifically, the device managing any database may add a timestamp field timestamp and a synchronization status field syncstatus to each database table contained in the database in advance. Then, when writing data to any database table contained in the database, the time of writing to the database can be recorded. For example, the format of any database table can refer to Table 1:

[0084] Table 1

[0085]

[0086]

[0087] It can be seen from Table 1 that the row of each serial number represents a piece of data, and the column co...

Embodiment 2

[0143] After using the method provided by Embodiment 1 of the present invention to synchronize the unsynchronized data in other databases to be synchronized except the central database to the central database, in order to realize data synchronization between databases, for other databases to be synchronized, the central database can be The data in the database is synchronized to other databases to be synchronized. That is to say, the present invention can also execute after performing step S14 Image 6 The process shown includes the following steps:

[0144] S11a. Determine the database tables in the central library that need to be synchronized according to the identification information of the database tables that need to be synchronized in the central library.

[0145] During specific implementation, when performing the data synchronization method provided by Embodiment 1 of the present invention, when synchronizing the unsynchronized data in other databases to be synchroni...

Embodiment 3

[0186] Based on the same inventive concept, an embodiment of the present invention also provides a data synchronization device. Since the problem-solving principle of the above-mentioned device is similar to that of the data synchronization method, the implementation of the above-mentioned device can refer to the implementation of the method, and the repetition will not be repeated.

[0187] like Figure 10As shown, it is a schematic structural diagram of a data synchronization device provided in Embodiment 3 of the present invention, including: an acquisition unit 61, a first determination unit 62, a second determination unit 63, and a first synchronization processing unit 64, wherein:

[0188] The acquisition unit 61 is configured to acquire a configuration file for providing synchronization services, the configuration file includes attribute information of a pre-selected central library, identification information of database tables to be synchronized in each database to be ...

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 data synchronization method, device and equipment. The method includes: obtaining a configuration file for providing synchronization services; The identification information of the database table determines the database table that needs to be synchronized in the database to be synchronized; according to the synchronized timestamp corresponding to the database to be synchronized, extract the write time from the determined database table that needs to be synchronized later than the synchronized timestamp . The synchronization status field represents unsynchronized data, wherein each database table contained in each database to be synchronized includes a timestamp field and a synchronization status field; and the data extracted from each database to be synchronized is synchronized to the central library. Using the above method, by adding a timestamp field and a synchronization state field in the database, data synchronization between databases of different types and versions can be realized without considering the type or version of the database.

Description

technical field [0001] The present invention relates to the technical field of data processing, in particular to a data synchronization method, device and equipment. Background technique [0002] The data synchronization method in the database commonly used in the prior art is generally based on the synchronization technology of the database itself to realize the data synchronization. The devices carrying the two databases are connected, that is, dual-machine hot backup is performed, thereby realizing the synchronization of data in the two databases. [0003] Existing data synchronization methods are generally only suitable for data synchronization between databases of the same type and version. It can be concluded that the existing data synchronization methods of databases have high requirements for the attributes of the database itself, and cannot achieve data synchronization between different types of databases. data synchronization. [0004] Therefore, how to realize d...

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 Patents(China)
IPC IPC(8): G06F16/23G06F16/27
Inventor 赵剑竹张庆勇王翊心
Owner 北京信安世纪科技股份有限公司