Information, tips, tricks and sample code for Big Data Warehousing in an autonomous, cloud-driven world

  • News
    April 20, 2009

Oracle Releases Industry Data Models

Jean-Pierre Dijcks
Master Product Manager

There is a lot of interesting news coming out of Oracle these days... And while the sun is shining here in California there are interesting things going on.

We just made the first in a series of industry data models available. The new product is called Oracle Retail Data Model and is now generally available on OTN (more info and downloads are here) and for general licensing of course.

The retail model is really a complete data model to create a retail data warehouse in weeks rather than years. The retail model delivers an excellent time to value and if combined with the HP Oracle Database Machine it is a fast deployable, very low risk solution.


So what is in the box?

First of all, this is not just a data model. The data model provides a few data models linked with intra solution pre-built ETL jobs. These ETL jobs take the data from the sources (via interfaces) and move it between the 3NF base model and the aggregations.


The aggregations are used for advanced analytical solutions like OLAP and Data Mining. Both these advanced analytical solutions are pre-built to deliver immediate value.

On top of the collection of schemas you will find sample reports and dashboard supporting the most common KPIs for a retail business.


Now, retail is a big area where many specialties exist. Oracle Retail Data Model is equipped to handle areas such as:

- Grocery

- Department Stores

- Discounters

- Hard Goods

- Apparel and Footwear

- Soft Goods

- Convenience Stores

- Gas Stations

Within those sectors you can look at different major subject areas, like for example:

- Store operations and loss prevention

- Point of Service

- Merchandise and category management

- Promotions

- Etc.

All in all, and this is just the first data model released, this is a great product getting a data warehouse implemented at much higher speed with a lot less risk. For the data sheet click here.

Stay tuned for more models to come on line and don't forget to talk to your friendly Oracle Representative about pricing and licensing...

Join the discussion

Comments ( 2 )
  • Erik Ykema Tuesday, April 21, 2009
    That's interesting news.
    Can you shed some light on the technology used for the intra-ETL? OWB? ODI? PLSQL? I have not been able to find that in the documentation (which BTW can be found at http://www.oracle.com/technology/documentation/retaildm.html).
    Regards, Erik
  • Jean-Pierre Tuesday, April 21, 2009
    As far as I know, in the initial release the intra-ETL is effectively custom PL/SQL. It is being rendered using Workflow (now part of the OWB product). The PL/SQL and all SQL is specifically tuned for the environment and the models.
    One thing on top of this. This model is a set of models and you can choose to use all components, or only the 3NF part, or only some of the aggregation layers or mining models...
    Hope this helps,
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.