Integrating View Schemata Using an Extended Object Definition Language

  • Mark Roantree
  • Jessie B. Kennedy
  • Peter J. Barclay
Conference paper
Part of the Lecture Notes in Computer Science book series (LNCS, volume 2172)


Viewm echanisms play an important role in restructuring data for users, while maintaining the integrity and autonomy for the underlying database schema. Although far more complex than their relational counterparts, numerous object-oriented viewm echanisms have been specified and implemented over the last decade. These viewmec hanisms have served different functions: viewsc hemata for object-oriented databases; object views of relational (and other) database systems, and the formation of federated schemata for distributed information systems. In the latter category there is still a significant amount of research required to construct a viewl anguage powerful enough to support federated views. Such a language (or set of languages) should support not only object views, but also a wrapper specification language for external information sources, and a set of restructuring and integration operators. Furthermore, with the advent of standard models and technologies such as CORBA for distribution, ODMG for storage, and XML for web publishing, these languages should be based upon, or cooperate with, these standards. In this research, we present a view mechanism which retains the semantic information incorporated in ODMG schemata, provide a set of operators which facilitate the restructuring and integration necessary to merge schemata, and provide wrappers to heterogenous systems such as legacy systems, ODBC databases, and XML data sources.


Database Schema Patient Class Common Data Model Virtual Class Patient Administration System 
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.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. 1.
    Abiteboul S. On Views and XML. SIGMOD Record 28:4, pp. 30–38, ACM Press, 1999. 151CrossRefGoogle Scholar
  2. 2.
    ANTLR Reference Manual. 1999. 160
  3. 3.
    Batini C., Lenzerini M. and Navathe S. A Comparative Analysis of Methodologies for Database Schema Integration. ACM Computing Surveys, 18:4, December 1986. 160Google Scholar
  4. 4.
    Bukhres O. and Elmagarmid A. (eds.), Object-Oriented Multidatabase Systems, Prentice Hall, 1996. 151Google Scholar
  5. 5.
    Cattel R. et. al. (eds.) (2000). The Object Data Standard: ODMG 3.0, Morgan Kaufmann.Google Scholar
  6. 6.
    Cattell R. and Barry D. (eds), The Object Database Standard: ODMG 2.0. Morgan Kaufmann, 1997. 150Google Scholar
  7. 7.
    Dos Santos C., Abiteboul S. amd Delobel C. Virtual schemas and bases. Advances in Database Technology (EDBT94), pp. 81–94, Springer, 1994. 151Google Scholar
  8. 8.
    Fahrner C. and Vossen G. Transforming Relational Database schemata into Object-Oriented schemata According to ODMG-93. Proceedings of 4th International Conference on Dedictive and Object-Oriented Databases (DOOD 95), pp 429–446, LNCS 1013, 1995. 160Google Scholar
  9. 9.
    Jordan D. C++ Object Databases: Programming with the ODMG Standard. Addison Wesley, 1998.Google Scholar
  10. 10.
    Motro A. Superviews: Visual Integration of Multiple Databases. IEEE Transactions on Software Engineering, 13:7, 1987. 151CrossRefGoogle Scholar
  11. 11.
    Roantree M., Murphy J. and Hasselbring W. The OASIS Multidatabase Prototype. ACM Sigmod Record, 28:1, March 1999. 151CrossRefGoogle Scholar
  12. 12.
    Roantree M., Kennedy J., and Barclay P. Using a Metadata Software Layer in Information Systems Integration. Proceedings of 13th Conference on Advanced Information Systems Engineering (CAiSE 2001), pp. 299–314, LNCS 2068, June 2001. 160Google Scholar
  13. 13.
    Roantree M., Kennedy J., and Barclay P. Interoperable Services for Federations of Database Systems. To appear in 5th East-European Conference on Advances in Databases and Information Systems (ADBIS 2001), Vilnius, September 2001. 161Google Scholar
  14. 14.
    Roantree M. Constructing ViewSc hemata Using an Extended Object Definition Language. PhD Thesis. Napier University, November 2000. 152, 153, 155, 158, 159, 160Google Scholar
  15. 15.
    Rundensteiner E. Multiview: A Methodology for Supporting Multiple Views in Object-Oriented Databases. Proceedings on the 18th International Conference on Very Large Databases (VLDB’92), pp 187–198, 1992. 151Google Scholar
  16. 16.
    Saltor F., Castellanos M. and Garcia-Solaco M. Suitability of Data models as Canonical Models for Federated Databases. ACM SIGMOD Record, 20:4, 1991. 151CrossRefGoogle Scholar
  17. 17.
    Sheth A and Larson J. Federated Database Systems for Managing Distributed, heterogeneous, and Autonomous Databases. ACM Computing Surveys, 22:3, pp 183–236, ACM Press, 1990. 150CrossRefGoogle Scholar
  18. 18.
    Scholl M., Schek H. and Tresch M. Object Algebra and Views for Multi-Objectbases. In Distributed Object Management, özsu, Dayel & Valdiurez (eds), pp. 353–374, Morgan Kaufmann, 1994. 151Google Scholar
  19. 19.
    Subieta K. Object-Oriented Standards: Can ODMG OQL be extended to a Programming Language? Proceedings of the International Symposium on Cooperative Database Systems for Advanced Applications, pp. 546–555, Japan, 1996. 156Google Scholar
  20. 20.
    Versant Corporation. Versant C++ Reference Manual 5.2, April 1999. 160Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 2001

Authors and Affiliations

  • Mark Roantree
    • 1
  • Jessie B. Kennedy
    • 2
  • Peter J. Barclay
    • 2
  1. 1.School of Computer ApplicationsDublin City UniversityDublinIreland
  2. 2.School of ComputingNapier UniversityEdinburghScotland

Personalised recommendations