CONV2XML: RELATIONAL SCHEMA CONVERSION TO XML NESTED-BASED SCHEMA

Angela C. Duta, Ken Barker, Reda Alhajj

Abstract

Conversion of relational data to XML is a critical topic in the database area. This approach translates the rigid tabular structures of relational databases into hierarchical XML structures. Logical connections between bits of data depicted by relationships are represented more naturally by tree-like structures. Conv2XML and ConvRel are two algorithms for converting relational schema to XML Schema focusing on preserving the source relationships and their structural constraints. ConvRel translates each relationship individually into a nested XML structure. Conv2XML identifies complex nested structures capable of modelling all relationships existent in a relational database.

References

  1. Cormen, T. H., 2001. Introduction to Algorithms, Reading, The MIT Press, 2nd edition.
  2. Duta, A., Barker, K., and Alhajj R., 2004. ConvRel: Relationship conversion to XML nested structures (to appear). In ACM Symposium on Applied Computing (SAC'04), Cyprus, March, 2004.
  3. Elmasri, R., and Navathe, S. B., 2003. Fundamentals of Database Systems, Addison-Wesley, 4th edition.
  4. Fernandez, M., Tan, W.-C., and Suciu, D., 2000. SilkRoute: Trading between Relations and XML. In International World Wide Web Conference (WWW), Amsterdam, Netherlands, May 2000.
  5. Lee, D., Mani, M., Chiu, F. and Chu, W. W., 2002. NeT & CoT: Translating Relational Schemas to XML Schemas using Semantic Constraints. In 11th ACM Int'l Conf. on Information and Knowledge Management (CIKM), McLean, VA, USA, November 2002.
  6. Lee, D., Mani, M., Chiu, F. and Chu, W. W., 2001. Nesting-based Relational-to-XML Schema Translation. In International Workshop on the Web and Databases (WebDB), Santa Barbara, CA, USA, May 2001.
  7. Lee, D., Mani, M. and Chu, W. W., 2002. Effective Schema Conversions between XML and Relational Models. In European Conference on Artificial Intelligence (ECAI), Knowledge Transformation Workshop(ECAI-OT), Lyon, France, July 2002.
  8. Turau V., 1999. Making Legacy Data Accessible for XML Applications. [Internet] Available from <http://citeseer.nj.nec.com/turau99making.html> [Accessed January 15th, 2004]
  9. World Wide Web Consortium, 2001. XML Schema Part 0, 1, and 2. [Internet] Available from <http://www.w3.org/TR> [Accessed January 19th, 2004]
Download


Paper Citation


in Harvard Style

C. Duta A., Barker K. and Alhajj R. (2004). CONV2XML: RELATIONAL SCHEMA CONVERSION TO XML NESTED-BASED SCHEMA . In Proceedings of the Sixth International Conference on Enterprise Information Systems - Volume 1: ICEIS, ISBN 972-8865-00-7, pages 210-215. DOI: 10.5220/0002619902100215


in Bibtex Style

@conference{iceis04,
author={Angela C. Duta and Ken Barker and Reda Alhajj},
title={CONV2XML: RELATIONAL SCHEMA CONVERSION TO XML NESTED-BASED SCHEMA},
booktitle={Proceedings of the Sixth International Conference on Enterprise Information Systems - Volume 1: ICEIS,},
year={2004},
pages={210-215},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0002619902100215},
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 - CONV2XML: RELATIONAL SCHEMA CONVERSION TO XML NESTED-BASED SCHEMA
SN - 972-8865-00-7
AU - C. Duta A.
AU - Barker K.
AU - Alhajj R.
PY - 2004
SP - 210
EP - 215
DO - 10.5220/0002619902100215