Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Database or store to handle 30 Mb/sec and 40,000 inserts/sec

Re: Database or store to handle 30 Mb/sec and 40,000 inserts/sec

From: DA Morgan <damorgan_at_psoug.org>
Date: Tue, 21 Feb 2006 09:28:16 -0800
Message-ID: <1140542882.448677@jetspin.drizzle.com>


Mark Townsend wrote:

> Serge Rielau wrote:
>

>> Galen Boyer wrote:
>>
>>> On 19 Feb 2006, galen_boyer_at_yahoo.com wrote:
>>>
>>>
>>>>    When would you ever want to read uncommitted records?
>>
>>
>> Uncommitted read is just fine for anything statistical.
>> When mining a DSS or ODS system there is no need to get exact data.
>> Whether someone returned a pair of shoes or not is irrelevant for 
>> trend analysis.
>> Does Oracle support query sampling? If so, there you go...

>
>
> So IBM never recommends UR for DB2 LUW except for situations where users
> can tolerate wrong results (i.e data sampling ?). And presumably you
> would advise MS users to not use UR as well ? What is the default
> isolation level for DB2 LUW ? What is the default isolation level for
> SQL Server 2005 ?

Seems to me we have a semi-official statement from IBM that exact answers when data mining are unimportant.

I can see the full-page four-colour advertisement now. ;-)

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Tue Feb 21 2006 - 11:28:16 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US