Aggregate Function Trichotomy

• Distributive

  • F(X[*,*]) = G( {F(X[*,1]), F(X[*,2]), …} )
  • Count, Min, Max

• Algebraic

  • F(X[*,*]) = H( {G(X[*,1]), G(X[*,2]), …} )
  • Average, STD, MaxN?, MinN?

• Holistic

  • Median, MostFrequent, Rank

Previous slide

Next slide

Back to first slide

View graphic version