Table of Contents
Auditing the Development of a Data Warehouse
Topics
Advances in DBMS/data Warehousing
Current DBMS Environment
What Is a Data Warehouse ?
Some Definitions:
Some Definitions:
Major Differences Between a DBMS--an OS and a Data Warehouse--a Depository
Major Differences Between a DBMS--an OS and a Data Warehouse--a Depository
Three Principles of Data Warehouse:
PPT Slide
Data Warehouse Architectures
Data Warehouse Architectures
PPT Slide
Three-layer Architecture
On Line Analytical Processing (OLAP)
Datamart
Some More Definitions:
Some More Definitions:
Metadata Contains
What Are the Controls That You Need to Ensure for When Auditing Data Warehouse Development?
Auditing Criteria:
Project Planning Controls
Project Planning Controls (cont’d)
Is There a Corporate Policy Dealing With the Deployment of Data Warehouse?
Is the Project Sponsored by Senior Management?
Is the Project Sponsored by Senior Management?
Is the Data Warehouse Project Planned With Project Management Approach?
Has the Project Manager Worked With Senior Management to Identify the Scope of the Project to Include Data From All Appropriate Departments?
Has the PM Included Data Owners From All Departments Who Have Knowledge of Their Database Metadata?
System Architectural Controls
Two Vs Three Layer Design?
Flat File Design
Flat File Design
Identifying Indexing Fields
Scrubbing and Ensuring Data Integrity
Hardware Requirements
Hardware Requirements
Hardware Requirements (Cont’d)
Data Storage Concerns
Ensuring Data Cannot Be Edited
Datamart (OLAP) Requirements
Project Implementation Controls
Project Implementation Controls(cont’d)
Data Warehouse System Operational Controls
Data Warehouse System Operational Controls
Datamart Implementation Controls
Data on the Datamart Must Not Be Editable
Access to the Data Should Be Limited to Those Requiring the Data for Analysis
Users Should Have Control When Data Replication Takes Place
Disposition of Data After Use
Summary
|