data warehousing and dimensional modelling

pts.
Tags:
Business Objects
Cognos
Customer relationship management applications
Data analysis
Data mining/analysis
Data warehousing applications
Database Management Systems
Development
Ecommerce applications
ERP
Hardware
Informatica
Lifecycle development
Software Quality Assurance
is there any way to conclude if any particular schema (star,snow flake or any other) is most suitable for an industry type (pharma,manufacturing,retail, etc) irrespective of the paltform on which the data warehouse will be developed. Is there any book which dicusses this in depth or some online material which can further help. Thanks all

Answer Wiki

Thanks. We'll let you know when a new response is added.

You are raising the perennial question on what model is best. There is unfortunately no clear cut global answer to that: it will depend on the particular needs of your data environment (hard- and software) and not the least the reporting needs that the users express.
Based on those needs you can start to architect a solution for setting up the data: the most common approach is still a star scheme. For teams that are not quite familiar with the effects of queries in a star or snowflake or relation, a star scheme is the best fit, i.e. has the best chance for satisfactory to good results.
When time and budget permits, one can build two solutions and run a few tests to evidence which solution is the best or where the architecture can be changed to improve the performance.

I have no ready title for an international book or article that may compare in more detail the different solutions. The most popular books come from Ralf Kimball & co-authors but he is in favour of star scheme solutions.

One of the authors I know who has a balanced view on this subject is a Dutchman called Rick van der Lans (R20/Consultancy). He has a website on www.R20.nl with an English mirror. You may want to check if he has on his site more info (In his presentations, he has, but the ones I have are in Dutch)

Success !
Dries GEERAERT

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following