Browse Prior Art Database

Interpretive Database Aggregation Operations

IP.com Disclosure Number: IPCOM000058418D
Original Publication Date: 1988-Oct-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 single aggregate result. One such aggregate func (Image Omitted) tion is the determination of the minimum data value of a specified column within a table. Another such aggregate function is the determination of the number of rows which contain a non-null, distinct data value for that column. Other database products employ a system of control blocks which implement control functions and record accesses specified by a given SQL statement.