Transformation of a relational database to RDF/RDFS with ER2iDM

Doo Kwon Baik, Mi Young Choi, Chang Joo Moon

Research output: Contribution to journalArticle

2 Citations (Scopus)

Abstract

The Semantic Web uses RDF/RDFS, which can enable a machine to understand web data without human interference. But most web data is not available in RDF/RDFS documents because most web data is still stored in databases. It is much more favorable to use stored data in a database to build the Semantic Web. This paper proposes an enhanced relational RDF/RDFS interoperable data model (ER2iDM) and a transformation procedure from relational data model (RDM) to RDF/RDFS based on ER2iDM. The ER2iDM is a data model that plays the role of an inter-mediator between RDM and RDF/RDFS during a transformation procedure. The data and schema information in the database are migrated to the ER2iDM according to the proposed translation procedures without incurring loss of meaning of the entities, relationships, and data. The RDF/RDFS generation tool makes a RDF/RDFS XML document automatically from the ER2iDM. The proposed ER2iDM and transformation procedure provides detailed guidelines for transformation from RDM to RDF/RDFS unlike existing studies; therefore, we can more efficiently build up the Semantic Web using database stored data.

Original languageEnglish
Pages (from-to)1478-1488
Number of pages11
JournalIEICE Transactions on Information and Systems
VolumeE96-D
Issue number7
DOIs
Publication statusPublished - 2013 Jul 1

Fingerprint

Data structures
Semantic Web
XML

Keywords

  • RDF/RDFS
  • Relational data model
  • Relational database
  • Semantic Web

ASJC Scopus subject areas

  • Electrical and Electronic Engineering
  • Software
  • Artificial Intelligence
  • Hardware and Architecture
  • Computer Vision and Pattern Recognition

Cite this

Transformation of a relational database to RDF/RDFS with ER2iDM. / Baik, Doo Kwon; Choi, Mi Young; Moon, Chang Joo.

In: IEICE Transactions on Information and Systems, Vol. E96-D, No. 7, 01.07.2013, p. 1478-1488.

Research output: Contribution to journalArticle

Baik, Doo Kwon ; Choi, Mi Young ; Moon, Chang Joo. / Transformation of a relational database to RDF/RDFS with ER2iDM. In: IEICE Transactions on Information and Systems. 2013 ; Vol. E96-D, No. 7. pp. 1478-1488.
@article{8c3a118ee4ca47f6b47da3c9b7342be2,
title = "Transformation of a relational database to RDF/RDFS with ER2iDM",
abstract = "The Semantic Web uses RDF/RDFS, which can enable a machine to understand web data without human interference. But most web data is not available in RDF/RDFS documents because most web data is still stored in databases. It is much more favorable to use stored data in a database to build the Semantic Web. This paper proposes an enhanced relational RDF/RDFS interoperable data model (ER2iDM) and a transformation procedure from relational data model (RDM) to RDF/RDFS based on ER2iDM. The ER2iDM is a data model that plays the role of an inter-mediator between RDM and RDF/RDFS during a transformation procedure. The data and schema information in the database are migrated to the ER2iDM according to the proposed translation procedures without incurring loss of meaning of the entities, relationships, and data. The RDF/RDFS generation tool makes a RDF/RDFS XML document automatically from the ER2iDM. The proposed ER2iDM and transformation procedure provides detailed guidelines for transformation from RDM to RDF/RDFS unlike existing studies; therefore, we can more efficiently build up the Semantic Web using database stored data.",
keywords = "RDF/RDFS, Relational data model, Relational database, Semantic Web",
author = "Baik, {Doo Kwon} and Choi, {Mi Young} and Moon, {Chang Joo}",
year = "2013",
month = "7",
day = "1",
doi = "10.1587/transinf.E96.D.1478",
language = "English",
volume = "E96-D",
pages = "1478--1488",
journal = "IEICE Transactions on Information and Systems",
issn = "0916-8532",
publisher = "Maruzen Co., Ltd/Maruzen Kabushikikaisha",
number = "7",

}

TY - JOUR

T1 - Transformation of a relational database to RDF/RDFS with ER2iDM

AU - Baik, Doo Kwon

AU - Choi, Mi Young

AU - Moon, Chang Joo

PY - 2013/7/1

Y1 - 2013/7/1

N2 - The Semantic Web uses RDF/RDFS, which can enable a machine to understand web data without human interference. But most web data is not available in RDF/RDFS documents because most web data is still stored in databases. It is much more favorable to use stored data in a database to build the Semantic Web. This paper proposes an enhanced relational RDF/RDFS interoperable data model (ER2iDM) and a transformation procedure from relational data model (RDM) to RDF/RDFS based on ER2iDM. The ER2iDM is a data model that plays the role of an inter-mediator between RDM and RDF/RDFS during a transformation procedure. The data and schema information in the database are migrated to the ER2iDM according to the proposed translation procedures without incurring loss of meaning of the entities, relationships, and data. The RDF/RDFS generation tool makes a RDF/RDFS XML document automatically from the ER2iDM. The proposed ER2iDM and transformation procedure provides detailed guidelines for transformation from RDM to RDF/RDFS unlike existing studies; therefore, we can more efficiently build up the Semantic Web using database stored data.

AB - The Semantic Web uses RDF/RDFS, which can enable a machine to understand web data without human interference. But most web data is not available in RDF/RDFS documents because most web data is still stored in databases. It is much more favorable to use stored data in a database to build the Semantic Web. This paper proposes an enhanced relational RDF/RDFS interoperable data model (ER2iDM) and a transformation procedure from relational data model (RDM) to RDF/RDFS based on ER2iDM. The ER2iDM is a data model that plays the role of an inter-mediator between RDM and RDF/RDFS during a transformation procedure. The data and schema information in the database are migrated to the ER2iDM according to the proposed translation procedures without incurring loss of meaning of the entities, relationships, and data. The RDF/RDFS generation tool makes a RDF/RDFS XML document automatically from the ER2iDM. The proposed ER2iDM and transformation procedure provides detailed guidelines for transformation from RDM to RDF/RDFS unlike existing studies; therefore, we can more efficiently build up the Semantic Web using database stored data.

KW - RDF/RDFS

KW - Relational data model

KW - Relational database

KW - Semantic Web

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

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

U2 - 10.1587/transinf.E96.D.1478

DO - 10.1587/transinf.E96.D.1478

M3 - Article

AN - SCOPUS:84880562369

VL - E96-D

SP - 1478

EP - 1488

JO - IEICE Transactions on Information and Systems

JF - IEICE Transactions on Information and Systems

SN - 0916-8532

IS - 7

ER -