Aggregate Function

An Aggregate Function is a function structure that produces a summary value.

• Context:
  • It can (often) be a Database Aggregate Function.
  • …
• Example(s):
  • a Counting Function.
  • a Maximum Function, Median Function, Minimum Function, Mode Function.
  • …
• Counter-Example(s):
  • a Sampling Function.
• See: Summation, Statistic Function, Descriptive Statistic, SQL Group By.

---

---

References

2015

• (Wikipedia, 2015) ⇒ http://en.wikipedia.org/wiki/aggregate_function Retrieved:2015-2-13.
  • In database management an aggregate function is a function where the values of multiple rows are grouped together as input on certain criteria to form a single value of more significant meaning or measurement such as a set, a bag or a list.

    Common aggregate functions include:

    • Average() (i.e., arithmetic mean)
    • Count()
    • Maximum()
    • nanmean() (mean ignoring NaN values (or undefined values or 'nil's))
    • Median()
    • Minimum()
    • Mode()
    • Sum()
  • Aggregate functions are common in numerous programming languages, spreadsheets, and relational algebra.

---