Identifying and Treating NULL Values in the Oracle Database - Performance Case Study

Relational scheme has been created to serve data in a precise format by accepting the structure, conditions, and constraints. It consists of the entities and relationships between them. Each entity is formed by the attributes defined by the data type and various column constraints ensuring integrity and consistency. In this environment, however, undefined values can be present. This paper aims at identifying NULL values by optimizing the storage capacity and data retrieval performance in Oracle Database. Additionally, it provides new unique NULL pointer layer for the undefined value reference. Besides, it summarizes existing approaches by focusing on representation, 3-valued logic, and indexing.