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

A breakpoint renewal method during synchronization of database initialized loading

A technology of resuming transmission from breakpoints and databases, which is applied in the directions of database indexing, database distribution/replication, electronic digital data processing, etc. It can solve problems such as reloading and achieve the effect of avoiding repeated initialization

Inactive Publication Date: 2019-03-01
WUHAN DAMENG DATABASE
View PDF5 Cites 6 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] The purpose of the present invention is to overcome the above-mentioned technical deficiencies, provide a method for resuming transmission from breakpoints during synchronous database synchronous initialization and loading, and solve the technical problem in the prior art that the interruption of database synchronous initialization and loading requires reloading of all data tables

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 breakpoint renewal method during synchronization of database initialized loading
  • A breakpoint renewal method during synchronization of database initialized loading

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0012] Such as figure 1 As shown, the embodiment 1 of the present invention provides a method for resuming uploading during database synchronization initialization and loading, including the following steps:

[0013] Step S1: Establish a synchronization record table in the target database, and register the data table that has been initialized and loaded in the synchronization record table;

[0014] Step S2, if the initial loading is interrupted, obtain the synchronization record table from the target database and send it to the source database;

[0015] Step S3: The source database queries the synchronization record table to determine whether the current data table that is being initialized and loaded has been loaded, and if so, skip the initial loading of the current data table, otherwise continue to execute the current data table The initial loading.

[0016] In the method for resuming the interruption during initial loading in the database provided by the present invention, a synch...

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 discloses a breakpoint renewal method during synchronization of database initialized loading, which comprises the following steps: step S1, a synchronous record table is established in atarget database, and the data table which has been initialized and loaded is registered in the synchronous record table; S2, if that load interrupt is initialized, obtain the synchronous record tablefrom the target database and sending the synchronous record table to the source end database; Step S3, the source end database queries the synchronous record table to judge whether the current data table being initially loaded has been loaded, if so, skipping the initialization loading of the current data table, otherwise, continuing to execute the initialization loading of the current data table. The invention can avoid the initialization loading of repeated data tables when the database is synchronized, and the synchronization efficiency is high.

Description

Technical field [0001] The present invention relates to the technical field of database synchronization initialization loading, in particular to a method for resuming data transmission when the database is synchronized initialization loading. Background technique [0002] When using a data synchronization tool to synchronize database data in real time, you first need to perform data initialization operations on the target database to obtain the basic points of data synchronization. After completing the data initialization operation, real-time incremental data synchronization can be performed on this basic data. In real database applications, there may be thousands of data tables in the source database, and the amount of table data is large, which leads to a long time-consuming process of initializing and loading data. In the process of initializing and loading, the network may be unstable. , Database abnormalities, operating system abnormalities and synchronization tool abnormal...

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/27G06F16/242G06F16/22
Inventor 付铨孙峰赵家威杨春
Owner WUHAN DAMENG DATABASE
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