File based database synchronization method

A data synchronization and database technology, which is applied in the field of file-based database synchronization, can solve the problems of low database synchronization efficiency, impact on source database performance, and non-support for heterogeneous database synchronization, etc., and achieve the goal of improving synchronization efficiency and efficient storage Effect

Inactive Publication Date: 2012-10-24
天津神舟通用数据技术有限公司
View PDF5 Cites 72 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] The purpose of the present invention is to overcome the deficiencies of the prior art, and provide a file-based database synchronization method, which uses the file method to quickly synchronize from the source database to the target data

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
  • File based database synchronization method
  • File based database synchronization method
  • File based database synchronization method

Examples

Experimental program
Comparison scheme
Effect test

Example Embodiment

[0029] Embodiments of the present invention are described in further detail below in conjunction with the accompanying drawings:

[0030] A file-based database synchronization method such as figure 1 As shown, the data synchronization tool component is installed on the source database, and the ETL service component (data extraction, transformation and loading service component) is installed on the target database. Quickly synchronize from the source database to the target database.

[0031] The main function of the data synchronization tool component is: to receive the control command of the ETL service component, store the data to be synchronized into the incremental log file and write the incremental log file to the FTP server.

[0032] The main functions of the ETL service component are: to send control commands to the data synchronization tool component to realize the database synchronization control function; to obtain the incremental log file from the FTP server through...

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 file based database synchronization method, which has the following main technical features that through a mode of installing a data synchronization tool component in a source-end database and installing an ETL (extract transform and load) service component in a target-end database, the control between the ETL service component and the data synchronization tool component is implemented through a protocol, and the synchronization is implemented from the source-end database and the target-end database in a file mode. The method disclosed by the invention is reasonable in design; because the database synchronization is implemented from the source-end database and the target-end database in a file mode, the database data required to be synchronized can be efficiently stored, and in a heterogeneous database and an operating system environment, the synchronous operation of data can be implemented through file analysis, thereby supporting a characteristic of carrying out synchronization on various heterogeneous databases, meanwhile, by using a total synchronization method and an incremental synchronization method, the efficiency of database synchronization is improved.

Description

technical field [0001] The invention belongs to the technical field of database synchronization, in particular to a file-based database synchronization method. Background technique [0002] In a production environment, operating system upgrades or changes, database upgrades, and storage device upgrades can greatly increase the complexity of data migration and synchronization. In the process of data migration, it is often necessary to interrupt the existing business. Such interruption will reduce the service quality and customer satisfaction, and cause huge losses to the enterprise. It can be seen that the synchronization technology of the database is of great significance. [0003] Currently, data synchronization solutions for existing databases mainly include storage replication technology, database replication technology and ETL extraction technology. 1. The storage replication technology is to use the storage array's own disk array to disk array data block replication to...

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): H04L29/08G06F17/30
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