User Experiences with Star Schema with a 200 million row Fact tab le

George W A133 Sercombe

User Experiences with Star Schema with a 200 million row Fact tab le
Fellow DBA's

My name is George Sercombe and I am a DBA at the CIGNA Corporation. I have
been asked to survey this forum to understand user experiences with large
DB2 Star Schema physical data models. Our Healthcare Economics' group would
like to understand the processing benefits of a 200 million row Fact table
with approximately 15 Dimension tables extending to a "Snowflake" model with
5 of the Dimension tables having 3 or slightly more Dimension tables
associated with these Dimension tables. This model's performance is to be
compared to their current "denormalized" relational database model which is
I/O bound due to the degree of denormalization.

If your company has a comparable Star Schema (Snowflake) database with
similar dimensions I would like to hear about your experiences using either
the DB2 or UDB database managers. Additionally, in the UDB environment if
you could comment about the use of Bit Map indexes and your performance
gain/loss by using this index paradigm would be greatly appreciated.

Thank you, George Sercombe



William G. Sercombe

email: George.Sercombe@ CIGNA.com
Phone: (860) 226-8220 or 6-8220

> Confidential, unpublished property of CIGNA
> Do not duplicate or distribute
> Use and distribution limited solely to authorized personnel.
>(c) Copyright 2004 (CIGNA Corporation)



++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
CONFIDENTIALITY NOTICE: If you have received this e-mail in error, please immediately notify the sender by e-mail at the address shown. This e-mail transmission may contain confidential information. This information is intended only for the use of the individual(s) or entity to whom it is intended even if addressed incorrectly. Please delete it from your files if you are not the intended recipient. Thank you for your compliance. Copyright (c) 2004 CIGNA

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

George W A133 Sercombe

User Experiences with Star Schema with a 200 million row Fact tab le
(in response to George W A133 Sercombe)
Fellow DBA's

My name is George Sercombe and I am a DBA at the CIGNA Corporation. I have
been asked to survey this forum to understand user experiences with large
DB2 Star Schema physical data models. Our Healthcare Economics' group would
like to understand the processing benefits of a 200 million row Fact table
with approximately 15 Dimension tables extending to a "Snowflake" model with
5 of the Dimension tables having 3 or slightly more Dimension tables
associated with these Dimension tables. This model's performance is to be
compared to their current "denormalized" relational database model which is
I/O bound due to the degree of denormalization.

If your company has a comparable Star Schema (Snowflake) database with
similar dimensions I would like to hear about your experiences using either
the DB2 or UDB database managers. Additionally, in the UDB environment if
you could comment about the use of Bit Map indexes and your performance
gain/loss by using this index paradigm would be greatly appreciated.

Thank you, George Sercombe



William G. Sercombe

email: [login to unmask email]
Phone: (860) 226-8220 or 6-8220

> Confidential, unpublished property of CIGNA
> Do not duplicate or distribute
> Use and distribution limited solely to authorized personnel.
>(c) Copyright 2004 (CIGNA Corporation)



++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
CONFIDENTIALITY NOTICE: If you have received this e-mail in error, please immediately notify the sender by e-mail at the address shown. This e-mail transmission may contain confidential information. This information is intended only for the use of the individual(s) or entity to whom it is intended even if addressed incorrectly. Please delete it from your files if you are not the intended recipient. Thank you for your compliance. Copyright (c) 2004 CIGNA

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm