Re: Convert SAP Oracle Database to IBM DB2 Database??
From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 07 Feb 2008 19:11:15 -0800
Message-ID: <1202440247.467059@bubbleator.drizzle.com>
>> Serge Rielau wrote:
>>> DA Morgan wrote:
>>>> Serge Rielau wrote:
>>>>> DA Morgan wrote:
>>>>>> My testing of Oracle compression versus DB2 compression indicates
>>>>>> that
>>>>>> DB2 has some catching up to do.
>>>>> Interesting, care to elaborate? Always thriving to improve...
>>>>> Given Oracle's DeWitt clause I'll gladly accept any information you
>>>>> have by email as to not get you into trouble.
>>>> Going to have to disappoint you this time for reasons I am sure you can
>>>> appreciate.
>>> So an unsubstantiated claim... Aside you should use DB2 9.5 to
>>> compare to Oracle 11
>>
>> If I'd used Oracle 11 I would have.
>>
>> But as long as you are actively participating how about a brief
>> technical presentation from the expert explaining to us how compression
>> in DB2 differs from that in Oracle 10g and 11g.
>>
>> Please include also information as to how headers are designed and how
>> blocks are filled? Top down as in Informix for both Top-Down and
>> Bottom-Up as in Oracle? Or some other means.
Date: Thu, 07 Feb 2008 19:11:15 -0800
Message-ID: <1202440247.467059@bubbleator.drizzle.com>
Serge Rielau wrote:
> DA Morgan wrote:
>> Serge Rielau wrote:
>>> DA Morgan wrote:
>>>> Serge Rielau wrote:
>>>>> DA Morgan wrote:
>>>>>> My testing of Oracle compression versus DB2 compression indicates
>>>>>> that
>>>>>> DB2 has some catching up to do.
>>>>> Interesting, care to elaborate? Always thriving to improve...
>>>>> Given Oracle's DeWitt clause I'll gladly accept any information you
>>>>> have by email as to not get you into trouble.
>>>> Going to have to disappoint you this time for reasons I am sure you can
>>>> appreciate.
>>> So an unsubstantiated claim... Aside you should use DB2 9.5 to
>>> compare to Oracle 11
>>
>> If I'd used Oracle 11 I would have.
>>
>> But as long as you are actively participating how about a brief
>> technical presentation from the expert explaining to us how compression
>> in DB2 differs from that in Oracle 10g and 11g.
>>
>> Please include also information as to how headers are designed and how
>> blocks are filled? Top down as in Informix for both Top-Down and
>> Bottom-Up as in Oracle? Or some other means.
> http://blogs.ittoolbox.com/database/technology/archives/compression-in-11g-vs-db2-9-21173 > > Maybe we can also take the discussion there.... > > Cheers > Serge
I would but there is a rather substantial problem: Chris Eaton's understanding of Oracle compression appears to not even include the marketing materials much less the rather substantial discussion of the concepts and architecture.
What I'm saying is that it is not just superficial ... from a technical point-of-view it is mostly incorrect. He needs to learn how to read the on-line docs.
-- Daniel A. Morgan Oracle Ace Director & Instructor University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Thu Feb 07 2008 - 21:11:15 CST