aggregate function


Also found in: Wikipedia.

aggregate function

[¦ag·rə·gət ′fəŋk·shən]
(computer science)
A command in a database management program that performs an arithmetic operation on the values in a specified column or field in all the records in the database, such as computing their sum or average or counting the number of records that satisfy particular criteria.

aggregate function

A calculation that is made on several records or cells of data. SUM, AVG, MAX, MIN and COUNT are examples of aggregate functions that are used in spreadsheets and database programs.
References in periodicals archive ?
Of Occurrences 0 Audio/Visual 2 Books 2 Null values will effect the results from an aggregate function
For an aggregate production function to exist, one must be able to aggregate different production techniques into a single aggregate function and aggregate heterogeneous outputs and inputs into aggregate indexes.
In this approach, information about the characteristics of the monetary aggregates is obtained by empirically estimating the parameters of a monetary aggregate function consisting of various monetary assets.
High-Performance SPARQL-compliant RDF Quad Store - Full Text Indexing extension to SPARQL - SPARQL Update Language (SPARUL) support - Aggregate Function extensions to SPARQL - Integration of SPARQL and SQL - Built-in Middleware ("Sponger") for dynamically producing RDF data from non-RDF data sources - Declarative SQL to RDF mapping
For each grouping field, you can define a collection of totals to be displayed - each total calculating its own aggregate function.
CDR reports can be created with aggregate functions like Sum, Average, Percentage and any grouping of columns other than start time.
Some paper topics include an early-stopping protocol for computing aggregate functions in sensor networks, a hardware virtualization tool for malware analysis, an entropy based method for network anomaly detection, and chip-level redundancy in distributed shared-memory multiprocessors.
Aggregate Functions in WebGrid Column Footers fulfills users' need for a spreadsheet-style data display which shows calculations such as sum, average, count, minimum and maximum.
Quicksheet is a spreadsheet for your PDA with more than 60 built-in financial, scientific, statistical, date and time, table, and aggregate functions.
Tempdb, a very frequent bottleneck for complex online applications as well as decision support applications that use aggregate functions (and hence, tempdb).
1 with the inclusion of analytic functionality normally associated with sophisticated SQL products, such as windowed aggregate functions.
He covers the theories behind structured data mining, multi-relational data, multi-relational patterns, multi-relational rule recovery, multi-relational decision tree induction, aggregate functions and pre-positionalization, aggregate functions and rule discovery, MRDM primitives, MRDM in action as a blueprint and project and then as a way to locate transformation rules, and the validity of the MRMD approach.
Full browser ?