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 16

Updates

Like queries, updates too have the potential to be quite complicated in the temporal context. The chapter begins by considering updates on a database consisting of current relvars only (a comparatively straightforward case). It then considers databases consisting of historical relvars only; these investigations lead to a discussion of “U_updates,” PORTION specifications, and the need for a multiple form of assignment. It then considers databases containing both kinds of relvars. The chapter also discusses the possibility of using automatically defined views to simplify the formulation of such updates.

Keywords

“temporal” update; PORTION; multiple assignment; current relvar; historical relvar; automated view

Change is inevitable ...

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