Document Type

Closed Project

Publication Date

Summer 2012


Mike Freiling

Course Title

DSS: Data Warehousing

Course Number

ETM 538/638


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


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.


In Copyright. URI: This Item is protected by copyright and/or related rights. You are free to use this Item in any way that is permitted by the copyright and related rights legislation that applies to your use. For other uses you need to obtain permission from the rights-holder(s).


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

Persistent Identifier