Advertisement

A localized approach to distributed query processing

  • Arbee L. P. Chen
Session 5: Query Processing
Part of the Lecture Notes in Computer Science book series (LNCS, volume 416)

Abstract

To process queries against a global schema in a distributed multidatabase system, query transformation which maps the query against the global schema to the local schemas is necessary. In this paper, a localized approach is presented which optimizes distributed query processing. This approach transforms a query to subqueries. Each subquery references data contained at a local site and therefore can be locally processed. It reduces data transmission time and query response time due to local processing and parallel processing. It can therefore be applied in distributed database systems implemented in either long-haul or local networks. Moreover, semantic information can be incorporated with this approach to process distributed queries at a single site. Data fragmentation and schema and data conflicts exist in the multidatabase environment, which are treated in a uniform framework in this approach.

Keywords

Query Processing Data Fragmentation Query Optimization Aggregate Attribute Query Response Time 
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.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. [1]
    Apers, P., A. Hevner, S.B. Yao, "Optimization Algorithm for Distributed Queries," in IEEE Transactions on Software Engineering, January 1983.Google Scholar
  2. [2]
    Batini, C., M. Lenzerini and S. Navathe, "A comparative analysis of methodologies for database schema integration," ACM Computing Surveys, Dec. 1986.Google Scholar
  3. [3]
    Bernstein, P. and D.M. Chiu, "Using Semi-joins to Solve Relational Queries," in JACM, January 1981.Google Scholar
  4. [4]
    Bernstein, P., N. Goodman, E. Wong, C. Reeve, J. Rothnie, "Query Processing in a System for Distributed Databases (SDD-1)," in ACM Transactions on Database Systems, December 1981.Google Scholar
  5. [5]
    Breitbart, Y., P. Olson and G. Thompson, "Database integration in a distributed heterogeneous database system," Proc. IEEE International Conference on Data Engineering, 1986.Google Scholar
  6. [6]
    Breitbart, Y. and L. Tieman, "ADDS — Heterogeneous distributed database system," Distributed Data Sharing Systems, Schreiber, F. and W. Litwin (Ed's), North Holland, 1984.Google Scholar
  7. [7]
    Brill, D., M. Templeton, C.T. Yu, "Distributed Query Processing Strategies in Mermaid, A Frontend to Data Management Systems," in Proc. IEEE International Conference on Data Engineering, 1984.Google Scholar
  8. [8]
    Ceri, S. and G. Pelagatti, Distributed Databases: Principles and Systems, McGraw-Hill, 1984.Google Scholar
  9. [9]
    Chen, A.L.P., D. Brill, M. Templeton and C. Yu, "Distributed query processing in a multiple database system," IEEE Journal on Selected Areas in Communications, special issue on Databases in Communications Systems, Apr. 1989.Google Scholar
  10. [10]
    Chen, A.L.P. and V.O.K. Li, "Optimizing Star Queries in a Distributed Database System," in Proc. of VLDB, 1984.Google Scholar
  11. [11]
    Chen, A.L.P. and V.O.K. Li, "Improvement Algorithms for Semijoin Query Processing Programs in Distributed Database Systems," in IEEE Transactions on Computers, November 1984.Google Scholar
  12. [12]
    Chen, A.L.P. and V.O.K. Li, "An Optimal Algorithm for Processing Distributed Star Queries," in IEEE Transactions on Software Engineering, October 1985.Google Scholar
  13. [13]
    Chiu, D.M., P. Bernstein, Y.C. Ho, "Optimizing Chain Queries in a Distributed Database System," in SIAM J. Comput., February 1984.Google Scholar
  14. [14]
    Chiu, D.M. and Y.C. Ho, "A Method for Interpreting Tree Queries into Optimal Semi-join Expressions," in Proc. of ACM SIGMOD, 1980.Google Scholar
  15. [15]
    Chu, W. and P. Hurley, "Optimal query processing for distributed database systems," IEEE Trans. on Computers, Sep. 1982.Google Scholar
  16. [16]
    Czejdo, B., M. Rusinkiewicz and D. Embley, "An approach to schema integration and query formulation in federated database systems," Proc. IEEE International Conference on Data Engineering, 1987.Google Scholar
  17. [17]
    Dayal, U., "Query processing in a multidatabase system," Query Processing in Database Systems, Kim, Reiner and Batory (Ed's), 1985.Google Scholar
  18. [18]
    Dayal, U. and H. Hwang, "View definition and generalization for database integration in multibase: A system for heterogeneous distributed databases," IEEE Trans. Softw. Eng., Nov. 1984.Google Scholar
  19. [19]
    Deen, S.M., R.R. Amin and M.C. Taylor, "Query decomposition in PRECI*," Distributed Data Sharing Systems, Schreiber and Litwin (Ed's), 1985.Google Scholar
  20. [20]
    Deen, S., R. Amin and M. Taylor, "Data integration in distributed databases," IEEE Trans. Softw. Eng., Jul. 1987.Google Scholar
  21. [21]
    Deen, S. et al., "The architecture of a generalized distributed database — PRECI*," Comput. J., Jul. 1985.Google Scholar
  22. [22]
    Epstein, R., M. Stonebraker, E. Wong, "Distributed Query Processing in a Relational Database System," in Proc. of ACM SIGMOD, 1978.Google Scholar
  23. [23]
    Freytag, C.F., "A ruled-based view of query optimization," in Proc. of ACM SIGMOD, 1987.Google Scholar
  24. [24]
    Gamal-Eldin, M., G. Thomas and R. Elmasri, "Integrating relational databases with support for updates," in Proc. IEEE International Symposium on Databases for Parallel and Distributed Systems, 1988.Google Scholar
  25. [25]
    Graefe, G. and D. DeWitt, "The EXODUS optimizer generator," in Proc. of ACM SIGMOD, 1987.Google Scholar
  26. [26]
    Hammer, M. and S. Zdonik, "Knowledge-Based Query Processing," in Proc. of VLDB, 1980.Google Scholar
  27. [27]
    Hwang, H., U. Dayal and M.G. Gouda, "Using semiouterjoins to process queries in multidatabase systems," in Proc. of ACM PODS, 1984.Google Scholar
  28. [28]
    King, J., Query Optimization by Semantic Reasoning, UMI Research Press, 1984.Google Scholar
  29. [29]
    Lohman, G., C. Mohan, L. Hass, D. Daniels, B. Lindsay, P. Selinger, P. Wilms, "Query Processing in R*," Query Processing in Database Systems, Kim, Reiner and Batory (Ed's), 1985.Google Scholar
  30. [30]
    Lohman, G.M., "Grammar-like functional rules for representing query optimization alternatives," in Proc. of ACM SIGMOD, 1988.Google Scholar
  31. [31]
    Luk, W. and L. Luk, "Optimizing Semi-join Programs for Distributed Query Processing," in Proc. International Conference on Databases, 1983.Google Scholar
  32. [32]
    Shenoy, S.T. and Z.M. Ozsoyoglu, "A system for semantic query optimization," in Proc. of ACM SIGMOD, 1987.Google Scholar
  33. [33]
    Smith, J. et al., "Multibase — Integrating heterogeneous distributed database systems," in Proc. of AFIPS NCC, 1981.Google Scholar
  34. [34]
    Stonebraker, M., "Implementation of integrity constraints and views by query modification," in Proc. of ACM SIGMOD, 1975.Google Scholar
  35. [35]
    Templeton, M., D. Brill, A.L.P. Chen, S. Dao, E. Lund, R. MacGregor, P. Ward, "Mermaid — A Front-end to Distributed Heterogeneous Databases," Proceedings of the IEEE, May, 1987.Google Scholar
  36. [36]
    Yu, C.T., C.C. Chang, M. Templeton, D. Brill, E. Lund, "On the Design of a Query Processing Strategy in a Distributed Database Environment," in Proc. of ACM SIGMOD, 1983.Google Scholar
  37. [37]
    Yu, C.T., C.C. Chang, M. Templeton, D. Brill, E. Lund, "Query Processing in a Fragmented Relational Distributed System: MERMAID," IEEE Transactions on Software Engineering, August 1985.Google Scholar
  38. [38]
    Yu, C.T., K. Guh, D. Brill, A.L.P. Chen, "Partition Strategy for Distributed Query Processing in Fast Local Networks," IEEE Trans. on Software Engineering, June 1989.Google Scholar
  39. [39]
    Yu, C., K. Guh and A.L.P. Chen, "An integrated algorithm for distributed query processing," in Proc. IFIP Conference on Distributed Processing, 1987.Google Scholar
  40. [40]
    Yu, C.T., L. Lilien, K. Guh, M. Templeton, D. Brill, A.L.P. Chen, "Adaptive Techniques for Distributed Query Optimization," in Proc. IEEE International Conference on Data Engineering, 1986.Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 1990

Authors and Affiliations

  • Arbee L. P. Chen
    • 1
  1. 1.Bell Communications ResearchPiscatawayU.S.A.

Personalised recommendations