Re: Decline of Science: Computer Science and Databases
Date: Mon, 4 Nov 2002 13:00:28 +0100
Message-ID: <aq5n1g$jce$05$1_at_news.t-online.com>
Leandro Guimarăes Faria Corsetti Dutra wrote:
> > Are the examples really that hard to read?
>
> Yes.
Obviously, since you know SQL and S.O.D.A. is new.
S.O.D.A. does have trade-offs at legibility due to the nature
of the used OO language (Java) and due to the fact that we
wanted to make it possible to plug existing objects into a query.
Step 1:
Constrain the query by any object.
Step 2:
Choose the comparator.
constraint.greater();
> Just see that for all but two of the examples, your comments are
> actually much simpler, more logical SQL statements.
The examples listed are not possible with common SQL databases:
(1) You can not select from all tables!
(2) You can not execute Java code against stored objects.
(3) SQL does not understand Java classes or Java interfaces.
(4) In a union, you can not use the same where clause for multiple tables.
(5) SQL queries do not have a viewpoint, as in the last example.
> And that given that SQL is already below relational standards.
> The other two are simple enough to be expressed in a relational
> system also much clearer.
Kind regards,
Carl
-- Carl Rosenberger db4o - database for objects - http://www.db4o.comReceived on Mon Nov 04 2002 - 13:00:28 CET