Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: oracle - mysql comparison
"Alex Filonov" <afilonov_at_yahoo.com> wrote in message news:336da121.0407150733.5db6de1_at_posting.google.com...
> According to some information M$ is going to implement read-only
> consistency (Oracle style) in the next version.
Yes, MS SQL Server is going to have multiversion concurrency control (the latest Yukon beta actually already has it). It'll be exposed to the user as SNAPSHOT isolation level.
>As for correct concurrency
> model,
A correct concurrency control/model ensures that all the permitted transactions are serializable. In this sense, databases like DB2 or MSSQL implement a correct concurrency model albeit at the expense of lower concurrency in some circumstances. Funnily enough, none of the Oracle isolation levels can make the same promise, i.e. ensure serializable transaction histories, in any of its isolation levels. Usually, it's quite easy to obtain correct results by augmenting an isolation level with something like 'select for update', though..
>I remember one project, when data warehouse was build using MSSQL,
> everything was almost OK, management was pleased immensely. Until they
> started running reports. When management found out that reports
practically
> stopped online work, mood changed.
Well, there are several possible responses to this anecdote:
VC Received on Thu Jul 15 2004 - 17:01:59 CDT