Dynamic constraints derivation and maintenance in the teradata RDBMS

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

Volumn 2113, Issue , 2001, Pages 390-399

  Ghazal, Ahmad ^a   Bhashyam, Ramesh ^a  

^a NCR CORPORATION   (United States)

Author keywords

[No Author keywords available]

Indexed keywords

EXPERT SYSTEMS; QUERY LANGUAGES;

DATABASE ENGINE; DYNAMIC CONSTRAINTS; OPTIMAL PLAN; PROTOTYPE IMPLEMENTATIONS; QUANTITATIVE MEASURES; QUERY OPTIMIZER; REFERENTIAL INTEGRITY CONSTRAINTS; TPC-H QUERIES;

QUERY PROCESSING;

EID: 84949461815     PISSN: 03029743     EISSN: 16113349     Source Type: Book Series    
DOI: 10.1007/3-540-44759-8_39     Document Type: Conference Paper

References (20)

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. J. J. King. Quist: A system for semantic query optimization in relational databases. Proc. 7th VLDB, pages 510-517, September 1981.
3. Transaction Processing Performance Council, 777 No. First Street, Suite 600, San Jose, CA 95112-6311, TPC-H BenchmarkTM, 1.2.1
4. H. Pirahesh, J. M. Hellerstein, and W. Hasan. Extensible/rule based query rewrite optimization in Starbust. In Proc. Sigmod, pages 39-48, 1992.
5. Qi Cheng, Jack Gryz, Fred Koo, et al. Implementation of two semantic query optimization techniques in DB2 Universal Database. Proc. 25th VLDB, pages, September 1999.
6. 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.
7. Sreekumar 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.
8. Surajit Chaudhuri, An overview of query optimization in relational systems. Proceedings of the 17th ACM SIGACT-SIGMOD-SIGART symposium on Principles of database systems, 1998, 34-43.
9. M. Jarke, J. Koch, Query Optimization in Database Systems. ACM Computing Surveys 16 (1984), 111-152
10. I.S. Mumick, S.J. Finkestein, H. Pirahesh, R. Ramakrishnan. Magic Conditions. ACM Transactions Database Systems Mar 1996, 107-155
11. I.S. Mumick, S.J. Finkestein, H. Pirahesh, R. Ramakrishnan. Magic Is Relevant. ACM SIGMOD International Conference on Management of data May 23-26, 1990 247-258
12. Yan W. P., Larson P. A., “Performing Group-By before Join”, International Conference on Data Engineering, Feb. 1993, Houston.
13. G.D. Xu. Search Control in Semantic Query Optimization. Tech. Rep, Dept of Computer Science, Univ. of Mass, Amherst, 1983
14. 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.
15. M. T. Hammer and S. B. Zdonik. Knowledge based query processing. Proc. 6th VLDB, pages 137-147, October 1980.
16. M. Jarke, J. Clifford, and Y. Vassiliou. An optimizing PROLOG front end to a relational query system. SIGMOD, pages 296-306, 1984.
17. A. Y. Levy, I. Mumick, and Y. Sagiv. Query optimization by predicate move-around. In Proc. Of VLDB, pages 96-108, 1994.
18. 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.
19. S. Shekar, J. Srivistava and S. Dutta, A formal model of trade-off between optimization and execution costs in semantic query optimization. Proc. 14th VLDB, pages: 457-467, Los Angeles, 1988.
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