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

Get Time and Relational Theory, 2nd Edition now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.