Title :
Evaluating recursive queries in distributed databases
Author :
Nejdl, Wolfgang ; Ceri, Stefano ; Wiederhold, Gio
Author_Institution :
Tech. Univ. of Aachen, Germany
fDate :
2/1/1993 12:00:00 AM
Abstract :
The execution of logic queries in a distributed database environment is studied. Conventional optimization strategies, such as the early evaluation of selection conditions and the clustering of processing to manipulate and exchange large sets of tuples, are redefined in view of the additional difficulties due to logic queries, in particular to recursive rules. In order to allow efficient processing of these logic queries, several program transformation techniques that attempt to minimize distribution costs based on the idea of semijoins and generalized semijoins in conventional databases are presented. Although local computation of semijoins is not possible for the general case, classes of programs are indicated for which these transformations succeed in producing set-oriented computation. Processes evaluating the recursive program in a distributed network are described, and an efficient method for testing the termination of the computation is developed. The approach is compared with sequential as well as dataflow-oriented evaluation
Keywords :
distributed databases; query processing; clustering; dataflow-oriented evaluation; distributed databases; distributed network; logic queries; optimization strategies; program transformation; recursive queries evaluation; selection conditions; semijoins; set-oriented computation; Computer networks; Costs; Database systems; Design methodology; Distributed databases; Logic design; Logic programming; Query processing; Relational databases; Testing;
Journal_Title :
Knowledge and Data Engineering, IEEE Transactions on