This chapter introduces the Oracle Retail Data Model, which is a start-up kit for implementing a retail data warehouse solution:
Oracle Retail Data Model is a startup kit for implementing a retail business intelligence solution. It is a standards-based data model, designed and pre-tuned for Oracle data warehouses, including the HP Oracle Database Machine.
The Oracle Retail Data Model for Retail offers a single-vendor solution package that is tightly integrated with the business intelligence platform. With pre-built data mining, On-line Analytical Processing (OLAP) and dimensional models, Oracle Retail Data Model provides you with industry-specific metrics and insights that you can act on immediately to improve your bottom line. These BI solution offerings take advantage of Oracle's scalability and reliability, using Oracle's familiar optimization, parallelism, and performance engineering within the database.
Oracle Retail Data Model can be used in any application environment and is easily extendable.
By leveraging Oracle's strong retail domain expertise, Oracle Retail Data Model provides an industry standard compliant foundation schema that is modern, relevant, topical, and addresses needs of most retail segments. This normalized foundation schema serves as a detailed and structured representation of the retail business, providing an integrated base for business information with fully defined entities and relationships. Oracle Retail Data Model includes an exhaustive set of embedded advanced analytics, using Oracle's OLAP and data mining technology. You can take advantage of pre-built and pre-tested solution sets designed by industry experts that deliver relevant insights, are actionable, and aimed at improving both top-line and bottom-line results. You can see summarized, aggregated information or quickly navigate to drill-down transaction details to better understand business issues. For example, with Oracle Retail Data Model's out-of-the-box sample reports, merchandisers gain improved insight into product affinities; loss prevention specialists gain improved visibility; and marketing analysts gain improved understanding of promotional effectiveness and customer segmentation. You can add your own reports as well. Oracle Retail Data Model, combined with Oracle technology, provides all of the components required for a complete and extendable Retail Data Warehouse and Business Intelligence framework in order to eliminate complex and costly integration requirements, all designed to reduce your total cost of ownership.
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
ORDM includes the following components:
Logical model
The logical model is described in detail in Chapter 2, "Logical Data Model of Oracle Retail Data Model".
Physical model
The physical model is described in detail in Chapter 3, "Physical Data Model of Oracle Retail Data Model". The logical to physical mapping is detailed in Chapter 4, "Logical to Physical Mappings in the Oracle Retail Data Model".
Intra-ETL database packages and SQL scripts to extract, transform, and load (ETL) data from one layer of Oracle Retail Data Model to another.
The intra-ETL packages and SQL scripts are described in detail in Chapter 5, "ETL for the Oracle Retail Data Model". How to use these packages and scripts to populate a data warehouse based on the Oracle Retail Data Model is discussed in Oracle Retail Data Model Operations Guide.
Pre-defined data mining models.
These models are described in detail in Chapter 6, "Data Mining Models in Oracle Retail Data Model". How to create these models is discussed in Oracle Retail Data Model Operations Guide.
Sample reports and dashboards using OBIEE.
These reports are discussed in Oracle Retail Data Model Operations Guide.
DDL and installation scripts
Several Oracle technologies are involved in building the infrastructure for retail business intelligence.
Oracle Database with OLAP, Data Mining and Partitioning Option
Oracle Retail Data Model utilizes a complete Oracle technical stack. It leverages the following data warehousing features of the Oracle database: SQL model, compression, partitioning, advanced statistical functions, materialized views, data mining, and online analytical processing (OLAP).
Tip:
To save some money, you can consider using RAC and commodity hardware.The following Oracle tools can be used to customize the predefined logical and physical models provided with ORDM, or to populate the target relational tables,mmaterialized views, or OLAP cubes.
Table 1-1 Oracle Development Tools Used with Oracle Retail Data Model
Name | Use |
---|---|
Designer |
To create the logical model |
SQL Developer or SQL*Plus |
To create or modify database objects |
Oracle Warehouse Builder |
For the process control of the intra ETL process |
Analytic Workspace Manager |
To populate the target OLAP cubes |
Oracle BI EE Presentation Tools
Oracle Business Intelligence Suite Enterprise Edition (Oracle BI EE) is a comprehensive suite of enterprise BI products that delivers a full range of analysis and reporting capabilities. You can use Oracle BI EE Answers and Dashboard presentation tools to customize the predefined sample dashboard reports that are provided with Oracle Retail Data Model.