Home All Groups Group Topic Archive Search About

Data warehousing primer?

Author
21 Jul 2006 8:53 PM
Ronald S. Cook
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

Author
22 Jul 2006 5:08 PM
naka55n
Try the Kimball Group at http://www.kimballgroup.com/


--
Mark Graveline
mgraveline"at"sqlchallenge.com
http://www.sqlchallenge.com
*** Learn, Look & Win

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
>
>

AddThis Social Bookmark Button