Web for studying Data Warehouse
-
Hi...
Im new to Data Warehouse. Is there anyone could recommend me any website to study Data Warehouse (with examples/tutorial) ? and when I should make a Data Warehouse for my existing database ?
thanks
-
Hi,
just search for the following topics:
search for: "ROLAP tutorial" at http://vivisimo.com/ ,
I think there are good results wich will help you!
ROLAP (relational OLAP) -> for data storage methods,
Snowflake- , Star Scheme -> for a standard data model.
Bye
-
okay, I'll try that one...
thanks...
-
Hi.
Usefull links (for me).
DataWarehouse (by DMReview)
(Spend some time inwhite papers)
Microsoft - MSDN - Best Pratices in BI and DW
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/sql_analservbp.asp
Directory of Datawarehouse.
http://www.infogoal.com/dmc/dmcdwh.htm
DW Infocenter (by Larry Greenfield)
Ralph Kimball
Bill Inmon
http://www.b-eye-network.com/channels/index.php?filter_channel=1134
Hope this help!!
Regards
-
Here is an example of my vehicle crash warehouse : http://www.utcodes.org/queryabledata/cube/default.htm
Richard Lees thin slicer is also a good example: http://richardlees.com.au/
and here is the best intro to making cubes with AS 2000: http://www.databasejournal.com/features/mssql/article.php/1429671
And I would say anytime is a good time to warehouse, when you have users that want to do their own analysis, you have lots of data that bogs down the OLTP system when queried, or when you want to start digging into your data to see what you have.
Good luck
-
There is a new book by Joy Mundy and Warren Thornthwaite of the Kimball Group, it's a pretty good treatment of Data Warehouses on Microsoft. Wiley publishing. 'The Microsoft Data Warehouse Toolkit'
Good luck;
Mark E. Johnson
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply