Exploiting interactions among query rewrite rules in the teradata DBMS

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

Volumn 5181 LNCS, Issue , 2008, Pages 596-609

  Ghazal, Ahmad ^a   Seid, Dawit ^a   Crolotte, Alain ^a   McKenna, Bill ^a  

^a TERADATA CORPORATION   (United States)

Author keywords

[No Author keywords available]

Indexed keywords

ALGEBRAIC TRANSFORMATIONS; EXPERIMENTAL STUDIES; INTERNATIONAL CONFERENCES; QUERY OPTIMIZATION; REWRITE RULES; SIGNIFICANT REDUCTION; SQL QUERIES; TRANSITIVE CLOSURES; TRIGGERING MECHANISM;

ADMINISTRATIVE DATA PROCESSING; ARTIFICIAL INTELLIGENCE; CODES (SYMBOLS); COST REDUCTION; DECISION SUPPORT SYSTEMS; EXPERT SYSTEMS; FLOW INTERACTIONS; LAWS AND LEGISLATION; MANAGEMENT INFORMATION SYSTEMS; OPTIMIZATION;

DATABASE SYSTEMS;

EID: 53049093958     PISSN: 03029743     EISSN: 16113349     Source Type: Book Series    
DOI: 10.1007/978-3-540-85654-2_50     Document Type: Conference Paper

References (17)

1. Pirahesh, H., Hellerstein, J.M., Hasan. W.: Extensible/rule Based Query Rewrite Optimization in Starburst. SIGMOD, 39-48 (1992)
2. Pirahesh, H., Cliff Leung, T.Y., Hasan, W.: A Rule Engine for Query Transformation in Starburst and IBM DB2 C/S DBMS. In: ICDE, pp. 391-400 (1997)
3. Graefe, G., McKenna, W.J.: The Volcano Optimizer Generator: Extensibility and Efficient Search. In: ICDE. pp. 209-218 (1993)
4. Graefe, G.: The Cascade Framework for Query Optimization. IEEE Data Engineering Bulletin 18(3), 19-29 (1995)
5. Graefe, C., Dewitt, D.J.: The Exodus Optimizer Generator. SIGMOD, 160-172 (1987)
6. Cherniack, M., Zdonik, S.: Changing the Rules: Transformations for Rule-based Optimizers. SIGMOD, 61-72 (1998)
7. Warshaw, L.B., Miranker, D.P.: Rule-based Query Optimization. Revisited. In: CIKM, pp. 267-275 (1999)
8. Popa, L., Deutsch, A., Sahuguet, A., Tannen. V.: A Chase Too Far? In: SIGMOD, pp. 273-284 (2000)
9. Haas, L.M., Kossmann, D., Wimmers, E.L., Yang, J.: Optimizing Queries Across Diverse Data Sources. In: VLDB. pp. 276-285 (1997)
10. Ghazal, A., Bhashyam, R., Crolotte, A.: Block Optimization in the Teradata RDBMS. In: Mařík, V., Štěpá nková, O., Retschitzegger, W. (eds.) DEXA 2003. LNCS, vol. 2736, pp. 782-791. Springer, Heidelberg (2003)
11. Ghazal, A., Crolotte, A., Bhashyam, R.: Dynamic Constraints Derivation and Maintenance in the Teradata RDBMS. In: Mayr, H.C., Lazanský, J., Quirchmayr, G., Vogel, P. (eds.) DEXA 2001. LNCS, vol. 2113, pp. 390-399. Springer, Heidelberg (2001)
12. Ahmed, R., Lee, A., Witkowski, A.: Cost-Based Query Transformation in Oracle. In: VLDB. pp. 1026-1036 (2007)
13. Elhemali, M., Galindo-Legaria, C.A., Grabs, T., Joshi, M.M.: Execution Strategies for-SQL Subqueries. In: SIGMOD, pp. 993-1003 (2007)
14. Brownston, L., Farrell, R., Kant, E., Martin, N.: Programming Expert Systems in OPS5: An Introduction to Rule-based Programming. Addison-Wesley, Reading (1985)
15. Levy, A.Y., Mumick, I., Sagiv, Y.: Query Optimization by Predicate Move-around. In: VLDB, pp. 96-108 (1994)
16. TPC-H specification-Transaction Performance Council, http://www.tpc.org
17. Aiken, A., Widon, J., Hellerstein, J.M.: Behavior of Database Production Rules: Termination, Confluence, and Observable Determinism. In: SIGMOD, pp. 59-68 (1992)