Using Aggregate -MarketBasket Analysis

Hi,

it does basically the same thing as the aggregation known from databases (group by plus aggregation function). Here are some infos:

http://www.sqlcommands.net/sql+group+by/
http://www.w3schools.com/sql/sql_groupby.asp

Cheers,
Ingo

i think u have missunderstood me ::)  . i know what the aggregation does. but i need a motivation to use it.

i need a specific situation where this operator is applied.



greetings

Lotus

Oh, I must than have misunderstood

But what exactly does it do?

By reading your statement again it of course says "I need a motivation" for using it 

The answer still is the same: Read the text given in the links, they also give a motivation in which situations the operator can be applied.

Cheers,
Ingo

as far as i understood the content given in the link this operator can be used to get sum of each product in the data set.

But in which cases do i need to know how much e.g. apple i got in the Data set. That was my question.

Both links say 'u can use the aggregate for sum, average etc. but when is it useful in Association analysis...


greetings

Lotus

Hi,

That was my question.

No, is was not. But anyway...

If this is useful in association analysis or not can not be answered in general. If you want to search for associations in aggregations you will probably need the aggregation operator. Don't forget that you could define several attribute which should be used for grouping and in that case you will end up with several transactions containing different sums of apples / bananas / ... for different groups - what is quite similar to different items for different transactions.

If you are not aiming at something like that, you probably won't need it. It's as simple as that.

Cheers,
Ingo

thx alot for the information. now i have enough to work on the problem on my own 

greetings

Lotus