For optimal user experience, please upgrade your browser.

Data Models

Floating Widget

Floating Share Widget

Operational Data Model and Data Warehouse Model

The ARTS Operational Data Model and the ARTS Data Warehouse Model provide retailers and vendors with a mature data architecture for developing retail business solutions.

The operational data model (ODM) offers a transaction-oriented view of retail enterprise data, and is designed to support the day-to-day functions of a retail enterprise. The data warehouse model (DWM) supports business reporting and analysis.

Both models offer a reference design to help retailers build or acquire integrated business applications, help developers and analysts understand basic retail business principles, and offer a canonical data model (design pattern) to allow different data formats to communicate.

Both models are maintained and developed by the ARTS Data Subcommittee.

Data Model downloads are available only to members. Check each page for more details:

For more information about ARTS Data Models, email Karen Shunk at shunkk@nrf.com.

ARTS Operational Data Model version 7.0 FAQs

What is the ARTS Operational Data Model (ODM)?

The ARTS Operational Data Model (ODM) is a retail-specific roadmap for database design that allows a company to plan how it organizes and uses its transaction data.   

The ARTS ODM offers retailers a comprehensive, mature basis for building integrated applications or selecting off-the-shelf retail solutions, and for helping application developers and analysts understand retail business principles and terminology.

What is new in the ARTS ODM version 7.0?

Release 7.0 is the most significant expansion to the ODM in over 10 years.  It adds support for retailers to describe and understand customer behavior, to track the consumer-to-customer lifecycle in order to better understand when and why a consumer becomes a customer, and sets the stage for further extension of the ARTS Operational Data Model into promotion management, customer interaction, social networking and other aspects of consumer-retailer interaction.

In addition, for the first time ARTS is providing a sample generated database in SQL Server 2012 populated with sample data for merchandise hierarchies and calendars to help ARTS users understand the model more quickly.

What Business Problem is ARTS trying to solve?

The role of information management in retail has evolved from tracking unit control and financial transactional activity to becoming a strategic asset.  Information is the 21st century's capital and ARTS is showing retailers how they can manage information planning, acquisition, stewardship and disposition with the same diligence they apply to merchandise, store sites, human talent and other tangible assets.  Retailers who do not learn how to manage their information capital will not survive.  Those who learn how to fully exploit information will outperform their competitors.

According to a survey ARTS conducted in 2012, while the role of ARTS standards in reducing IT integration time and costs was cited as the top benefit — and one of the principles on which ARTS was founded – the second-most-cited benefit was found in learning about retail and implementing best practices.   ARTS users and implementers are getting new-hires up to speed, breaking into new markets and supporting IT alignment to business strategy using the terminology and best practices embedded in ARTS standards.

What is available with the Operational Data Model?

ODM version 7.0 includes documentation with background and explanatory information about the ODM plus information to help users understand the changes to version 7.0 and philosophy behind them; a logical data model represented as entity relationship diagrams; a physical data model in ERwin, the data modeling product ARTS uses to create and manage its reference models; and sample databases with sample data for merchandise hierarchies and calendars.

ARTS Collaboration Tool

Are you an ARTS member looking to access the collaboration tool? (Requires separate password.)

Looking for color and size codes?

Standard Color and Size Codes are an EDI standard that give retailers, vendors and manufacturers a common language for product color and size, supplementing data conveyed by UPC codes.