::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