Data Model Artifacts

Top  Previous  Next

Data Model Package Components


The narrative content provides background and explanatory information about the ARTS Operational Data Model.  It is organized into retail business themes and subject areas.  The topics are viewable in the left side of the web page.  Each retail theme and associated subject areas are defined and described in the narrative.

Logical Data Model

The logical data model is composed of  a set of subject area entity relationship diagrams and supporting meta data for each entity in a subject area.  The entity diagrams include attributes in a large, scrollable format to make them readable.  Each entity has a link to meta data that defines key properties of the entity itself and all of its attributes.  Meta data presents both logical and physical properties for each entity and attribute.

Physical Data Model

The physical data model (in terms of names, data types, null options) is reflected in the entity meta data described under Logical Data Model.  Physical properties for each entity include table name, column name, column data type, column usage (owned attribute, foreign key, primary key, alternate key, etc.), null options etc.

Generated SQL Data Definition

The ERWIN physical database model is used to generate SQL Server 2014 DDL that users may run to create an ARTS ODM 7.3 database.

ARTS ODM V7.3 Database (SQL Server 2012)

In addition to the DDL, a sample generated ARTS ODM 7.3 SQL Server 2014 database populated with sample data for merchandise hierarchies as wells calendars is provided.

Repackaged Data Model Work Products

Beginning with Version 7.1 of the ARTS ODM, the work products are repackaged and consolidated into a web site, HTML based presentation format.  The goal is to electronically publish ARTS data model artifacts to make it easier for users to navigate the web site and access model diagrams and meta data.  The prior versions of ARTS data model work products were delivered as a collection of separate work products as shown below.  The packaging is changing, but the content is not.

In addition to the data model narratives, diagrams and meta data, ARTS is also introducing generated SQL 2012 DDL for the entire data model.  The physical DDL is further supplemented with a generated ARTS ODM V7 database (for SQL Server 2012 ) and contains some sample data for merchandise hierarchies and calendars.

Version 7.3 retains this same collection of artifacts.

Figure 2 - Repackaging ARTS Work Products