Summary
This chapter dealt with interval representation and type relationships. In the first part, transformation principles across time intervals were stated and demonstrated by adding the smallest time element to the interval. Then, the focus shifted to the positional and temporal relationships by discussing interval interaction types. These positions are crucial for state monitoring in a timeline.
Oracle Database provides a PERIOD
structure that applies to the table definition expressing the duration forming temporal validity. This chapter dealt with its concepts, modeling, and definition. By reading this chapter, you will have become familiar with using the data dictionary to evaluate and identify the PERIOD
structure for a particular table that already exists. The PERIOD
structure is associated with the ENABLE_AT_VALID_TIME
function of the DBMS_FLASHBACK_ARCHIVE
package. By using that function, temporal principles can be applied. It allows you to highlight current valid states...