Part 4: Modeling Validity Intervals

The aim of this part is to provide a complex description of validity modeling using intervals. Duration modeling generally requires two timepoints expressing a start and end point. However, what about unlimited validity? How can you model it? It is generally clear that if a new state is to be loaded into the system, the user does not need to know when its validity will end – or even whether it ever will. Thus, we will describe various techniques of unlimited validity modeling. Oracle Database provides the Period definition to carry out this modeling.

Temporal models will also be discussed, focusing on various granularity precisions. But that is not enough. Therefore, temporal dimensions will also be explored, such as validity, transaction validity, the IPL model, the IPLT model, online and offline application modes, and future valid record management. We will draw your attention to the fact that the existence of attributes expressing date...