Data difference comparison method based on Oracle database

A technology of data difference and database, applied in the direction of database management system, database distribution/replication, electronic digital data processing, etc.

Inactive Publication Date: 2018-03-09
THE 28TH RES INST OF CHINA ELECTRONICS TECH GROUP CORP
View PDF4 Cites 13 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] The technical problem to be solved by the present invention is to provide a data difference comparison method based on the Oracle database, which can make full use of the existing data access interface of the Oracle database system, and automatically realize the database comparison without manual intervention, and list the primary and secondary databases. Differences in database table names, database table structures, and data records between databases

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
  • Data difference comparison method based on Oracle database
  • Data difference comparison method based on Oracle database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0025] Such as figure 1 As shown, a data difference comparison method based on an Oracle database includes the following steps:

[0026] Step 1. Connect to two Oracle databases through two user names and passwords, and use SQL statements to obtain all database table names of the two databases through the access interface provided by the databases. After sorting by table names, compare and output inconsistent databases Table Name;

[0027] Step 2, for database tables with the same name, read all the fields and their attributes (data type, length, whether it can be empty, etc.) Same, output different field names and attributes;

[0028] Step 3. Re-sort all fields according to different attributes, sort by unique key, primary key, and name through SQL query statements, convert data records into strings, compare the differences of data records at one time, and output the difference fields.

[0029] Such as figure 2 As shown, in step 1, through the SQL statement, read all the ...

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 data difference comparison method based on an Oracle database. The data difference comparison method comprises the following steps: respectively converting data table names,database table fields and data items in two databases into text strings by utilizing a text comparison method, comparing after respectively sequencing, and finding out data difference. According to the data difference comparison method disclosed by the invention, the difference, comparing database table name difference, database table structure difference, data recording difference and a difference statistical result, of two designated databases can be automatically given; existing data access interfaces and data management characteristics of an Oracle database system can be fully utilized, and detailed difference records of data can be obtained just by providing the user names and the passwords of the two databases without other manual intervention; the problem of database difference caused by various reasons during a running process of quickly and automatically searching main and standby databases is solved, and the problems that under the situation of a large data volume, the manualcomparison speed is slow, and the operation is tedious are solved.

Description

technical field [0001] The invention relates to the technical field of computer database processing, in particular to a data difference comparison method based on an Oracle database. Background technique [0002] The main and standby databases are an effective method to solve data security and improve data access efficiency. The system realizes the data consistency of the main and standby databases through data synchronization technology. However, in the process of data synchronization, there will always be various abnormalities that lead to the inconsistency between the main and standby databases. How to find out the difference between the main and standby databases is the basis for the continued synchronization of the main and standby databases. In the existing database consistency inspection methods, more data consistency inspections are performed manually, and a targeted transformation of the database is required. Contents of the invention [0003] The technical probl...

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): G06F17/30
CPCG06F16/2282G06F16/2433G06F16/25G06F16/27
Inventor 田振兴杨宇静代杰张晓敏史慕志钱金星
Owner THE 28TH RES INST OF CHINA ELECTRONICS TECH GROUP CORP
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