EDW Data Models

Last updated: March 24, 2023

The following models represent the views of the University of Washington’s data, starting with a high-level, University-wide view in the Data Map, down to table and column level detail in the Enterprise Data Warehouse (EDW) Physical Models. From conceptual, to logical, to physical views, our data models help UW link key business process with actual data structures.

UW Data Map

UW Data Map - 7 subject areas are Academics, Research, University Advancement, Services and Resources, Financial Resources, Human Resources and Master Data

The UW Data Map is the highest level data model, representing a data and business process classification scheme. The Data Map provides consistency in the cataloging and maintenance 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 DMC.

Learn more about the Data Map

Conceptual Model

EDW Conceptual Model Thumbnail

The Conceptual Model breaks down the Data Map into the University’s major business concepts and their relationships to one another. The Conceptual Model is based on input from business stakeholders and is managed by the Enterprise Data Warehouse (EDW) Information Architect. Consumers of the Conceptual Model include Data Custodians, the DMC, the Information Architect, data modelers and those involved with University source data systems.

View the Conceptual Model

EDW Physical Models

EDW 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 EDW 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).

View the interactive Physical Model