DATABASE AUDITING FOR BULK OPERATIONS

摘要

A method facilitates auditing of database transactions by maintaining logical consistency between a source database table and a shadow database table. A bulk command is received that specifies edits to a plurality of rows in the source database table. The bulk command is executed on the source database table. The shadow database table is queried to obtain an indication of the plurality of rows edited by the bulk command. The indication is stored as part of an audit trail for the source database table.

主权项

1. A method for row level auditing of partition operations, comprising:
replicating a source table to create a shadow table that is hidden from users of the source table; maintaining transactional consistency between the source table and the shadow table; replicating, in response to receiving standard row level operations for the source table, row level operations into the shadow table; transmitting, in response to a partition-level operation on the source table, information about the partition-level operation to the shadow table; retrieving, using the information about the partition-level operation, rows from the shadow table designated as being part of the partition-level operation; constructing a row-level entry for each retrieved row; recording each row-level entry in an audit table; and implementing, in response to completion of the constructing a row-level entry for each retrieved row, the partition-level operation on the shadow table.