REFERENTIAL INTEGRITY MODEL FOR XML DATA INTEGRATED FROM HETEROGENEOUS DATABASES SYSTEMS - Using the power of XML for consistent data integration

Mauri Ferrandin, Murilo S. de Camargo

Abstract

This article presents a proposal for maintenance of the referential integrity in data integrated from relational heterogeneous databases stored in XML materialized views. The central idea is the creation of a repository of rules that will have to be observed to if carrying through any operation of update in the mediating layer of a system for integration of heterogeneous relational sources of data to guarantee that the updates carried through in the data stored in this layer can be propagated to the relational databases that are part of the system integrated without causing problem of referential integrity in the same ones. This proposal has as main objective to specify a mechanism capable to guarantee that the data after exported from the relational heterogeneous databases in a mediating layer continue respecting the same integrity which these were submitted in the origin databases.

References

  1. ABITEBOUL, S.; BUNEMAN, P.; SUCIU, D. Data on the Web : From relations to semistructured data and XML. Morgan Kaufmann Publishers, San Francisco, CA, 2000.
  2. BUNEMAN, Peter; DAVIDSON, Susan; et al. Reasoning about Keys for XML (Technical Report). International Workshop on Database Programming Languages (DBPL), 2001. Disponível em http://db.cis.upenn.edu/DL/absreltr.ps.gz
  3. CASTRO, C. E. P. S.. Integração de Legacy Systems a Sistemas de Bancos de Dados Heterogêneos. Dissertação de Mestrado, Departamento de Informática, Pontifícia Universidade Católica do Rio de Janeiro, Rio de Janeiro, Jul. 1998.
  4. CHEN, Yi; DAVIDSON, Susan; ZHENG, Yifeng. Validating Constraints in XML. Department of Computer and Information Science, University of Pennsylvania, 2002. Disponível em http://db.cis.upenn.edu/DL/validate.ps.
  5. FERNANDEZ, M.; TAN, W. C.; SUCIU, D. SilkRoute: Trading between Relations and XML. University of Pennsylvania: [s.n.], 1999. Disponível em: < http://db.cis.upenn.edu/RXL/papers/sr.html>. Acesso em: 22 mar 2000.Technical Report.
  6. HULL, R. Managing semantic heterogeneity in databases : A theoretical perspective. In: ICDT, 1997. [s.n.], 1997.
  7. MURPHY, J. & GRIMSON, J.. Multidatabase Interoperability in the Jupiter System. Information and Software Technology. Vol 37, N. 9, 1995.
  8. QUAN, L.; CHEN, L.; RUNDENSTEINER, E. A. Argos: Efficient refresh in an XQL-based Web caching system. Lecture Notes in Computer Science, [S.l.], v.1997.
  9. WIEDERHOLD, G. Mediators in the architecture of future information systems. Computer Magazine of the Computer Group News of the IEEE Computer Group Society, [S.l.], 1992.
  10. ZHU, Y. et al. Materializing Web data for OLAP and DSS. In: WEB-AGE INFORMATION MANAGEMENT, 2000. [s.n.], 2000. p.201-214.
Download


Paper Citation


in Harvard Style

Ferrandin M. and S. de Camargo M. (2004). REFERENTIAL INTEGRITY MODEL FOR XML DATA INTEGRATED FROM HETEROGENEOUS DATABASES SYSTEMS - Using the power of XML for consistent data integration . In Proceedings of the Sixth International Conference on Enterprise Information Systems - Volume 1: ICEIS, ISBN 972-8865-00-7, pages 15-20. DOI: 10.5220/0002643800150020


in Bibtex Style

@conference{iceis04,
author={Mauri Ferrandin and Murilo S. de Camargo},
title={REFERENTIAL INTEGRITY MODEL FOR XML DATA INTEGRATED FROM HETEROGENEOUS DATABASES SYSTEMS - Using the power of XML for consistent data integration},
booktitle={Proceedings of the Sixth International Conference on Enterprise Information Systems - Volume 1: ICEIS,},
year={2004},
pages={15-20},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0002643800150020},
isbn={972-8865-00-7},
}


in EndNote Style

TY - CONF
JO - Proceedings of the Sixth International Conference on Enterprise Information Systems - Volume 1: ICEIS,
TI - REFERENTIAL INTEGRITY MODEL FOR XML DATA INTEGRATED FROM HETEROGENEOUS DATABASES SYSTEMS - Using the power of XML for consistent data integration
SN - 972-8865-00-7
AU - Ferrandin M.
AU - S. de Camargo M.
PY - 2004
SP - 15
EP - 20
DO - 10.5220/0002643800150020