Role-based query processing in multidatabase systems

  • Peter Scheuermann
  • Eugene Inseok Chong
Conference paper
Part of the Lecture Notes in Computer Science book series (LNCS, volume 779)

Abstract

We address the problem of data integration and query processing in multidatabase systems in the presence of conflicting values for the attributes that correspond to different instances of the same real-world object appearing in multiple roles. We present a new method for schema and data integration in multidatabase systems that presents the answer to the query as a set of sets representing the distinct intersections between the relations representing the various roles of interest. We present extensions to MSQL that allow us to express role-sets and quantifiers applied to them. We further develop a strategy for query processing based on our role-based model. Our method allows for local selection for all queries with/without aggregation and thus reduces the amount of data transmitted. In addition, it makes efficient use of merge-sort techniques to generate the role-sets and compute joins at the global query site.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. 1.
    Apers, P.M.G., Hevner, A.R., and Yao, S.B.: Optimization algorithms for distributed queries. IEEE Trans. on Soft. Eng. (1983) 57–68Google Scholar
  2. 2.
    Apers, P. and Scheuermann, P.: Schema architectures and their relationship to transaction processing in distributed database systems. Information Sciences 54 (1991) 41–66Google Scholar
  3. 3.
    Bernstein, P.A. and Chiu, D.: Using semijoins to solve relational queries. JACM (1981) 25–40Google Scholar
  4. 4.
    Bernstein, P.A., Goodman, N., Wong, E., Reeve, C., and Rothnie, J.B.: Query processing in a system for distributed databases(SDD-1). ACM Trans. on Database Systems (1981) 602–625Google Scholar
  5. 5.
    Blasgen, M.W. and Eswaran, K.P.: Storage and access in relational data bases. IBM Systems Journal (1977) 363–377Google Scholar
  6. 6.
    Bratbergsengen, K.: Hashing methods and relational algebra operations. Proc. Tenth Intl. Conf. on Very Large Data Bases (1984) 323–333Google Scholar
  7. 7.
    Ceri, S. and Pelagatti, G.: Distributed Databases: Principles and Systems. McGraw-Hill (1984)Google Scholar
  8. 8.
    Chen, A.L.P.: Outerjoin optimization in multidatabase systems. Proc. IEEE 2nd Intl. Symp. on Databases in Parallel and Distributed Systems (1990) 211–218Google Scholar
  9. 9.
    Chong, E.I.: Query optimization in distributed database systems and multi-database systems. Ph.D. Dissertation, Dept. of Elec. Eng. and Computer Science, Northwestern University (in preparation)Google Scholar
  10. 10.
    Dayal, U.: Query processing in a multidatabase system. In: W. Kim, et al.(eds.): Query Processing: Database Systems. New York: Springer 1985, pp.81–108Google Scholar
  11. 11.
    Dayal, U. and Hwang, H.Y.: View definition and generalization for database integration in a multidatabase system. IEEE Trans. on Software Engineering 10 (1984) 628–644Google Scholar
  12. 12.
    Du, W., Krishnamurthy, R., and Shan, M.-C.: Query optimization in heterogeneous DBMS. Proc. 18th Intl. Conf. on Very Large Data Bases (1992) 277–291Google Scholar
  13. 13.
    Grant, J., Litwin, W., Roussopoulos, N., and Sellis, T.: Query languages for relational multidatabases. VLDB Journal 2 (1993) 153–171Google Scholar
  14. 14.
    Hwang, H.Y., Dayal, U. and Gouda, M.: Using semiouterjoins to process queries in multidatabase systems. Proc. Third ACM SIGACT-SIGMOD Symp. on Principles of Database Systems (1984) 153–162Google Scholar
  15. 15.
    Kent, W.: The breakdown of the information model in multi-database systems. ACM SIGMOD Record 20 (1991) 10–15Google Scholar
  16. 16.
    Lim, E., Srivastava, J., Prabhakar, S., and Richardson, J.: Entity identification in database integration. Proc. IEEE Intl. Conf. on Data Engineering (1993) 294–301Google Scholar
  17. 17.
    Litwin, W. and Abdellatif, A.: Multidatabase Interoperability. IEEE Computer 19 (1986) 10–18Google Scholar
  18. 18.
    Litwin, W., Abdellatif, A., Zeroual, A., Nicolas, B., and Vigier, P.: MSQL: A multidatabase language. Information Sciences 49 (1989) 59–101Google Scholar
  19. 19.
    Litwin, W., Mark, L., and Roussopoulos, N.: Interoperability of multiple autonomous databases. ACM Computing Surveys 33 (1990) 267–293Google Scholar
  20. 20.
    Position Papers. Workshop on Heterogeneous Databases, Northwestern University, Evanston, IL. (1989)Google Scholar
  21. 21.
    Rosenthal, A. and Reiner, D.: Extending the algebraic framework of query processing to handle outerjoins. Proc. Tenth Intl. Conf. on Very Large Data Bases (1984) 334–343Google Scholar
  22. 22.
    Rusinkiewicz, M. and Czejdo, B.: An approach to query processing in federated database systems. Proc. 20th Hawaii Intl. Conf. on System Sciences (1987) 430–440Google Scholar
  23. 23.
    Scheuermann, P. (editor): Report of the workshop on heterogeneous database systems held at Northwestern University. ACM SIGMOD Record 19 (1989)Google Scholar
  24. 24.
    Scheuermann, P. and Chong, E.I.: Query processing in multidatabase systems. Proc. IEEE Intl. Conf. on Systems, Man, and Cybernetics (1992) 1250–1254Google Scholar
  25. 25.
    Selinger, P.G., Astrahan, M.M., Chamberlin, D.D., Lorie, R.A., and Price, T.G.: Access path selection in a relational database management system. Proc. ACM SIGMOD Intl. Conf. on Management of Data (1979) 23–34Google Scholar
  26. 26.
    Yu, C.T. and Chang, C.C.: Distributed Query Processing. ACM Computing Surveys 16 (1984) 399–433Google Scholar
  27. 27.
    Yu, C.T., et al.: Query processing in a fragmented relational distributed system:MERMAID. IEEE Trans. on Soft. Eng. (1985) 795–810Google Scholar
  28. 28.
    Yu, C.T., et al.: Partition strategy for distributed query processing in fast local networks. IEEE Trans. on Soft. Eng. (1989) 780–793Google Scholar
  29. 29.
    Yu, C.T., et al.: On the design of a distributed query processing algorithms. Proc. ACM SIGMOD Intl. Conf. on Management of Data (1983) 30–39Google Scholar

Copyright information

© Springer-Verlag 1994

Authors and Affiliations

  • Peter Scheuermann
    • 1
  • Eugene Inseok Chong
    • 1
  1. 1.Department of Electrical Engineering and Computer ScienceNorthwestern UniversityEvanstonUSA

Personalised recommendations