IEEE Transactions on Software Engineering · 1991 · 26 citations · 10 references
ComputingComputer ScienceComputer SystemsAlgorithmsDatabasesStorage SystemsCachingQuery OptimizationQuery ProcessingMeasurement Of Relative PerformanceRecursive QueriesRelative Performance AnalysisTransitive Closure
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.< <ETX xmlns:mml="http://www.w3.org/1998/Math/MathML" xmlns:xlink="http://www.w3.org/1999/xlink">></ETX>
10
On compiling queries in recursive first-order databases
Lawrence J. Henschen, Shamim A. Naqvi · Journal of the ACM · 1984 · 285 citations · Full text