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 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.
