Re: abstraction of table relationships

JOG wrote:
> Cimode wrote:
> > [snip]
> > Select * from Books --> Authorship --> Persons where PersonId = 'Steven King';
> > Select * from Books --> Editorship --> Persons where PersonId = 'John Doe';
> > [snip]
>
> I like this syntax. Might it follow that I could ask:
This is Cache SQL if interested...

I would prefer

ALL Books(*) writtenby 'Stephen King'
ALL Books(*) editedby 'John Doe'

much more natural for human interpretation

> select * from books --> authorship, editorship --> person_id = "jog"
>
> ...to determine books either edited or authored by me. Or even:
>
> select * from books --> ALL --> person_id = "jog"
or even better....
ALL Books(*) writtenby, editedby 'JOG'

> ...to determine books with which I have any role of involvement with at
> all, as specified by foreign key reference clauses?
All domain derived from Books could be expressed using a BY key word ALL Books(*) BY 'JOG'

(BY would be equivalent to union of all derived domains) Received on Thu Sep 07 2006 - 14:12:44 CDT