source end Oracle database DDL synchronization method and device based on log analysis

A database and log technology, applied in the computer field, can solve problems affecting the execution efficiency of oracle database transactions, application customers are not allowed to create event triggers, etc.

Active Publication Date: 2019-04-19
WUHAN DAMENG DATABASE
View PDF4 Cites 31 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, in actual application systems, event triggers will affect the execution efficiency of Oracle database transactions, so there are scenarios where application customers are not allowed to create event triggers on the source Oracle database

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
  • source end Oracle database DDL synchronization method and device based on log analysis
  • source end Oracle database DDL synchronization method and device based on log analysis
  • source end Oracle database DDL synchronization method and device based on log analysis

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0023] In order to make the purpose, technical solutions and advantages of the embodiments of the present invention clearer, the technical solutions in the embodiments of the present invention will be clearly and completely described below in conjunction with the drawings in the embodiments of the present invention. Obviously, the described embodiments It is a part of embodiments of the present invention, but not all embodiments. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts belong to the protection scope of the present invention. In addition, the technical features in each embodiment or a single embodiment provided by the present invention can be combined arbitrarily with each other to form a feasible technical solution, but it must be based on the realization of those skilled in the art. When there is a contradiction or cannot be realized, it should be considered that ...

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 embodiment of the invention provides a source end Oracle database DDL synchronization method and device based on log analysis. The method comprises the following steps of: obtaining a sample; deploying a synchronization system in a source end Oracle database and a target end database. initializing an Oracle system dictionary table, constructing a data type mapping table from a source end Oracle database to a target end database, and reading an Oracle log from the source end Oracle database synchronization system by the source end Oracle database synchronization system; Obtaining DDL operation log information and a transaction number according to the operation code of the Oracle log, collecting a DML operation log according to the log information and the transaction number, and collecting the log; analyzing the collected DDL operation logs and the corresponding DML operation logs; according to the Oracle system dictionary table, restoring the DDL statements, and in combination witha data type mapping table from the source end Oracle database to the target end database, comverting the restored DDL statements into DDL statements suitable for being executed by the target end database to achieve target end database synchronization. According to the embodiment of the invention, the DDL operation can be synchronized between the source end Oracle database and the target end database.

Description

technical field [0001] The embodiment of the present invention relates to the field of computer technology, and in particular to a source-end Oracle database DDL synchronization method and device based on log parsing. Background technique [0002] In the database real-time synchronization system (supporting heterogeneity), if the source is Oracle, usually the event trigger of Oracle is used to capture the DDL operation of the source library. However, in an actual application system, event triggers will affect the execution efficiency of Oracle database transactions, so there are scenarios where application customers are not allowed to create event triggers on the source Oracle database. The object information in the database management system is stored by a series of system dictionary tables. When a user creates an object, it will be stored in the system dictionary tables such as SYS.OBJ$, SYS.COL$, and SYS.LOB$ of the Oracle database. Insert corresponding records (table na...

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/23G06F16/27
Inventor 孙峰付铨陈艳杨春
Owner WUHAN DAMENG DATABASE
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