Novel Approach for Reengineering Relational Databases into XML

Authors:
Chunyan Wang;Anthony Lo;Reda Alhajj;Ken Barker
Affiliations:
University of Calgary, Canada;University of Calgary, Canada;University of Calgary, Canada;University of Calgary, Canada
Venue:
ICDEW '05 Proceedings of the 21st International Conference on Data Engineering Workshops
Year:
2005

Citing 0
Cited 6

Know your limits: enhanced XML modeling with cardinality constraints

ER '07 Tutorials, posters, panels and industrial contributions at the 26th international conference on Conceptual modeling - Volume 83
VIREX and VRXQuery: interactive approach for visual querying of relational databases to produce XML

Journal of Intelligent Information Systems
XML materialized views and schema evolution in VIREX

Information Sciences: an International Journal
Re-engineering relational databases: the way forward

Proceedings of the 2011 International Conference on Intelligent Semantic Web-Services and Applications
Formal transformation from fuzzy object-oriented databases to fuzzy XML

Applied Intelligence
Incorporating fuzzy information into the formal mapping from web data model to extended entity-relationship model

Integrated Computer-Aided Engineering

Quantified Score

Hi-index	0.00

Visualization

Abstract

In this paper, we present COCALEREX (converting relational to XML) which can address both catalog-based and legacy relational databases. It handles the latter category by first applying the reverse engineering approach described in [2] to extract the ER (Extended Entity Relationship) model from legacy relational databases. This reverse engineering approach is emplyed also not to extract from catalog-based databases meta-data not available in the catalog. Then, COCALEREX converts the ER to XML schema. Deriving the ER model empowers the proposed approach to smoothly consider many-to-many and nary relationships during the mapping into XML schema.COCALEREX provides a user-friendly interface that displays the result of each phase of the conversion process. Experimental results are encouraging, demonstrating the applicability and effectiveness of the proposed approach.