I am involved in a new project, where I have to create data cube from the existing relational database system.
I understood that, the existing system is not properly designed, I am not sure where to start.
My question are:
- What is difference between Star Schema and data cube?
- Where I have to start? From star schema or directly data cube?
- Is data cube generated from star schema?
I have little experience in relational data modeling, this question may seems too basic, I tried to figure out from few resources, still not clear. Please give your advice and suggestions?
If I missed, something very important related with this question, please share your thoughts on that too.