CWM-BASED INTEGRATION OF XML DOCUMENTS AND OBJECT-RELATIONAL DATA

Iryna Kozlova, Martin Husemann, Norbert Ritter, Stefan Witt, Natalia Haenikel

Abstract

In today’s networked world, a plenitude of data is spread across a variety of data sources with different data models and structures. In order to leverage the potential of distributed data, effective methods for the integrated utilization of heterogeneous data sources are required. In this paper, we propose a model for the integration of the two predominant types of data sources, (object-)relational and XML databases. It employs the Object Management Group’s Common Warehouse Metamodel to resolve structural heterogeneity and aims at an extensively automatic integration process. Users are presented with an SQL view and an XML view on the global schema and can thus access the integrated data sources via both native query languages, SQL and XQuery.

References

  1. Bernstein, P. A. et al., 2000: A Vision for Management of Complex Models. In: SIGMOD Record, Vol. 29, pp. 55-63.
  2. Carey, M. et al., 1995: Towards heterogeneous multimedia information systems: The Garlic approach. In: Proc. of the 5th International Workshop on Research Issues in Data Engineering, pp. 124-131.
  3. IBM Corporation, 2002: XML Extender Administration and Programming, Version 8. ftp://ftp.software.ibm. com/ps/products/db2/info/vr8/pdf/letter/db2sxe80.pdf Fernandez, M. et al., 2000: SilkRoute: Trading between relations and XML. In: WWW9/Computer Networks, 33(16), pp. 723-745.
  4. Garcia-Molina, H. et al., 1997: The TSIMMIS Approach to Mediation: Data Models and Languages. In: Journal of Intelligent Information Systems, vol. 8, pp. 117- 132.
  5. Halevy, A., 2000: Logic-based techniques in data integration. In: Logic Based Artificial Intelligence, pp. 575-595.
  6. Härder, T. et al., 1999: The intrinsic problems of structural heterogeneity and an approach to their solution. In: The VLDB Journal, 8, pp. 25-43.
  7. Higgins, S. et al., 2002: Oracle 9i XML Developers Guide - Oracle XML DB, Release 2 (9.2). Oracle Corporation.
  8. International Organization for Standardization. ISO/IEC 9075-14:2003: Information technology - Database languages - SQL - Part 14: XML-Related Specifications (SQL/XML).
  9. Ludäscher, B. et al., 1998: Managing Semistructured data with FLORID: A Deductive Object-Oriented Perspective. In: Information Systems, 23(8), pp. 589- 612.
  10. Madhavan, J. et al., 2001: Generic Schema Matching with Cupid. In: Proceedings of the 27th VLDB Conference, Roma, Italy, pp. 49-58.
  11. Microsoft Corporation, 2004: SQL Server 2000 Product Documentation. http//www.microsoft.com/sql/ techinfo/productdoc/2000/books.asp
  12. Manolescu, I. et al., 2001: Answering XML queries over heterogeneous data sources. In: Proc. of the 27th VLDB Conf., Roma, Italy.
  13. OMG, 2003: Common Warehouse Metamodel (CWM) Specification, Version 1.1 Volume 1. Object Management Group (OMG) Specification.
  14. Pottinger, R. A., Bernstein, P. A., 2003: Merging Models Based on Given Correspondences. In: Proc. of the 29th VLDB Conference, Berlin, Germany, pp. 862- 873.
  15. Rahm, E., Bernstein, P. A., 2001: A Survey of Approaches to Automatic Schema Matching. In: VLDB Journal 10(4), pp. 334-350.
  16. Shanmugasundaram, J. et al., 2001: Querying XML views of relational data. In: Proc. of the 27th VLDB Conference, Roma, Italy.
  17. Tamino XML Server, Software AG, 2004: http://www2.softwareag.com/corporate/products/ tamino/default.asp
  18. W3C, 2001a: XML Schema Part 1: Structures. W3C Recommendation.
  19. W3C, 2001b: XML Schema Part 2: Datatypes. W3C Recommendations.
Download


Paper Citation


in Harvard Style

Kozlova I., Husemann M., Ritter N., Witt S. and Haenikel N. (2005). CWM-BASED INTEGRATION OF XML DOCUMENTS AND OBJECT-RELATIONAL DATA . In Proceedings of the Seventh International Conference on Enterprise Information Systems - Volume 1: ICEIS, ISBN 972-8865-19-8, pages 35-43. DOI: 10.5220/0002523300350043


in Bibtex Style

@conference{iceis05,
author={Iryna Kozlova and Martin Husemann and Norbert Ritter and Stefan Witt and Natalia Haenikel},
title={CWM-BASED INTEGRATION OF XML DOCUMENTS AND OBJECT-RELATIONAL DATA},
booktitle={Proceedings of the Seventh International Conference on Enterprise Information Systems - Volume 1: ICEIS,},
year={2005},
pages={35-43},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0002523300350043},
isbn={972-8865-19-8},
}


in EndNote Style

TY - CONF
JO - Proceedings of the Seventh International Conference on Enterprise Information Systems - Volume 1: ICEIS,
TI - CWM-BASED INTEGRATION OF XML DOCUMENTS AND OBJECT-RELATIONAL DATA
SN - 972-8865-19-8
AU - Kozlova I.
AU - Husemann M.
AU - Ritter N.
AU - Witt S.
AU - Haenikel N.
PY - 2005
SP - 35
EP - 43
DO - 10.5220/0002523300350043