The Community for Technology Leaders
2013 IEEE 29th International Conference on Data Engineering (ICDE) (2003)
Bangalore, India
Mar. 5, 2003 to Mar. 8, 2003
ISSN: 1063-6382
ISBN: 0-7803-7665-X
pp: 689
Carlo Zaniolo , University of California at Los Angeles
Cindy X. Chen , University of Massachusetts at Lowell
Jiejun Kong , University of California at Los Angeles
ABSTRACT
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.
INDEX TERMS
null
CITATION
Carlo Zaniolo, Cindy X. Chen, Jiejun Kong, "Design and Implementation of a Temporal Extension of SQL", 2013 IEEE 29th International Conference on Data Engineering (ICDE), vol. 00, no. , pp. 689, 2003, doi:10.1109/ICDE.2003.1260836
94 ms
(Ver )