Temporal query processing in Teradata

ACM International Conference Proceeding Series

Volumn , Issue , 2013, Pages 573-578

  Al Kateb, Mohammed ^a   Ghazal, Ahmad ^a   Crolotte, Alain ^a   Bhashyam, Ramesh ^a   Chimanchode, Jaiprakash ^a   Pakala, Sai Pavan ^a  

^a TERADATA CORPORATION   (United States)

Author keywords

temporal

Indexed keywords

COMMERCIAL DATABASE SYSTEM; IMPLEMENTATION APPROACH; PERFORMANCE STUDY; STRUCTURAL COMPLEXITY; TEMPORAL; TEMPORAL DATABASE; TEMPORAL FEATURES; TEMPORAL QUERIES;

BENCHMARKING; DATABASE SYSTEMS; INFORMATION MANAGEMENT;

QUERY PROCESSING;

EID: 84876784591     PISSN: None     EISSN: None     Source Type: Conference Proceeding    
DOI: 10.1145/2452376.2452443     Document Type: Conference Paper

References (16)

1. I. Ahn and R. Snodgrass. Performance evaluation of a temporal database management system. In SIGMOD, pages 96-107, 1986.
2. M. Al-Kateb, A. Crolotte, A. Ghazal, and L. Rose. Adding a temporal dimension to the TPC-H benchmark. In TPCTC, 2012.
3. M. Al-Kateb, A. Ghazal, and A. Crolotte. An efficient SQL rewrite approach for temporal coalescing in the teradata RDBMS. In DEXA, pages 375-383, 2012.
4. M. H. Böhlen, R. T. Snodgrass, and M. D. Soo. Coalescing in temporal databases. In VLDB, pages 180-191, 1996.
5. C. X. Chen, J. Kong, and C. Zaniolo. Design and implementation of a temporal extension of SQL. In ICDE, pages 689-691, 2003.
6. A. Ghazal, R. Bhashyam, and A. Crolotte. Block optimization in the teradata RDBMS. In DEXA, pages 782-791, 2003.
7. A. Ghazal, D. Y. Seid, A. Crolotte, and B. McKenna. Exploiting interactions among query rewrite rules in the teradata DBMS. In DEXA, pages 596-609, 2008.
8. IBM. Temporal data management in DB2 for z/OS: http://www.ibm.com/ developerworks/data/library/techarticle/dm-1204db2temporaldata/.
9. K. Kulkarni and J.-E. Michels. Temporal features in SQL:2011. SIGMOD Rec., 41(3):34-43, Oct. 2012.
10. D. B. Lomet and F. Li. Improving transaction-time DBMS performance and functionality. In ICDE, pages 581-591, 2009.
11. R. Mata-Toledo and M. Monger. Implementing a temporal data management system within Oracle. J. Comput. Sci. Coll., 23(3):76-81, Jan. 2008.
12. Oracle. Oracle flashback technologies: http://www.oracle.com/technetwork/ database/features/availability/flashback-overview-082751.html.
13. R. T. Snodgrass, editor. The TSQL2 Temporal Query Language. Kluwer, 1995.
14. R. T. Snodgrass. Developing Time-Oriented Database Applications in SQL. Morgan Kaufmann, 1999.
15. Teradata. Teradata temporal analytics www.teradata.com/database/teradata- temporal/.
16. TPC. TPC-H benchmark: http://www.tpc.org/tpch/spec/tpch2.14.4.pdf.