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

Table comparison method and system in ORACLE database synchronization environment

A database and environment technology, applied in the field of table comparison

Active Publication Date: 2021-08-20
INFORMATION2 SOFTWARE SHANGHAI
View PDF8 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, in a busy system, there will be a large number of transactions running, and the data of the source database and the target database are changing in real time. How to compare tables in Oracle database synchronization products in such an environment is difficult. Therefore, it is necessary Propose a technical means to solve the problem

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
  • Table comparison method and system in ORACLE database synchronization environment
  • Table comparison method and system in ORACLE database synchronization environment
  • Table comparison method and system in ORACLE database synchronization environment

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0029] The implementation of the present invention is described below through specific examples and in conjunction with the accompanying drawings, and those skilled in the art can easily understand other advantages and effects of the present invention from the content disclosed in this specification. The present invention can also be implemented or applied through other different specific examples, and various modifications and changes can be made to the details in this specification based on different viewpoints and applications without departing from the spirit of the present invention.

[0030] Before describing the present invention, introduce several relevant concepts earlier:

[0031] SCN: System change number, which is used to distinguish the sequence of all operations. SCN in the database is a single sequence that continuously increases with the change of the consistency state of the database. Just as a timestamp represents a fixed point in time, each SCN value also re...

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 table comparison method and system in an ORACLE database synchronization environment, and the method comprises the steps that: S1, when a database synchronization task is in an execution state, a log analysis module analyzes a transaction, and records a source end SCN of the last transaction of a currently analyzed source library; S2, a loading module obtains the transaction from the log analysis result data flow and loads the transaction; S3, the table comparison module sends a snapshot point query request to the log analysis module; S4, when a log analysis module receives a snapshot point query request of the table comparison module, snapshot point query information is generated and inserted into a log analysis result data stream; and S5, in the loading process of the loading module, if the snapshot point query information is encountered, all previous transactions are loaded, the SCN of the target library at the moment is queried, and the SCN of the last transaction of the source library and the target SCN queried from the target library are used as snapshot point messages to be sent to the table comparison module.

Description

technical field [0001] The invention relates to the technical field of computer data backup, in particular to a table comparison method and system in an ORACLE database synchronization environment. Background technique [0002] Oracle database is a very widely used computer software. In order to meet the requirements of disaster recovery and read-write separation in the production environment, database synchronization software is often deployed to synchronize the source database to the target database in real time. The data in the source database is changing in real time, and the target database will also be updated in real time. Database synchronization is divided into two phases: full and incremental. Full synchronization is to synchronize all data at a certain point in time to the target end; incremental synchronization is to synchronize each change to the target end on the basis of full synchronization. . [0003] In ORACLE database synchronization, in some cases, it i...

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/2458G06F16/27
CPCG06F16/2471G06F16/27Y02D10/00
Inventor 李一铭高志会江俊胡军擎
Owner INFORMATION2 SOFTWARE SHANGHAI
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