Summary

This chapter dealt with the monthly calendar composition through our own implementation. The principles were based on building a list of days followed by a weekday association. It was done with PL/SQL, as well as SQL. The focus was on the proper positioning of the days on the calendar. A calendar can be filled with individual events, birthdays, or name days. Therefore, a definition of a package managing name days was introduced and discussed.

So far, we have been dealing with temporality using data model extensions. However, the relational paradigm is associated with transactions ensuring isolation and durability. These key elements are supervised by transaction logging – UNDO and REDO structures. By extracting values from logs, historical data can be reconstructed.

The next chapter deals with the Flashback technology, providing you with images of the database, table, or query result as they existed at the defined time point or reference. Thus, if the transaction...