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-7.3?
Starting with verion 7.0, this 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, the materials provide 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 is included with the Operational Data Model?
Materials include documentation with background and explanatory information about the ODM, plus information to help users understand the changes 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.
- Operational Data Model version 7.3 (ERwin 7.3.8)
- Operational Data Model version 7.3 (ERwin 9.6.4)
- Operational Data Model version 7.3 (XML generated from ERwin 7.3.8)
- Data Dictionary (MS Access 2016)
- Database Backup (SQL Server 2012) with some sample data
- SQL DDL to define physical views and populate data warehouse tables
- Logical Narrative, Operational Data Model version 7.3 (html)
Documentation with background and explanatory information about the ODM plus information to help users understand the changes to the current version and philosophy behind them.
- Business Process Models