Browse Prior Art Database

Method And System For Providing Auditing Information Using Audit System-Version Tables

IP.com Disclosure Number: IPCOM000200554D
Publication Date: 2010-Oct-19
Document File: 2 page(s) / 16K

Publishing Venue

The IP.com Prior Art Database

Abstract

A method and system for providing auditing information using audit system-version tables is disclosed. The auditing information is included in the audit system-version tables by generating additional columns while creating the audit system-version tables.

This text was extracted from a PDF file.
This is the abbreviated version, containing approximately 51% of the total text.

Page 01 of 2

Method And System For Providing Auditing Information Using Audit System-Version Tables

Disclosed is a method and system for providing auditing information using audit system-version tables.

A version table acts as a persistent base table for tracking

inserts and updates to a base table in Structured Query Language (SQL). In order to track inserts and updates, the version table contains additional rows to capture the history of changes as rows are updated or deleted. The additional rows identify the subset of rows that constitutes the content of the table, i.e., the version, as of any point in time. Thus the version table acts as an extension to history tables in SQL.

Further, the version table includes additional columns to capture the start and end times of each row in the table. The behavior of Data Manipulation language (DML) operations on the version table is different from behavior of DML operations on a regular base table.

A query that needs to be evaluated on a specific version table may

be allowed to specify a point in time or a period to identify the specific version table. In the case when a query does not contain a time or period, then the query would be evaluated with respect to a version table that is present when the query is run.

When creating the version table, the version table is identified as an audit system-version table to be used for auditing. Whenever a row is inserted into the system-version table used for auditing, its system-version start time, system-version end time, and auditing information are automatically set by an implementation. In order to update rows of the system-version table, the system-versio...