Abstract: Described is a database audit system used to monitor, and optionally alert on database activity, providing a complete record of access to data and database structure. The data audit system may also provide an audit trail of data accesses and changes to database schema and permissions. A database audit may be performed by collecting data from database transaction logs and traces, exporting the collected data into a repository, and analyzing the data in the repository to create data audit reports and to provide data audit browsing capabilities.
Type:
Grant
Filed:
November 5, 2003
Date of Patent:
August 5, 2014
Assignee:
Lumigent Technologies, Inc.
Inventors:
Lev Vaitzblit, Jonathan Jesse, Jason Orendorff, Stephen Ng, Murray S. Mazer
Abstract: A database audit system monitors database activity, providing a complete record of access to data and database structure. A database audit may be performed by collecting data from database transaction logs and traces, exporting the collected data into a repository, and analyzing the data in the repository to create data audit reports and to provide data audit browsing capabilities. A separation between audit side and audited data side is maintained through limited access permissions.
Type:
Application
Filed:
June 30, 2005
Publication date:
January 4, 2007
Applicant:
Lumigent Technologies, Inc.
Inventors:
Lev Vaitzblit, Jonathan Jesse, Gregory George
Abstract: Described is a database audit system used to monitor, and optionally alert on database activity, providing a complete record of access to data and database structure. The data audit system may also provide an audit trail of data accesses and changes to database schema and permissions. A database audit may be performed by collecting data from database transaction logs and traces, exporting the collected data into a repository, and analyzing the data in the repository to create data audit reports and to provide data audit browsing capabilities.
Type:
Application
Filed:
November 5, 2003
Publication date:
May 5, 2005
Applicant:
Lumigent Technologies, Inc.
Inventors:
Lev Vaitzblit, Jonathan Jesse, Jason Orendorff, Stephen Ng, Murray Mazer
Abstract: Most commercial database systems provide a recovery mechanism that is used to restore data integrity in the event of a hardware or software failure. Many of these systems restore the database from the most recent backup file by rolling forward all transactions from the most recent undamaged transaction log. The present invention discloses a novel system and method for recovering data from user or application errors. Embodiments of the present invention selectively target and undo only those transactions that caused data corruption. In this way, the present invention is able to recover fine-grained database objects such as a table or a row within a table. The present invention has the further advantage of minimizing the number of transactions that are lost after recovery.