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

A method and device for real-time synchronization of database data

A real-time synchronization, database technology, applied in the direction of database distribution/replication, structured data retrieval, etc., can solve the problems of long synchronization time and low database synchronization efficiency.

Inactive Publication Date: 2019-01-29
ANHUI JIYUAN SOFTWARE CO LTD +1
View PDF3 Cites 7 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

This method needs to parse the log information, and then convert the log information into SQL statements, which makes the database synchronization inefficient, especially for the first full synchronization of the database, and the synchronization time is longer

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
  • A method and device for real-time synchronization of database data
  • A method and device for real-time synchronization of database data

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0037] This embodiment provides a method for synchronizing database data in real time, which is used in a device for synchronizing database data in real time. like figure 1 As shown, the method includes the following steps:

[0038] S101: Perform full synchronization, and fully synchronize the first data to be synchronized in the source server database to the target database;

[0039] calling the database interface to fully back up the first data to be synchronized;

[0040] Specifically, the first data to be synchronized is all the data in the source server database or part of the specified data in the source server database;

[0041] In this step 101, it may be that the target server where the target database is located actively initiates a data transmission request to the source server, and the source server sends the first data to be synchronized to the target database after receiving the data transmission request, or the source server sends the data to the target databa...

Embodiment 2

[0054] This embodiment provides a real-time database data synchronization device. like figure 2 As shown, the device includes:

[0055] 201: The first execution module executes full synchronization, and fully synchronizes the first data to be synchronized in the source server database to the target database;

[0056] Wherein, the first execution module includes:

[0057] Call unit, call database interface;

[0058] The first synchronization unit is configured to fully back up the first data to be synchronized

[0059] 202: The second execution module executes incremental synchronization, and synchronizes the second data to be synchronized generated in the source server database to the target database;

[0060] Wherein, the second execution module includes,

[0061] The monitoring unit monitors the I / O controller of the source server, and detects that the I / O controller has changed;

[0062] The second synchronization unit synchronizes the second data to be synchronized ...

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 data synchronization, in particular to a method and a device for real-time synchronization of database data. The method includes executing complete synchronization to synchronize the first data to be synchronized in the source server database to the target database; performing incremental synchronization to synchronize the second data to be synchronized generated in the source server database to the target database. The invention is applicable to the real-time synchronization between all databases of the same type, and realizes the real-time synchronization of the database data only through one-time complete synchronization and continuous incremental synchronization. The operation method is simple, and the efficiency of the real-time synchronization of the database is improved.

Description

technical field [0001] The invention relates to the technical field of data synchronization, in particular to a method and device for real-time synchronization of database data. Background technique [0002] With the rapid development of computer technology and database technology, the application range of database is more and more extensive, and the importance of database is getting higher and higher in business system. For some important business systems, especially those in banking, securities, telecommunications and other industries, it is necessary to ensure the business continuity of the business system. One of the important aspects is to ensure the reliability and continuity of database services. [0003] At present, configuring a backup database for the database in the production environment is a common practice to ensure the reliability and continuity of the database. When the database node in the production environment fails, the business can be switched to the bac...

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): G06F16/27
Inventor 胡俊李志浩许良杰沙波谢科军
Owner ANHUI JIYUAN SOFTWARE 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