Recommended Books on Data Modeling in OLAP/ROLAP Environment

DW David (7091) Mulkey

Recommended Books on Data Modeling in OLAP/ROLAP Environment
Does anyone know of any books (and/or web sites) that they would recommend
for learning about data modeling in a relational OLAP (ROLAP) environment?
One particular topic of interest is about the design of star schemas. The
material can be DB2 specific or generic for any RDBMS.

Currently, training courses are not an option. Thus, I'm hoping to learn
more about it on my own.

Thank you in advance for any suggestions!

David Mulkey



Jim Knisley

Re: Recommended Books on Data Modeling in OLAP/ROLAP Environment
(in response to DW David (7091) Mulkey)
There are couple of excellent books I have found that deal with
multi-dimensional modeling (both star and snowflake). They are:
The Data Warehouse Lifecycle Toolkit, Ralph Kimball, ISBN 0-471-25547-5
Building the Data Warehouse, W.H. Inmon

Jim





"Mulkey, DW David (7091)" <[login to unmask email]> on 12/15/99 12:24:16 PM

Please respond to DB2 Data Base Discussion List <[login to unmask email]>

To: [login to unmask email]
cc: (bcc: Jim Knisley/TFG/HII)
Subject: Recommended Books on Data Modeling in OLAP/ROLAP Environment



Does anyone know of any books (and/or web sites) that they would recommend
for learning about data modeling in a relational OLAP (ROLAP) environment?
One particular topic of interest is about the design of star schemas. The
material can be DB2 specific or generic for any RDBMS.

Currently, training courses are not an option. Thus, I'm hoping to learn
more about it on my own.

Thank you in advance for any suggestions!

David Mulkey








Raffi Garabedian

Re: Recommended Books on Data Modeling in OLAP/ROLAP Environment
(in response to Jim Knisley)
David,

I find "The Data Model Resource Book" by Len Silverston, W.H. Inmon, Kent Graziano very resourceful. Just a start.

Enjoy,

Raffi Garabedian


"Mulkey, DW David (7091)" wrote:

> Does anyone know of any books (and/or web sites) that they would recommend
> for learning about data modeling in a relational OLAP (ROLAP) environment?
> One particular topic of interest is about the design of star schemas. The
> material can be DB2 specific or generic for any RDBMS.
>
> Currently, training courses are not an option. Thus, I'm hoping to learn
> more about it on my own.
>
> Thank you in advance for any suggestions!
>
> David Mulkey
>
>
>



Mark Doyle

Re: Recommended Books on Data Modeling in OLAP/ROLAP Environment
(in response to Raffi Garabedian)
When we did a data warehouse methodology project in the pharmaceuticals industry, we used three references extensively:

The Data Warehouse Lifecycle Toolkit: Expert Methods for Designing, Developing and Deploying Data Warehouses, Kimball, Ralph; Reeves, Laura: Ross, Margy & Thornthwaite, Warren; New York,
John Wiley & Sons, Inc 1998

The Data Warehouse Toolkit: Practical Techniques for Building Dimensional Data Warehouses, Kimball, Ralph; New York, John Wiley & Sons, Inc 1996

“Enterprise Data Warehouse, Volume 1: Planning, Building and Implementing, Sperley, Eric; Upper Saddle River, N.J.; Prentice Hall PTR (http://www.phptr.com) 1999

Kimball 1998 is an expanded, updated version of the 1996 book, and both are worth having. He goes into great (sometimes excruciating) detail about the topics he covers. Either is
recommended for people who are new to data management, and data warehousing. Sperley covers the same info, but in 300 fewer pages.


"Mulkey, DW David (7091)" wrote:

> Does anyone know of any books (and/or web sites) that they would recommend
> for learning about data modeling in a relational OLAP (ROLAP) environment?
> One particular topic of interest is about the design of star schemas. The
> material can be DB2 specific or generic for any RDBMS.
>
> Currently, training courses are not an option. Thus, I'm hoping to learn
> more about it on my own.
>
> Thank you in advance for any suggestions!
>
> David Mulkey
>
>
>