Information Technology Division (ITD)

University of Memphis Photo
Data Warehouse Related Topics

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

Text Only | Print | Got a Question? Ask TOM | Contact Us | Memphis, TN 38152 | 901/678-2000 | Copyright 2013 University of Memphis | Important Notice | Last Updated: 
Information Technology Division | 100 Administration Bldg. | Phone: 901.678.8888 | Email: UMTech@memphis.edu
Last Updated: 1/30/13