Referring Null Values in Partitioned Tables

Nowadays, working with data is very important in the decision-making process. A large amount of data is generated daily and needs to be stored efficiently. The database system makes it possible to divide tables into smaller, more manageable chunks, so-called partitions. Partitions are created based on the partition key column. If we insert records that do not contain any anomalies, there is no problem with inserting records into the partitioned table. The problem can arise if we are trying to insert records that contain null values of the partition key column. Therefore, the aim of this paper is to show how records with null values of the partition key columns behave when inserted into a partitioned table and to create methodology for managing partitions with records with null values. We focus on three types of partitioning: Range, List and Hash partitioning. As part of the experiments, we will show how it is possible to modify the definition of the created tables and partitions so, that the records with null value of the partition key column can also be inserted into the table.