Historical Selection and Projection

Historical selection is the analogue of conventional selection: the identification of tuples that satisfy some specified predicate, in this case a predicate on the time(s) the data elements (attribute values or tuples) were valid. One design issue is whether the where clause in SQL should be extended, or whether a new clause, such as the when clause in TQuel, is preferred.

Historical projection is an analogue of conventional projection, where component(s) of tuples are retained, in this case, components of the time(s) the data elements were valid. One fundamental question is whether the derived intervals must be subsets of the underlying intervals. A second design issue is whether the target list in SQL should be extended, or whether a new clause, such as the valid clause in TQuel, is preferred. The subject of temporal joins, such as time intersection, time union, and temporal outer joins, also needs to be addressed here.