DSS: Data Warehousing
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.
Rahman, Nayem; Sengupta, Sowmini; and Aldhaban, Fahad, "Data Warehouse Governance Best Practices" (2012). Engineering and Technology Management Student Projects. 528.