KEYS GRAPH - BASED RELATIONAL TO XML TRANSLATION ALGORITHM

Wilmondes Manzi de Arantes Júnior, Christine Verdier

Abstract

The authors propose two algorithms for generating a DTD and an XML document respectively from the metadata and the content of a relational database without any intermediary language or user intervention. Such algorithms always generate semantically correct XML output by respecting database functional dependencies represented in a graph structure they take as input. Finally, different XML representations (or views) meeting expectations of different kind of users can be obtained from the same data according to the data entity chosen as translation pivot.

References

  1. Carey M., Florescu D., Ives Z. et. al., 'XPERANTO: Publishing Object-Relational Data as XML', Workshop on the Web and Databases, 2000.
  2. Fernandez M., Morishima F., Suciu D. et. al., 'Publishing Relational Data in XML: the SilkRoute Approach', Data Engineering, 24:2 (2001), 12-19.
  3. Fernandez M., Suciu D., Tan W., 'SilkRoute: trading between relations and XML', In Proceedings of the WWW9, pages 723-746, Amsterdam, 2000.
  4. Flory A., Kouloumdjian J. 1978, 'A model and a method for logical database design'. In 4th int. conf. on VLDB, Berlin, 333-350.
  5. Kleiner C., Lipeck U. W., 'Automatic Generation of XML DTDs from Conceptual Database Schemas', GI Jahrestagung (1) 2001: 396-405.
  6. Lee D., Mani M., Chiu F. et al., 'Nesting-based Relational-to-XML Schema Translation', In International Workshop on the Web and Databases, Santa Barbara, CA, May 2001.
  7. Lee D., Mani M., Chiu F. et. al., 'NeT & CoT: Translating Relational Schemas to XML Schemas using Semantic Constraints', In: 11th ACM CIKM Conference, McLean, USA, 2002.
  8. Lewis B., 'Extraction of XML from Relational Databases', EDBT Workshops 2002: 228-241.
  9. Liu C., Liu J., Guo M., 'On Transformation to Redundancy Free XML Schema from Relational Database Schema', APWeb 2003: 35-46.
  10. Manzi W., Verdier C., Flory A., 'XML-Based Document to Query a Relational Database', ICEIS 2002: 26-33.
  11. Shanmugasundaram J., Shekita E., Barr R. et. al., 'Efficiently Publishing Relational Data as XML Documents', VLDB Conference, 2000.
  12. Turau V., 'Making Legacy Data Accessible For XML Applications', 1999.
  13. Vittori C. M., Dorneles C.F., Heuser C.A., 'Creating XML Documents from Relational Data Sources', EC-Web 2001: 60-70.
Download


Paper Citation


in Harvard Style

Manzi de Arantes Júnior W. and Verdier C. (2004). KEYS GRAPH - BASED RELATIONAL TO XML TRANSLATION ALGORITHM . In Proceedings of the Sixth International Conference on Enterprise Information Systems - Volume 1: ICEIS, ISBN 972-8865-00-7, pages 142-148. DOI: 10.5220/0002645801420148


in Bibtex Style

@conference{iceis04,
author={Wilmondes Manzi de Arantes Júnior and Christine Verdier},
title={KEYS GRAPH - BASED RELATIONAL TO XML TRANSLATION ALGORITHM},
booktitle={Proceedings of the Sixth International Conference on Enterprise Information Systems - Volume 1: ICEIS,},
year={2004},
pages={142-148},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0002645801420148},
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 - KEYS GRAPH - BASED RELATIONAL TO XML TRANSLATION ALGORITHM
SN - 972-8865-00-7
AU - Manzi de Arantes Júnior W.
AU - Verdier C.
PY - 2004
SP - 142
EP - 148
DO - 10.5220/0002645801420148