Method and device for synchronizing whole-quantity data

A technology for full data and data, applied in the field of full data synchronization methods and devices, can solve the problems of slow data synchronization, heavy database load, affecting the normal operation of the database, etc., so as to improve synchronization efficiency, reduce resource occupancy, and reduce load Effect

Active Publication Date: 2018-06-05
农信银资金清算中心有限责任公司
View PDF12 Cites 9 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

For example, the data in the original database can be copied to the disk, and then copied to the target database through the disk, and the data can also be transferred by calling SQL. However, these methods have slow data synchronization speed and heavy database load, so the original Real-time synchronization of database and target database data, and during the data synchronization process, it will also affect the normal operation of the online database

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
  • Method and device for synchronizing whole-quantity data
  • Method and device for synchronizing whole-quantity data
  • Method and device for synchronizing whole-quantity data

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0031] In order to make the purpose, technical solutions and advantages of the embodiments of the present invention clearer, the technical solutions in the embodiments of the present invention will be clearly and completely described below in conjunction with the drawings in the embodiments of the present invention. Obviously, the described embodiments It is a part of embodiments of the present invention, but not all embodiments. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without creative efforts fall within the protection scope of the present invention.

[0032] figure 1 A schematic flow chart of the full data synchronization method provided by the embodiment of the present invention, as shown in figure 1 As shown, the method includes:

[0033] S101. Read the data file of the source database, and parse out the data dictionary, database objects and transaction data of the data file;

[0034] S102...

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 provides a method and device for synchronizing whole-quantity data. The method comprises the steps that a data file of a source database is read, and a data dictionary, a database objectand transaction data of the data file are analyzed; a data framework formed by the data dictionary and the database object is sent to a data receiving end of a target database in a transaction file form; the transaction data is sent to the data receiving end in a transaction file form; the data receiving end loads the received data framework and the received transaction data into the target database in sequence, and synchronization of the source database and the target database is achieved. According to the method, the synchronization efficiency of the database can be improved, the load of the database can be reduced, and the resource occupancy rate of the database can be reduced.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to a method and device for synchronizing full data. Background technique [0002] The database is the core component of the application business system, and the stability of the database and the continuity of the business are the most concerned issues in the application business system. [0003] In many database application scenarios (such as active-active, remote disaster recovery, etc.), it is usually necessary to keep the data in two or more databases synchronized. [0004] Nowadays, the full amount of data in the original database is usually transferred to the target database through a third-party data container. For example, the data in the original database can be copied to the disk, and then copied to the target database through the disk, and the data can also be transferred by calling SQL. However, these methods have slow data synchronization speed and heavy database load...

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/275
Inventor 白崇东李远卓刘玉李希民刘春生梁永杰李晓远
Owner 农信银资金清算中心有限责任公司
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