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 14

Database Design III : General Constraints

This chapter proposes a general framework for dealing with temporal database design questions. To be specific, it describes a set of requirements that apply to the design of the running example and (it’s claimed) can be used as a template for pinning down the requirements that apply to any temporal database. The chapter then shows how those requirements can be expressed in terms of formal integrity constraints for (a) a database consisting of current relvars only, (b) a database consisting of historical relvars only, and (c) a database consisting of a mixture of current and historical relvars. The chapter also offers some hope for automating the definitions of such constraints.

Keywords

“temporal” ...

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