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

Database online synchronization method

A data synchronization and database technology, applied in database indexing, database update, database distribution/replication, etc., can solve problems such as slow query, long time spent in data synchronization, and large database impact, and achieve stable synchronization of large amounts of data, The effect of reducing manual participation and short synchronization cycle

Pending Publication Date: 2022-06-24
海南格子山网络科技有限公司
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0002] With the increase of projects, the amount of corresponding data increases rapidly, and as the business scale grows, the time spent on data synchronization will become longer and longer, which cannot meet the time requirements of downstream data warehouse production
Performance bottleneck: directly connecting to the database to query data has a great impact on the database, which is likely to cause slow queries. If the business database does not adopt the active / standby strategy, it will affect the normal service on the business line. If the active / standby strategy is adopted, although it can avoid The performance impact of the business system, but when the amount of data is large, the performance will still be poor

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 online synchronization method

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0027] like figure 1 As shown, this embodiment provides an online database synchronization method, which includes the following steps:

[0028] 1. Establish a data synchronization service;

[0029] 2. Create a service configuration list on the source database to save the service name;

[0030] 3. Create a stored procedure to send synchronization messages, and then create a cursor to read the list information in the service configuration list, and send messages to different services;

[0031] 4. Create a synchronization exception information table and a data synchronization feedback table, which are used to record the exception information that occurs during the data synchronization process and record it in the exception information table, and feed back to the UI interface when the data is abnormal;

[0032] 5. Activate the message queue created in the source database and specify the stored procedure created before;

[0033] 6. Determine the type of operation to perform sync...

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 database synchronization, in particular to a database online synchronization method, which comprises the following steps of: 1, establishing a data synchronization service; 2, creating a service configuration list on the source database; 3, creating a storage process, then reading list information in the service configuration list, and sending messages to different services; 4, creating a synchronization exception information table and a data synchronization feedback table; 5, activating the message queue created in the source database and assigning a storage process; 6, judging an operation type for executing synchronization, and creating a storage process to process and send the data; 7, synchronizing data in the XML data source into the data table; 8, reading information in the message queue and calling a storage process to synchronize the data into a target database; and 9, checking whether the data synchronization information is correct or not through the message queue in the target database. In the task synchronization process, manual participation can be reduced, and the efficiency is high.

Description

technical field [0001] The invention relates to the technical field of database synchronization, in particular to a method for database online synchronization. Background technique [0002] As the number of projects increases, the corresponding data volume increases rapidly, and with the growth of business scale, the time required for data synchronization will become longer and longer, which cannot meet the time requirements of downstream warehouse production. Performance bottleneck: Querying data directly connected to the database has a great impact on the database and is likely to cause slow queries. If the business database does not adopt the active-standby strategy, it will affect the normal services on the business line. The performance of the business system is affected, but when the amount of data is large, the performance will still be poor. SUMMARY OF THE INVENTION [0003] The content of the present invention is to provide an online database synchronization meth...

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/23G06F16/22
CPCG06F16/27G06F16/2379G06F16/2282
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

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