Fog Creek Software
Discussion Board




Datawarehouse and dimensional modeling

Hi,

So far my researchs on Google didn't bring interesting sites. Do you guys have interesting information (sites and recommended books) about datawarehouse architecture and modeling?

I'm specially interested about dimensional modeling.

Thanks in advance

Robert Chevallier
Tuesday, October 22, 2002

I suggest starting with Kimball's Data Warehouse Toolkit book.

RH
Tuesday, October 22, 2002

Data Warehousing for Cavemen
http://eveander.com/arsdigita/asj/data-warehousing

(A classic Philip Greenspun article)

Matthew Lock
Tuesday, October 22, 2002

I have been a Pick developer for a long time (d3, www.rainingdata.com).

It turns out that the non relational database model that pick has been using for the last 30 years is actually quite well suited to data warehousing.

Pick always has been the same old story: When compared to a SQL engine, it is slow. Well, that is only when you try to use the Pick multi-valued model in a relational way does that occur.

Check out the article below, it is called “diamond in the rough”. This article talks about the multi-dimensional data model in Pick, and how well it is suited to data warehousing.

Note that the below link is the whole magazine as a pdf file, and thus is very LARGE!!

Caution, that link is a 5 meg PDF file. You want to right click, and do a save as. Since a loading that large pdf right into your browser is likely to crap it out.

Hence, again...do a right click and a save as on the link below (you really do not want to click on the link below...you want to right click, nd do a save as...).

  http://www.intl-spectrum.com/Publications/SepOct01.pdf

Once again, that is a 5 meg file, but that article on data warehousing is very interesting.

Albert D. Kallal
Edmonton, Alberta Canada
Kallal@msn.com

Albert D. Kallal
Wednesday, October 23, 2002


The best book I think on data-warehousing is:

Data Warehouse Toolkit: the Complete Guide to Dimensional Modeling  by ralph Kimball

http://www.amazon.co.uk/exec/obidos/ASIN/0471200247/ref=sr_aps_books_1_1/202-7287699-2980624

It is a tad dated but is still the definitive work on data wrehouse design and techniques

Generally speaking anything by Kimball is worth a read.

JB
Wednesday, October 23, 2002

Hey Albert,

When I left click on your link, its timing out :)

Ged Byrne
Wednesday, October 23, 2002

*  Recent Topics

*  Fog Creek Home