发明名称 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.
申请公布号 US2015095287(A1) 申请公布日期 2015.04.02
申请号 US201414302461 申请日期 2014.06.12
申请人 International Business Machines Corporation 发明人 Spyker James D.
分类号 G06F17/30 主分类号 G06F17/30
代理机构 代理人
主权项 1. A system for facilitating auditing of database transactions, the system comprising: a replication module configured to maintain logical consistency between a source database table and a shadow database table; a database management module configured to receive a bulk command that specifies edits to a plurality of rows in the source database table, andexecute the bulk command on the source database table; a row level tracking module configured to query the shadow database table to obtain an indication of the plurality of rows edited by the bulk command; andstore the indication as part of an audit trail for the source database table.
地址 Armonk NY US