Data synchronization method between memory database and physical database

A data synchronization and database technology, applied in the field of data processing, can solve the problem of low data synchronization efficiency, reduce transmission loss and waste of disk space, reduce size, and improve synchronization efficiency

Active Publication Date: 2011-01-12
SHENZHEN TIANYUAN DIC INFORMATION TECH CO LTD
View PDF3 Cites 26 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0009] The existing data synchronization method needs to record a large number of logical logs, and the efficiency of data synchronization is not high, so it needs to be improved urgently

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 between memory database and physical database
  • Data synchronization method between memory database and physical database
  • Data synchronization method between memory database and physical database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0040] figure 1 Shown is a flow chart of the data synchronization method between the memory database and the physical database of the present invention. The method includes: step 1, expressing the operation on the source database in the form of SQL operation, decomposing the SQL operation into SQL syntax and corresponding SQL parameters, registering the SQL syntax and SQL parameters for operating the source database, and combining the registered SQL syntax and SQL parameters are stored in the SQL management area for management; step 2, for data changes in the source database, generate logical logs in the form of SQL syntax combined with SQL parameters; step 3, according to the registered SQL syntax and SQL parameters, the Logical logs are redone at the destination database.

[0041]In step 3, each logical log is associated with an SQL syntax. When redoing the destination database, first search for the prepared SQL syntax through the SQL syntax registered in the management are...

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 an memory database and a physical database. The method comprises the following steps: 1) representing the operation to the source database in the mode of SQL operation, decomposing the SQL operation to an SQL syntax and the corresponding SQL parameters, registering the SQL syntax and the SQL parameters of the operation source database, storing the registered SQL syntax and the SQL parameters in an SQL management region to manage; 2) for a data change of the source database, combining the SQL syntax with the SQL parameters to generate a logical log; and 3) regenerating the logical log of the step 2) in the target database according to the registered SQL syntax and the SQL parameters. The data synchronization method of the invention utilizes the prepare mechanism once and the execute mechanism many times to greatly increase the synchronization efficiency; the size of the logical log is reduced, the transmission loss of the system and the waste of the disk space are reduced; and the synchronization application and the corresponding SQL changes can be supported, and the updating and extending of the system can be supported.

Description

technical field [0001] The invention relates to a data processing method, in particular to a data synchronization method between an internal memory database and a physical database. Background technique [0002] Modern communication is increasingly dependent on computer technology. In the continuous development of telecom operators, various information systems have been established, including operating network systems, integrated camping systems, billing systems, office automation systems, customer service systems, large Customer management system, business analysis and decision-making system, etc. These systems have accumulated a large amount of valuable data. Through data mining, query analysis and online analysis of these data, market opportunities can be identified, market strategies can be formulated, and customers can be further improved. relation. However, these data materials are too large, and the number of records is often in the hundreds of millions. Taking China...

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
Inventor 蒋述庭杨东洋汪东升
Owner SHENZHEN TIANYUAN DIC 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

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