Aggregate function

Aggregate function

In computer science, an aggregate function is a function that computes a single result value from a collection of input values such as a set, a bag or a list.

Common aggregate functions include:

* Average()
* Count()
* Maximum()
* Minimum()
* Sum()

Aggregate functions are common in numerous programming languages such as Ruby, SQL (where it goes by the name Group by), and in relational algebra.

ee also

* Group by (SQL), SQL implementation


Wikimedia Foundation. 2010.

Игры ⚽ Поможем решить контрольную работу

Look at other dictionaries:

  • Aggregate Function — A mathematical computation involving a set of values rather than a single value. Aggregate functions are often used in databases and spreadsheets, and include the mean or sum of a set of numbers. The calculation performed by an aggregate function …   Investment dictionary

  • Aggregate — may refer to: * Aggregate (composite), in materials science, a component of a composite material used to resist compressive stress * Construction aggregate, materials used in construction, including sand, gravel, crushed stone, slag, or recycled… …   Wikipedia

  • Function (mathematics) — f(x) redirects here. For the band, see f(x) (band). Graph of example function, In mathematics, a function associates one quantity, the a …   Wikipedia

  • Aggregate demand — This article is about a concept in macroeconomics. For microeconomic demand aggregated over consumers, see Demand curve. In macroeconomics, aggregate demand (AD) is the total demand for final goods and services in the economy (Y) at a given time… …   Wikipedia

  • Aggregate expenditure — In economics, Aggregate Expenditure is a measure of national income. Basically it is one of the approaches to measure GDP. It is defined as the value of planned goods and services produced in an economy. Where GDP is defined as C + I + G + NX and …   Wikipedia

  • Aggregate Level Simulation Protocol — The Aggregate Level Simulation Protocol (ALSP) is a protocol and supporting software that enables simulations to interoperate with one another. Replaced by the High Level Architecture (simulation) (HLA), it was used by the US military to link… …   Wikipedia

  • Aggregate behavior — In economics, aggregate behavior refers to relationships between economic aggregates such as national income, government expenditure and aggregate demand. For example, the consumption function is a relationship between aggregate demand for… …   Wikipedia

  • Aggregate pattern — An Aggregate pattern can refer to concepts in either statistics or computer programming. Both uses deal with considering a large case as composed of smaller, simpler, pieces. Statistics An aggregate pattern is an important statistical concept in… …   Wikipedia

  • Production function — Graph of Total, Average, and Marginal Product In microeconomics and macroeconomics, a production function is a function that specifies the output of a firm, an industry, or an entire economy for all combinations of inputs. This function is an… …   Wikipedia

  • Lucas aggregate supply function — The Lucas aggregate supply function or Lucas surprise supply function, based on the Lucas imperfect information model, is a representation of aggregate supply based on the work of new classical economist Robert Lucas. The model states that… …   Wikipedia

Share the article and excerpts

Direct link
Do a right-click on the link above
and select “Copy Link”