Re: Unknown SQL

Bob Badour wrote:
> > The difference is that the OODBMS will not have to do the join
> >(WHERE c.custid = p.custid) because the transactions associated with a
> >customer are already associated with the customer, allowing direct
 access.
>
> Huh? Of course it has to do the join.

Yes, but the relation can be handled automatically and internally without any necessary work for the application developer. Links between objects in a query language would also be predefined by the class model. The "WHERE clause" could omit many keys.

> A relational database management
> system need not perform any more poorly than a
> network model OODBMS.

The implementations behind the user-interface (SQL or "pass objects") will get more and more similar with evolution. Relational databases will improve object support. Object databases will improve declarative query capabilities, indices and memory management.

Today the commonly used relational databases have one big disadvantage: They don't support inheritance cleanly.

The commonly used object databases have one big disadvantage: They don't live up to the quality standards that relational databases provide.

Kind regards,
Carl

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