Advertisement

Semantic query optimization in distributed databases

  • H. J. A. van Kuijk
  • F. H. E. Pijpers
  • P. M. G. Apers
Data And Software Engineering
Part of the Lecture Notes in Computer Science book series (LNCS, volume 468)

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 Property 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. [Ceri 84]
    S. Ceri and G. Pelagatti, Distributed Databases: Principles and Systems, McGraw-Hill, Inc., New York, (1984).Google Scholar
  2. [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
  3. [Frey 87]
    J.C. Freytag, “A Rule-Based View of Query Optimization,” Proceedings of the ACM-SIGMOD Conference, pp. 172–180, (1987).Google Scholar
  4. [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
  5. [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
  6. [Hevn 79]
    A.R. Hevner, “The Optimization of Query Processing on Distributed Database Systems,” PhD Thesis, Purdue University, (1979).Google Scholar
  7. [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
  8. [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
  9. [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
  10. [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
  11. [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
  12. [Pearl 84]
    J. Pearl, Heuristics: Intelligent Search Strategies for Computer Problem Solving, Addison-Wesley, Inc., Reading, Massachusetts, (1984).Google Scholar
  13. [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
  14. [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

Copyright information

© Springer-Verlag Berlin Heidelberg 1991

Authors and Affiliations

  • H. J. A. van Kuijk
    • 1
  • F. H. E. Pijpers
    • 1
  • P. M. G. Apers
    • 1
  1. 1.University of TwenteEnschedeThe Netherlands

Personalised recommendations