A data warehouse is a central repository that stores transactional or operational data that is generated by the normal day to day operations, such as data collected from calls dialed,
payments made, prepaid card generation, user transactions, patients?visits etc. In it the data warehouse integrates data from several diverse sources. It then organizes and stores this data for informative analytical processing over a long historical time perspective. Operational data is thus summarized into the data warehouse on a regular schedule, after which users can perform complex queries and analysis on the information without slowing down the operational systems. |
|
Online analytical processing (OLAP)Data warehouses are based on relational technology; OLAP on the other hand uses multidimensional view of aggregate data to provide quick access to
important information for further analysis. The most important aspect of OLAP is that is allows users to have multiple and different views of the data, in relation to each other. Simply the OLAP transforms raw data in the data warehouse into information that can be used for analysis. It does this by taking a snapshot of the data in the data warehouse and restructures it into an OLAP cube, and the queries would then run against this cube |
In it the data warehouse integrates data from several diverse sources. It then organizes and stores this data |