Oracle database synchronization system and method based on SCN mode

A technology for synchronizing systems and databases. It is applied in database management systems, database distribution/replication, and redundancy in operations for data error detection. It can solve the problems of high network load, inability to reflect historical data status, and high performance costs. Achieving the effect of efficient transmission, wide application prospects, and improved transmission efficiency

Pending Publication Date: 2019-08-27
INSPUR QILU SOFTWARE IND
View PDF2 Cites 16 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, this method has high network load, high performance cost, and cannot reflec

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
  • Oracle database synchronization system and method based on SCN mode

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0030] In order to make the technical problems, technical solutions and beneficial effects to be solved by the present invention clearer, the present invention will be described in detail below in conjunction with the embodiments. It should be noted that the specific embodiments described here are only used to explain the present invention, not to limit the present invention.

[0031] This Oracle database synchronous system based on SCN mode comprises extraction module, conversion module and warehouse-in module, and described extraction module is arranged in the collection front-end processor, is used to extract the raw data of source Oracle database; Described conversion module and warehouse-in The module is set in the synchronization server, the conversion module is used to convert the received raw data into a standard format, and the storage module is used to write the standard format data into the target Oracle database.

[0032] Also be provided with CMSP distributed mess...

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 particularly relates to an Oracle database synchronization system and method based on an SCN mode. The Oracle database synchronization system based on the SCN mode comprises an extraction module, a conversion module and a storage module, the extraction module is arranged in an acquisition front-end processor and is used for extracting the original data of a source Oracle database, and the conversion module and the storage module are arranged in the synchronous server. The conversion module is used for converting the received original data into a standard format, and the storage module is used for writing the standard format data into a target Oracle database. According to the Oracle database synchronization system and method based on the SCN mode, the data synchronization ofthe table structure can be realized, the automatic table building at a destination end, the total data synchronization and the real-time incremental data synchronization are supported, messages are efficiently transmitted by the aid of the CMSP distributed message service, the data transmission efficiency is greatly improved, and the method and the system have a wide application prospect in business scenarios with higher data synchronization requirements.

Description

technical field [0001] The invention relates to the technical field of database data synchronization and backup, in particular to an Oracle database synchronization system and method based on an SCN mode. Background technique [0002] With the rapid development of the information age and the rise of big data and artificial intelligence, data, as a resource, is increasingly valued by some enterprises and units, and the economic and social value of data output is becoming more and more obvious. In today's society, enterprise data is becoming more and more large and complex, showing the characteristics of huge data volume, various types of data including structured data and unstructured data, and single data storage, which will inevitably bring hidden dangers to data security and unreliability. Therefore, Data synchronization and backup are becoming more and more important. [0003] The commonly used Oracle incremental data synchronization methods are as follows: [0004] 1. ...

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/27G06F16/25G06F11/14
CPCG06F16/275G06F16/254G06F11/1448
Inventor 曹景亮李朝铭
Owner INSPUR QILU SOFTWARE IND
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap