The Community for Technology Leaders
RSS Icon
Subscribe
Bangalore, India
Mar. 5, 2003 to Mar. 8, 2003
ISBN: 0-7803-7665-X
pp: 689
Cindy X. Chen , University of Massachusetts at Lowell
Jiejun Kong , University of California at Los Angeles
Carlo Zaniolo , 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
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
17 ms
(Ver 2.0)

Marketing Automation Platform Marketing Automation Tool