Abstract
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.
Chapter PDF
Similar content being viewed by others
Keywords
- 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.
References
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.
Melton, J. (Ed.): Database Language SQL 2. ANSI, Washington, D.C., USA, 1990.
Date, C.J., Darwen, H.: A Guide to the SQL Standard. Addison-Wesley, 4th Ed., USA, 1997.
Härder, T., Mitschang, B., Nink, U., Ritter, N.: Workstation/Server Architectures for Database-Based Engineering Applications (in German). Informatik Forschung & Entwicklung, 1995.
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.
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.
Rezende, F.F.: Transaction Services for Knowledge Base Management Systems–Modeling Aspects, Architectural Issues, and Realization Techniques. infix Verlag, Germany, 1997.
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.
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.
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.
Roussopoulos, N., Delis, A.: Modern Client-Server DBMS Architectures. ACM SIGMOD Record, Vol. 20,No. 3, Sept. 1991. pp. 52–61.
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.
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.
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.
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.
Cood, E.F.: A Relational Model of Data for Large Shared Data Banks. Communications of the ACM, Vol. 13, 1970. pp. 377–387.
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.
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.
IBM Corporation: DB2 DataJoiner Administration Guide. IBM, 1997.
Sun Microsystems Inc. http://java.sun.com/products/jdbc/overview.html, 1998.
Hamilton, G., Cattell, R., Fisher, M.: JDBC Database Access with Java: A Tutorial and Annotated Reference, Addison-Wesley, USA, 1997.
Sun Microsystems Inc. http://java.sun.com/products/jdk/rmi/index.html, 1998.
Object Management Group. The Common Object Request Broker Architecture and Specification (CORBA), OMG, Framingham, USA, 1992.
Object Management Group. The Common Object Request Broker Architecture and Specification–Rev. 2.0, Technical Report, OMG, Framingham, USA, 1995.
Orfali, R., Harkey, D., Edwards, J.: The Essential Distributed Objects Survival Guide. John Wiley & Sons, USA, 1994.
Davis, T.E.: Build your own Object Pool in Java to Boost Application Speed. JavaWorld, http://www.javaworld.com/javaworld/jw-06-1998/jw-06-object-pool.html, Jun. 1998.
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.
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).
Garfinkel, S., Spafford, G.: Practical Unix & Internet Security. O’Reilly & Associates Inc., USA, 1996.
Fritzinger, J.S., Mueller, M.: Java Security. White Paper, Sun Microsystems Inc., 1996.
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).
Cattell, R.G.G. (Ed.): The Object Database Standard: ODMG-93. Morgan Kaufmann, USA, 1994.
Kim, W.: Introduction to Object-Oriented Databases. The MIT Press, Massachusetts, USA, 1990.
Loomis, M.E.S., Atwood, T., Cattell, R., Duhl, J., Ferran, G., Wade, D.: The ODMG Object Model. Joop, Jun. 1993. pp. 64–69.
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.
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.
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 1999 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
de Ferreira Rezende, F., Hermsen, U., de Sá Oliveira, G., Costa Guedes Pereira, R., Rütschlin, J. (1999). A Practical Approach to Access Heterogeneous and Distributed Databases. In: Jarke, M., Oberweis, A. (eds) Advanced Information Systems Engineering. CAiSE 1999. Lecture Notes in Computer Science, vol 1626. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-48738-7_24
Download citation
DOI: https://doi.org/10.1007/3-540-48738-7_24
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-66157-3
Online ISBN: 978-3-540-48738-8
eBook Packages: Springer Book Archive