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

Initialization loading method and device for database synchronization, equipment and storage medium

A data synchronization and database technology, applied in the computer field, can solve problems such as inaccessibility, large amount of table data, and upper-level applications cannot run

Pending Publication Date: 2021-01-15
北京人大金仓信息技术股份有限公司 +1
View PDF5 Cites 1 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] However, if the amount of table data to be loaded is large and the amount of data is large, the method of locking the source-end database will cause the upper-layer application to fail to run for a long time due to the inability to access the source-end database
Although the method of establishing a mapping table avoids locking the source-end database, its implementation logic is complex and will generate a large amount of log data, which not only occupies a large amount of storage space resources of the source-end database, but also affects the source-end log analysis program. Brings extra pressure, and also risks clearing the target database due to cleaning up the mapping table

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
  • Initialization loading method and device for database synchronization, equipment and storage medium
  • Initialization loading method and device for database synchronization, equipment and storage medium
  • Initialization loading method and device for database synchronization, equipment and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0058] In order to more clearly understand the above objects, features and advantages of the present disclosure, the solutions of the present disclosure will be described in further detail below. It should be noted that the embodiments of the present disclosure and the features in the embodiments may be combined with each other under the condition of no conflict.

[0059] Many specific details are set forth in the following description to facilitate a full understanding of the present disclosure, but the present disclosure can also be implemented in other ways different from those described herein; obviously, the embodiments in the specification are only a part of the embodiments of the present disclosure, and Not all examples.

[0060] The database synchronization initialization loading method provided by the embodiment of the present disclosure is mainly applicable to the data initialization process of data synchronization between at least two databases. The database synchr...

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 embodiment of the invention discloses an initialization loading method and device for database synchronization, equipment and a storage medium. The method comprises the steps of acquiring a current activity SCN of a log in a source end database, and sending a synchronization pause request to source end data synchronization service to control the source end data synchronization service to pauselog analysis operation at the current activity SCN; packaging to-be-loaded table data in the source end database into a target data format corresponding to the source end data synchronization service, and inserting the packaged to-be-loaded table data into a synchronization file corresponding to the source end data synchronization service; and sending a synchronization recovery request to the source end data synchronization service, so that the source end data synchronization service sends the synchronization file to the target end database. The to-be-loaded table data is inserted into the synchronization file with data being synchronized, so that the to-be-loaded table data in the source-end database is synchronized to the target-end database by utilizing a synchronization mechanism of incremental data in the database.

Description

technical field [0001] The present disclosure relates to the field of computer technologies, and in particular, to a method, apparatus, device and storage medium for initializing and loading database synchronization. Background technique [0002] The process of real-time synchronization of database data by using data synchronization tools includes three stages: the first stage is to initialize and load the existing data to obtain the basic point of data synchronization; In the third stage, the source data and the target data of the data synchronization are regularly compared and verified. Among them, in the first stage, a large amount of stock data in the source database needs to be loaded into the target database, and the operation of the upper-layer business is not affected. [0003] At present, the implementation methods of initial loading mainly include: locking the source database, and then using the database interface to export all the existing data and loading it int...

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/273
Inventor 王凯龙黄海峰
Owner 北京人大金仓信息技术股份有限公司
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