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

Teradata Database Design

prodname
Teradata Database
vrm_release
15.00
category
User Guide
featnum
B035-1094-015K

Alternatives To Nulls for Representing Missing Information

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:

  • “Systematic Use of Default Values” on page 679
  • “Redesigning the Database to Eliminate the Need for Nulls” on page 680