Research Article Open Access

Query Pattern-based Relational Data to XML Data Translation Algorithm

Jinhyung Kim1, Dongwon Jeong1 and Doo-Kwon Baik1
  • 1 ,
Journal of Computer Science
Volume 3 No. 4, 2007, 212-217

DOI: https://doi.org/10.3844/jcssp.2007.212.217

Submitted On: 7 August 2006 Published On: 30 April 2007

How to Cite: Kim, J., Jeong, D. & Baik, D. (2007). Query Pattern-based Relational Data to XML Data Translation Algorithm. Journal of Computer Science, 3(4), 212-217. https://doi.org/10.3844/jcssp.2007.212.217

Abstract

This paper proposes a new query pattern-based relational schema-to-XML schema translation (QP-T) algorithm to resolve implicit referential integrity issue. Various translation methods have been introduced on structural aspects and/or semantic aspects. However, most of conventional methods consider only explicit referential integrities specified by relational schema. It causes several problems such as incorrect transformation, abnormal relational model transition and so on. Researches about syntactic/semantic structure extraction also have been executed in reverse-engineering part. Many systems or algorithms suggested in Reverse Engineering researches are so complicate and not proper to RDB-to-XML translation. Some of them just consider syntactic structure extraction and others reflect every structure and constraints. That is, most of methods in reverse engineering part include unnecessary part. The QP-T algorithm analyzes query pattern and extract implicit referential integrities through equi-join between columns. The QP-T algorithm was based on a concept that columns related to equi-join in relational schema can have referential integrity. The most distinct contribution of QP-T algorithm was to enhance extraction of referential integrity relation information for translation. Therefore, the QP-T algorithm reflects not only explicit referential integrities but also implicit referential integrities during RDB-to-XML translation.

  • 1,143 Views
  • 1,415 Downloads
  • 1 Citations

Download

Keywords

  • Relational schema model
  • query-pattern
  • XML schema model
  • referential integrity relation information