Extending the relational algebra to support transaction time

  • Authors:
  • Edwin McKenzie;Richard Snodgrass

  • Affiliations:
  • Univ. of North Carolina, Chapel Hill;Univ. of North Carolina, Chapel Hill

  • Venue:
  • SIGMOD '87 Proceedings of the 1987 ACM SIGMOD international conference on Management of data
  • Year:
  • 1987

Quantified Score

Hi-index 0.00

Visualization

Abstract

In this paper we discuss extensions to the conventional relational algebra to support transaction time. We show that these extensions are applicable to historical algebras that support valid time, yielding a temporal algebraic language. Since transaction time concerns the storage of information in the database, the notion of state is central. The extensions are formalized using denotational semantics. The additions preserve the useful properties of the conventional relational algebra.