<Insert Picture Here>
Oracle Retail Data Model – Overview
The following is intended to outline our general
product direction. It is intended for information
purposes only, and may not be incorporated into any
contract. It is not a commitment to deliver any
material, code, or functionality, and should not be
relied upon in making purchasing decisions.
The development, release, and timing of any
features or functionality described for Oracle’s
products remains at the sole discretion of Oracle.
Retail Data Model
Database Technology
Available
Today!
Retail Domain Knowledge
BI Technology
3
Copyright © 2009, Oracle and / or its affiliates. All rights reserved.
Key Messages
Standards-based, pre-built, pre-tuned data model with
Speed to
intelligent insight into detailed retailer and market data
Value
enabling retailers to quickly gain value
Fast, easy and predictable implementation, reduced
Reduced Total
technology & 3rd Party costs for both immediate and on-
Cost of Ownership
going operations by leveraging pre-built content
Modern, topical and relevant Data Model developed
Best in class using deep retail market expertise with leading Data
Warehousing and Business Intelligence technology
4
Copyright © 2009, Oracle and / or its affiliates. All rights reserved.
Speed to Value
Build from Scratch with
Best of Breed Approach Oracle Retail Data Model
Training & Roll-out Oracle’s Approach:
• Delivers retailer and market insight
Define Metrics & quickly
Dashboards • Rapid implementation, predictable costs
lead to higher ROI
• Combines deep retail market expertise
with industry-leading technology
Data Movement
Training & Roll-out Easy to Use, Easy to Adapt
Define Metrics Comprehensive Retail Measures & Metadata for
& Dashboard Business Intelligence Reporting & Ad-hoc Query
Automatic Data Movement from your ARTS compliant
Data Movement 3NF schema to OLAP, Mining & Dimensional Schema
DW Design
Pre-built DW Schema (3NF,STAR,OLAP) with Retail
DW Design best Practice embedded and Pre-tuned for Oracle data
warehouses, including the HP Oracle DB Machine
months or years weeks or months
5
Copyright © 2009, Oracle and / or its affiliates. All rights reserved.
Reduced Total Cost of Ownership
Complete Open Integrated
Comprehensive Standards-Based Designed to
Industry Portfolio Architecture Work Together
More Value More Choice More Flexibility
Less Complexity Less Risk Less Cost
6
Copyright © 2009, Oracle and / or its affiliates. All rights reserved.
Best-in-class
Oracle #1 for Retail Oracle #1 for Data Warehousing
Market Size is $6.7 Billion with 14.6% Growth YoY1
7
Copyright © 2009, Oracle and / or its affiliates. All rights reserved.
Oracle Retail Data Model
An Overview
• Industry Standard Compliant (ARTS)
• Embedded strong Retail expertise
• 3NF Logical Data Model
• Physical Data Model designed & pre-
tuned for Oracle
Oracle Retail Data Model – Including Exadata Storage
• Industry-specific measures & KPIs
Compression
Data Mining
Pre-built OLAP models
Partitioning
•
OLAP
RAC
• Pre-built Data Mining models
• Usable within any Retail Application
Oracle Database Enterprise Edition Environment
• Sample reports and dashboards
Oracle Exadata Storage
– Based on Oracle BI EE Plus
Oracle Retail Data Model
Foundation for Business Information Flow
• POS (Point-of-Sale)
Sell-Side • Web stores & Catalog
Buy-Side
• Order Management
• Inventory Optimization • Advanced Planning &
• Advertising & Promotions Scheduling
(Demand Driven)
Customer & Consumer Interaction • Customer Service
• Inventory Tracking
• Workforce Scheduling
• Pricing
• Personalized Marketing
• Cost Forecasting
Retailer Sales Marketing • Purchase Order Mgmt.
Knowledge Knowledge Knowledge • Retail Partnerships
Demand Consumer • Warehouse Mgmt.
Knowledge Knowledge
Product
Knowledge
In-Side
• Manufacturing/Sourcing
Partners
• Sales Forecasting
• Inventory Tracking
Inventory Data
Knowledge Suppliers
Warehouse
Forecasting Mfg Perf. Sourcing
Knowledge Knowledge Knowledge Distributors
Oracle Retail Data Model
Foundation for Business Information Flow
Store-side Data Warehouse
Retailer Knowledge
Marketing Knowledge
Sales Knowledge
In-side Consumer Knowledge
Demand Knowledge
Inventory Knowledge
Forecasting Knowledge
Buy-side
Sourcing Knowledge
Mfg Perf. Knowledge
Product Knowledge
10
Copyright © 2009, Oracle and / or its affiliates. All rights reserved.
Oracle Retail Data Model
Industry Coverage
Grocery
Department Stores
Discounters
Hard Goods
Apparel & Footwear
Soft Goods
Convenience Stores
Gas Stations
11
Copyright © 2009, Oracle and / or its affiliates. All rights reserved.
Oracle Retail Data Model
Key Statistics
• Data Model Contents
– 650+ Tables and 10,500+ Attributes (“ARTS++”)
– Industry-specific 1200+ Measures & KPIs with Business and
Technical Definitions
– 4 Pre-built Analytical Workspaces
– 12 Pre-built Data Mining Models
– Automatic Data Movement from 3NF to STAR schema, OLAP
Cubes and Data Mining Models
– Sample Reports & Dashboards using OBIEE
• Designed and optimized for Oracle data warehouses, including
the HP Oracle Database Machine
• Central repository for atomic level data
• Rapid implementation
Business Area Coverage
Pre-Built Measures & KPIs
Store
Store performance, Shopper Conversion, Comparative Store Analysis
Operations
Point of Sale Multi Channel, POS Flow
Loss
Unusual Transactions, Hidden Patterns, Attribute Analysis
Prevention
Merchandising Merchandise Performance, Item-Basket, Fast & Slow Movers
Inventory Inventory State Analysis, Forecast out-of-stock and zero selling.
Category
Product Mix, Shelf Analysis, Customer Purchase vs. Syndicated Data
Management
Workforce
Employee Utilization, SPIFF & Split Commission Analysis
Management
Customer Clustering & Segment - Creation, Migration, Analysis
Promotion Causal Factor, Halo Impact & Promotional Lift
Order
Integrated Analytic between e-commerce and Retail
Management
Business Area Coverage
Pre-Built Measures & KPIs
Merchandising
Merchandising StoreStore
Operations
Operations
• Role: Commonly a merchant or planner • Role: Commonly a store manager
• Product ‘stars’ and ‘dogs’ • Store traffic patterns to determine staffing
• Inventory levels vs. planned inventory levels • Understand opportunities to control loss
• Suppliers that help / hinder performance • Relative store performance rankings
• Identifying locations that over/under perform • Identify what sells in the stores vs. doesn’t
• Identifying potential risks for out of stocks
Category Management Marketing
• Role: Commonly a Category Manager • Role: Commonly a marketing analyst
• Controlling purchase costs • Identify consumer spending habits using
• Reviewing supplier item coverage market data
• Understanding consumer purchases of new / • Analyzing a retailer’s loyalty program
current products vs. market data customers to better target campaigns
• Determining store layouts and planogams • Measuring customer promotion response rates
Oracle Retail Data Model
Components
Base Layer (3NF) Derived & Aggregate Layer Sample Reports
Oracle Retail Data Model
Why multiple layers
Intelligent Interactions (Data Mining)
•Is the product assortment optimal for all my regions?
Fact-Based Actions (OLAP, Statistics) Predictive
•What are my potential out-of-stock situations?
Performance Management (KPI, Guided Analytics)
Forecasting
•How is the business doing compared to last year?
Compared to plan?
Value 5
Slice/Dice, Ad-hoc, Query , BI Tools
•What is my gross margin return on space?
Analysis 4
3
Transactional Reporting Reporting
•How are my catalog and internet 2
sales performing?
1
Generation Step
Oracle Retail Data Model
Automatic Data Movement
Oracle Retail Data Model
Lookup
Reference
Intra-ETL Derived Intra-ETL
3NF Base (Derived) (Aggregate)
Aggregate
Source ETL
OLTP Systems
(Data Quality,
Staging,
Interface)
Leveraging Data Warehouse Features
Embedded as part of VLDB design, not an afterthought
Partitioning Reference Architecture Advanced Statistics
•Partitioned Outer Join •Frequent Item Set •Ranking
•Lag / Lead
Compression OLAP Data Mining
•3-5x Storage Savings •Time Series •Classification
(ABN/Decision Tree)
•Forecasting
•Association Rules
(Apriori)
Materialized Views
•User Choice
•‘SQL’ Rewritten
Differentiator: Smart Inventory Reports
Out of Stock Forecast (using built-in Forecasting & OLAP cubes –
numerous methods supported)
OLAP
forecasting of
sales &
inventory to
predict
potential
stock
shortage
See which
forecasting
method fits
best
19
Copyright © 2009, Oracle and / or its affiliates. All rights reserved.
Differentiator: Smart Category Report
Product Category Mix Analysis: Suggest Items/Categories to
Merchandise Together using a Pre-built Mining Model
Analyzes Sales Transactions using the Association Rules (Apriori) Model to understand the
Product Category Mix [If a Customer buys A and C, what is the likelihood the Customer would
buy D?]
20
Copyright © 2009, Oracle and / or its affiliates. All rights reserved.
Why Oracle Retail Data Model?
Top 10 Reasons
1 Retail expertise with best-in-class technology 6 Easily extendable & customizable model
2 ARTS based normalized data model 7 Usable within any retail environment
3 Modern and topical with retail depth and breadth 8 Designed and optimized for VLDB
4 Intelligent retail insight using OLAP & Mining 9 Automated data flow between components
5 Extensive business intelligence metadata 10 Reduced implementation risk
The Oracle Solution Set
Complete, Integrated, Open
EPM Workspace
EPM Applications BI Applications
Business Intelligence Foundation
Middleware
Oracle Retail Data Model
Database
HP Oracle Database Machine / Storage
For More Information
http://search.oracle.com
Oracle Retail Data Model
or
oracle.com
