O'Reilly logo

Database Design for Mere Mortals™: A Hands-On Guide to Relational Database Design, Second Edition by Michael J. Hernandez

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required