K-DB database data synchronization method, device, equipment and storage medium

A data synchronization and database technology, applied in database distribution/replication, digital data processing, structured data retrieval, etc., can solve the problems of wasting database memory space, unable to synchronize data alone, low data synchronization efficiency, etc., and achieve savings The effect of memory space, improving data synchronization efficiency, and facilitating data recovery

Inactive Publication Date: 2018-08-28
ZHENGZHOU YUNHAI INFORMATION TECH CO LTD
View PDF4 Cites 5 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] The K-DB database in the prior art uses the KSC (K-DB Standby Cluster) architecture that provides core functions such as high availability, data protection, and disaster recovery for the database. Separately synchronize specified table-level, table field-level, or user-level data, and KSC requires that the version and machine configuration of the source and target databases are the same, and requires the use of third-party data synchronization software that is charged and not necessarily adapted. Waste database memory space, data synchronization efficiency 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
  • K-DB database data synchronization method, device, equipment and storage medium
  • K-DB database data synchronization method, device, equipment and storage medium
  • K-DB database data synchronization method, device, equipment and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0041] In order to enable those skilled in the art to better understand the solution of the present invention, the present invention will be further described in detail below in conjunction with the accompanying drawings and specific embodiments. Apparently, the described embodiments are only some of the embodiments of the present invention, but not all of them. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts belong to the protection scope of the present invention.

[0042] see figure 1 , is an implementation flowchart of a K-DB database synchronization method in an embodiment of the present invention, and the method may include the following steps:

[0043] S101: The source database maps the changed target data in the first data table to redo logs.

[0044] When data in the first data table of the source-end database changes, the source-end database may map the changed ...

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 method for K-DB database data synchronization. The K-DB database data synchronization method comprises the following steps: a source end database maps the changed target datato a redo log; the target redo log corresponding to the target data is extracted; the target redo log is sent to target end database, the target end database obtains the target data according to thetarget redo log and synchronizes the target data to the second data table. According to the technical scheme provided by the method for K-DB database data synchronization, the version and the machineconfiguration of the source end database and the target end database are not limited, the third-party synchronization software is not needed, only the changed target data is needed, and the memory space of the target end database is saved, and the data synchronization efficiency is improved. The invention also discloses a K-DB database data synchronization device, a system and a storage medium, and has the corresponding technical effect.

Description

technical field [0001] The invention relates to the technical field of data synchronization, in particular to a K-DB database data synchronization method, device, equipment and a readable storage medium. Background technique [0002] With the development of information technology, enterprises rely more and more on information management. The data information of various business applications is mainly stored in the database, and enterprises have higher and higher requirements for the continuity of these data access. In order to avoid various losses caused by data interruption and ensure data security, real-time data synchronization has become an important method for database management data. [0003] The K-DB database in the prior art uses the KSC (K-DB Standby Cluster) architecture that provides core functions such as high availability, data protection, and disaster recovery for the database. Separately synchronize specified table-level, table field-level, or user-level dat...

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/2358G06F16/27
Inventor 任启立杜彦魁魏本帅
Owner ZHENGZHOU YUNHAI INFORMATION TECH CO LTD
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