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

A method and a device for realizing cross-gateway Oracle database synchronization based on CMSP

A database and cross-network technology, applied in the direction of database distribution/replication, structured data retrieval, etc., can solve problems such as unable to transmit data normally, destroy the order of messages, etc., to ensure orderliness, efficiency, and timeliness and high efficiency, to ensure real-time effects

Inactive Publication Date: 2019-02-12
INSPUR QILU SOFTWARE IND
View PDF4 Cites 16 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

In the intranet environment with gatekeeper isolation, when the isolation security is guaranteed (only file exchange is allowed, protocol is not allowed to pass, etc.), CMSP cannot transmit data normally, such as simply taking the message out of the message queue to generate a file and The exchange through the gatekeeper destroys the order of the messages, and CMSP loses some application scenarios that require strict order, such as Oracle database synchronization.

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 a device for realizing cross-gateway Oracle database synchronization based on CMSP
  • A method and a device for realizing cross-gateway Oracle database synchronization based on CMSP
  • A method and a device for realizing cross-gateway Oracle database synchronization based on CMSP

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0045] As attached figure 1 , 2 As shown, the method of the present invention for realizing cross-gatekeeper Oracle database synchronization based on CMSP, the method is based on Oracle database and CMSP, including external network Oracle database, internal network Oracle database, first message queue 10, second message queue 20 , Gatekeeper 30, the implementation steps of the method include:

[0046] S100: Collect information of the Oracle database on the external network and save it in the first message queue 10 in the form of a message;

[0047] S200: The messages of the first message queue 10 are sequentially transmitted across the gatekeeper 30 to the second message queue 20;

[0048] S300: The internal Oracle database obtains the collected information of the external Oracle database from the second message queue 20 in an orderly manner.

[0049] In step S100, the collected external network Oracle database information includes full data and incremental data; full data is obtained...

Embodiment 2

[0055] As attached figure 2 , 3 As shown, the present invention also provides a device for realizing cross-gatekeeper Oracle database synchronization based on CMSP. The device is based on Oracle database and CMSP and includes external network Oracle database, internal network Oracle database, first message queue 10, and second message queue. 20. Gatekeeper 30. The gatekeeper 30 itself has a file exchange function and includes:

[0056] The collection module 60 is responsible for collecting information of the Oracle database on the external network and storing it in the first message queue 10 in the form of messages;

[0057] The first conversion module 40 is responsible for reading messages from the first message queue 10 in an orderly manner and generating a first file M with an encoded file name in real time. The file name of the first file contains the start of the message read by the first conversion module 40 Serial number and ending serial number. For example, the file name ...

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 provides a method for realizing cross-gateway Oracle database synchronization based on CMSP, belonging to the technical field of cross-gateway data synchronization, The method is based on Oracle database and CMSP, including an intranet Oracle database, an outer-net Oracle databse, a first message queue, a second message queue and an network gate, and comprises the following steps: collecting the information of Oracle database in the external network and storing the information in the form of message to the first message queue; A first conversion module is added between the firstmessage queue and the gateway, and a second conversion module is added between the second message queue and the gateway. By utilizing the file exchange function of the gateway, the messages of the first message queue are transmitted to the second message queue through the first conversion module and the second conversion module in an orderly and real-time manner. The intranet Oracle database orderly obtains the collected information of the extranet Oracle database from the second message queue. The method realizes the cross-gateway synchronization of the Oracle database, and ensures the timeliness and efficiency of the Oracle database. The invention also protects a device for realizing cross-gateway Oracle database synchronization based on CMSP.

Description

Technical field [0001] The invention relates to the technical field of cross-gatekeeper data synchronization, and specifically relates to a method and device for realizing cross-gatekeeper Oracle database synchronization based on CMSP. Background technique [0002] In the government or enterprise environment, due to security requirements, the internal network and the external network need to be "physically separated", but the internal network and the external network also need to exchange data (such as Oracle database synchronization), so a gatekeeper is introduced. There are three levels in the definition of gatekeeper isolation: [0003] Physical isolation: To simulate the process of manual exchange, data must be exchanged on the nodes of the internal and external networks, and data exchange between any computer on the network cannot be realized. This method is highly secure. [0004] Network isolation: On the basis of simple exchange, the data package exchange of the file transfe...

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 INSPUR QILU SOFTWARE IND
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