Monday, April 09, 2007
Audit Data Warehouse
At MIS Training's Super Strategies conference in Las Vegas Oversight will present an early morning workshop (7:30 to 8:15am) on the characteristics of a robust audit data warehouse (ADW).
The audit data warehouse can provide the basis for continuous auditing (CA) and continuous monitoring (CM) solutions. There are considerable efficiencies that can be gained by leveraging a single data infrastructure for both programs. However there are a number of critical requirements that the ADW must meet to maintain the integrity for the regulatory compliance applications.
First and foremost the ADW must maintain an uncorrupted copy of the transaction data, then the subsequent analysis for CA and CM can occur without compromising compliance. In a sense the ADW is equivalent to the financial systems themselves and obviously both CA and CM can be applied to the same financial systems. The ADW is simply a mirror of the financial systems. Typically the ADW data structures follow a different organizational layout than the financial systems. Financial systems have an on-line transaction processing (OLTP) based data model. The OLTP model is designed to support a high transaction rate while the ADW is designed to support decision support queries. Ralph Kimball is often cited as one of the originators of specific data warehouse data models - see www.kimballgroup.com
See you early in the morning in Las Vegas.
posted by Patrick Taylor @ 10:51 PM