Oracle Retail Data Model

BI.JPGAn important function of IT at any retailer is to turn data into information. Sounds a little cliche, but its important now more than ever. Most retailers collect every transaction from every store, track every movement of goods, and record every customer service interaction. So there's no shortage of data, but how does one translate all that data into actionable information? How can information be used to make better decisions?

If you don't have a data warehouse, or you have multiple siloed data warehouses that need to be combined, then Oracle Retail Data Model (ORDM), which was announced in a press release today, deserves consideration. It runs on Oracle's database and easily makes use of Oracle's business intelligence suite (OBIEE+) on the front-end (although other tools are also possible).

ORDM incorporates all the latest technology including OLAP cubes, data mining, and optional use of Exadata, Oracle's data warehouse appliance. This gives retailers access to advanced analytics such as forecasting out-of-stock situations, understanding hidden patterns for loss prevention, contribution and market basket analysis, product affinity, customer clustering and segmentation, halo impact and promotional lift.

If you recall the previous posting on Inmon vs Kimball, then ORDM follows Inmon's designs. It provides 3NF tables, based on ARTS standards, into which raw data is loaded. Then internal ETL aggregates the data for faster reporting. This approach gives retailers access to both summary and detailed data.

For those that are wondering about RDW, its still alive and kicking too.

Comments:

Hi David. I have just surfed around and saw this blog. Nice one!

ORDW is kicking indeed, with nice RETL shoes on :) still wondering until when :)... I have worked with it ... hmm let's see .. version 9.3 :)

I gave a quick look into ORDM and it looks promising. OLAP option + MINING + OBIEE... hmmm I still have to check OLAP AW's and ODMINING models again. I have tried both some time ago, but quit using it, since I dind't enjoy very the performance of that :S... Let's see with new versions...

Can you provide me further details, or some recent presentation regarding ORDM and external ETL options? Will OWB or ODI be used??

Regards,
Alvaro Silva

Posted by Álvaro Silva on May 11, 2009 at 02:11 AM CDT #

Post a Comment:
  • HTML Syntax: NOT allowed
About


David Dorf, Sr Director Technology Strategy for Oracle Retail, shares news and ideas about the retail industry with a focus on innovation and emerging technologies.


Industry Connect


Stay Connected
Blogroll

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
8
9
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today