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.
Subject
Written By
Posted
Re: A design quiz
August 11, 2012 02:01AM
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.