Transaction Log on WORM Architecture with Built-in Audit Helper

摘要

Regulatory Compliance in current industries has become a mandatory requirement of every day business.Many of regulations and policies set standard of conduct by insiders, who, by definition, have been entrusted with authorized access to the system. Therefore, existing security measures that aim at protecting the systemfrom unauthorized access from outside are ineffective in providing sufficient protection and compliance solutions.In considering the compliance solution for current industries, it is vital that the cost of compliant is justifiable for companies. That is, if the costs such as system migration and operational cost outweigh the business value and societal benefits brought on by compliance, there is no rationale for the companies to actively install compliance solutions.This thesis reviews and extends transaction log on WORM (TLOW) architecture, a practical compliance solution that supports long-term immutability for relational tuples. Given that majority of enterprise informationsystems are supported by RDBMS, TLOW allows for smooth transition to the compliant system minimizing the cost and user resistance in its adoption. This thesis aims to solidify the TLOW architecture by internalizing the Audit Helper (AH) module, allowing for securer and more efficient operations by the module.