Document Type

Closed Project

Publication Date

Summer 2012

Instructor

Mike Freiling

Course Title

DSS: Data Warehousing

Course Number

ETM 538/638

Subjects

Data warehousing -- Management, Information technology, Metadata, Data libraries -- Quality assurance

Abstract

Maintaining a stable data warehouse becomes quite a challenge if code development, code changes, code performance, systems computing resources usage and configurations of various integration specifications are not done with discipline. As the size of the data warehouse increases the value it brings to an organization also increases. However these benefits come at a cost of maintaining the applications and running the data warehouse efficiently on a twenty four by seven basis. Governance is all about bringing discipline and control in place so that application developers and IT integration engineers follow certain guidelines so that the behavior of a data warehouse application becomes predictable and manageable. In this paper we have defined and explained some of the governance best practices being followed in large enterprise data warehouse of an organization. With a data warehouse governance process in place it can help in maintaining a stable data warehouse. Data warehouse governance can support the development life cycle, maintenance, data quality assurance, and the Sarbanes-Oxley (SOX) Act requirements and enforce numerous business requirements.

Description

This project is only available to students, staff, and faculty of Portland State University

Persistent Identifier

http://archives.pdx.edu/ds/psu/22076

Share

COinS