Title
An Efficient Database Transitive Closure Algorithm
Abstract
The integration of logic rules and relational databases has recently emerged as an important technique for developing knowledge management systems. An important class of logic rules utilized by these systems is the so-called transitive closure rules, the processing of which requires the computation of the transitive closure of database relations referenced by these rules. This article presents a new algorithm suitable for computing the transitive closure of very large database relations. This algorithm proceeds in two phases. In the first phase, a general graph is condensed into an acyclic one, and at the same time a special sparse matrix is formed from the acyclic graph. The second phase is the main one, in which all the page I/O operations are minimized by removing most of the redundant operations that appear in previous algorithms. Using simulation, this article also studies and examines the performance of this algorithm and compares it with the previous algorithms.
Year
DOI
Venue
1994
10.1007/BF00872109
Appl. Intell.
Keywords
Field
DocType
Knowledge bases,deductive databases,recursive rules,recursive query processing,transitive closure queries
Transitive reduction,Relational database,Computer science,Very large database,Algorithm,Directed acyclic graph,Theoretical computer science,Transitive closure,Rule of inference,Database,Sparse matrix,Computation
Journal
Volume
Issue
ISSN
4
2
0924-669X
Citations 
PageRank 
References 
3
2.04
23
Authors
3
Name
Order
Citations
PageRank
Ismail Hakki Toroslu1456102.80
Ghassan Z. Qadah2116173.61
Lawrence J. Henschen3478280.94