Client/Server Based Data Warehouse at the University of Arizona

Abstract

The University of Arizona is implementing a data warehouse on a relational database to be accessed by desktop tools using client/server technology. The warehouse is a repository of data extracted from the "legacy" systems and loaded into a Digital Equipment Corp.'s Rdb database. The database contains data from University Student Information, Payroll/Personnel, and Financial Accounting systems.This presentation will provide an overview of how information is acquired currently for decision support and other management needs. The client/server model being implemented will be described including the warehouse system configuration and the client desktop tools being used. Management issues related to this project will be discussed along with associated data administration activities. The presentation will conclude with a live demonstration of the system if Internet connectivity is available in the presentation area.The targeted audience is information services personnel at all levels of institutions with basic to intermediate knowledge of relational databases and client/server computing.

Download Resources