Data synchronizing method and device

A data synchronization and data technology, applied in the database field, can solve the problems of low disk database processing performance, in-memory database data cannot be persistent and safe storage, etc., to achieve high reliability and real-time synchronization effect.

Inactive Publication Date: 2016-06-22
SHENZHEN KINGDOM TECH
View PDF8 Cites 16 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] The purpose of the present invention is to provide a method and device for data synchronization, aiming to solve the problems in the prior art that the processing performance of the disk database is not high, and the data of the memory database cannot be stored persistently and safely

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
  • Data synchronizing method and device
  • Data synchronizing method and device
  • Data synchronizing method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0022] figure 1 It is a flow chart of the data synchronization method provided by Embodiment 1 of the present invention, specifically including steps S101 to S103, which are described in detail as follows:

[0023] S101. Synchronize the data in the disk database to the memory database, so that the data in the memory database and the disk database are consistent.

[0024] Specifically, when the system is started, the data in the disk database is synchronized to the memory database, so that the data in the memory database and the disk database are consistent.

[0025] Usually, in order to improve performance, the application program and the memory database are located on the same server, and for data security, the disk database and the memory database can be respectively configured on different servers.

[0026] S102. When the data in the memory database changes, record the database transaction that causes the data change into the transaction log.

[0027] A database transacti...

Embodiment 2

[0034] figure 2 It is a flow chart of the data synchronization method provided in Embodiment 2 of the present invention, specifically including steps S201 to S204, which are described in detail as follows:

[0035] S201. Synchronize the data in the disk database to the memory database, so that the data in the memory database and the disk database are consistent.

[0036] Specifically, when the system is started, the data in the disk database is synchronized to the memory database, so that the data in the memory database and the disk database are consistent.

[0037] Usually, in order to improve performance, the application program and the memory database are located on the same server, and for data security, the disk database and the memory database can be respectively configured on different servers.

[0038] S202. When the data in the memory database changes, record the database transaction that causes the data change into the transaction log.

[0039] A database transact...

Embodiment 3

[0061] image 3 It is a schematic structural diagram of the data synchronization device provided by Embodiment 3 of the present invention. For convenience of description, only the parts related to the embodiment of the present invention are shown. image 3 The exemplary apparatus for data synchronization may be the executing body of the method for data synchronization provided in the first embodiment, which may be a server or a functional module in the server. image 3 The example device for data synchronization mainly includes: an export module 31, a recording module 32 and a synchronization module 33, and each functional module is described in detail as follows:

[0062] The export module 31 is used to synchronize the data in the disk database to the memory database, so that the data in the memory database and the disk database are consistent;

[0063] Recording module 32, for when the data in memory database changes, the database transaction that will cause data to change ...

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 relates to the technical field of a database, provides a data synchronizing method and device and is used for solving the problems in the prior art that the processing performance to the disk database is low and the data in the memory database cannot be stored securely and persistently. The method comprises following steps of synchronizing the data in the disk database to the memory database, thus enabling the data in the memory database and the disk database to be consistent; when the data in the memory database is changed, recording a database affair causing data change in an affair log; and according to the affair log, synchronizing the changed data in the memory database to the disk database. According to the technical scheme provided by the invention, the real time synchronization from the memory database to the disk database is realized; therefore, the memory database satisfies the high processing performance to the data; moreover, the disk database satisfies the demand for storing the data securely and persistently; and the high speed of the memory database and the high reliability of the disk database are exerted fully.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to a data synchronization method and device. Background technique [0002] The traditional database management system puts all the data on the disk for management. Due to I / O (Input / Output, input / output) processing and other reasons, the processing performance of the disk data is often not high, even if the SSD is introduced. (SolidStateDrive, solid state drive), its performance improvement is still limited. [0003] The in-memory database puts almost all the data in the memory, and has carried out various targeted optimization designs on the operation algorithm and data structure of the database, so that the data processing speed of the in-memory database is more than 10 times faster than that of the traditional disk database. up to 1000 times. [0004] However, since the memory database stores data in the memory, once the host machine goes down, the data will be lost, making i...

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/27G06F16/2365
Inventor 赵程章
Owner SHENZHEN KINGDOM TECH
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