Re: Dreaming About Redesigning SQL

Patrick K. O'Brien wrote:
> As I've said before, I haven't focused on optimization yet. But I
> remain convinced that an ODBMS with the proper object model can be
> optimized as you describe. Does that make me an optimist? ;-)

The proof is trivial:

If you back up your object database system with a parallel fast relational system (or write that yourself), you should be able to achieve the same performance for relational queries as any relational database. :-)

...plus you keep all your object database benefits such as: - navigational speed
- tight language binding, resulting in

• less code
• better refactorability with existing IDEs
• the possibility to execute object methods during query evaluation

Hi Patrick,

I just had a look over your flame thread with Alfredo and others. I have had very similar discussions here in the past. Never mind their agressive tone. Time will tell.

Cheers,
Carl

--
Carl Rosenberger
db4o - database for objects - http://www.db4o.com