GNOSIS AUDITABLE DATABASE

12 October 2005

The Gnosis Auditable Database is designed for the forthcoming release of Microsoft SQL Server 2005, and will comprise the following capabilities.

1. The ability to create a single On-line and Auditable database combined.
2. The ability to easily migrate an existing database to become a Gnosis Auditable database.
3. Programs developed for data viewing and maintenance can work for viewing on-line and audit data identically.
4. Access to on-line data equates to the performance of a typical on-line system, as on-line data is partitioned separately from audit data, through the use of SQL Server 2005 Partitioned tables.
5. Access to Audit data is greatly improved by the use of Audit Archives and a Temporal Index, a new technology developed by Gnosis Solutions that greatly improves access to audit data. The Temporal index is specifically designed for SQL Server 2005 and utilises Partitioned tables.
6. Store who changed/committed and when changed/committed for any and every insert, update and delete operation made to the database throughout history.
7. Provide the ability to view the database 'as it was' at any historical date and time.
8. Be able to find out all the objects that were changed in the same SQL-Transaction or Gnosis Transaction.
9. Provide capabilities to manage Audit archives, which store historical audit data. Such as the ability to create new Audit Archives or take an old Audit Archive off-line if so desired, to reduce storage requirements.

An Evaluation version of the Gnosis Auditable database will be made available from the Gnosis web site..