SELF VALIDATING AND METADATA DRIVEN ENTERPRISE DATA WAREHOUSING SYSTEM

摘要

A system and method for Enterprise Data Warehousing (EDW) has been disclosed. The Enterprise Data Warehousing system envisaged by the present invention is designed, developed, monitored and controlled by metadata. The metadata includes self validation means which validates, cleanses and tallies the data up to the grain level to attain 100% data tallying thereby, increasing user confidence in reported figures. The Enterprise Data Warehouse has the ability to store multinational organizational data which operates in different time zones, countries, languages and currencies. Additionally, the system includes a Corporate Data Warehouse (CDW) to store summary data for head quarter reporting and a History Data Warehouse (HDW) to store full data from multiple countries without any cutoff dates. The system provides the top, middle and executive level management with 360 degrees view of the data / performance parameters stored in the warehouse with grain level drill down capability based on their individual privilege levels.