September 11, 2013 \ Ananth TM What is DataWarehouse? A data warehouse is a central integrated database containing data from all the operational sources and archive systems in an organization. It contains a copy of transaction data specifically structured for query analysis. This database can be accessed by all users, ensuring that each group in an organization is accessing valuable, stable data A Data Warehouse Is A Structured Repository of Historic Data. It Is Developed in an Evolutionary Process by Integrating Data from Non-integrated Legacy Systems. It Is Usually: ü Subject Oriented ü Integrated ü Time Variant ü Non-volatile Next: Under stand Why do we need a Data warehouse