Chapter 12. Temporal Support in the Relational Model

Dejan Sarka

Databases that serve business applications should often support temporal data. For example, suppose a contract with a supplier is valid for a limited time only. It can be valid from a specific point in time onward, or it can be valid for a specific time interval—from a starting time point to an ending time point. However, I have heard many times that the relational model and relational databases can only support current data. In this chapter, I will show you that the relational model is ready for temporal data, and how to implement temporal support in Microsoft SQL Server 2008. By temporal support, I mean support for representing data with a limited validity time. I will call data ...

Get Inside Microsoft® SQL Server® 2008: T-SQL Programming now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.