Title :
Performance issues in distributed query processing
Author :
Liu, Chengwen ; Yu, Clement
Author_Institution :
Dept. of Comput. Sci. & Inf. Syst., DePaul Univ., Chicago, IL, USA
fDate :
8/1/1993 12:00:00 AM
Abstract :
The authors discuss various performance issues in distributed query processing. They validate and evaluate the performance of the local reduction (LR) the fragment and replicate strategy (FRS) and the partition and replicate strategy (PRS) optimization algorithms. The experimental results reveal that the choices made by these algorithms concerning which local operations should be performed, which relation should remain fragmented or which relation should be partitioned are valid. It is shown using experimental results that various parameters, such as the number of processing sites, partitioning speed relative to join speed, and sizes of the join relations, affect the performance of PRS significantly. It is also shown that the response times of query execution are affected significantly by the degree of site autonomy, interferences among processes, interface with the local database management systems (DBMSs) and communications facilities. Pipeline strategies for processing queries in an environment where relations are fragmented are studied
Keywords :
database theory; distributed databases; performance evaluation; query processing; distributed query processing; fragment and replicate strategy; local reduction; partition and replicate strategy; performance issues; pipeline strategies; query execution; response times; Cost function; Data communication; Database systems; Delay; Distributed databases; Interference; Local area networks; Partitioning algorithms; Pipeline processing; Query processing;
Journal_Title :
Parallel and Distributed Systems, IEEE Transactions on