Re: Which one is better, Oracle or SQL server - clear answer !

> By the way, who knows, what OO databases have what sort of locking ? Do
> they need locking ?

OOFILE Professional has one locking mode used by default in GUI apps with record locking via c-tree's engine but because it models relationships as first class entities knows when you are in a master-detail situation and just locks the parent records.

So here we immediately see one possibility for an OODBMS - more domain knowledge implied in the engine so it can avoid locks altogether (the fastest algorithm being one you avoid performing!).

If producing a database library for use in a variety of related applications and you are paranoid about people directly accessing the detail tables, you can hide them as member variables so only related records are accessible.

You can also exert more fine grained locking and transaction control in your app.

-- 
Andy Dent BSc  MACS  AACM   http://www.oofile.com.au/
OOFILE - Database, Reports, Graphs, GUI for c++ on Mac, Unix & Windows
PP2MFC - PowerPlant->MFC portability