About Data Warehoousing

Winnie Cruz

About Data Warehoousing
We are in the process of evaluating data warehousing, and are looking for the
right database software. Has anyone using DB2 UDB for their DW encountered
problem? We are also looking at TERADATA, a specialized software for DW. There
are a lot of write up that tell us about TERADATA not being able to handle
killer queries and CEO queries which UDB can handle thru the WLM.
And with regards to UDB, TERADATA also say that to mix OLTP with DW, there will
be a dramatic degradation in response time of the DW. And IBM told us that there
will be degradation but it will be minimal.

I am right now having a hard time comparing the two implementation, IBM S/390
with DB2 UDB, RS/6000 with DB2 EEE and MPRAS with TERADATA. Can anyone help me?
What kind of DW implementation do you have?

Thank You

Cuneyt Goksu

FW: About Data Warehoousing
(in response to Winnie Cruz)
Our DW is on OS/390 with DB2. We have some OLTP trans. goes into DW but no DW trans. go
to Operational Data. Mixed workload is just working fine. Use different BPs for OLTP and DW
if you're in Datasharing. Use Part. ts. and parallesim as mush as possible.


Cuneyt GOKSU
GARANTÝ TEKNOLOJÝ
Istanbul / TURKEY
Tel : 0090-212-657 0404 Ext: 1218
mailto:[login to unmask email]




-----Original Message-----
From: [login to unmask email] [mailto:[login to unmask email]
Sent: Thursday, October 07, 1999 9:38 AM
To: [login to unmask email]
Subject: About Data Warehoousing


We are in the process of evaluating data warehousing, and are looking for the
right database software. Has anyone using DB2 UDB for their DW encountered
problem? We are also looking at TERADATA, a specialized software for DW. There
are a lot of write up that tell us about TERADATA not being able to handle
killer queries and CEO queries which UDB can handle thru the WLM.
And with regards to UDB, TERADATA also say that to mix OLTP with DW, there will
be a dramatic degradation in response time of the DW. And IBM told us that there
will be degradation but it will be minimal.

I am right now having a hard time comparing the two implementation, IBM S/390
with DB2 UDB, RS/6000 with DB2 EEE and MPRAS with TERADATA. Can anyone help me?
What kind of DW implementation do you have?

Thank You

Rick Davis

Re: About Data Warehoousing
(in response to Cuneyt Goksu)
At you're current juncture, I think the more appropriate questions would be:

How much data? How many users? How much data must be delivered to how many users
at the same time? Is time-to-recover or reorg an issue? What aggregate data
transfer rate must the proposed platform handle; avg and peak? What does the
data look like; char, mixed, LOB, BLOB, GLOB and can the proposed DB and
platform handle it? What will be the business-critical access type(s) and can
the proposed DB and platform handle it? When can I benchmark the options? What
methods will be available with the proposed DB and platform to keep DW users
from interfering with OLTP users, if need be?
HTH, Rick


---------------------------------------- Message History
----------------------------------------


From: [login to unmask email] on 10/07/99 07:37 AM GMT

Please respond to [login to unmask email]

To: [login to unmask email]
cc:
Subject: About Data Warehoousing




We are in the process of evaluating data warehousing, and are looking for the
right database software. Has anyone using DB2 UDB for their DW encountered
problem? We are also looking at TERADATA, a specialized software for DW. There
are a lot of write up that tell us about TERADATA not being able to handle
killer queries and CEO queries which UDB can handle thru the WLM.
And with regards to UDB, TERADATA also say that to mix OLTP with DW, there will
be a dramatic degradation in response time of the DW. And IBM told us that there
will be degradation but it will be minimal.

I am right now having a hard time comparing the two implementation, IBM S/390
with DB2 UDB, RS/6000 with DB2 EEE and MPRAS with TERADATA. Can anyone help me?
What kind of DW implementation do you have?

Thank You

Piontkowski Michael ML

Re: About Data Warehoousing
(in response to Rick Davis)
Check out the article DB2 for OS390: Providing Business Value
in a Query Environment in IDUG Solutions Journal Vol 6 No 2
http://www.idug.org.

IBM's DB2 for OS/390 website, http://www.software.ibm.com/data/db2/os390,
has a link to white papers and case studies on data warehousing.
Also check out http://www.software.ibm.com/data/


Mike Piontkowski
Voice/Fax: 302.886.4612
mailto:[login to unmask email]

> ----------
> From: [login to unmask email]:[login to unmask email]
> Sent: Thursday, October 07, 1999 3:37 AM
> To: [login to unmask email]
> Subject: [DB2-L] About Data Warehoousing
>
> We are in the process of evaluating data warehousing, and are looking for
> the
> right database software. Has anyone using DB2 UDB for their DW
> encountered
> problem? We are also looking at TERADATA, a specialized software for DW.
> There
> are a lot of write up that tell us about TERADATA not being able to handle
> killer queries and CEO queries which UDB can handle thru the WLM.
> And with regards to UDB, TERADATA also say that to mix OLTP with DW, there
> will
> be a dramatic degradation in response time of the DW. And IBM told us that
> there
> will be degradation but it will be minimal.
>
> I am right now having a hard time comparing the two implementation, IBM
> S/390
> with DB2 UDB, RS/6000 with DB2 EEE and MPRAS with TERADATA. Can anyone
> help me?
> What kind of DW implementation do you have?
>
> Thank You
>

Richard A Yevich

Re: About Data Warehoousing
(in response to Piontkowski Michael ML)
Have you looked at the customer reference stories and references on DB2
Warehouses on the www.software.ibm.com/db2 web sites? There are many VERY
large and successful warehouses on OS/390 and UNIX. There are also white
papers and many articles on the internet as well showing the success of
these platforms and DB2 in the warehouse and BI area. Your choice of
platform needs to be based on the business requirements for your warehouse,
and where the source data is coming from. Many of those articles and white
papers should point you in the right direction.

Also, try this article: www.db2mag.com/98spYevc.htm on why to warehouse on
the OS/390.

Richard Yevich
+=====+======+
Information Technology Consulting, Data Modeling, Advanced Education
RYC® Inc. USA: 1-800-664-2421 Int'l: 1-305-361-8585 Fax: 1-512-476-3930
Web: < http://www.ryci.com > Email: [login to unmask email] Offices: USA and Europe
DB2® Family and Oracle® Specialists - Parallel Technologies
VLDB and Data Sharing Technologies (specialties SAP®, Peoplesoft®)
Authors of "DB2 Answers" by Osborne-McGraw Hill, May, 1999

> -----Original Message-----
> From: DB2 Data Base Discussion List [mailto:[login to unmask email]On Behalf Of
> [login to unmask email]
> Sent: Thursday, October 07, 1999 3:38 AM
> To: [login to unmask email]
> Subject: About Data Warehoousing
>
>
> We are in the process of evaluating data warehousing, and are
> looking for the
> right database software. Has anyone using DB2 UDB for their DW
> encountered
> problem? We are also looking at TERADATA, a specialized software
> for DW. There
> are a lot of write up that tell us about TERADATA not being able to handle
> killer queries and CEO queries which UDB can handle thru the WLM.
> And with regards to UDB, TERADATA also say that to mix OLTP with
> DW, there will
> be a dramatic degradation in response time of the DW. And IBM
> told us that there
> will be degradation but it will be minimal.
>
> I am right now having a hard time comparing the two
> implementation, IBM S/390
> with DB2 UDB, RS/6000 with DB2 EEE and MPRAS with TERADATA. Can
> anyone help me?
> What kind of DW implementation do you have?
>
> Thank You
>