Audit method for data object of database

The invention relates to the field of computers, and discloses an audit method for a data object of a database. The method comprises the following steps that (1) six audit tables are created and used for recording data information of the database, and the six audit tables comprise data object inform...

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
Hauptverfasser: LUO CHUN, ZANG BINGLING, LI CHUN, CHEN DONG, WEI XINGHUA, XIONG ZHONGZHE, QIU DALONG, LI JIANHUI, ZHANG WENJIAN
Format: Patent
Sprache:chi ; eng
Schlagworte:
Online-Zugang:Volltext bestellen
Tags: Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
Beschreibung
Zusammenfassung:The invention relates to the field of computers, and discloses an audit method for a data object of a database. The method comprises the following steps that (1) six audit tables are created and used for recording data information of the database, and the six audit tables comprise data object information, column information of the tables, data object correction historical information, data object dependency information, column correction historical information of the tables and data creating object statements respectively; (2) data in the database is inserted into all the tables which are created in the step (1) through PL/SQL statements, and data initialization is completed; (3) a timing task function is called, and the audit tables are updated through the PL/SQL statements; (4) a trigger records a data object definition operation. The audit method for the data object of the database is characterized in that current and historical data object information is recorded through permanent tables, the precision re