Re: U_SUMMARIZE: how aggregate is calculated?
Date: Thu, 2 Dec 2004 10:02:36 -0800
Message-ID: <RXIrd.54$G45.97_at_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