Managing History: Oracle Total Recall Enables Users to Find, Track, and Use Past and Present Information

Overview

Oracle Total Recall yields many benefits over traditional application- and trigger-based archival methods. First, archival data is tamper-proof. No database users, not even privileged users, can change the historical record. This level of security is increasingly demanded by government regulation. No programming effort is required. There are no archive tables to design, no code to write, and no triggers to debug. The result has far less risk that anyone will inadvertently damage the archive. Performance impact is minimal. There is no direct impact on transaction throughput, because the processes involved in archiving run asynchronously. Oracle Total Recall is implemented natively in Oracle Database and is application-transparent. One can implement it underneath a running application without making changes to existing code.