Data Model

Current Release 6.0 - members only

The Data Model and its related products - the Member Data Dictionary and the Data Warehouse Model - are available to ARTS members only.

The ARTS Retail Data Model offers two distinct perspectives across the retail business.  These are the Enterprise Context, which offers insight into the retail enterprise via three levels within the retail operation (home office, distribution and store levels), and Subject Area Composition, which gives an insight into the retail enterprise via the subject areas which cut across all three levels of retail operation.

The ARTS Retail Data Model currently supports ten of eleven retail business areas. These areas include:

  • Merchandise flow management

  • Inventory management

  • Item and price maintenance

  • Point of sale processing

  • Tender control

  • Store administration

  • Customer relationship management

  • Sales and productivity reporting

  • Ordering (partially supported)

  • Workforce Management (partially supported)

 

Version 6.0 is now available!  Click here to access the new Model!

ARTS is excited to announce the forthcoming release of version 6.0 of the model and the complete make over of the Data Dictionary, which offers access to ARTS standards, including the Data Model and Schemas, in a fully searchable format.  We are very proud of the excellent work done by our volunteer Data Model committee, whose members include: adidas, AfterBot, Alpha Bay, El Corte Inglés, Epicor, GK Software, InfoAdvisors, QuantiSense, Retail Anywhere, Shell, Versátil and Vertex.

 

A complete list of the changes and enhancements is available here.

 

Review Committee Chair Kirstin Wright's presentation about the new data model release and dictionary here.

 

Release 6.0 has extensive documentation available.  The Model is provided in Erwin with the following supplemental PDFs:

 

Logical Model:

Volume I High level overview of mission and purpose of the ARTS Data Model.  This document includes the views from the data model as well as a narrative for each view.
Volume 2 Entities and attributes showing the name, domain and definition for all elements.
Volume 3 A complete list of the Entity Relationship Diagrams from the Data Model available in both PDF and HTML.  The HTML version makes it easy to navigate through the Business Functions and drill into the Entity and Attribute definitions.

 

Near Physical Model:

Volume I High level overview of mission and purpose of the ARTS Data Model, naming conventions for both Logical and Physical and considerations to be made when implementing the Physical data model. 
Volume 2 Reference to every Table and respective Columns showing the Table logical name, physical name and definition.  Shows the Column physical name (no ref to logical name), domain, data type, definition, nullability and whether the Column participates in a PK and/or FK.
Volume 3 Definition of all relationships.
Volume 4 List of abbreviations referenced in definitions and narratives.

 

Review the Scope Document for release 6.0 of the ARTS Data Model

Members Only

Download all documentation for release 6.0 of the Model

Review the Conformance Test Process

Test matrix 4.01

Test matrix 5.0

 

Copyright © 1995-2009 NRF. See Disclaimers