Oracle Releases Industry Data Models

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.

RetailModel_Time_to_value.JPG


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.

RetailModel_IntraETL.JPG

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.

RetailModel_SampleDashboard.JPG

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...

Comments:

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

Posted by Erik Ykema on April 21, 2009 at 05:23 AM PDT #

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, JP

Posted by Jean-Pierre on April 21, 2009 at 06:14 AM PDT #

Post a Comment:
Comments are closed for this entry.
About

The data warehouse insider is written by the Oracle product management team and sheds lights on all thing data warehousing and big data.

Search

Archives
« May 2015
SunMonTueWedThuFriSat
     
1
2
3
4
5
6
8
9
10
11
12
13
14
16
17
18
19
21
22
23
24
25
27
28
29
30
31
      
Today