Outer join elimination in the Teradata RDBMS

Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)

Volumn 3180, Issue , 2004, Pages 730-740

  Ghazal, Ahmad ^a   Crolotte, Alain ^a   Bhashyam, Ramesh ^a  

^a NCR CORPORATION   (United States)

Author keywords

[No Author keywords available]

Indexed keywords

DATABASE SYSTEMS; DECISION SUPPORT SYSTEMS; EXPERT SYSTEMS; QUERY PROCESSING; RELATIONAL DATABASE SYSTEMS;

DECISION SUPPORTS; ELIMINATION TECHNIQUES; OUTER JOINS; RELATIONAL DBMS; SQL QUERY; TPC-H BENCHMARKS; USER CONTROL; VERTICAL PARTITIONING;

BENCHMARKING;

EID: 35048857035     PISSN: 03029743     EISSN: 16113349     Source Type: Book Series    
DOI: 10.1007/978-3-540-30075-5_70     Document Type: Article

References (24)

1. U. Chakravarty, J.J. Grant and J Minker. Logic Based approach to semantic query optimization. ACM TODS, 15(2): 162-207, June 1990.
2. th VLDB, pages , September 1999.
3. César A. Galindo-Legaria, Arnon Rosenthal: How to Extend a Conventional Optimizer to Handle One- and Two-Sided Outer join. ICDE 1992:402-409
4. César A. Galindo-Legaria: Outerjoins as Disjunctions. SIGMOD Conference 1994: 348-358.
5. César A. Galindo-Legaria, Amon Rosenthal: Outerjoin Simplification and Reordering for Query Optimization. TODS 22(1): 43-73 (1997).
6. A. Ghazal and R, Bhashyam. Dynamic constraints derivation and maintenance in the Teradata RDBMS, DEXA 2001.
7. A. Ghazal, R. Bhashyam and A. Crolotte: Block Optimization in the Teradata RDBMS, DEXA 2003.
8. J. Gryz, L. Liu, and X. Qian. Semantic query optimization in DB2: Initial results. Technical Report CS-1999-01, Department of Computer Science, York University, Toronto, Canada, 1999.
9. L. M. Haas et al. Starbust Mid-Flight: As the dust clears. IEEE TKDE, pages 143-160, March 1990.
10. th VLDB, pages 137-147, October 1980.
11. M. Jarke, J. Clifford, and Y. Vassiliou. An optimizing PROLOG front end to a relational query system. SIGMOD, pages 296-306, 1984
12. M. Jarke, J. Koch, Query Optimization in Database Systems. ACM Computing Surveys 16(1984), 111-152
13. th VLDB, pages 510-517, September 1981.
14. G. Paulley and P. Larson. Exploiting uniqueness in query optimization. In Proceeding of ICDE, pages 68-79, 1994.
15. H. Pirahesh, J.M. Hellerstein, and W. Hasan. Extensible/rule based query rewrite optimization in Starbust. In Proc. Sigmod, pages 39-48, 1992.
16. H. Pirahesh, T Y. Leung, and W Hassan. A rule engine for query transformation in Starburst and IBM DB2 C/S DBMS. ICDE, pages: 391-400, 1997.
17. Jun Rao, Bruce G. Lindsay, Guy M. Lohman, Hamid Pirahesh, David E. Simmen: Using EELs, a Practical Approach to Outerjoin and Antijoin Reordering. ICDE 2001: 585-594.
18. Arnon Rosenthal, César A. Galindo-Legaria: Query Graphs, Implementing Trees, and Freely-Reorderable Outerjoins. SIGMOD Conference 1990: 291-299.
19. Arnon Rosenthal, David S. Reiner: Extending the Algebraic Framework of Query Processing to Handle Outerjoins. VLDB 1984: 334-343.
20. S.T. Shenoy and Z.M. Ozsoyoglu. Design and implementation of a semantic query optimizer. IEEE transactions on Knowledge and data Engineering, Sep 1989 1(3) 344-361
21. S.T. Shenoy and Z Meral Ozsolyoglu. A System for Semantic Query Optimization. Proceedings of the ACM SIGMOD Annual Conference on Management of data 1987, 181-195.
22. M. Siegel, E. Scorie and S. Salveter. A method for automatic rule derivation to support semantic query optimization. ACM TODS, 17(4):563-600, December 1992.
23. th ACM SIGACT-SIGMOD-SIGART symposium on Principles of database systems, 1998, 3443
24. TPC-H specification - Transaction Performance Council www.tpc.org