|
Home > Archive > MS SQL Data Warehousing > January 2006 > Which Model? Relational Or Multidimentional Model?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Which Model? Relational Or Multidimentional Model?
|
|
| Maryam Arshi via SQLMonster.com 2006-01-14, 7:23 am |
| Hi, i Studied Both Relational and Multidimentional model for Data Warehousing,
but i don't know which is the best to do? can u Please Guide me?
Thx
--
Message posted via webservertalk.com
http://www.webservertalk.com/Uwe/Fo...ehouse/200601/1
| |
|
|
| Peter Nolan 2006-01-31, 1:23 pm |
| Maryam,
it's like saying 'what is the best car to drive'....it depends on what
you want to achieve.....I am a believer that the archive and underlying
dimensional models live in some form of relational
database.....especially if you have any reasonable amount of
volumes....then, if you need the features that a cube product like
analysis services brings you, by all means copy a subset of data into
the cubes and use the features you need from the cube product...
Some people try to build their BI Infrastructure entirely in cube
products....this is rarely a workable solution.
Best Regards
Peter
|
|
|
|
|