Mar. 5, 2003 to Mar. 8, 2003
Cindy X. Chen , University of Massachusetts at Lowell
Jiejun Kong , University of California at Los Angeles
Carlo Zaniolo , University of California at Los Angeles
We present a valid-time extension of SQL and investigate its efficient implementation on an Object-Relational database system. We propose an approach where temporal queries are expressed using a point-based time model, which only requires minimal extensions to SQL:1999. Our prototype system called TENORS (for Temporal ENhanced Object-Relational System) maps the external point-based temporal queries and data model into equivalent internal representations based on time intervals. We describe the mapping of queries from external views to internal relations, and the temporal clustering and indexing methods used to support these queries on DB2.
Cindy X. Chen, Jiejun Kong, Carlo Zaniolo, "Design and Implementation of a Temporal Extension of SQL", ICDE, 2003, 2013 IEEE 29th International Conference on Data Engineering (ICDE), 2013 IEEE 29th International Conference on Data Engineering (ICDE) 2003, pp. 689, doi:10.1109/ICDE.2003.1260836