| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> comp.databases.theory -> Re: Idempotence and "Replication Insensitivity" are equivalent ?
William Hughes <wpihughes_at_hotmail.com> wrote:
> You are correct.
>
I happen to be reading both discussions. Perhaps it's better to say that Pamela is right about what she proposed here in the sci.math newsgroup. The real question is more like this. (This is a rough attempt at formalizing the notion of aggregate functions. It may contain errors.)
h(a, P) = h(g(a, b), P - {b})
As a technical detail, h remains undefined when its value depends on the choice of b. In practice, g should be chosen so that this never happens.
5. Let f: M(A) -> A be a function defined as follows. To evaluate f(P),
choose an arbitrary member a from P.
f(P) = h(b, P - {a})
As with h, f is undefined if its value depends on the choice of a, and g is expected to be chosen so that this cannot occur.
The question, then, is this: are the following two statements equivalent?
I. f(P) is replication insensitive (i.e., it produces the same result
regardless of the replication of items in P. II. g(a, b) is idempotent.
I think it's clear that the two statements are equivalent.
-- Chris SmithReceived on Mon Sep 18 2006 - 21:55:15 CDT
![]() |
![]() |