Database Audit Table Tamper Detection via Hash Verification

The patent implements periodic archiving of audit records at predetermined intervals. The audit manager archives audit records from the audit table to archival storage at scheduled times, retaining only recent audit records in the active audit table. This periodic action maintains audit trail completeness while managing storage resources by moving older records to less frequently accessed archival storage.

The patent applies preliminary anti-action by proactively preventing harmful operations before tampering can occur. The audit manager explicitly prohibits delete, update, and drop operations on audit tables, allowing only insert and select operations. This preliminary restriction on permitted operations prevents unauthorized tampering while maintaining necessary audit record management flexibility through selective operation allowance.

The patent extracts historical audit data from the active audit table and stores it in separate archival storage. The audit manager identifies and archives older audit records to external archival storage, allowing the circular audit table to maintain its fixed efficient size while preserving historical data externally. This extraction of historical records resolves the contradiction by maintaining storage efficiency while preventing information loss through external archival preservation.

The patent prevents the creation of duplicate audit tables by implementing a check before table creation. The audit manager verifies whether an audit table with the specified name and schema already exists, and if it does, prevents the creation of a new table with the same characteristics. This preliminary verification prevents security vulnerabilities associated with duplicate tables while maintaining versatility by allowing audit tables to be created with different names or schemas when appropriate.