Issue No. 03 - March (1991 vol. 17)
DOI Bookmark: http://doi.ieeecomputersociety.org/10.1109/32.75418
<p>The performances of several algorithms suitable for processing an important class of recursive queries called the instantiated transitive closure (TC) queries are studied and compared. These algorithms are the wavefront, delta -wavefront, and a generic algorithm called super-TC. During the evaluation of a TC query, the first two algorithms may read a given disk page more than once, whereas super-TC reads the disk page at most once. A comprehensive performance evaluation of these three algorithms using rigorous analytical and simulation models is presented. The study reveals that the relative performance of the algorithms is a strong function of the parameters which characterize the processed TC query and the relation referenced by that query. The superiority of one of the super-TC variants over all of the other presented algorithms is shown.</p>
database theory; instantiated transitive closure queries; recursive queries; wavefront; delta -wavefront; generic algorithm; super-TC; disk page; performance evaluation; processed TC query; database theory; performance evaluation; query languages
J. Kim, L. Henschen and G. Qadah, "Efficient Algorithms for the Instantiated Transitive Closure Queries," in IEEE Transactions on Software Engineering, vol. 17, no. , pp. 296-309, 1991.