Skip to main content
SpringerLink
Log in

Providing Database Interoperability through Object-Oriented Language Constructs

  • Published:
Journal of Systems Integration

Abstract

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.

This is a preview of subscription content, log in via an institution to check access.

Access this article

Log in via an institution

Price excludes VAT (USA)
Tax calculation will be finalised during checkout.

Instant access to the full article PDF.

Institutional subscriptions

Similar content being viewed by others

References

  1. S. Abiteboul and A. Bonner. “Objects and views,” in Proceedings of the ACMSIGMOD, 1991, pp. 238–247.

  2. D. Agrawal, A. E. Abbadi, and A. K. Singh. “Consistency and orderability: Semantics-based correctness criteria for databases.” ACM Transactions on Database Systems 18(3), pp. 460–486, September 1993.

    Google Scholar 

  3. D. Agrawal, J. Bruno, A. Abbadi, and V. Krishnaswamy. “Relative serializability: An approach for relaxing the atomicity of transactions,” in Proceedings of the 13th ACM Symposium on Principles of Database Systems, 1994, pp. 139–149.

  4. R. Ahmed, J. Albert, W. Du, W. Kent, W. Litwin, and M-C. Shan. “An Overview of Pegasus,” in Proceedings of the RIDE-IMS, April 1993, pp. 273–277.

  5. P. Attie, M. Singh, A. Sheth, and M. Rusinkiewicz. “Specifying and enforcing intertask dependencies,” in Proceedings of the 9th International Conference on Very Large Database Systems, 1993, pp. 134–144.

  6. J. Banerjee, H-T. Chou, J. F. Garza, W. Kim, D. Woelk, and N. Ballou. “Data model issues for object-oriented applications.” ACM Transactions on Office Information Systems 5(4), pp. 3–26, January 1987.

    Google Scholar 

  7. C. Batini, M. Lenzerini, and S. B. Navathe. “Comparison of methodologies for database schema integration.” ACM Computing Surveys 18(4), pp. 323–364, 1986.

    Google Scholar 

  8. P. K. Batra, M. Rusinkiewics, and D. Georgakopoulos. “A decentralized deadlock-free concurrency control method for multidatabase transactions,” in Proceedings of the 12th International Conference on Distributed Computing Systems, June 1992.

  9. E. Bertino. “Integration of heterogeneous data repositories by using object-oriented views,” in Proceedings of the First International Workshop on Interoperability in Multidatabase Systems, April 1991, pp. 22–29.

  10. E. Bertino. “A view mechanism for object-oriented databases.” In A. Pirotte, C. Delobel, and G. Gottlob, editors, '92, pp. 136–151. Springer Verlag, 1992.

  11. A. Biliris, S. Dar, N. Gehani, H. V. Jagadish, and K. Ramamritham. “ASSET: A system for supporting extended transactions,” in Proceedings of the 1994 SIGMOD Conference, May 1994, pp. 44–54.

  12. J. Chen, O. Bukhres, and A. K. Elmagarmid. “IPL: A multidatabase transaction specification language,” in Proceedings of the 1993 International Conference on Distributed Computing, 1993.

  13. J. Chomicki and W. Litwin. “Declarative definition of object-oriented multidatabase mappings,” in Proceedings of the International Workshop on Distributed Object Management, Edmonton, Canada, August 1992, pp. 307–325.

    Google Scholar 

  14. U. Dayal and H. Hwang. “View definition and generalization for database integration in a multidatabase system.” IEEE Transactions on Software Engineering 10(6), pp. 628–645, 1984.

    Google Scholar 

  15. A. K. Elmagarmid, editor. Database Transaction Models for Advanced Applications. Morgan Kaufmann, 1992.

  16. A. K. Elmagarmid, Y. Leu, W Litwin, and M. Rusinkiewics. “A multidatabase transaction model for InterBase,” in Proceedings of the 16th International Conference on Very Large Data Bases, August 1990, pp. 507–518.

  17. A. A. Farrag and M. T. Ozsu. #x201C;Using semantic knowledge of transactions to increase concurrency.” ACM Transactions on Database Systems 14(4), pp. 503–525, December 1989.

    Google Scholar 

  18. Object Management Group. “The common object request broker: Architecture and specification.” OMG Document Number 91.12.1, December 1991.

  19. T. Hadjilacos and V. Hadjilacos. “Transaction synchronization in object bases.” Journal of Computer and System Sciences 43, pp. 2–24, 1991.

    Google Scholar 

  20. S. Heiler and S. Zdonik. “Object views: Extending the vision,” in Proceedings of the 6th International Conference on Data Engineering, 1990, pp. 86–93.

  21. M. Kaul, K. Drosten, and E.J. Neuhold. “Viewsystem: integrating heterogeneous information bases by object-oriented views.” In IEEE International Conference on Data Engineering, 1991, pp. 2–10.

  22. J. Klein. “Advanced rule driven transaction management,” in Proceedings of the IEEE COMPCON, 1991.

  23. F. Manola, S. Heiler, D. Georgakopoulos, M. Hornick, and M. Brodie. “Distributed object management.” International Journal of Intelligent and Cooperative Information Systems 1(1), June 1992.

  24. B. Meyer. “Systematic concurrent object-oriented programming.” Communications of the ACM 36(9), pp. 56–80, September 1993.

    Google Scholar 

  25. A. Motro. “Superviews: Virtual integration of multiple databases.” IEEE Transactions on Software Engineering 13(7), pp. 785–798, July 1987.

    Google Scholar 

  26. P. Muth, T. C. Rakow, G. Weikum, P. Brossler, and C. Hasse. “Semantic concurrency control in object-oriented database systems,” in Proceedings of the 9th International Conference on Data Engineering, 1993, pp. 233–242.

  27. J. R. Nicol, C. T. Wilkes, and F. A. Manola. “Object orientation in heterogeneous distributed computing systems.” IEEE Computer 26(6), pp. 57–67, June 1993.

    Google Scholar 

  28. S. Owiski and D. Gries. “An axiomatic proof technique for parallel programs.” Acta Informatica 6, pp. 319–340, 1976.

    Google Scholar 

  29. M. P. Papazoglou and L. Marinos. “An object-oriented approach to distributed data management.” Journal of Systems and Software 11(2), pp. 95–109, February 1990.

    Google Scholar 

  30. C. H. Pedersen. “Extending ordinary inheritance schemes to include generalization,” in '89, October 1989, pp. 407–417.

  31. E. Pitoura, O. Bukhres, and A. Elmagarmid. “Object-orientation in multidatabase systems.” ACM Computing Surveys 27(2), pp. 141–195, June 1995.

    Google Scholar 

  32. E. Pitoura, O. Bukhres, and A. Elmagarmid. “Object-oriented multidatabase systems: An overview.” In A. Elmagarmid and O. Bukhres, editors, Object-Oriented Multidatabases. Prentice Hall, 1996.

  33. Evaggelia Pitoura. “Extending an object-oriented programming language to support the integration of database systems.” In 28th Annual Hawaii International Conference on System Sciences (HICSS-28), Maui, Hawaii, Jan. 1995, pp. 707–716.

  34. M. Rusinkiewicz and A. Sheth. “Specification and execution of transactional workflows.” In W. Kim, editor, Modern Database Systems, pp. 592–620. Addison Wesley, 1995.

  35. M. H. Scholl, C. Laasch, and M. Tresch. “Updatable views in object-oriented databases,” in Proceedings of the 2nd International Conference on Deductive and Object-Oriented Databases, Munich, Germany, December 1991, pp. 188–207.

  36. M. Schrefl and E. J. Neuhold. “Object class definition by generalization using upward inheritance,” in Proceedings of the IEEE International Conference on Data Engineering, 1988, pp. 4–13.

  37. A. Sheth and J. Larson. “Federated database systems.” ACM Computing Surveys 22(3), pp. 183–236, September 1990.

    Google Scholar 

  38. D. Ungar and R. B. Smith. “Self: The power of simplicity,” in '87, October 1987, pp. 227–242.

  39. H. Wachter and A. Reuter. “The ConTract model.” In Ahmed K. Elmagarmid, editor, Database Transaction Models for Advanced Applications, pp. 239–264. Morgan Kaufmann, 1992.

  40. William E. Weihl. “Commutativity-based concurrency control for abstract data types.” IEEE Transactions on Computers 37(12), pp. 1488–1505, 1988.

    Google Scholar 

  41. D. L. Wells, J. A. Blakeley, and G. W. Thompsosn. “Architecture of an open object-oriented database management system.” IEEE Computer 25(10), pp. 74–82, October 1992.

    Google Scholar 

  42. J. Widom. “Research problems in data warehousing,” in '95), November 1995, pp. 25–30.

  43. G. Wiederhold. “Views, objects, and databases.” IEEE Computer, pp. 37–44, December 1986.

  44. G. Wiederhold. “Mediators in the architecture of future information systems.” IEEE Computer 25(3), pp. 38–49, March 1992.

    Google Scholar 

  45. G. Wiederhold, P. Wegner, and S. Ceri. “Towards megaprogramming.” Communications of the ACM 35(11), pp. 89–99, November 1992.

    Google Scholar 

Download references

Authors
  1. Evaggelia Pitoura
    View author publications

    You can also search for this author in PubMed Google Scholar

Rights and permissions

Reprints and permissions

About this article

Cite this article

Pitoura, E. Providing Database Interoperability through Object-Oriented Language Constructs. Journal of Systems Integration 7, 99–126 (1997). https://doi.org/10.1023/A:1008242720789

Download citation

  • Issue Date:

  • DOI: https://doi.org/10.1023/A:1008242720789

Search

Navigation