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.
Similar content being viewed by others
References
Agawal R. and Devonbu, Moving selections into linear fixpoint queries. IEEE Proc. 4th Int. Conf. Data Engineering Los Angeles, 1988, 452–461.
Aho A. V. and Ullman J. D., Universality of data retrieval languages. Proc. 6th ACM Symp. Principle of Programming Languages, 1979, 110–120.
Bancilhon F. and Ramakrishman R., An amateur's introduction to recursive query processing strategies. InA Reading in Database Systems, Ed. by M. Stonebraker, 1988.
Gallaire H. and Minker J., Logic and Database. 1978.
Kifer M. and Lozinskii E. L., SYGRAF: Implementing logic programs in a database style.IEEE Trans. on Software Engineering, 1988, 14(7).
Ullman J. D., Implementation of logical query languages for database.ACMTODS, 1985, 10 (3), 289–321.
Ullman J. D., Principle of Database Systems. 2nd edition, Computer Science Press, 1982.
Ullman J. D., Parinciple of Database System and Knowledge Base System. Vol. II. Computer Science Press, 1989.
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.
Author information
Authors and Affiliations
Rights 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
Received:
Issue Date:
DOI: https://doi.org/10.1007/BF02943552