Article

Free access

TIP: a temporal extension to Informix

Authors:

Jun Yang,

Huacheng C. Ying,

Jennifer WidomAuthors Info & Claims

SIGMOD '00: Proceedings of the 2000 ACM SIGMOD international conference on Management of data

Page 596

https://doi.org/10.1145/342009.336578

Published: 16 May 2000 Publication History

PDF eReader

Abstract

Commercial relational database systems today provide only limited temporal support. To address the needs of applications requiring rich temporal data and queries, we have built TIP (Temporal Information Processor), a temporal extension to the Informix database system based on its DataBlade technology. Our TIP DataBlade extends Informix with a rich set of datatypes and routines that facilitate temporal modeling and querying. TIP provides both C and Java libraries for client applications to access a TIP-enabled database, and provides end-users with a GUI interface for querying and browsing temporal data.

References

[1]

J. F. Allen. Maintaining knowledge about temporal intervals. Communications of the ACM, 26(11):832-843, November 1983.]]

Digital Library

Google Scholar

[2]

R. Bliujute, S. Saltenis, G. Slivinskas, and C. S. Jensen. Developing a DataBlade for a new index. In Proc. of the 1999 Intl. Conf. on Data Engineering, pages 314-323, Sydney, Austrialia, March 1999.]]

Digital Library

Google Scholar

[3]

M. H. B6hlen. Temporal database system implementations. SIGMOD Record, 24(4):53-60, December 1995.]]

Digital Library

Google Scholar

[4]

M. H. B6hlen, R. T. Snodgrass, and M. D. Soo. Coalescing in temporal databases. In Proc. of the 1996 Intl. Conf. on Very Large Data Bases, pages 180-191, Bombay, India, September 1996.]]

Digital Library

Google Scholar

[5]

J. Clifford, C. E. Dyreson, T. Isakowitz, C. S. Jensen, and R. T. Snodgrass. On the semantics of "NOW" in databases. ACM Trans. on Database Systems, 22(2): 171-214, June 1997.]]

Digital Library

Google Scholar

[6]

I. Goralwalla, M. T. Ozsu, and D. Szafron. An object-oriented framework for temporal data models. In O. Etzion, S. Jajodia, and S. M. Sripada, editors, Temporal Databases: Research and Practice, pages 1-35. Springer-Verlag, Berlin/Heidelberg, Germany, 1998.]]

Crossref

Google Scholar

[7]

R. T. Snodgrass, editor. The TSQL2 Temporal Query Language. Kluwer Academic Publishers, Boston, Massachusetts, 1995.]]

Digital Library

Google Scholar

[8]

TimeCenter homepage, http://www, cs. auc. dk/research/DP/tdb/TimeCenter/.]]

Google Scholar

[9]

J. Yang and J. Widom. Maintaining temporal views over non-temporal information sources for data warehousing. In Proc. of the 1998 Intl. Conf. on Extending Database Technology, pages 389-403, Valencia, Spain, March 1998.]]

Digital Library

Google Scholar

[10]

J. Yang and J. Widom. Temporal view self-maintenance in a warehousing environment. In Proc. of the 2000 Intl. Conf. on Extending Database Technology, Konstanz, Germany, March 2000. To appear.]]

Digital Library

Google Scholar

Cited By

View all

Torp K(2009)Temporal StrataEncyclopedia of Database Systems10.1007/978-0-387-39940-9_409(3018-3023)Online publication date: 2009
https://doi.org/10.1007/978-0-387-39940-9_409
Noh SGadia SMa S(2008)An XML-based methodology for parametric temporal database model implementationJournal of Systems and Software10.1016/j.jss.2007.08.01881:6(929-948)Online publication date: 1-Jun-2008
https://dl.acm.org/doi/10.1016/j.jss.2007.08.018
Ngoc Chau VChittayasothorn S(2007)A temporal compatible object relational database systemProceedings 2007 IEEE SoutheastCon10.1109/SECON.2007.342862(93-98)Online publication date: Mar-2007
https://doi.org/10.1109/SECON.2007.342862
Show More Cited By

Index Terms

TIP: a temporal extension to Informix
1. Information systems
  1. Information retrieval
  2. Information systems applications

Recommendations

TIP: a temporal extension to Informix

Commercial relational database systems today provide only limited temporal support. To address the needs of applications requiring rich temporal data and queries, we have built TIP (Temporal Information Processor), a temporal extension to the Informix ...
Sql: Learn Basics of Queries and Implement Easily (sql programming, SQL 2016, sql database programming, sql for beginners, sql beginners guide, sql ... sql workbook, sql guide, MSSQL) (Volume 1)
Oracle High-Performance SQL Tuning

Comments

Information & Contributors

Information

Published In

SIGMOD '00: Proceedings of the 2000 ACM SIGMOD international conference on Management of data

May 2000

604 pages

ISBN:1581132174

DOI:10.1145/342009

Chairmen:
Maggie Dunham
Southern Methodist Univ.
,
Jeffrey F. Naughton
Univ. of Wisconsin-Madison
,
Weidong Chen
Southern Methodist Univ.
,
Nick Koudas
AT &T Labs

ACM SIGMOD Record Volume 29, Issue 2
June 2000
609 pages
ISSN:0163-5808
DOI:10.1145/335191
Editors:
Weidong Chen
Southern Methodist Univ., Dallas, TX
,
Jeffrey Naughton
Univ. of Wisconsin-Madison, Madison
,
Philip A. Bernstein
Microsoft
Issue’s Table of Contents

Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 16 May 2000

Permissions

Request permissions for this article.

Request Permissions

Check for updates

Qualifiers

Article

Conference

SIGMOD/PODS00

Sponsor:

SIGMOD

SIGMOD/PODS00: ACM International Conference on Management of Data and Symposium on Principles of Database Systems

May 15 - 18, 2000

Texas, Dallas, USA

Acceptance Rates

SIGMOD '00 Paper Acceptance Rate 42 of 248 submissions, 17%;

Overall Acceptance Rate 785 of 4,003 submissions, 20%

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

10
Total Citations
View Citations
87
Total Downloads

Downloads (Last 12 months)46
Downloads (Last 6 weeks)13

Reflects downloads up to 01 Sep 2024

Other Metrics

View Author Metrics

Citations

Cited By

View all

Torp K(2009)Temporal StrataEncyclopedia of Database Systems10.1007/978-0-387-39940-9_409(3018-3023)Online publication date: 2009
https://doi.org/10.1007/978-0-387-39940-9_409
Noh SGadia SMa S(2008)An XML-based methodology for parametric temporal database model implementationJournal of Systems and Software10.1016/j.jss.2007.08.01881:6(929-948)Online publication date: 1-Jun-2008
https://dl.acm.org/doi/10.1016/j.jss.2007.08.018
Ngoc Chau VChittayasothorn S(2007)A temporal compatible object relational database systemProceedings 2007 IEEE SoutheastCon10.1109/SECON.2007.342862(93-98)Online publication date: Mar-2007
https://doi.org/10.1109/SECON.2007.342862
Noh SGadia S(2006)A comparison of two approaches to utilizing XML in parametric databases for temporal dataInformation and Software Technology10.1016/j.infsof.2005.10.00248:9(807-819)Online publication date: Sep-2006
https://doi.org/10.1016/j.infsof.2005.10.002
Kleiner CLipeck U(2002)Performance of querying temporal attributes in object-relational databasesProceedings Ninth International Symposium on Temporal Representation and Reasoning10.1109/TIME.2002.1027475(58-60)Online publication date: 2002
https://doi.org/10.1109/TIME.2002.1027475
Slivinskas GJensen CSnodgrass R(2001)Adaptable query optimization and evaluation in temporal middlewareACM SIGMOD Record10.1145/376284.37567830:2(127-138)Online publication date: 1-May-2001
https://dl.acm.org/doi/10.1145/376284.375678
Slivinskas GJensen CSnodgrass R(2001)Adaptable query optimization and evaluation in temporal middlewareProceedings of the 2001 ACM SIGMOD international conference on Management of data10.1145/375663.375678(127-138)Online publication date: 1-May-2001
https://dl.acm.org/doi/10.1145/375663.375678
Slivinskas GJensen CSnodgrass R(2001)A Foundation for Conventional and Temporal Query Optimization Addressing Duplicates and OrderingIEEE Transactions on Knowledge and Data Engineering10.1109/69.90897913:1(21-49)Online publication date: 1-Jan-2001
https://dl.acm.org/doi/10.1109/69.908979
Chau VChittayasothorn S(2008)A temporal object relational SQL language with attribute timestamping in a temporal transparency environmentData & Knowledge Engineering10.1016/j.datak.2008.06.00867:3(331-361)Online publication date: 1-Dec-2008
https://dl.acm.org/doi/10.1016/j.datak.2008.06.008
Slivinskas GJensen CSnodgrass R(2001)A Foundation for Conventional and Temporal Query Optimization Addressing Duplicates and OrderingIEEE Transactions on Knowledge and Data Engineering10.1109/69.90897913:1(21-49)Online publication date: 1-Jan-2001
https://dl.acm.org/doi/10.1109/69.908979

View Options

View options

PDF

View or Download as a PDF file.

PDF

eReader

View online with eReader.

eReader

Get Access

Login options

Check if you have access through your login credentials or your institution to get full access on this article.

Cited By

Index Terms

Recommendations

TIP: a temporal extension to Informix

Sql: Learn Basics of Queries and Implement Easily (sql programming, SQL 2016, sql database programming, sql for beginners, sql beginners guide, sql ... sql workbook, sql guide, MSSQL) (Volume 1)

Oracle High-Performance SQL Tuning