Re: Db2, Oracle, SQL Server

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)