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: Db2, Oracle, SQL Server

Re: Db2, Oracle, SQL Server

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Wed, 09 Feb 2005 18:45:30 -0800
Message-ID: <1108003362.15250@yasure>


Mark A wrote:

> Good database design for OLTP would suggest that if someone is in the middle
> of an update to a row, you should not see the old or current data until the
> work in progress work is committed or rolled back.

Based on your idea of good design one might safely assume that Amazon.com might never need to query its databases and deliver the books.

> For the TPC-H benchmark (Data Warehouse), this is a complete non-issue
> becasue there only selects.

<SCREAMING SARCASM>
Which, of course, is why the benchmark so closely resembles the real-world situations and is so valuable to customers when analyzing their needs.
</SCREAMING SARCASM>

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
Received on Wed Feb 09 2005 - 20:45:30 CST

Original text of this message

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