Please use this identifier to cite or link to this item: http://hdl.handle.net/1959.3/37453

Title

Holistic constraint-preserving transformation from relational schema into XML schema

Author(s)

Zhou, Rui;  Liu, Chengfei;  Li, Jianxin

Abstract

In this paper, we propose a holistic scheme of transforming a relational schema into an XML Schema with integrity constraints preserved. This scheme facilitates constructing a schema for the published XML views of relational data. With this schema, users are able to issue qualified queries against XML views, and discover update anomalies in advance before propagating the view updates into relational database. Compared to the previous work which splits the transformation process into two steps, we establish a holistic solution to directly transform a relational schema into an XML Schema without building a reference graph. We achieve this by classifying the underlying relations in a more concise and effective way, and applying the converting rules wisely. The rules are also devised to be more compact and less complicated in contrast to those in our previous work. Finally, we manage to crack another hard nut which was seldom touched before, i.e. converting circularly referenced relations into recursive XML Schema.

Publication type

Conference paper

Research centre

Swinburne University of Technology. Faculty of Information and Communication Technologies

Source

Lecture notes in computer science: database systems for advanced application: Proceedings of the 13th International Conference on Database Systems for Advanced Applications (DASFAA 2008), New Delhi, India, 19-21 March 2008, Vol. 4947, pp. 4-18

Publication year

2008

Keyword(s)

Extensible markup language;  Relational data;  XML;  XML schemas

Publisher

Springer

ISBN

9783540785675

Publisher URL

http://dx.doi.org/10.1007/978-3-540-78568-2_4

Copyright

Copyright © 2008 Springer-Verlag Berlin Heidelberg.

Peer reviewed