Previous | Page 4 of 4 | Next

The ORDM Platform

What Does ORDM Deliver?

Predefined, Retail-Specific Models

Oracle Retail Data Model is a pre-built, pre-tested solution designed by industry experts to help retailers maximize the value of their Oracle data warehouse. Using sophisticated trending and data mining capabilities based on Oracle's OLAP and data mining technology, retailers - including grocery stores, department stores, specialty store chains, mass merchants, convenience stores, and multi-channel retailers - now have the data analysis capabilities to develop retail-specific insights that are relevant, actionable, and can improve both top-line and bottom-line results.

With Oracle Retail Data Model, you can jump-start the design and implementation of a retail data warehouse to quickly achieve a positive ROI for your data warehousing and business intelligence project with a predictable implementation effort.

Naming Convention for Tables

When examining the predefined tables, keep in mind the naming convention using DW (Data Warehouse) prefixes to identify the types of tables:

• DWR_ : Reference data tables
• DWL_ : Lookup tables
• DWB_ : Base transaction data (3NF) tables
• DWD_ : Derived (data mining) tables
• DWA_ : Aggregate (ROLAP and MOLAP) tables

Click the Show Me button to see SQL Developer screenshots of some of the predefined back end data, such as, tables, views, and packages.

...Show me some of the predefined back end data...

Previous | Page 4 of 4 | Next