Re: A design quiz
Posted by: Vincent S
Date: August 11, 2012 02:01AM

Thank you Rick,

Let me tell you what I am going to do:

We have an OLTP mysql database which works fine and designed with scalability feature in mind. (at least when I compare with your recommendations)

Now we want to narrow our solution to a complete BI. To do this, we need to equip our OLTP db with ROLAP concept (which I don't know much about it).

To load ROLAP with suitable data we need to define ETL processes (which I don't know much about it either).

Then at the end we need to equip our data warehouse with suitable sort of BI high level features such as visualization etc. This part is feasible by using avaialbe open source applications or we can develop it internally.

Currently we finished our OLTP design and I wonder where should we go from here to accomplish above mission.

Please correct me if I misunderstood the road map towards BI.

Yours sincerely,
Vincent



Edited 1 time(s). Last edit at 08/11/2012 02:08AM by Vincent S.

Options: ReplyQuote


Subject
Written By
Posted
August 08, 2012 11:36PM
August 09, 2012 11:53PM
Re: A design quiz
August 11, 2012 02:01AM
August 18, 2012 10:54PM
August 20, 2012 11:22PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.