Sunday, March 25, 2012

AdventureWorksDW

Hi everybody,

I'm searching for a full description of AdventureWorksDW and also its relationship with AdventureWorks database.

Tanx

Hello. I have not found a full documentation but perhaps Books On Line can tell you something.

A short description is that AdventureWorks is the OLTP-version(read transaction system version) of a fictive company that sells bicycles and related equipment on the internet.

AdventureWorksDW is the data warehouse structure of this company's business that include several starschemas /data marts. This structure is for analysis, not for entering transactions. After installing tools and samples, that is part of the SQL Server 2005 installation, you will also find an Aventure Works cube project built on top of the AdventureWorksDW database.

HTH

Thomas Ivarsson

No comments:

Post a Comment