Translating relational schema into XML schema definition with data semantic preservation and XSD graph

Fong, Joseph; Cheung, Sai On

doi:10.1016/j.infsof.2004.09.010

Cited by 33 publications

(23 citation statements)

References 13 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…This is mainly due to their lack of support for such semantics either in source or target data models, e.g., ER model and DTD lack support for inheritance. Despite the ability of UML to model data semantics such as aggregations and inheritances, UML is still weak and unsuitable for handling the hierarchical structure of the XML data model [23]. Although inheritance relationships could be indirectly realized in an RDB, they have been either ignored or only briefly considered.…”

Section: Discussionmentioning

confidence: 99%

“…To enrich a source RDB structurally and semantically, graphs and models are proposed as an intermediate stage [1,13,14,2,23]. A graph called an RID, developed by Alhajj [2], has been used to translate an RDB into an OODB [3] or into an XML [46].…”

Section: Conceptual Models Usedmentioning

confidence: 99%

“…However, inheritance and aggregation relationships are not considered properly in this study. Fong and Cheung introduced a method in which data semantics are extracted from an RDB schema into an EER model, which is then mapped into an XSD graph [23]. The XSD graph captures relationships and constraints and is mapped in turn into an XML Schema.…”

Section: Migrating Rdb Into Xmlmentioning

confidence: 99%

“…Vela and Marcos proposed a method for extending UML to represent an XML Schema in graphical notation, which has a unique equivalence with an XML Schema [45]. However, although UML can model data semantics such as aggregation and inheritance, it is still weak and unsuitable in handling the hierarchal structure of the XML data model [23].…”

Section: Migrating Rdb Into Xmlmentioning

confidence: 99%

See 3 more Smart Citations

Re-engineering relational databases

Maatuk

Ali

Rossiter

2011

Proceedings of the 2011 International Conference on Intelligent Semantic Web-Services and Applications

View full text Add to dashboard Cite

This paper surveys the recent literature about various research trends relevant to Relational DataBase (RDB) reengineering. The paper presents an analysis of approaches and techniques used in this context, including construction of object views on top of RDBs, database integration and database migration. A categorisation is presented of the selected work, concentrating on migrating an RDB as a source into object-based and XML databases as targets. Database migration from the source into each of the targets is discussed and critically evaluated, including the semantic enrichment, schema translation and data conversion. Based on a detailed analysis of the existing literature, it seems that the existing work does not provide a complete solution for more than one target database for either schema or data conversion. Besides, none of the existing proposals can be considered as a method for migrating an RDB into an objectrelational database. We propose such a method based on an intermediate canonical data model, which enriches the semantics of the source RDB and captures characteristics of the target databases.

show abstract

Section: Discussionmentioning

confidence: 99%

Section: Conceptual Models Usedmentioning

confidence: 99%

Section: Migrating Rdb Into Xmlmentioning

confidence: 99%

Section: Migrating Rdb Into Xmlmentioning

confidence: 99%

See 2 more Smart Citations

Re-engineering relational databases

Maatuk

Ali

Rossiter

2011

Proceedings of the 2011 International Conference on Intelligent Semantic Web-Services and Applications

View full text Add to dashboard Cite

show abstract

“…SQL query has used to extract relational database catalog, transform schema catalog into XML schema (XSD) and transform contents catalog into document tree [16]. Fong [17] investigated applying schema translation technique and transformed the Extended Entity Relationship (EER) into XML Schema (XSD). Yan-Feng Zhang et al [18] proposed converting XML Schema into UML diagram by clustering, restructuring, and unification of relationships, for providing a unified model for users.…”

Section: Related Workmentioning

confidence: 99%