A comparative analysis of managing XML data in relational database

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

8 Citations (Scopus)

Abstract

The eXtensible Markup Language (XML) has recently emerged as a standard for data representation and interchange on the web. Based on its popularity used in most application, the critical issues are to store and to query XML data to exploit the full power of this technology. Since relational database is widely used technology for storing and querying, therefore replacing it with pure XML database is not a good choice and very expensive process. It is thus crucial to map XML data into relational data and this process is one that occurs frequently. Many existing methods exist in the literature, and defining what the best mapping method is explicitly important. The intention of this paper is to the existing mapping methods in terms of generating good relational schema. At the end a new mapping method is developed to overcome the limitations the limitations and shows that it is efficient in terms of removing relation redundancy.

Original languageEnglish
Title of host publicationLecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)
Pages100-108
Number of pages9
Volume6591 LNAI
EditionPART 1
DOIs
Publication statusPublished - 2011
Event3rd International Conference on Intelligent Information and Database Systems, ACIIDS 2011 - Daegu
Duration: 20 Apr 201122 Apr 2011

Publication series

NameLecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)
NumberPART 1
Volume6591 LNAI
ISSN (Print)03029743
ISSN (Electronic)16113349

Other

Other3rd International Conference on Intelligent Information and Database Systems, ACIIDS 2011
CityDaegu
Period20/4/1122/4/11

Fingerprint

Relational Database
Comparative Analysis
XML
XML Database
Schema
Redundancy
Interchanges
Query

Keywords

  • comparative analysis
  • Mapping method
  • relational database
  • XML

ASJC Scopus subject areas

  • Computer Science(all)
  • Theoretical Computer Science

Cite this

Ahmad, K. (2011). A comparative analysis of managing XML data in relational database. In Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics) (PART 1 ed., Vol. 6591 LNAI, pp. 100-108). (Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics); Vol. 6591 LNAI, No. PART 1). https://doi.org/10.1007/978-3-642-20039-7-10

A comparative analysis of managing XML data in relational database. / Ahmad, Kamsuriah.

Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics). Vol. 6591 LNAI PART 1. ed. 2011. p. 100-108 (Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics); Vol. 6591 LNAI, No. PART 1).

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

Ahmad, K 2011, A comparative analysis of managing XML data in relational database. in Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics). PART 1 edn, vol. 6591 LNAI, Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics), no. PART 1, vol. 6591 LNAI, pp. 100-108, 3rd International Conference on Intelligent Information and Database Systems, ACIIDS 2011, Daegu, 20/4/11. https://doi.org/10.1007/978-3-642-20039-7-10
Ahmad K. A comparative analysis of managing XML data in relational database. In Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics). PART 1 ed. Vol. 6591 LNAI. 2011. p. 100-108. (Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics); PART 1). https://doi.org/10.1007/978-3-642-20039-7-10
Ahmad, Kamsuriah. / A comparative analysis of managing XML data in relational database. Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics). Vol. 6591 LNAI PART 1. ed. 2011. pp. 100-108 (Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics); PART 1).
@inproceedings{0d98d68ba91e47c283b4fb7d3377e099,
title = "A comparative analysis of managing XML data in relational database",
abstract = "The eXtensible Markup Language (XML) has recently emerged as a standard for data representation and interchange on the web. Based on its popularity used in most application, the critical issues are to store and to query XML data to exploit the full power of this technology. Since relational database is widely used technology for storing and querying, therefore replacing it with pure XML database is not a good choice and very expensive process. It is thus crucial to map XML data into relational data and this process is one that occurs frequently. Many existing methods exist in the literature, and defining what the best mapping method is explicitly important. The intention of this paper is to the existing mapping methods in terms of generating good relational schema. At the end a new mapping method is developed to overcome the limitations the limitations and shows that it is efficient in terms of removing relation redundancy.",
keywords = "comparative analysis, Mapping method, relational database, XML",
author = "Kamsuriah Ahmad",
year = "2011",
doi = "10.1007/978-3-642-20039-7-10",
language = "English",
isbn = "9783642200380",
volume = "6591 LNAI",
series = "Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)",
number = "PART 1",
pages = "100--108",
booktitle = "Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)",
edition = "PART 1",

}

TY - GEN

T1 - A comparative analysis of managing XML data in relational database

AU - Ahmad, Kamsuriah

PY - 2011

Y1 - 2011

N2 - The eXtensible Markup Language (XML) has recently emerged as a standard for data representation and interchange on the web. Based on its popularity used in most application, the critical issues are to store and to query XML data to exploit the full power of this technology. Since relational database is widely used technology for storing and querying, therefore replacing it with pure XML database is not a good choice and very expensive process. It is thus crucial to map XML data into relational data and this process is one that occurs frequently. Many existing methods exist in the literature, and defining what the best mapping method is explicitly important. The intention of this paper is to the existing mapping methods in terms of generating good relational schema. At the end a new mapping method is developed to overcome the limitations the limitations and shows that it is efficient in terms of removing relation redundancy.

AB - The eXtensible Markup Language (XML) has recently emerged as a standard for data representation and interchange on the web. Based on its popularity used in most application, the critical issues are to store and to query XML data to exploit the full power of this technology. Since relational database is widely used technology for storing and querying, therefore replacing it with pure XML database is not a good choice and very expensive process. It is thus crucial to map XML data into relational data and this process is one that occurs frequently. Many existing methods exist in the literature, and defining what the best mapping method is explicitly important. The intention of this paper is to the existing mapping methods in terms of generating good relational schema. At the end a new mapping method is developed to overcome the limitations the limitations and shows that it is efficient in terms of removing relation redundancy.

KW - comparative analysis

KW - Mapping method

KW - relational database

KW - XML

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

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

U2 - 10.1007/978-3-642-20039-7-10

DO - 10.1007/978-3-642-20039-7-10

M3 - Conference contribution

AN - SCOPUS:80053249480

SN - 9783642200380

VL - 6591 LNAI

T3 - Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)

SP - 100

EP - 108

BT - Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)

ER -