|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Data warehousing primer?I'm looking for a 1-pager that will explain data warehousing simply, and
preferably with examples (so I can prssent to/sell my boss). I.e... We have our normal OLTP database with tables like... Here is a simple star schema and why it's what we do And then there are OLAP tools in SQL Server 2005 if you want to get really crazy... If our needs are simple, would we just create a star schema in regular SQL Server 2005 database, or would we need to embrace and get into all that OLAP, analysis services, cubes and stuff (you can tell I'm at ground zero, no?). Thanks, Ron Try the Kimball Group at http://www.kimballgroup.com/
Show quote "Ronald S. Cook" <rc***@westinis.com> wrote in message news:efA$HfQrGHA.2440@TK2MSFTNGP03.phx.gbl... > I'm looking for a 1-pager that will explain data warehousing simply, and > preferably with examples (so I can prssent to/sell my boss). > > I.e... > We have our normal OLTP database with tables like... > Here is a simple star schema and why it's what we do > And then there are OLAP tools in SQL Server 2005 if you want to get really > crazy... > > If our needs are simple, would we just create a star schema in regular SQL > Server 2005 database, or would we need to embrace and get into all that > OLAP, analysis services, cubes and stuff (you can tell I'm at ground zero, > no?). > > Thanks, > Ron > > |
|||||||||||||||||||||||