Providing Database Interoperability through Object-Oriented Language Constructs

Seamless access to resources and services provided by distributed, autonomous, and heterogeneous systems is central to many advanced applications. Building an integrated system to provide such uniform access and cooperation among underlying heterogeneous systems is both an increasing necessity and a formidable challenge. An important component of such a complex integrated system is a unified language that serves both as a data definition and as a data manipulation tool. Special requirements are posed in the instance of an integrated system which includes database systems among its components. In this paper, we introduce the necessary constructs that an object-oriented programming language should provide for being adopted as the language of the integrated system in such a setting. We adopt a modular, object-based approach to integration. Each component system that joins the integration provides a set of basic classes and pre-defined basic methods. We show how the class hierarchy of the system can be used to provide a uniform way of mapping database resources to basic classes and associative queries to basic methods. A view mechanism is introduced that supports the integration of the basic classes and provides a means of expressing relationships among them and resolving any potential conflicts. The view mechanism is implemented by extending the standard class constructors of an object-oriented language to support the definition of virtual classes. The language provides workflow constructs for defining the structure of programs and for attaining synchronization among concurrently executing programs. Furthermore, atomicity and concurrency control information is included in the form of consistency assertions as part of the interface of each basic method.

[1]  John R. Nicol,et al.  Object orientation in heterogeneous distributed computing systems , 1993, Computer.

[2]  Divyakant Agrawal,et al.  Relative Serializability: An Approach for Relaxing the Atomicity of Transactions , 1997, J. Comput. Syst. Sci..

[3]  Umeshwar Dayal,et al.  View Definition and Generalization for Database Integration in a Multidatabase System , 1984, IEEE Transactions on Software Engineering.

[4]  Andreas Reuter,et al.  The ConTract Model , 1991, Database Transaction Models for Advanced Applications.

[5]  Michael Schrefl,et al.  Object class definition by generalization using upward inheritance , 1988, Proceedings. Fourth International Conference on Data Engineering.

[6]  Jan Chomicki,et al.  Declarative Definition of Object-Oriented Multidatabase Mappings , 1992, IWDOM.

[7]  Ahmed K. Elmagarmid,et al.  Object orientation in multidatabase systems , 1995, CSUR.

[8]  Jennifer Widom,et al.  Research problems in data warehousing , 1995, CIKM '95.

[9]  Ahmed K. Elmagarmid,et al.  A Multidatabase Transaction Model for InterBase , 1990, VLDB.

[10]  Elisa Bertino,et al.  Integration of heterogeneous data repositories by using object-oriented views , 1991, [1991] Proceedings. First International Workshop on Interoperability in Multidatabase Systems.

[11]  Bertrand Meyer,et al.  Systematic concurrent object-oriented programming , 1993, CACM.

[12]  Gerhard Weikum,et al.  Semantic concurrency control in object-oriented database systems , 1993, Proceedings of IEEE 9th International Conference on Data Engineering.

[13]  James A. Larson,et al.  Federated Database Systems , 1999 .

[14]  M. Tamer Özsu,et al.  Using semantic knowledge of transactions to increase concurrency , 1989, TODS.

[15]  Ahmed K. Elmagarmid,et al.  Object-oriented multidatabase systems: an overview , 1995 .

[16]  Ahmed K. Elmagarmid,et al.  IPL: a multidatabase transaction specification language , 1993, [1993] Proceedings. The 13th International Conference on Distributed Computing Systems.

[17]  Gio Wiederhold,et al.  Mediators in the architecture of future information systems , 1992, Computer.

[18]  Markus Tresch,et al.  Updatable Views in Object-Oriented Databases , 1991, DOOD.

[19]  José A. Blakeley,et al.  Architecture of an open object-oriented database management system , 1992, Computer.

[20]  Sandra Heiler,et al.  Distributed Object Management , 1992, Int. J. Cooperative Inf. Syst..

[21]  Johannes Klein Advanced rule driven transaction management , 1991, COMPCON Spring '91 Digest of Papers.

[22]  Stanley B. Zdonik,et al.  Object views: Extending the vision , 1990, [1990] Proceedings. Sixth International Conference on Data Engineering.

[23]  Ambuj K. Singh,et al.  Consistency and orderability: semantics-based correctness criteria for databases , 1993, TODS.

[24]  Mike P. Papazoglou,et al.  An object-oriented approach to distributed data management , 1990, J. Syst. Softw..

[25]  Claus H. Pedersen,et al.  Extending ordinary inheritance schemes to include generalization , 1989, OOPSLA '89.

[26]  Amit P. Sheth,et al.  Specifying and Enforcing Intertask Dependencies , 1993, VLDB.

[27]  William E. Weihl Commutativity-based concurrency control for abstract data types , 1988 .

[28]  Randall B. Smith,et al.  Self: The power of simplicity , 1987, OOPSLA 1987.

[29]  Evaggelia Pitoura,et al.  Extending an object-oriented programming language to support the integration of heterogeneous database systems , 1995, Proceedings of the Twenty-Eighth Annual Hawaii International Conference on System Sciences.

[30]  Narain H. Gehani,et al.  ASSET: a system for supporting extended transactions , 1994, SIGMOD '94.

[31]  Marek Rusinkiewicz,et al.  A decentralized deadlock-free concurrency control method for multidatabase transactions , 1992, [1992] Proceedings of the 12th International Conference on Distributed Computing Systems.

[32]  Elisa Bertino,et al.  A View Mechanism for Object-Oriented Databases , 1992, EDBT.

[33]  Serge Abiteboul,et al.  Objects and views , 1991, SIGMOD '91.

[34]  A. Elmagarmid Database transaction models for advanced applications , 1992 .

[35]  Amihai Motro,et al.  Superviews: Virtual Integration of Multiple Databases , 1987, IEEE Transactions on Software Engineering.

[36]  Thanasis Hadzilacos,et al.  Transaction Synchronisation in Object Bases , 1991, J. Comput. Syst. Sci..

[37]  Stefano Ceri,et al.  Towards Megaprogramming , 1990 .

[38]  Stefano Ceri,et al.  Toward megaprogramming , 1992, CACM.

[39]  Amit P. Sheth,et al.  Specification and Execution of Transactional Workflows , 1995, Modern Database Systems.

[40]  Weimin Du,et al.  An overview of Pegasus , 1993, Proceedings RIDE-IMS `93: Third International Workshop on Research Issues in Data Engineering: Interoperability in Multidatabase Systems.

[41]  Jay Banerjee,et al.  Data model issues for object-oriented applications , 1987, TOIS.

[42]  Gio Wiederhold,et al.  Views, Objects, and Databases , 1986, Computer.

[43]  Erich J. Neuhold,et al.  ViewSystem: integrating heterogeneous information bases by object-oriented views , 1990, [1990] Proceedings. Sixth International Conference on Data Engineering.