::scr Data integrity and why databases suck

Alaric Snell scr@thegestalt.org
Thu, 7 Feb 2002 11:52:43 +0000


On Wednesday 06 February 2002 19:19, you wrote:

> On top of that, most of the vast and expensive apparatus built into
> relational databases in never used. Object-oriented tools  that talk to
> databases make almost no use of the kind of complex, set based operations
> databases specialise in implementing efficiently. Instead, they spend their
> time inserting, updating and deleting single rows, and occasionally doing a
> multi-row "select". Your expensive BEA application server never even uses
> your even more expensive Oracle database to do a join.

Oh, hell, yes!

The only 'good' thing about this situation I've found is that you can 
sometimes build the OO layer on top of an existing database that other tools 
are already using.

For a completely new system, however, it seems a crazy approach to take. 
You'd be better serialising the damned objects and putting them in a 
filesystem!

> Simon

-- 
                               Alaric B. Snell
 http://www.alaric-snell.com/  http://RFC.net/  http://www.warhead.org.uk/
   Any sufficiently advanced technology can be emulated in software