Data synchronization method and system for internal memory database physical data base

A data synchronization and database technology, applied in the direction of electrical digital data processing, special data processing applications, instruments, etc., can solve the problems that data security cannot be guaranteed, peripheral programs cannot realize functions, etc., and achieve convenient and free file transmission and analysis. Achieve database type independence and operating platform independence, and ensure real-time effects

Inactive Publication Date: 2009-02-18
ZTE CORP
View PDF0 Cites 59 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, the synchronization problem has not been solved, many peripheral progra...

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 synchronization method and system for internal memory database physical data base
  • Data synchronization method and system for internal memory database physical data base
  • Data synchronization method and system for internal memory database physical data base

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0028] Below in conjunction with accompanying drawing and specific embodiment the present invention is described in further detail:

[0029] see figure 1 , the figure shows the data synchronization system proposed by the present invention, including a dedicated memory database A 1 —A N , physical database B 1 —B N . A data synchronization device; wherein, the memory database includes a synchronization log file generation module, and the data synchronization device includes a synchronization log file transmission module, a synchronization log file analysis module, and a synchronization log file redo module. The functions of each part of the above system are as follows:

[0030] Each in-memory database, each time a data modification operation is performed, calls its synchronous log generation module to generate a synchronous log file in binary format for recording data modification operation information, and saves the synchronous log file on the host where the in-memory data...

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 a data synchronization method between a storage database and a physical database and a system, comprising: a storage database, a physical database and a data synchronization unit. The method comprises that: the storage database generates a synchronization log file for recording the data modification operation information according to the established criterion when performing data modification, and stores the file in a host computer of the storage database; the data synchronization unit timely obtains the synchronization log file which is generated novelly from the host computer of the storage database, and stores in an established list locally, then resolves the file, transforms into basic SQL sentences which match with syntactic rules of an object physical database, then builds connection with the object physical database, executes the basic SQL sentences. The invention not only ensures synchronization real-time, but also effectively controls data size of synchronization, accelerates synchronization speed, which is used in a plurality of operating system platforms.

Description

technical field [0001] The invention relates to a data synchronization method and system between a memory database and a physical database. Background technique [0002] With the gradual deepening of social informatization, databases are used more and more widely in all walks of life, especially in the field of communication. The business data volume is very large, the performance requirements are getting higher and higher, and it has a great impact on data security. high demands. In-memory databases have the advantages of fast speed and high performance, so more and more application systems have developed their own dedicated storage programs based on memory computing, which cache commonly used data in memory to speed up access. However, the security of in-memory databases is insufficient. When an abnormal downtime or power failure occurs, the data in the memory will be lost. In this way, a corresponding physical database in the background is required for data backup; in ad...

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 ZTE CORP
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