O'Reilly logo

Time and Relational Theory by Nikos Lorentzos, Hugh Darwen, C.J. Date

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 17

Logged Time and Stated Time

This chapter takes a much closer look at two concepts originally introduced in Chapter 4, viz., “valid time” and “transaction time.” Valid time has to do with when we believe (explicitly or implicitly) that some proposition is, was, or will be true. Transaction time has to do with when the database said (explicitly or implicitly) that we believe (again, explicitly or implicitly) that some proposition is, was, or will be true. Valid times are maintained—at least in a relational system—just like any other kind of data; in particular, they’re updatable just like any other kind of data. By contrast, transaction times are maintained by the system; in particular, therefore, they’re read-only (at least from the ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required