An algorithm for extracting referential integrity relations using similarity during RDB-to-XML translation

Jangwon Kim, Dongwon Jeong, Jinhyung Kim, Doo Kwon Baik

Research output: Chapter in Book/Report/Conference proceedingConference contribution

1 Citation (Scopus)

Abstract

XML is rapidly becoming technologies for information exchange and representation. It causes many research issues such as semantic modeling methods, conversion for interoperability with other models, and so on. Especially, the most important issue in practical area is how to achieve the interoperability between XML model and relational database model. Until now, many methods have been proposed to achieve it. However, several problems still remain. Most of all, existing methods do not consider implicit referential integrity relations, so it causes loss of information. This paper proposes an algorithm for extracting referential integrity relations during RDB to XML translation. The key point of our method is how to find implicit referential integrity relations among columns which have different names to represent the same semantic. To resolve it, we define an enhanced extraction algorithm which based on a widely used ontology, WordNet. The proposed algorithm can reduce an extraction time among comparison columns in RDB tables and prevent loss of information.

Original languageEnglish
Title of host publicationProceedings - 2007 International Conference on Computational Intelligence and Security, CIS 2007
Pages157-161
Number of pages5
DOIs
Publication statusPublished - 2007 Dec 1
Event2007 International Conference on Computational Intelligence and Security, CIS'07 - Harbin, Heilongjiang, China
Duration: 2007 Dec 152007 Dec 19

Other

Other2007 International Conference on Computational Intelligence and Security, CIS'07
CountryChina
CityHarbin, Heilongjiang
Period07/12/1507/12/19

Fingerprint

XML
Interoperability
Semantics
Ontology

ASJC Scopus subject areas

  • Artificial Intelligence
  • Computational Theory and Mathematics

Cite this

Kim, J., Jeong, D., Kim, J., & Baik, D. K. (2007). An algorithm for extracting referential integrity relations using similarity during RDB-to-XML translation. In Proceedings - 2007 International Conference on Computational Intelligence and Security, CIS 2007 (pp. 157-161). [4415322] https://doi.org/10.1109/CIS.2007.81

An algorithm for extracting referential integrity relations using similarity during RDB-to-XML translation. / Kim, Jangwon; Jeong, Dongwon; Kim, Jinhyung; Baik, Doo Kwon.

Proceedings - 2007 International Conference on Computational Intelligence and Security, CIS 2007. 2007. p. 157-161 4415322.

Research output: Chapter in Book/Report/Conference proceedingConference contribution

Kim, J, Jeong, D, Kim, J & Baik, DK 2007, An algorithm for extracting referential integrity relations using similarity during RDB-to-XML translation. in Proceedings - 2007 International Conference on Computational Intelligence and Security, CIS 2007., 4415322, pp. 157-161, 2007 International Conference on Computational Intelligence and Security, CIS'07, Harbin, Heilongjiang, China, 07/12/15. https://doi.org/10.1109/CIS.2007.81
Kim J, Jeong D, Kim J, Baik DK. An algorithm for extracting referential integrity relations using similarity during RDB-to-XML translation. In Proceedings - 2007 International Conference on Computational Intelligence and Security, CIS 2007. 2007. p. 157-161. 4415322 https://doi.org/10.1109/CIS.2007.81
Kim, Jangwon ; Jeong, Dongwon ; Kim, Jinhyung ; Baik, Doo Kwon. / An algorithm for extracting referential integrity relations using similarity during RDB-to-XML translation. Proceedings - 2007 International Conference on Computational Intelligence and Security, CIS 2007. 2007. pp. 157-161
@inproceedings{2a9abc7cf0154270aaae532ca71db8dd,
title = "An algorithm for extracting referential integrity relations using similarity during RDB-to-XML translation",
abstract = "XML is rapidly becoming technologies for information exchange and representation. It causes many research issues such as semantic modeling methods, conversion for interoperability with other models, and so on. Especially, the most important issue in practical area is how to achieve the interoperability between XML model and relational database model. Until now, many methods have been proposed to achieve it. However, several problems still remain. Most of all, existing methods do not consider implicit referential integrity relations, so it causes loss of information. This paper proposes an algorithm for extracting referential integrity relations during RDB to XML translation. The key point of our method is how to find implicit referential integrity relations among columns which have different names to represent the same semantic. To resolve it, we define an enhanced extraction algorithm which based on a widely used ontology, WordNet. The proposed algorithm can reduce an extraction time among comparison columns in RDB tables and prevent loss of information.",
author = "Jangwon Kim and Dongwon Jeong and Jinhyung Kim and Baik, {Doo Kwon}",
year = "2007",
month = "12",
day = "1",
doi = "10.1109/CIS.2007.81",
language = "English",
isbn = "0769530729",
pages = "157--161",
booktitle = "Proceedings - 2007 International Conference on Computational Intelligence and Security, CIS 2007",

}

TY - GEN

T1 - An algorithm for extracting referential integrity relations using similarity during RDB-to-XML translation

AU - Kim, Jangwon

AU - Jeong, Dongwon

AU - Kim, Jinhyung

AU - Baik, Doo Kwon

PY - 2007/12/1

Y1 - 2007/12/1

N2 - XML is rapidly becoming technologies for information exchange and representation. It causes many research issues such as semantic modeling methods, conversion for interoperability with other models, and so on. Especially, the most important issue in practical area is how to achieve the interoperability between XML model and relational database model. Until now, many methods have been proposed to achieve it. However, several problems still remain. Most of all, existing methods do not consider implicit referential integrity relations, so it causes loss of information. This paper proposes an algorithm for extracting referential integrity relations during RDB to XML translation. The key point of our method is how to find implicit referential integrity relations among columns which have different names to represent the same semantic. To resolve it, we define an enhanced extraction algorithm which based on a widely used ontology, WordNet. The proposed algorithm can reduce an extraction time among comparison columns in RDB tables and prevent loss of information.

AB - XML is rapidly becoming technologies for information exchange and representation. It causes many research issues such as semantic modeling methods, conversion for interoperability with other models, and so on. Especially, the most important issue in practical area is how to achieve the interoperability between XML model and relational database model. Until now, many methods have been proposed to achieve it. However, several problems still remain. Most of all, existing methods do not consider implicit referential integrity relations, so it causes loss of information. This paper proposes an algorithm for extracting referential integrity relations during RDB to XML translation. The key point of our method is how to find implicit referential integrity relations among columns which have different names to represent the same semantic. To resolve it, we define an enhanced extraction algorithm which based on a widely used ontology, WordNet. The proposed algorithm can reduce an extraction time among comparison columns in RDB tables and prevent loss of information.

UR - http://www.scopus.com/inward/record.url?scp=48349116843&partnerID=8YFLogxK

UR - http://www.scopus.com/inward/citedby.url?scp=48349116843&partnerID=8YFLogxK

U2 - 10.1109/CIS.2007.81

DO - 10.1109/CIS.2007.81

M3 - Conference contribution

AN - SCOPUS:48349116843

SN - 0769530729

SN - 9780769530727

SP - 157

EP - 161

BT - Proceedings - 2007 International Conference on Computational Intelligence and Security, CIS 2007

ER -