Administrative Data Environments at U-M

Online Transaction Processing Databases (OLTP)

Online Transaction Processing (OLTP) Databases, where all data entry is performed, are also known as the "production" or "operational" databases.

U-M Data Warehouse

The U-M Data Warehouse is a collection of data organized in data sets to support reporting activity for university business. The U-M Data Warehouse includes data extracted from OLTP systems, Legacy systems, and other central data sources.

Relationship Between OLTP Databases and U-M Data Warehouse

The administrative data environments at U-M supports different tasks. Characteristics include:

	Online Transaction Processing System (OLTP)	U-M Data Warehouse (DW)
Primary Use	Supports critical University business processes via predefined, user-requested reports with real-time transaction processing in all data areas	Primary repository for ad hoc inquiry and reporting
Data	Offers real-time transaction processing in all data areas	Read-only, reformatted data for all data areas simplifies data structures and optimizes data accessibility
Refresh Schedule	Always current	Refresh schedule varies by data set
How to Access	From PeopleSoft via Wolverine Access, except for DAC System, which is accessed via CICS	From BusinessObjects via Wolverine Access