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...
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 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 |
---|