Skip to main content
Log in

A study of optimization and Rule/Goal Graph for a logical query

  • Regular Papers
  • Published:
Journal of Computer Science and Technology Aims and scope Submit manuscript

Abstract

Static optimization of logical queries is, in substance, to move selections down as far as possible in evaluating logical queries. This paper extends Ullman's RGG (Rule/Goal Graph)[6] and introduces P-graph, with which a wide range of recursive logical queries can be statically optimized top-down and evaluated bottom-up, some of which are usually optimized by dynamic approaches. The paper also shows that for some logical queries the complexity of pushing selections down and computing bottom-up is related to the complexity of base relation in the queries.

This is a preview of subscription content, log in via an institution to check access.

Access this article

Price excludes VAT (USA)
Tax calculation will be finalised during checkout.

Instant access to the full article PDF.

Similar content being viewed by others

References

  1. Agawal R. and Devonbu, Moving selections into linear fixpoint queries. IEEE Proc. 4th Int. Conf. Data Engineering Los Angeles, 1988, 452–461.

  2. Aho A. V. and Ullman J. D., Universality of data retrieval languages. Proc. 6th ACM Symp. Principle of Programming Languages, 1979, 110–120.

  3. Bancilhon F. and Ramakrishman R., An amateur's introduction to recursive query processing strategies. InA Reading in Database Systems, Ed. by M. Stonebraker, 1988.

  4. Gallaire H. and Minker J., Logic and Database. 1978.

  5. Kifer M. and Lozinskii E. L., SYGRAF: Implementing logic programs in a database style.IEEE Trans. on Software Engineering, 1988, 14(7).

  6. Ullman J. D., Implementation of logical query languages for database.ACMTODS, 1985, 10 (3), 289–321.

    MATH  Google Scholar 

  7. Ullman J. D., Principle of Database Systems. 2nd edition, Computer Science Press, 1982.

  8. Ullman J. D., Parinciple of Database System and Knowledge Base System. Vol. II. Computer Science Press, 1989.

  9. Guntzer U. and Bayer W. K. A. R., On evaluation of recursions in deductive database systems by differential fixpoint iteration. IEEE Proc. 3rd Int. Conf. Data Engineering, 1987, 120–129.

Download references

Author information

Authors and Affiliations

Authors

Rights and permissions

Reprints and permissions

About this article

Cite this article

Li, T. A study of optimization and Rule/Goal Graph for a logical query. J. of Comput. Sci. & Technol. 7, 356–362 (1992). https://doi.org/10.1007/BF02943552

Download citation

  • Received:

  • Issue Date:

  • DOI: https://doi.org/10.1007/BF02943552

Keywords

Navigation