Data synchronization method and device, computer equipment and storage medium

A data synchronization and computer program technology, applied in the field of data processing, can solve the problems of difficulty in database data migration, migration affecting the normal use of the database, etc.

Pending Publication Date: 2019-08-20
PING AN TECH (SHENZHEN) CO LTD
View PDF7 Cites 20 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

At present, users will use various types of databases for data storage, such as PG, MySQL, ORACLE and other types of databases. Sometimes users need to migrate the data in various types of databases to achieve synchronization in order to save costs. Many types of databases bring difficulties to data migration, and also affect the normal use of the database during the migration process

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 device, computer equipment and storage medium
  • Data synchronization method and device, computer equipment and storage medium
  • Data synchronization method and device, computer equipment and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0028] The following will clearly and completely describe the technical solutions in the embodiments of the present application with reference to the drawings in the embodiments of the present application. Obviously, the described embodiments are part of the embodiments of the present application, not all of them. Based on the embodiments in this application, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts belong to the scope of protection of this application.

[0029] The flow charts shown in the drawings are just illustrations, and do not necessarily include all contents and operations / steps, nor must they be performed in the order described. For example, some operations / steps can be decomposed, combined or partly combined, so the actual order of execution may be changed according to the actual situation.

[0030] Embodiments of the present application provide a data synchronization method, device, computer equipment, an...

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 field of data processing, achieves data synchronization between databases, and particularly provides a data synchronization method and device, equipment and a storage medium. The method comprises the steps of obtaining a log operation file of a source database and a database type corresponding to the source database; determining a file analysis rule corresponding to the database type of the source database according to a preset corresponding relation between the database type and the file analysis rule; analyzing the log operation file according to the determined file analysis rule to obtain an analysis file; obtaining a database type of a target database, and generating an SQL file according to the database type of the target database and the analysis file; and uploading the SQL file to a cloud server to enable the cloud server to send the SQL file to the target database for execution so as to complete data synchronization. According to the method, data synchronization between different databases can be achieved, and meanwhile the data synchronization efficiency is improved.

Description

technical field [0001] The present application relates to the technical field of data processing, and in particular to a data synchronization method, device, computer equipment and storage medium. Background technique [0002] The database can be understood as a data file cabinet, which is used to store various electronic data files. Users can add, intercept, update, delete and other operations on the data in the data files. Now almost all applications are inseparable from the database. support. At present, users will use various types of databases for data storage, such as PG, MySQL, ORACLE and other types of databases. Sometimes users need to migrate the data in various types of databases to achieve synchronization in order to save costs. Many types of databases bring difficulties to data migration, and at the same time, the normal use of the database will be affected during the migration process. Therefore, it is necessary to provide a data synchronization method to sol...

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): G06F16/27
CPCG06F16/275
Inventor 李巍
Owner PING AN TECH (SHENZHEN) 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