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
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.
Conceptual Model
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.
EDW Physical Models
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).