DocumentCode
871924
Title
Evaluating recursive queries in distributed databases
Author
Nejdl, Wolfgang ; Ceri, Stefano ; Wiederhold, Gio
Author_Institution
Tech. Univ. of Aachen, Germany
Volume
5
Issue
1
fYear
1993
fDate
2/1/1993 12:00:00 AM
Firstpage
104
Lastpage
121
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;
fLanguage
English
Journal_Title
Knowledge and Data Engineering, IEEE Transactions on
Publisher
ieee
ISSN
1041-4347
Type
jour
DOI
10.1109/69.204095
Filename
204095
Link To Document