 |
The Data Warehouse is a database designed for analytical and information processing.
Data are extracted from the university's business systems into a single integrated
information asset. The warehouse is a read-only collection of data intended to answer
business questions.
A Data Warehouse can:
- enable users with better information,
- improve accessibility to integrated data,
- enable informed decision-making leading to increased or improved service,
- improve data quality in the OLTP (On-Line Transaction Processing) systems,
- improve consistency with data from multiple systems,
- help identify hidden business opportunities, and
- act as a strategic planning tool.
The Data Warehouse is an On-Line Analytical Processing (OLAP) system that is populated
using data from the University's operational systems—also known as an On-Line Transaction
Processing (OLTP) systems. An OLAP system provides a means of archiving data gathered
over time by OLTP systems, and then analyzing that data for trends. OLAP and OLTP
can be compared in the following ways:
|