University Data Warehouse Design Issues: A Case Study | Zendy

Melissa Lin | Zendy

AI Assistant Blog Pricing

Home ZAIA Blog

Open Access

University Data Warehouse Design Issues: A Case Study

Author(s) -

Melissa Lin

Publication year - 2020

Language(s) - English

Resource type - Conference proceedings

DOI - 10.18260/1-2--9936

Subject(s) - data warehouse , computer science , officer , dimensional modeling , database transaction , database , online analytical processing , session (web analytics) , architecture , logical data model , data modeling , data science , engineering management , world wide web , engineering , art , political science , law , visual arts

A discussion of the design and modeling issues associated with a data warehouse for the University of Florida, as developed by the office of the Chief Information Officer (CIO). The data warehouse is designed and implemented on a mainframe system using a highly de-normalized DB2 repository for detailed transaction data and for feeding data to heterogeneous data models owned by different administrative units. The details of technology selection, business requirements, tools building, cultural challenges, architecture modes, models, and hardware information will be described. The data warehouse analysis, logical and physical design, application server, and implementation issues will also be explained.

The content you want is available to Zendy users.

Already have an account? Click here to sign in.

Having issues? You can contact us here

Accelerating Research