Re: object algebra

From: Marshall Spight <mspight_at_dnai.com>
Date: Fri, 27 Feb 2004 03:56:41 GMT
Message-ID: <Zdz%b.414643$xy6.2349603@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?

It's not clear to me you know what "normalized" means. Can you be specific about what normalization rules you are referring to? In what way is my schema not normalized?

Marshall Received on Thu Feb 26 2004 - 21:56:41 CST