On the complexity of distributed query optimization

IEEE Transactions on Knowledge and Data Engineering

Volumn 8, Issue 4, 1996, Pages 650-662

  Wang, Chihping ^a,b   Chen, Ming Syan ^a,c  

^a IEEE

^b Informix Software   (United States)

^c NATIONAL TAIWAN UNIVERSITY   (Taiwan)

Author keywords

Complexity; Distributed databases; Distributed query optimization; NP hard problems; Semijoin processing

Indexed keywords

ALGORITHMS; COMPUTATIONAL COMPLEXITY; DATA PROCESSING; OPTIMIZATION; POLYNOMIALS; QUERY LANGUAGES;

DISTRIBUTED QUERY OPTIMIZATION; SEMIJOIN PROCESSING; SUM PRODUCT OPTIMIZATION;

DISTRIBUTED DATABASE SYSTEMS;

EID: 0030216284     PISSN: 10414347     EISSN: None     Source Type: Journal    
DOI: 10.1109/69.536256     Document Type: Article

References (40)

1. P.M.G. Apers, A.R. Hevner, and S.B. Yao, "Optimization Algorithms for Distributed Queries," IEEE Trans. Software Eng., vol. 9, no. 1, pp. 57-68, Jan. 1983.
2. P.A. Bernstein, N. Goodman, E. Wong, C. Reeve, and J.B. Rothnie, "Query Processing in a System for Distributed Databases (SDD-1)," ACM Trans. Database Systems, vol. 6, no. 4, pp. 602-625, Dec. 1981.
3. P.A. Bernstein and D.M. Chiu, "Using Semi-Joins to Solve Relational Queries," J. ACM, vol. 28, no. 1, pp. 25-40, Jan. 1981.
4. P.A. Black and W.S. Luk, "A New Heuristic for Generating Semi-Join Programs for Distributed Query Processing," Proc. IEEE COMPSAC, pp. 581-588, 1982.
5. S. Ceri and G. Pelagatti, Distributed Databases Principle and Systems. New York: McGraw-Hill, 1985.
6. A.L.P. Chen and V.O.K. Li, "Improvement Algorithms for Semi-Join Query Processing Programs in Distributed Database Systems," IEEE Trans. Computers, vol. 33, no. 11, pp. 959-967, Nov. 1984.
7. A.L.P. Chen and V.O.K. Li, "An Optimal Algorithm for Distributed Star Queries," IEEE Trans. Software Eng., vol. 11, no. 10, pp. 1,097-1,107, Oct. 1985.
8. J.S.J. Chen and V.O.K. Li, "Optimizing Joins in Fragmented Database Systems on a Broadcast Local Network," IEEE Trans. Software Eng., vol. 15, no. 1, pp. 26-38, Jan. 1989.
9. M.-S. Chen and P.S. Yu, "Interleaving a Join Sequence with Semijoins in Distributed Query Processing," IEEE Trans. Parallel and Distributed Systems, vol. 3, no. 5, pp. 611-621, Sept. 1992.
10. M.-S. Chen and P.S. Yu, "Combining Join and Semijoin Operations for Distributed Query Processing," IEEE Trans. Knowledge and Data Eng., vol. 5, no. 3, pp. 534-542, June 1993.
11. M-S. Chen and P.S. Yu, "A Graph Theoretical Approach to Determine a Join Reducer Sequence in Distributed Query Processing," IEEE Trans. Knowledge and Data Eng., vol. 6, no. 1, pp. 152-165, Feb. 1994.
12. D.M. Chiu, P.A. Bernstein, and Y.C. Ho, "Optimizing Chain Queries in A Distributed Database System," SIAM J. Computing, vol. 13, no. 1, pp. 116-134, Feb. 1984.
13. D.M. Chiu and Y.C. Ho, "A Methodology for Interpreting Tree Queries into Optimal Semi-Join Expressions," Proc. ACM SIGMOD, pp. 169-178, May 1980.
14. W.W. Chu and P. Hurley, "Optimal Query Processing for Distributed Database Systems," IEEE Trans. Computers, vol. 31, no. 9, pp. 135-150, Sept. 1982.
15. D. Gardy and C. Pucch, "On the Effect of Join Operations on Relation Sizes," ACM Trans. Database Systems, vol. 14, no. 4, pp. 574-603, Dec. 1989.
16. M.R. Garey and D.S. Johnson, Computers and Intractability: A Guide to the Theory of NP-Completeness, Freeman, 1979.
17. B. Gavish and A. Segev, "Set Query Optimization in Distributed Database Systems," ACM Trans. Database Systems, vol. 11, no. 3, pp. 266-293, Sept. 1986.
18. N. Goodman and O. Shmueli, "The Tree Property Is Fundamental for Query Processing," Proc. ACM Symp. Principles of Database Systems, pp. 40-48, 1982.
19. N. Goodman and O. Shmueli, "Tree Queries: A Simple Class of Relational Queries," ACM Trans. Database Systems, vol. 7, no. 4, pp. 653-677, Dec. 1982.
20. A.K. Hevner, "The Optimization of Query Processing on Distributed Database Systems," PhD thesis, Purdue Univ., 1979.
21. A.R. Hevner, O.Q. Wu, and S.B. Yao, "Query Optimization on Local Area Networks," ACM Trans. Office Information, vol. 3, pp. 35-62, Jan. 1985.
22. A.R. Hevner and S.B Yao, "Query Processing in Distributed Databases," IEEE Trans. Software Eng., vol. 5, no. 3, pp. 177-187, May 1979.
23. E. Horowitz and S. Sahni, Fundamentals of Computer Algorithms. Computer Science Press, 1978.
24. K.T. Huang, "Query Optimization in Distributed Databases," PhD thesis, Laboratory for Information and Decision Systems, Massachusetts Inst. of Technology, 1982.
25. Y. Kambayashi, M. Yoshikawa, and S. Yajima, "Query Processing for Distributed Databases Using Generalized Semi-Joins," Proc. ACM SIGMOD, pp. 151-160, 1982.
26. H. Kang and N. Roussopoulos, "Combining Joins and Semijoins in Distributed Query Processing," Technical Report CS-TR-1794, Computer Science Dept., Univ. of Maryland, College Park, 1987.
27. S. Lafortune and E. Wong, "A State Transition Model for Distributed Query Processing," ACM Trans. Database Systems, vol. 11, no. 3, pp. 294-322, Sept. 1986.
28. W. Perrizo, J.Y. Li, and W. Hoffman, "Algorithms for Distributed Query Processing in Broadcasting Local Area Networks," IEEE Trans. Knowledge and Data Eng., vol. 1, no. 2, pp. 215-225, June 1989.
29. S. Pramanik and D. Vineyard, "Optimizing Join Queries in Distributed Databases," IEEE Trans. Software Eng., vol. 14, no. 9, pp. 1,319-1,326, Sept. 1988.
30. G. Sacco, "Distributed Query Evaluation in Local Area Networks," Proc. IEEE Data Eng. Conf., pp. 510-516, Apr. 1984.
31. Arie Segev, "Global Heuristics for Distributed Query Optimization," Proc. IEEE INFOCOM, pp. 388-394, Apr. 1986.
32. D. Shasha and T.-L. Wang, "Optimizing Equijoin Queries in Distributed Databases Where Relations Are Hash Partitioned," ACM Trans. Database Systems, vol. 16, no. 2, pp. 279-308, June 1991.
33. W. Sun and C. Yu, "Semantic Query Optimization for Tree and Chain Queries," IEEE Trans. Knowledge and Data Eng., vol. 6, no. 1, pp. 136-151, Feb. 1994.
34. P. Valduriez and G. Gardarin, "Join and Semijoin Algorithms for a Multiprocessor Database Machine," ACM Trans. Database Systems, vol. 9, no. 1, pp. 133-161, Mar. 1984.
35. C.P. Wang and V.O.K. Li, "The Relation-Partitioning Approach to Distributed Query Processing," Proc. Second IEEE Data Eng. Conf., pp. 21-28, Feb. 1986.
36. C.P. Wang, V.O.K. Li, and A.L.P. Chen, "One-Shot Semi-Join Execution Strategies for Processing Distributed Queries," Proc. Seventh IEEE Data Eng. Conf., pp. 756-763, Apr. 1991.
37. E. Wong, "Retrieving Dispersed Data from SDD-1: A System for Distributed Databases," Proc. Second Berkeley Workshop Distributed Data Management and Camputer Network, pp. 217-235, May 1977.
38. H. Yoo and S. Lafortune, "An Intelligent Search Method for Query Optimization by Semijoins," IEEE Trans. Knowledge and Data Eng., vol. 1, no. 2, pp. 226-237, June 1989.
39. C. Yu and C.C. Chang, "Distributed Query Processing," ACM Computing Surveys, vol. 16, no. 4, pp. 399-433, Dec. 1984..
40. C. Yu, Z.M. Ozsoyoglu, and K. Kam, "Optimization of Distributed Tree Queries," J. Comput. Syst. Sci., vol. 29, no. 3, pp. 409-445, Dec. 1984.