Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Database synchronization method and device, computer equipment and readable storage medium

A data synchronization and database technology, which is applied in the directions of database update, database distribution/replication, structured data retrieval, etc., can solve the problems of low efficiency of database synchronization and high labor cost, so as to improve synchronization efficiency and reduce labor cost. Effect

Pending Publication Date: 2021-03-26
PING AN BANK CO LTD
View PDF5 Cites 1 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] The purpose of the present invention is to provide a database synchronization method, device, computer equipment, and readable storage medium, which are used to solve the problems in the prior art that involve a large amount of manual identification of the database to be updated associated with the database, and iterate and update The data is added to the database to be updated, resulting in high labor costs and low efficiency of database synchronization

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

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0042] see figure 1 , a database synchronization method in this embodiment, comprising:

[0043] S102: identifying the target database and the original database;

[0044] S103: Acquire target data from the target database, and acquire original data from the original database;

[0045] S105: Comparing the difference between the target data and the original data to obtain difference data;

[0046] S107: Load the difference data into a preset formula program to obtain a synchronization script, and synchronize the difference data to the target database or the original database through the synchronization script, so that the target data and the original data Data synchronization in .

[0047]In an exemplary embodiment, the databases to be synchronized that have a corresponding relationship are obtained through the preset synchronization library table, the update time of the databases to be synchronized is obtained, and the database to be synchronized whose update time is closest...

Embodiment 2

[0052] This embodiment is a specific application scenario of the first embodiment above. Through this embodiment, the method provided by the present invention can be described more clearly and specifically.

[0053] Next, in the server running the database synchronization method, information synchronization is performed on the buffer and database therein and the return password identification is compared to the difference between the target data and the original data to obtain difference data, and the difference data is loaded The method provided in this embodiment will be described in detail by taking the synchronous script obtained from a preset formula program as an example. It should be noted that this embodiment is only exemplary, and does not limit the protection scope of the embodiment of the present invention.

[0054] figure 2 A schematic diagram of an environment application of the database synchronization method according to Embodiment 2 of the present application...

Embodiment 3

[0109] see Figure 4 , a database synchronization device 1 of the present embodiment, comprising:

[0110] Database identification module 12, for identifying target database and original database;

[0111] A data acquisition module 13, configured to acquire target data from the target database, and acquire original data from the original database;

[0112] A difference comparison module 15, configured to compare the difference between the target data and the original data to obtain difference data;

[0113] A data synchronization module 17, configured to load the difference data into a preset formula program to obtain a synchronization script, through which the difference data is synchronized to the target database or the original database, so that the target data Synchronize with the data in the original data. Optionally, the database synchronization device 1 also includes:

[0114] The trigger module 11 is configured to respond to a preset trigger cycle or a synchronizat...

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 technical field of big data processing, and discloses a database synchronization method and device, computer equipment and a readable storage medium. The method comprisesidentifying a target database and an original database; obtaining target data from the target database, and obtaining original data from the original database; comparing the difference between the target data and the original data to obtain difference data; and loading the difference data into a preset formula program to obtain a synchronization script, and synchronizing the difference data into the target database or the original database through the synchronization script to synchronize the data in the target data and the original data. The invention also relates to a blockchain technology,and information can be stored in the blockchain node. According to the invention, the synchronization operation of the target database and the original database is automatically realized, the databasesynchronization efficiency is greatly improved, and the situations of overlarge labor cost investment and relatively low efficiency caused by manual search and data synchronization are reduced.

Description

technical field [0001] The present invention relates to the technical field of data processing of big data, in particular to a database synchronization method, device, computer equipment and readable storage medium. Background technique [0002] In the process of IT system construction, with the continuous iteration of design and requirements, the database structure and configuration files are constantly updated. For the same application, the code is evolving, the database metadata information is evolving, and the configuration files are evolving; code evolution currently has The relatively mature code management tools GIT and SVN have mature configuration center systems (Apollo, etc.) for the evolution of configuration files, but there is no easy-to-use tool in the industry for the evolution of database structures. [0003] Therefore, the inventor found that once the data in a certain database is iterated, updated, etc., it is necessary to invest a lot of manual work to ide...

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/23G06F16/27
CPCG06F16/2365G06F16/27
Inventor 董青松梁海涛张广智
Owner PING AN BANK CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com