This Article 
   
 Share 
   
 Bibliographic References 
   
 Add to: 
 
Digg
Furl
Spurl
Blink
Simpy
Google
Del.icio.us
Y!MyWeb
 
 Search 
   
Efficient Algorithms for the Instantiated Transitive Closure Queries
March 1991 (vol. 17 no. 3)
pp. 296-309

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.

Index Terms:
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
Citation:
G.Z. Qadah, L.J. Henschen, J.J. Kim, "Efficient Algorithms for the Instantiated Transitive Closure Queries," IEEE Transactions on Software Engineering, vol. 17, no. 3, pp. 296-309, March 1991, doi:10.1109/32.75418
Usage of this product signifies your acceptance of the Terms of Use.