Re: isolation levels

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Bojidar Alexandrov (bojo_do_not_spam_at_kodar.net)
Date: 06/01/04 

Date: Tue, 1 Jun 2004 11:15:51 +0300

As far as I know SQL server uses blocking technology for achiving
concurency. So that cannot be changed.

Borland Interbase or the open source fork Firebird and also open source
PostgreSQL uses versioning - ie. keep old versions of the records. This way
not only one but there can be multiple back versions of one record and other
transactions will see them (if they want to - this is controled by
transaction flags so it can work with blocking too). This involves more
complex logic at database server level and one background process that mark
old versions as deleted when there are no interested transactions.

Bojidar Alexandrov

Relevant Pages

  • Re: Data source options
    ... >> It sounds like you have the technology, although not in an open source ... I've been watching the "maturation" of the XML space. ... > SQL Server for 'unstructured data', but that looks VERY INTERESTING ... ... Visage ISN'T free - but it is cheap as chips ...
    (comp.databases.pick)
  • Re: Common database code for Oracle, SQL Server, MS Access
    ... You should use a persistence framework to provide an additional layer of ... I've written one and released it as open source (LGPL, ... Firebird/Interbase support is in the works. ... > In phase one we want to develop the app on MS Access and later on wants to migrate to Oracle or SQL Server. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Why Should I Use MSSQL...?
    ... You are already using Open Source what? ... The pros of using MSSQL are here: http://www.microsoft.com/sql, ... One of the drawbacks of using MS SQL Server is that it is tied to ...
    (microsoft.public.sqlserver.server)
  • Re: Access to MS SQL from Linux?
    ... >> Is there any Python library for accessing MS SQL server ... >> from a Linux machine? ... Either open source or commerical one will do for me. ... I would think the ODBC driver would be the first choice. ...
    (comp.lang.python)