A Practical Approach to Access Heterogeneous and Distributed Databases

  • Fernando de Ferreira Rezende
  • Ulrich Hermsen
  • Georgiane de Sá Oliveira
  • Renata Costa Guedes Pereira
  • Jochen Rütschlin
Conference paper
Part of the Lecture Notes in Computer Science book series (LNCS, volume 1626)


A common problem within most large corporations nowadays is the diversity of database systems that are employed by their many departments in the development of a product. Usually, the total corporate data resource is characterized by multi-vendor database servers which, unfortunately, have no ability to relate data from heterogeneous data sources. In this paper, we present a database access interface which allows users to formulate SQL2 queries in a homogeneous way against a federation of heterogeneous databases. The database heterogeneity is not only completely hidden from the user, but what the user really perceives is a global database schema which can be queried as though all data reside in a single local database when, in fact, most of the data are distributed over heterogeneous, autonomous, and remote data sources. Further, the users can navigate through the database complex and compare, join, and relate information via a single graphic interface.


Graphic User Interface Mapping Table Select Statement Common Object Request Broker Architecture Garbage Collector 
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.


  1. 1.
    Rezende, F.F., Hergula, K.: The Heterogeneity Problem and Middleware Technology: Experiences with and Performance of Database Gateways. In: Proc. of the 24 th VLDB, USA, 1998. pp. 146–157.Google Scholar
  2. 2.
    Melton, J. (Ed.): Database Language SQL 2. ANSI, Washington, D.C., USA, 1990.Google Scholar
  3. 3.
    Date, C.J., Darwen, H.: A Guide to the SQL Standard. Addison-Wesley, 4th Ed., USA, 1997.Google Scholar
  4. 4.
    Härder, T., Mitschang, B., Nink, U., Ritter, N.: Workstation/Server Architectures for Database-Based Engineering Applications (in German). Informatik Forschung & Entwicklung, 1995.Google Scholar
  5. 5.
    Rezende, F.F., Härder, T.: An Approach to Multi-User KBMS in Workstation/Server Environments. In: Proc. of the 11 th Brazilian Symposium on Data Base Systems, São Carlos, Brazil, 1996. pp. 58–72.Google Scholar
  6. 6.
    DeWitt, D.J., Maier, D., Futtersack, P., Velez, F.: A Study of Three Alternative Workstation/Server Architectures for Object-Oriented Databases. In: Proc. of the 16 th VLDB, Australia, 1990. pp. 107–121.Google Scholar
  7. 7.
    Rezende, F.F.: Transaction Services for Knowledge Base Management Systems–Modeling Aspects, Architectural Issues, and Realization Techniques. infix Verlag, Germany, 1997.Google Scholar
  8. 8.
    Mitschang, B., Pirahesh, H., Pistor, P., Lindsay, B., Südkamp, S.: SQL/XNF-Processing Composite Objects as Abstractions over Relational Data. In: Proc. Int. Conf. on Data Engineering, Austria, 1993.Google Scholar
  9. 9.
    Küspert, K., Dadam, P., Günauer, J.: Cooperative Object Buffer Management in the Advanced Information Management Prototype. In: Proc. of the 13 th VLDB, Brighton, U.K., 1987. pp. 483–492.Google Scholar
  10. 10.
    Härder, T., Hübel, C., Meyer-Wegener, K., Mitschang, B.: Processing and Transaction Concepts for Cooperation of Engineering Workstations and a Database Server. DKE, Vol. 3, 1988. pp. 87–107.CrossRefGoogle Scholar
  11. 11.
    Roussopoulos, N., Delis, A.: Modern Client-Server DBMS Architectures. ACM SIGMOD Record, Vol. 20,No. 3, Sept. 1991. pp. 52–61.CrossRefGoogle Scholar
  12. 12.
    Ananthanarayanan, R., Gottemukkala, V., Käfer, W., Lehman, T.J., Pirahesh, H.: Using the Coexistence Approach to Achieve Combined Functionality of Object-Oriented and Relational Systems. In: Proc. of the ACM SIGMOD Int. Conf. on the Management of Data, USA, May 1993. pp. 109–118.Google Scholar
  13. 13.
    Keller, A., Jensen, R., Agrawal, S.: Persistence Software: Bridging Object-Oriented Programming and Relational Database. In: Proc. of the ACM SIGMOD Int. Conf. on the Management of Data, Washington, D.C., USA, May 1993. pp. 523–528.Google Scholar
  14. 14.
    Thomas, J., Mitschang, B., Mattos, N.M., Dessloch, S.: Enhancing Knowledge Processing in Client/Server Environments. In: Proc. of the 2 nd ACM Int. Conf. on Information and Knowledge Management (CIKM’93), Washington, D.C., USA, Nov. 1993. pp. 324–334.Google Scholar
  15. 15.
    Lee, B., Wiederhold, G.: Outer Joins and Filters for Instantiating Objects from Relational Databases Through Views. IEEE Transactions on Knowledge and Data Engineering, Vol. 6,No. 1, 1994.Google Scholar
  16. 16.
    Cood, E.F.: A Relational Model of Data for Large Shared Data Banks. Communications of the ACM, Vol. 13, 1970. pp. 377–387.CrossRefGoogle Scholar
  17. 17.
    Rezende, F.F., Hergula, K., and Schneider, P.: A Comparative Analysis and Performance of Database Gateways. Technical Report Nr. FT3/E-1998-001, DaimlerChrysler, Ulm, Germany, March 1998.Google Scholar
  18. 18.
    Hergula, K., and Rezende, F.F.: A Detailed Analysis of Database Middleware Technologies (in German). Technical Report Nr. FT3/E-1998-002, DaimlerChrysler, Ulm, Germany, June 1998.Google Scholar
  19. 19.
    IBM Corporation: DB2 DataJoiner Administration Guide. IBM, 1997.Google Scholar
  20. 20.
  21. 21.
    Hamilton, G., Cattell, R., Fisher, M.: JDBC Database Access with Java: A Tutorial and Annotated Reference, Addison-Wesley, USA, 1997.Google Scholar
  22. 22.
  23. 23.
    Object Management Group. The Common Object Request Broker Architecture and Specification (CORBA), OMG, Framingham, USA, 1992.Google Scholar
  24. 24.
    Object Management Group. The Common Object Request Broker Architecture and Specification–Rev. 2.0, Technical Report, OMG, Framingham, USA, 1995.Google Scholar
  25. 25.
    Orfali, R., Harkey, D., Edwards, J.: The Essential Distributed Objects Survival Guide. John Wiley & Sons, USA, 1994.Google Scholar
  26. 26.
    Davis, T.E.: Build your own Object Pool in Java to Boost Application Speed. JavaWorld,, Jun. 1998.
  27. 27.
    Hermsen, U.: Design and Implementation of an Adaptable Cache in a Heterogeneous Client/Server Environment (in German). M.S. Thesis, Univ. of Kaiserslautern, Germany, 1998.Google Scholar
  28. 28.
    Kim, W., Choi, I., Gala, S., Scheevel, M.: On Resolving Schematic Heterogeneity in Multidatabase Systems. In: Kim, W. (Ed.), Modern Database Systems–The Object Model, Interoperability, and Beyond, Addison-Wesley, USA, 1995. (Chapter 26).Google Scholar
  29. 29.
    Garfinkel, S., Spafford, G.: Practical Unix & Internet Security. O’Reilly & Associates Inc., USA, 1996.Google Scholar
  30. 30.
    Fritzinger, J.S., Mueller, M.: Java Security. White Paper, Sun Microsystems Inc., 1996.Google Scholar
  31. 31.
    Atkinson, M., Bancilhon, F., DeWitt, D., Dittrich, K., Maier, D., Zdonik, S.: The Object-Oriented Database System Manifesto. In: Bancilhon, F., Delobel, C., Kanellakis, P. (Eds.), Building an Object-Oriented Database System: The Story of O2, Morgan Kaufmann, USA, 1992. pp. 3–20. (Chapter 1).Google Scholar
  32. 32.
    Cattell, R.G.G. (Ed.): The Object Database Standard: ODMG-93. Morgan Kaufmann, USA, 1994.Google Scholar
  33. 33.
    Kim, W.: Introduction to Object-Oriented Databases. The MIT Press, Massachusetts, USA, 1990.Google Scholar
  34. 34.
    Loomis, M.E.S., Atwood, T., Cattell, R., Duhl, J., Ferran, G., Wade, D.: The ODMG Object Model. Joop, Jun. 1993. pp. 64–69.Google Scholar
  35. 35.
    Stonebraker, M., Rowe, R.A., Lindsay, B.G., Gray, J.N., Carey, M., Brodie, M., Bernstein, P., Beech, D.: Third-Generation Database System Manifesto. ACM SIGMOD Record, Vol. 19,No. 4, Dec. 1990.Google Scholar
  36. 36.
    Chen, P.P.: The Entity-Relationship Model: Toward a Unified View of Data. ACM Transactions on Database Systems, Vol. 1, March 1976. pp. 9–37.Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 1999

Authors and Affiliations

  • Fernando de Ferreira Rezende
    • 1
  • Ulrich Hermsen
    • 1
  • Georgiane de Sá Oliveira
    • 1
  • Renata Costa Guedes Pereira
    • 1
  • Jochen Rütschlin
    • 1
  1. 1.Research and Technology – Dept. FT3/EKDaimlerChrysler AGUlmGermany

Personalised recommendations