Re: Idempotence and "Replication Insensitivity" are equivalent ?

From: Aloha Kakuikanu <aloha.kakuikanu_at_yahoo.com>
Date: 22 Sep 2006 17:43:51 -0700
Message-ID: <1158972230.961294.94250@d34g2000cwd.googlegroups.com>

pamelafluente_at_libero.it wrote:
> The median, like the mean IS an aggregate function.
>
> All dbms implements it.

Look up any math book. Do you see an aggregate symbol except:

i. sigma capital (aka summation)
ii. pi capital (aka product)
iii. /\ (aka min, aka conjunction, aka "for any" quantifier) iv. \/ (aka max, disjunction, "forall" )

? I don't.

Expressing an arbitraty aggregation in terms of these is trivial. You just consult any math dictionary for the formula that defines it in terms of the above four fundamental aggregates and write a corresponding expression in SQL. Received on Fri Sep 22 2006 - 19:43:51 CDT