Journal of Computer Science and Technology

, Volume 4, Issue 2, pp 106–115 | Cite as

Properties of semijoin sequences

  • Beng C. Ooi
  • B. Srinivasan
Regular Papers


The problem of finding optimum semijoin sequence for an arbitrary query under linear cost function for the transmission cost is NP-hard. Hence heuristic algorithms with desirable properties are explored. In this paper four properties of semijoin programs for distributed query processing are identified. The use of these properties in constructing semijoin sequence is justified. An existing algorithm is modified incorporating these properties. Empirical comparison with existing algorithms shows the superiority of the proposed algorithm.


Query Processing Attribute Size User Site Transmission Cost Assembly Site 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. [1]
    Apers, P.M.G., Hevner, A.R. and Yao, S.B., Optimization algorithm for distributed queries,IEEE Trans. on Software Eng.,28:1 (1983), 57–68.CrossRefGoogle Scholar
  2. [2]
    Bernstein, P.A. and Chiu, D.M., Using semijoin to solve relational queries,J. ACM,28:1 (1981), 25–40.MATHCrossRefMathSciNetGoogle Scholar
  3. [3]
    Black, P.A. and Luk, W.S., A New Heuristic for Generating Semijoin Programs for Distributed Query Processing, IEEE COMPSAC, 1982, 581–588.Google Scholar
  4. [4]
    Chung, C. W. and Irani, K.B., A Semijoin Strategy for Distributed Query Optimization, IEEE Int. Conf. on Distributed Computing System, 1984.Google Scholar
  5. [5]
    Codd, E.F., A relational model of data for large shared data banks,CACM,13:6 (1970), 377–389.MATHGoogle Scholar
  6. [6]
    Hevner, A.R., Optimization of Query Processing in Distributed Databases, PhD Dissertation, Purdue University, Lafayette, Indiana, Sept., 1979.Google Scholar
  7. [7]
    Hevner, A.R. and Yao, S.B., Query Processing on a Distributed Database, Procs. 3rd Berkeley Workshop on Distributed Data Management and Comp. Networks, August, 1978.Google Scholar
  8. [8]
    Hevner, A.R. and Yao, S.B., Query processing in distributed database system,IEEE Trans on Soft. Eng., SE-5:3 (1979), 177–187.CrossRefGoogle Scholar
  9. [9]
    Goodman, al., Query Processing in SDD-1: A system for Distributed Databases, Tech. Rep. CCA-79-06. Computer Corporation of America, 1979.Google Scholar
  10. [10]
    Bernstein, P.A., Goodman, N., Wong, E., Reeve, C.L. and Rothnie, Jr. J.B., Query processing in a system for distributed databases (SDD-1),ACM TODS,6:4 (1981), 602–625.MATHCrossRefGoogle Scholar
  11. [11]
    Srinivasan, B., and Ooi, B.C., Optimal Properties of Semijoin Sequences for Distributed Query Processing, Technical Report, National University of Singapore, July, 1987.Google Scholar
  12. [12]
    Wong, E., Retrieving Dispersed Data from SDD-1: A System for Distributed Databases, Proc. 2nd Berkeley Workshop on Distributed Management and Computer Networks, May, 1977, 217–235.Google Scholar
  13. [13]
    Yao, S.B., Approximating block access in database organisation,CACM,20:4 (1977), 260–261.MATHGoogle Scholar
  14. [14]
    Yu, C.T. and Chang, C.C., Distributed query processing,ACM Computing Surveys,16:4 (1984), 399–433.MATHCrossRefGoogle Scholar
  15. [15]
    Yu, C.T. and Chang, C.C., On the Design of a Query Processing Strategy in a Distributed Database Environment, Proc. ACM SIGMOD, 1983, 30–39.Google Scholar
  16. [16]
    Yu, C.T. and Ozsoyoglu, M.E., An Algorithm for Tree Query Membership of a Distributed Query, IEEE COMPSAC, 1979, 306–312.Google Scholar

Copyright information

© Science Press, Beijing China and Allerton Press Inc. 1989

Authors and Affiliations

  • Beng C. Ooi
    • 1
  • B. Srinivasan
    • 1
  1. 1.Department of Computer ScienceMonash UniversityClaytonAustralia

Personalised recommendations