Oracle Releases Industry Data Models
By Jean-Pierre Dijcks on Apr 20, 2009
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:
- Department Stores
- 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
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...