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: U_SUMMARIZE: how aggregate is calculated?

Re: U_SUMMARIZE: how aggregate is calculated?

From: Mikito Harakiri <mikharakiri_at_iahu.com>
Date: Thu, 2 Dec 2004 10:02:36 -0800
Message-ID: <RXIrd.54$G45.97@news.oracle.com>


"Alfredo Novoa" <alfredo_at_ncs.es> wrote in message news:41af01f4.3703453_at_news.wanadoo.es...
> On Wed, 1 Dec 2004 17:59:11 -0800, "Mikito Harakiri"
> I that case Sum(1) would be equivalent to Count(R) and the result
> would be 3.

After reading "Temporal Data" my impression was that relation cardinality doesn't matter anymore. Although facts are still stored as tuples, they are easily merged with each other (pack) or partitioned into smaller ones (unpack).

Let me try stating the problem formally. Given

R: {A=[1,2], A= [3,5], A= [4,7]}

what is the result of

USING ( A ) <| SUMMARIZE R
PER TABLE_DEE
ADD SUM(1) AS THE_SUM_IN_QUESTION |> Unlike ordinary SUMMARIZE there is a USING clause. Does it have any effect at all? Received on Thu Dec 02 2004 - 12:02:36 CST

Original text of this message

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