Data difference comparison method based on Oracle database
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 compariso...
Gespeichert in:
Hauptverfasser: | , , , , , |
---|---|
Format: | Patent |
Sprache: | chi ; eng |
Schlagworte: | |
Online-Zugang: | Volltext bestellen |
Tags: |
Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
|
Zusammenfassung: | 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 dur |
---|