Which Datawarehouse Books good to read

Question

Post reply

Which Datawarehouse Books good to read

Bhushan Kulkarni

SSCrazy

Points: 2829
More actions
February 10, 2015 at 1:37 am

#315087

Hello all,
I am SQL Server Developer. Can you tell me , which books on Data warehouse concepts (Data warehouse concepts as well as design models) are good to read, which can take the beginners to expert level.
Also I want to know books on database design patterns which will give idea about different data models used in database designing.
Thank you

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Eirikur Eiriksson SSC Guru Points: 182915 More actions · Answer 1

Quick suggestion, check out this one, The Data Warehouse Toolkit

😎

Jason-299789 SSC-Insane Points: 21601 More actions · Answer 2

For Database design patterns Wiley has a set of three books this is a link to volume 1

http://eu.wiley.com/WileyCDA/WileyTitle/productCd-0471380237.html

In terms of Data Warehousing, any book by Inmon or Kimball will give you a good idea, and in a lot of cases you can get the wrong book, though the one Eirikur mentioned is a good start.

I found this one and used to loan it to juniors and new starters with limited experience as it explains the different architectures available and is SQL Specific. http://www.amazon.co.uk/Building-Data-Warehouse-Examples-Experts/dp/143024299X/ref=sr_1_3?ie=UTF8&qid=1423566865&sr=8-3&keywords=SQL+SERVER+Data+warehouse

_________________________________________________________________________
SSC Guide to Posting and Best Practices

Alan Burstein SSC Guru Points: 61141 More actions · Answer 3

Eirikur beat me to it but I was going to say

The Microsoft Data Warehouse Toolkit, 2nd Edition

[/url]. This is the geared towards data warehousing in Microsoft environments specifically. If they ever write a 2012 or 2014 version :Whistling: I'd say check that out but the 2008 R2 version is very good.

"I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

-- Itzik Ben-Gan 2001

Lempster SSCoach Points: 15651 More actions · Answer 4

For a good grounding in the principles that underpin Data Warehouse design which is agnostic of the particular implementation (Kimball or Inmon), Star Schema - The Complete Reference by Christopher Adamson is a must read.

Regards

Lempster

Bhushan Kulkarni SSCrazy Points: 2829 More actions · Answer 5

Thank you so much Eirikur, Jason, Alan and Lempster:-)