16.10 - Alternatives To Nulls for Representing Missing Information - Teradata Database

Teradata Database Design

Teradata Database
Release Number
Release Date
June 2017
Content Type
User Guide
Publication ID
English (United States)

Unlike every other feature of the database relational model, the treatment of missing information is not based on a formal foundation. As a result, even though the usual explanations of nulls often appear to make common sense, any detailed investigation reveals a number of potentially serious problems with SQL nulls.

The following sections describe some proposed alternative solutions to the missing value problem.