loading...
Design and Implementation of a Temporal Extension of SQL
Bangalore, India March 05-March 08
DOI Bookmark: http://doi.ieeecomputersociety.org/10.1109/ICDE.2003.126083619th International Conference on Data ...
 This Article 
 
Buy PURCHASE ARTICLE: $19
PDF
HTML
IEEE Xplore Subscribers
 
 Share 
   
 Bibliographic References 
   
 Add to: 
 
Digg
Furl
Spurl
Blink
Simpy
Google
Del.icio.us
Y!MyWeb
 
 Search 
   
ASCII Text
x 
 
Cindy X. Chen, Jiejun Kong, Carlo Zaniolo, "Design and Implementation of a Temporal Extension of SQL," Data Engineering, International Conference on, pp. 689, 19th International Conference on Data Engineering (ICDE'03), 2003.
 
 
BibTex
x
 
@article{ 10.1109/ICDE.2003.1260836,
author = {Cindy X. Chen and Jiejun Kong and Carlo Zaniolo},
title = {Design and Implementation of a Temporal Extension of SQL},
journal ={Data Engineering, International Conference on},
volume = {0},
year = {2003},
issn = {1063-6382},
pages = {689},
doi = {http://doi.ieeecomputersociety.org/10.1109/ICDE.2003.1260836},
publisher = {IEEE Computer Society},
address = {Los Alamitos, CA, USA},
}
 
 
RefWorks Procite/RefMan/Endnote
x 
 
TY - CONF
JO - Data Engineering, International Conference on
TI - Design and Implementation of a Temporal Extension of SQL
SN - 1063-6382
SP
EP
A1 - Cindy X. Chen,
A1 - Jiejun Kong,
A1 - Carlo Zaniolo,
PY - 2003
KW - null
VL - 0
JA - Data Engineering, International Conference on
ER -
 
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.
Citation:
Cindy X. Chen, Jiejun Kong, Carlo Zaniolo, "Design and Implementation of a Temporal Extension of SQL," icde, pp.689, 19th International Conference on Data Engineering (ICDE'03), 2003
Usage of this product signifies your acceptance of the Terms of Use.