Decision Support

University of Washington Data Models

The following models represent increasingly granular views of the University of Washington's data - starting at the 100,000 ft view with the Data Map, going down to the actual table and column level detail in the Physical Models. Read on to learn more about model contents, management, and target audiences.

UW Data Map

Data Wheel Thumbnail The "UW Data Map" is the highest level data model. It is at the 100,000 ft level and represents a data and business process classification scheme. The Data Map provides consistency in the cataloging and maintenance of vast amounts of institutional data contained within a wide spectrum of systems. The Data Map was created by and is owned by the Data Management Committee (DMC). Consumers of the Data Map include Data Custodians and the Data Management Committee.

Conceptual Model

Conceptual Model Thumbnail The Conceptual Model brings the Data Map down to the 50,000 ft level, reflecting the university's significant business concepts (those things about which it is inclined to collect data) and their relationships to one another. The Conceptual Model is based on input from business stakeholders and managed by the Enterprise Data Warehouse Information Architect. Consumers of the Conceptual Model include Data Custodians, the Data Management Committee, the Information Architect, data modelers and those involved with University source data systems.


Enterprise Data Warehouse Physical Models

Physical Model Thumbnail The physical data models contain all the details of the data structures in the EDW, including table names, column names, data types, key values, and relationship information. EDW Physical Models are managed by the Enterprise Data Warehouse Data Modeler. Consumers of the Physical Models include analysts, Business Intelligence tool builders, and Data Custodians.

The models currently available are for the Integrated Enterprise Data Warehouse (IEDW).