Previous [ 1] [ 2] [ 3] [ 4] [ 5] [ 6] [ 7] [ 8] [ 9] [ 10] [ 11] [ 12] [ 13] [ 14] [ 15] [ 16] [ 17] [ 18]


Journal of Information Science and Engineering, Vol. 25 No. 1, pp. 137-166 (January 2009)

A Translation Algorithm for Effective RDB-to-XML Schema Conversion Considering Referential Integrity Information*

Jinhyung Kim, Dongwon Jeong+ and Doo-Kwon Baik
Department of Computer Science and Engineering
Korea University
Sungbuk gu, Seoul 136-713, Republic of Korea
E-mail: {koolmania; baikdk}
+Department of Informatics and Statistics
Kunsan National University
Kunsan, Jollabuk do 573-701, Republic of Korea

In this paper, we propose a new relational schema (R-schema) to XML Schema translation algorithm that analyzes the cardinality between data values and patterns of user queries to resolve the implicit referential integrity issue. Many translation methods have been developed taking into account structural and/or semantic aspects. However, earlier methods have considered only the explicit referential integrity specified by the R-schema during translation or partially reflect the implicit referential integrity. It causes several problems such as incorrect translations, abnormal relational model transitions, and so on. In addition, many conventional translation algorithms support XML document type declaration (DTD) as the final translation result. However, it is insufficient to exactly represent the information of the R-schema. The VQT algorithm analyzes the value cardinality and user query patterns and extracts the implicit referential integrities by using the cardinality property of foreign key constraints between columns and the equi-join characteristic in user queries. The VQT algorithm can apply the extracted implied referential integrity relation information to the R-schema and create an XML Schema as the final result. Therefore, the VQT algorithm prevents the R-schema from incorrectly converting into the XML Schema, and it richly and powerfully represents all the information in the R-schema by creating an XML Schema as the translation result on behalf of the XML DTD.

Keywords: value cardinality, query pattern, relational schema, XML schema, explicit referential integrity relations, implicit referential integrity relations

Full Text () Retrieve PDF document (200901_08.pdf)

Received March 28, 2007; revised October 15, 2007 & May 13, 2008; accepted June 5, 2008.
Communicated by Tei-Wei Kuo.
* This work was supported by the 2nd Brain Korea 21 project.