Browse Prior Art Database

Interpretive Database Aggregate Average and Maximum Algorithms

IP.com Disclosure Number: IPCOM000057979D
Original Publication Date: 1988-Aug-01
Included in the Prior Art Database: 2005-Feb-15

Publishing Venue

IBM

Related People

Authors:
Copenhaver, MA Coyle, DJ Hintz, TE [+details]

Abstract

The Structured Query Language (SQL) developed for use with relational database systems is used to describe database operations to the IBM Database Manager. Aggregate functions are a category of such database operations. These are operations that are applied to a column of values to arrive at a single result. One such aggregate function is the averaging of data values within a specified column of a table. Another such aggregate function is the determination of the maximum data value of a specified column within a table. Other database products employ a system of control blocks which implement control functions and record accesses specified by a given SQL statement. These control blocks are subsequently manipulated by control block specific functions at execution time.