ICCI 1990: Advances in Computing and Information — ICCI '90 pp 295-303 | Cite as
Semantic query optimization in distributed databases
Abstract
In this paper, semantic query optimization in distributed database systems is translated into a multilevel search process. The overall search process is decomposed in two main stages: (1) guided by the syntactic complexity of a query expression, search for an appropriate optimization strategy, (2) given this strategy, transform the query expression into an efficient distributed query evaluation plan. During the second stage, properties of the application being modeled are used to attack a number of problems: detecting inconsistent and redundant selection and join conditions, estimating intermediate and final results, defining and using fragmentation knowledge. An extensible knowledge-based architecture is described to accommodate a variety of existing and future optimization techniques.
Keywords
State Constraint Algebraic Expression Query Optimization Syntactic Complexity Syntactic PropertyPreview
Unable to display preview. Download preview PDF.
References
- [Ceri 84]S. Ceri and G. Pelagatti, Distributed Databases: Principles and Systems, McGraw-Hill, Inc., New York, (1984).Google Scholar
- [Chak 88]U.S. Chakravarthy, J. Grant, and J. Minker, “Foundations of Semantic Query Optimizations for Deductive Databases,” Foundations of Deductive Databases and Logic Programming, pp. 243–273, Morgan-Kaufman, Los Altos, California, (1988)Google Scholar
- [Frey 87]J.C. Freytag, “A Rule-Based View of Query Optimization,” Proceedings of the ACM-SIGMOD Conference, pp. 172–180, (1987).Google Scholar
- [Grae 89]G. Graefe, “Research Problems in Database Query Optimization,” Proceedings of the ODBF Workshop on Database Query Optimization, pp. 1–11, May, (1989).Google Scholar
- [Hamm 80]M. Hammer and S.B. Zdonik, “Knowledge-Based Query Processing,” Proceedings of the 6 th International Conference on Very Large Databases, pp. 137–146, (1980).Google Scholar
- [Hevn 79]A.R. Hevner, “The Optimization of Query Processing on Distributed Database Systems,” PhD Thesis, Purdue University, (1979).Google Scholar
- [King 81]J.J. King, “QUIST: A System for Semantic Query Optimization in Relational Databases,” Proceedings of the 7 th International Conference on Very Large Databases, pp. 510–517, (1981).Google Scholar
- [Kuijk 88]H.J.A. van Kuijk and P.M.G. Apers, “The application of Constraints in Query Optimization,” Internal Report INF 88-55, University of Twente.Google Scholar
- [Kuijk 89]H.J.A. van Kuijk and P.M.G. Apers, “Semantic Query Optimization in Distributed Database: A Knowledge-Based Approach,” Proceedings of the ODBF Workshop on Database Query Optimization, pp. 53–58, May, (1989).Google Scholar
- [Morg 84]M. Morgenstern, “The Role of Constraints in Databases, Expert Systems, and Knowledge Representation,” Proceedings of the 1 st International Workshop on Expert Database Systems, pp. 207–223, (1984).Google Scholar
- [Osbo 88]S. Osborn, “Identity, Equality, and Query Optimization,” Advances in Object-Oriented Database Systems, pp. 346–351, Springer-Verlag, New York, (1988).Google Scholar
- [Pearl 84]J. Pearl, Heuristics: Intelligent Search Strategies for Computer Problem Solving, Addison-Wesley, Inc., Reading, Massachusetts, (1984).Google Scholar
- [Shek 88]S. Shekhar, J. Srivastava, and S. Dutta, “A Formal Model of Trade-off between Optimization and Execution Costs in Semantic Query Optimization,” Proceedings of the 14 th International Conference on Very Large Databases, pp. 457–467, (1988).Google Scholar
- [Shen 87]S.T. Shenoy and Z.M. Ozsoyoglu, “A System for Semantic Query Optimization,” Proceedings of the ACM-SIGMOD Conference, pp. 181–195, (1987).Google Scholar