Enterprise Data Warehouse (EDW)
An EDW is used to store current and historical data for reporting and data analysis. Data may come directly from a source system or it may pass from a source system to an ODS where additional operations take place before it is finally transferred to an EDW. DWRAC is our enterprise data warehouse owned by the University Hospital.
DWRAC contains the following data:
- Student Data Warehouse
Operational Data Stores (ODS)
An ODS is a database designed to integrate data from multiple source systems where additional operations on the data can happen if needed. Data is updated continuously in real time whereas a data warehouse is static and updated less frequently. BIPR is our operational data store owned by UIT BI.
BIPR contains the following data:
- Campus HR
- Hospital HR