Glossary

Aggregate Function

A snippet of programming code that executes a particular type of mathematical aggregation on a set of data and returns a single value.

Aggregate View

A view used to display information produced by aggregating a particular set of data in a specific manner.

Alternate Key

A candidate key that has not been designated as a primary key.

Analytical Database

A type of database that stores static data and is used when there is a need to track trends, view statistical data over a long period of time, or make tactical or strategic business projections; it is typically associated with OLAP.

Application

A commercial or custom-built software program that is typically used to provide a user-friendly interface for a database. ...

Get Database Design for Mere Mortals™: A Hands-On Guide to Relational Database Design, Second Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.