striped line
Information Technology Division (ITD)
University of Memphis Photo
Data Warehouse Related Topics
set cell vertical height

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:

Related Topics

striped line
Text Only | Print | Got a Question? Ask TOM | Contact Us | Memphis, TN 38152 | 901/678-2000 | Copyright 2009 University of Memphis | Important Notice | Last updated: 11/16/09 19:51:18