Temporal Data and Relational Theory
Publisher: O'Reilly Media
Final Release Date: October 2013
Run time: 8 hours 50 minutes

Two recent trends—the plummeting cost of storage and the widespread adoption of data warehouse technology—have led to an increasing interest in temporal databases. Indeed, the idea of maintaining and processing historical data has become not just a goal but a reality for many organizations. As a consequence, the ability to deal properly with the time dimension in databases has become an increasingly important practical problem. And today’s mainstream DBMS products are (at last, some might say) beginning to include features that are specifically designed to help with this important requirement—though it has to be said too that the support currently found in those products falls a long way short of the theoretical ideal.

This video seminar describes and explains that theoretical ideal—which, interestingly, is 100% consistent with the classical relational model—in depth. It also describes the new temporal support to be found in the SQL standard (“SQL:2011”), as well as in certain of today’s major SQL products.

The seminar overall falls into four major parts:

  • Part I consists of a quick review of relevant aspects of the relational model.
  • Part II, “Laying the Foundations,” explains some of the basic problems of temporal databases (some of which are far from obvious, incidentally) and lays the groundwork for solving those problems.
  • Part III, “Building on the Foundations,” uses the material from Part II as a basis for addressing a variety of practical issues, including temporal database design, temporal integrity constraints, and temporal querying and updating.
  • Part IV examines the pertinent features of SQL:2011 and today’s SQL products.

The seminar is aimed primarily at technical specialists, though managers should benefit from it too (most of the technical material needed to understand the overall message is included in the seminar itself).

Table of Contents
Product Details
About the Author
Recommended for You
Customer Reviews


by PowerReviews
oreillyTemporal Data and Relational Theory

(based on 1 review)

Ratings Distribution

  • 5 Stars



  • 4 Stars



  • 3 Stars



  • 2 Stars



  • 1 Stars



Reviewed by 1 customer

Displaying review 1

Back to top


Excellent video about theory

By teak

from Jyväskylä, Finland

About Me Designer, Developer, Educator, Sys Admin

Verified Reviewer


  • Accurate
  • Easy to understand
  • Helpful examples
  • Well-written


  • Only Theory

Best Uses

  • Expert
  • Intermediate
  • Student

Comments about oreilly Temporal Data and Relational Theory:

The lectures are almost nine hours and they are full of material. The lecture series starts with quick freshener on relational theory it is followed by logical build up of theory to include any kind of interval data and time intervals in special. The last hour was about how this is (not) supported (properly) in SQL products.

I was hoping for more concrete solutions to implement temporal variables, but those were not promised on the description of the lectures, so I can't blame them for not including it. But there was a slight omission which I'm not happy about. These lectures were filmed live lectures and the participants received slides before and few slides were totally skipped. They could have been visible even for a second in order to us to see them.

The style was minimalistic (I like it that way) and the lecturer was clear speaker and all of the questions were repeated so that recording captured them as well.

Displaying review 1

Back to top

Buy 2 Get 1 Free Free Shipping Guarantee
Buying Options
Immediate Access - Go Digital what's this?
Video:  $179.99
(Streaming, Downloadable)
This item is not available.