Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: Idempotence and "Replication Insensitivity" are equivalent ?

Re: Idempotence and "Replication Insensitivity" are equivalent ?

From: <pamelafluente_at_libero.it>
Date: 23 Sep 2006 02:34:19 -0700
Message-ID: <1159004059.715903.100580@m73g2000cwd.googlegroups.com>

Phil Carmody ha scritto:

> pamelafluente_at_libero.it writes:
> > the Median is the value which minimize the sum of absolute differences
> >
> > ie. sum | xi - c | is minimum for c = MEDIAN()
>
> If I were Bob Silverman, you'd get one heck of a flaming for
> posting something so obviously somewhere in between unintelligible
> and meaningless (including both endpoints) to sci.math.

 :)

What is that you do not understand there? I am talking about fact that are quite elementary and averyone knows about.

It's not meaningless. I am showing that AVERAGE and MEDIAN can be generated through the same device (k=2 for AVG and k=1 for MEDIAN). Even MIN and MAX fall within this conceptual scheme.

You cannot consider the AVG an aggregate function and say that MEDIAN is not. It does not make any sense (to me).

You can find that on every elementary text of statistics.

take a look here:

http://en.wikipedia.org/wiki/Median#An_optimality_property

see also

http://groups.google.it/group/sci.math/browse_frm/thread/34e57e7a7e0fb7cf/4e2b24bcea337c48?lnk=st&q=median+minimizes+absolute+&rnum=7&hl=it#4e2b24bcea337c48

http://groups.google.it/group/sci.stat.edu/browse_frm/thread/7ca5f5f10b5c6fd9/893309ef2eb9a828?lnk=st&q=median+minimizes+absolute+&rnum=1&hl=it#893309ef2eb9a828

-P

>
> Phil
> --
> "Home taping is killing big business profits. We left this side blank
> so you can help." -- Dead Kennedys, written upon the B-side of tapes of
> /In God We Trust, Inc./.
Received on Sat Sep 23 2006 - 04:34:19 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US