DIC FILE COPY . Supporting Valid Time : An Historical Algebra August 1987 0

-We define an historical algebra for historical relations. This historical algebra, a straightforward extension of the conventional relational algebra, supports valid time, the time when an object or relationship in the enterprise being modeled is valid. Historical versions of the five relational operators union, difference, cartesian product, selection, and projection are defined and a new operator, historical derivation, is introduced. The algebra includes aggregates and is shown to have the expressive power of the temporal query language TQuel. The algebra is consistent with the user-oriented model of historical 4 relations as space-filling objects and satisfies all but one of the associative, commutative, and distributive tautologies involving union, difference, and cartesian product. .7 -. , ,,, 5 ' . ' ' ,