CONVERTING LEGACY RELATIONAL DATABASE INTO XML DATABASE THROUGH REVERSE ENGINEERING

Chunyan Wang, Anthony Lo, Reda Alhajj, Ken Barker

Abstract

XML (eXtensible Markup Language) has emerged and is being gradually accepted as the standard for data interchange over the Internet. Since most data is currently stored in relational database systems, the problem of converting relational data into XML assumes special significance. Many researchers have already done some accomplishments in this direction. They mainly focus on finding XML schema (e.g., DTD, XML-Schema, and RELAX) that best describes a given relational database with a corresponding well-defined database catalog that contains all information about tables, keys and constraints. However, not all existing databases can provide the required catalog information. Therefore, these applications do not work well for legacy relational database systems that were developed following the logical relational database design methodology, without being based on any commercial DBMS, and hence do not provide well-defined metadata files describing the database structure and constraints. In this paper, we address this issue by first applying the reverse engineering approach described in (Alhajj 2003) to extract the ER (Extended Entity Relationship) model from a legacy relational database, then convert the ER to XML Schema. The proposed approach is capable of reflecting the relational schema flexibility into XML schema by considering the mapping of binary and nary relationships. We have implemented a first prototype and the initial experimental results are very encouraging, demonstrating the applicability and effectiveness of the proposed approach.

References

  1. R. Alhajj, "Extracting the Extended EntityRelationship Model from a legacy Relational Database, " Information Systems, Vol.28, No.6, pp.597-618, 2003.
  2. M. Carey, et al, "XPERATO: Publishing ObjectRelational Data as XML," Proc. of the International Workshop on Web and Databases, May 2000.
  3. J. Cheng and J. Xu, IBM DB2 XML Extender, IBM Silcom Valley, February, 2000.
  4. M.F. Fernandez, W.C. Tan, and D. Suciu, "SilkRoute: Trading between Relational and XML," Proc. of the International Conference on World Wide Web, May 2000.
  5. J. Fong, F. Pang, and C. Bloor, "Converting Relational Database into XML Document," Proc. of the International Workshop on Electronic Business Hubs, pp61-65, Sep. 2001.
  6. G. Kappel, et al, "X-Ray - Towards Integrating XML and Relational Database Systems," Proc. of the International Conference on Conceptual Modeling, pp. 339-353, Salt Lake City, UT, Oct. 2000.
  7. C. Kleiner and U.W. Lipeck, "Automatic Generation of XML DTDs from Conceptual Database Schemas," University of Hannover, Germany, Sept 2001.
  8. D. Lee, et al, "Nesting based Relational-to-XML Schema Translation," Proc. of the International Workshop on Web and Databases, May 2001.
  9. M. Mani, D. Lee, and R. Muntz, "Semantic Data Modeling using XML Schemas," Department of Computer Science, University of California, Los Angeles, 2001.
  10. V. Turau, "Making Legacy Data Accessible for XML applications," 1999, http://www.informatik.fhwiesbaden.de/ turau/ps/legacy.pdf.
Download


Paper Citation


in Harvard Style

Wang C., Lo A., Alhajj R. and Barker K. (2004). CONVERTING LEGACY RELATIONAL DATABASE INTO XML DATABASE THROUGH REVERSE ENGINEERING . In Proceedings of the Sixth International Conference on Enterprise Information Systems - Volume 1: ICEIS, ISBN 972-8865-00-7, pages 216-221. DOI: 10.5220/0002645602160221


in Bibtex Style

@conference{iceis04,
author={Chunyan Wang and Anthony Lo and Reda Alhajj and Ken Barker},
title={CONVERTING LEGACY RELATIONAL DATABASE INTO XML DATABASE THROUGH REVERSE ENGINEERING},
booktitle={Proceedings of the Sixth International Conference on Enterprise Information Systems - Volume 1: ICEIS,},
year={2004},
pages={216-221},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0002645602160221},
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 - CONVERTING LEGACY RELATIONAL DATABASE INTO XML DATABASE THROUGH REVERSE ENGINEERING
SN - 972-8865-00-7
AU - Wang C.
AU - Lo A.
AU - Alhajj R.
AU - Barker K.
PY - 2004
SP - 216
EP - 221
DO - 10.5220/0002645602160221