Nested bitemporal relational algebra

  • Authors:
  • Abdullah Uz Tansel;Canan Eren Atay

  • Affiliations:
  • Baruch College & Graduate Center, CUNY, New York, NY;Department of Computer Science, Dokuz Eylul University, Izmir, Turkey

  • Venue:
  • ISCIS'06 Proceedings of the 21st international conference on Computer and Information Sciences
  • Year:
  • 2006

Quantified Score

Hi-index 0.00

Visualization

Abstract

We introduce a nested bitemporal relational data model that allows arbitrary levels of nesting. Bitemporal data is attached to attributes. The fundamental construct for representing temporal data is a bitemporal atom that consists of three parts: transaction time, valid time and a value. We have defined algebra for the nested bitemporal relational model. The algebra includes operations to manipulate bitemporal data, to restructure nested bitemporal relations and to rollback database to a designated state in the past. We have also defined the concept of ‘context' for using temporal data. Bitemporal context is for auditing purposes and rollback context is for querying past states of a bitemporal database.