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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
