• 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