METU interoperable database system

ABSTRACT

METU INteroperable Database System (MIND) is a multidatabase system that aims at achieving interoperability among heterogeneous, federated DBMSs. MIND architecture if based on OMG distributed object management model. It is implemented on top of a CORBA compliant ORB, namely, ObjectBroker. MIND provides users a single ODMG-93 compliant common data model, and a single global query language based on SQL. This makes it possible to incorporate both relational and object oriented databases into the system. Currently Oracle 7, Sybase and METU OODBMS (MOOD) have been incorporated into MIND. The main components of MIND are a global query processor, a global transaction manager, a schema integrator, interfaces to supported database systems and a user graphical interface.In MIND all local databases are encapsulated in a generic database object with a well defined single interface. This approach hides the differences between local databases from the rest of the system. The integration of export schemas is currently performed manually by using an object definition language (ODL) which is based on OMG's interface definition language. The DBA builds the integrated schema as a view over export schemas. the functionalities of ODL allow selection and restructuring of schema elements from existing local schemas.MIND global query optimizer aims at maximizing the parallel execution of the intersite joins of the global subqueries. Through MIND global transaction manager, the serializable execution of the global transactions are provided.

REFERENCES

• 1: R. G. G. Cattell , Douglas K. Barry , Dirk Bartels , Mark Berler , Jeff Eastman , Sophie Gamerman , David Jordan , Adam Springer , Henry Strickland , Drew Wade, The object database standard: ODMG 2.0, Morgan Kaufmann Publishers Inc., San Francisco, CA, 1997
• 2: [DEC 94a] The Guide to CORBA, Digital Equipment Corp., August 1994.
• 3: [DEC 94b] ObjectBroker, System Integrator's Guide, Digital Equipment Corp., August 1994.
• 4: [DEOO 94] Dogac, A., Evrendilek, C., Okay, T., Ozkan, C., "METU Object- Oriented DBMS", in Object-Oriented Database Systems, edited by Dogac, A., Ozsu, T., Biliris, A., Sellis, T., Springer-Verlag, 1994.
• 5: Asuman Dogac , Budak Arpinar , Cem Evrendilek , Cetin Ozkan , Ilker Altintas , Ilker Durusoy , Mehmet Altinel , Tansel Okay , Yuksel Saygin, METU object-oriented DBMS, Proceedings of the 1994 ACM SIGMOD international conference on Management of data, p.513, May 24-27, 1994, Minneapolis, Minnesota, United States
• 6: Asuman Dogac , Mehmet Altinel , Cetin Ozkan , Budak Arpinar , Ilker Durusoy , Ilker Altintas, METU Object-Oriented DBMS Kernel, Proceedings of the 6th International Conference on Database and Expert Systems Applications, p.14-27, September 04-08, 1995
• 7: Asuman Dogac , Mehmet Altinel , Cetin Ozkan , Ilker Durusoy, Implementation aspects of an object-oriented DBMS, ACM SIGMOD Record, v.24 n.1, p.9-14, March 1995 [doi>10.1145/202660.202662]
• 8: [EDNO 95] Evrendilek, C., Dogac, A., Nural, S., Ozcan, F., "Query Optimization in Multidatabase Systems", in Proc. of the Next Generation Information Technologies and Systems, Israel, June 1995.
• 9: D. Georgakopoulos , M. Rusinkiewicz , A. Sheth, Using Tickets to Enforce the Serializability of Multidatabase Transactions, IEEE Transactions on Knowledge and Data Engineering, v.6 n.1, p.166-180, February 1994 [doi>10.1109/69.273035]
• 10: [HFBK 94] Huck, G., Fankhauser, P., Busse, R., Klas, W., "IRO-DB : An Object-Oriented Approach towards Federated and Interoprable DBMSs", in Proc. of ADBIS '94, Moscow, May 1994.
• 11: [KOD 95] E. Kilic, G. Ozhan, C. Dengi, N. Kesim, P. Koksal and A. Dogac, "Experiences in Using CORBA in a Multidatabase Implementation", in Proc. of 6th Intl. Workshop on Database and Expert System Applications, London, Sept. 1995.
• 12: [OMG 91] Object Management Group, "The Common Object Request Broker: Architecture and Specification", OMG Document Number 91.12.1, December 1991.
• 13: [OMG 94] Object Management Group, "The Common Object Services Specification, Volume 1", OMG Document Number 94.1.1, January 1994.
• 14: [ORACLE 92] Programmer's Guide to the Oracle Call Interfaces, Oracle Corporation, December 1992.
• 15: [SYBASE 90] Open Client DB-Library /C Reference Manual, Sybase Inc., November 1990.
• 16: Aidong Zhang , Ahmed K. Elmagarmid, A theory of global concurrency control in multidatabase systems, The VLDB Journal — The International Journal on Very Large Data Bases, v.2 n.3, July 1993

INDEX TERMS

Primary Classification:
  H. Information Systems
  H.2 DATABASE MANAGEMENT

Additional Classification:
  H. Information Systems
  H.2 DATABASE MANAGEMENT

General Terms:
Design, Management, Performance, Theory