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
 |
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
 |
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.
|
Business Dimensional Model
 |
The Business Dimensional Model (BDM) brings the Conceptual Model down the 10,000 ft level to show specific data of reporting interest. The BDM reflects, in non-technical terms, the types of queries and analyses used to manage the university. In addition to helping the university to better understand itself, it also guides design of the data structures built to support these analyses. The BDM is built collaboratively with university business stakeholders and is managed by the Enterprise Data Warehouse Data Design Team. Consumers of the BDM include the Decision Support Services team and business owners of the data.
|
Enterprise Data Warehouse 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 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).
|
