Chapter 10Alternatives for Handling Temporal Data

Key Skills & Concepts

Temporal Data Structures

Calendar Data Structures

Business Rules for Temporal Data

Most data models must handle temporal (time dependent) data in one form or another, be it past data values (history), future data values (records that are not to take effect until some point in the future), attaching a time zone to an event such as a flight or an online meeting, or audit trails to account for old and new values as the database is updated. This chapter explores alternatives for handling such temporal data.

Temporal Data Structures

Although many practitioners would find comfort in adopting an organization-wide standard method for handling temporal data, such an approach ...

Get Data Modeling, A Beginner's Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.