Design and Implementation of a Temporal Extension of SQL

	This Article
	Subscribers, please Login Purchase article: $19 PDF RSS feed
	Share
	Email this Article to a friend
	Bibliographic References
	ASCII Text BibTex RefWorks Procite/RefMan/Endnote
	Add to:
	Digg Furl Spurl Blink Simpy Google Del.icio.us Y!MyWeb
	Search
	Similar Articles Articles by Cindy X. Chen Articles by Jiejun Kong Articles by Carlo Zaniolo

19th International Conference on Data Engineering (ICDE'03)

Bangalore, India

March 05-March 08

ISBN: 0-7803-7665-X

	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

DOI Bookmark: http://doi.ieeecomputersociety.org/10.1109/ICDE.2003.1260836

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

Peer Review Notice | Give Us Feedback

Usage of this product signifies your acceptance of the Terms of Use.