Re: object algebra
Date: Fri, 27 Feb 2004 03:56:41 GMT
Message-ID: <Zdz%b.414643$xy6.2349603_at_attbi_s02>
"Neo" <neo55592_at_hotmail.com> wrote in message news:4b45d3ad.0402260934.351a6f24_at_posting.google.com...
> > > And now please write a query that returns an aggregate age of all persons.
> >
> > test=> select sum(to_number(object,'99')) from EX76 where object in
> > ( select subject from EX76 where relator = 'isa' AND object = 'age');
> >
> > Compare the length and clarity of the above SQL with Neo's pseudocode.
>
> If I use unnormalized data, the result would be similar. Can you use
> normalized data and solve the problem with similar level of
> genericness so that we can compare "length and clarity"?
>
> Are you advocating unnormalized data? If not why provide unnormalized
> solutions?
Marshall Received on Fri Feb 27 2004 - 04:56:41 CET