Issue No.10 - October (1987 vol.36)
C.T. Yu , Department of Electrical Engineering and Computer Science, University of Illinois
We propose a scheme to make use of semantic information to process distributed queries locally without data transfer with respect to the join clauses of the query. Since not all queries can be processed without data transfer, we give an algorithm to recognize the "locally processable queries." For nonlocally processable queries, a simple "fragment and replicate" algorithm is used. The algorithm chooses a relation to remain fragmented at the sites where they are situated while replicating the other relations at those sites. Our algorithm determines the chosen relation and the chosen copy of every fragment of the chosen relation such that the minimum response time is obtained. The algorithm runs in linear time. If the fragments of the relation are allowed to be processed in other sites, then the problem is NP hard. Two heuristics are given for that situation. They are compared to the optimal situation. Experimental results show that the strategies produced by the heuristics have small errors relative to the optimal strategy.
semi-join, Computer network, database management system, distributed databases, distributed systems, local network, processing, query optimizations, replicate algorithm
C.T. Yu, null Keh-Chang Guh, null Weining Zhang, M. Templeton, D. Brill, A.L.P. Chen, "Algorithms to Process Distributed Queries in Fast Local Networks", IEEE Transactions on Computers, vol.36, no. 10, pp. 1153-1164, October 1987, doi:10.1109/TC.1987.1676856