Re: hamsterdb Transactional Storage (thanks to all of you)
From: Bob Badour <bbadour_at_pei.sympatico.ca>
Date: Wed, 07 Oct 2009 20:26:32 -0300
Message-ID: <4acd23ab$0$23771$9a566e8b_at_news.aliant.net>
>
> If we could define aggregates like SUM(R, X) and PRODUCT(R, X+Y) for
> arbitrary operators via a generalization of standard math SIGMA and PI
> series notation over elements of a set then we could define R UNNEST A
> as the iterated UNION over tuples t in R of expression (relation{t}
> REMOVE A) JOIN t.A. So generalized aggregates give it for free.
Date: Wed, 07 Oct 2009 20:26:32 -0300
Message-ID: <4acd23ab$0$23771$9a566e8b_at_news.aliant.net>
> On Oct 5, 10:56 am, rp..._at_pcwin518.campus.tue.nl (rpost) wrote:
>
>>>If you have a generalized aggregate corresponding to series notation >>>you can express UNNEST as UNION over a set of tuples.
>
> If we could define aggregates like SUM(R, X) and PRODUCT(R, X+Y) for
> arbitrary operators via a generalization of standard math SIGMA and PI
> series notation over elements of a set then we could define R UNNEST A
> as the iterated UNION over tuples t in R of expression (relation{t}
> REMOVE A) JOIN t.A. So generalized aggregates give it for free.
Something I have been saying for well over 15 years: Give me adequate domain support and I don't need all the other crap folks want to throw into the database language. Received on Thu Oct 08 2009 - 01:26:32 CEST