Abstract
A branch- and-bound type algorithm is developed to optimize the evaluation of a set of expressions. The algorithm proceeds in a depth-first manner and achieves an optimal solution. The algorithm is applied to optimize the evaluation of sets of relational expressions. Analogies to the heuristic information associated with theA* algorithm are investigated. Examples are presented illustrating the use of the algorithm. Pragmatics associated with the algorithm and its application to Boolean optimization are also discussed.
Similar content being viewed by others
References
J. Grant and J. Minker, “On Optimizing the Evaluation of a Set of Expressions,” Technical Report (revised), Department of Computer Science, University of Maryland (1980).
J. Grant and J. Minker, “Optimization in Deductive and Conventional Relational Database Systems,” inAdvances in Database Theory Volume I, 195–234, Edited by H. Gallaire, J. Minker, and J. -M. Nicolas (Plenum Press, New York, 1981).
L. R. Harris, “The Heuristic Search Under Conditions of Error,”Artificial Intelligence 5:217–234 (1974).
N. J. Nilsson,Principles of Artificial Intelligence (Tioga Publishing Co., Palo Alto, CA, 1980).
E. M. Reingold, J. Nievergelt, and N. Deo,Combinatorial Algorithms: Theory and Practice (Prentice-Hall, Englewood-Cliffs, NJ., 1977).
P. G. Selinger et al., “Access Path Selection in a Relational Database Management System,”Proceedings of ACM-SIGMOD Conference (Boston, MA, 1979), pp. 23–34.
J. D. Ullman,Principles of Database Systems (Computer Science Press, Potomac, MD, 1980).
Author information
Authors and Affiliations
Additional information
Research supported by the National Science Foundation under grant number NSF MCS 79-19418 and by the National Aeronautics and Space Administration under grant number NGR 21-002-270-9.
Rights and permissions
About this article
Cite this article
Grant, J., Minker, J. On optimizing the evaluation of a set of expressions. International Journal of Computer and Information Sciences 11, 179–191 (1982). https://doi.org/10.1007/BF00999727
Received:
Revised:
Issue Date:
DOI: https://doi.org/10.1007/BF00999727