Patent ID: 9703821
Date: 2017-07-11
CPC Classifications: G06F

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