Schemaless Approach of Mapping XML Document into Relational Database

Ibrahim Dweib, Ayman Awadi, Seif Elduola Fath Elrhman, Joan Lu

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

1 Citation (Scopus)

Abstract

The extensible Markup Language (XML) is used for representing and exchanging data through the Internet, but this technology needs a suitable medium for storing these data. At present, three common technologies can be used to store and retrieve XML documents, i.e., native XML database, Object Oriented Database (OODB) and Relational Database (RDB). This paper describes a general method for mapping XML documents to RDB. The method does not need a DTD or XML schema. And it can be applied as a general solution for any tree data structure and not just for XML data. Also, it can be used for data-centric and document-centric documents. Experiments on this method shows it's ability to maintain document structure at a low cost price and easily, building of the original document is straightforward, performing first level semantic search is achievable either on a single document or on all documents.

Original languageEnglish
Title of host publication2008 8th IEEE International Conference on Computer and Information Technology, CIT 2008, Proceedings
EditorsQiang Wu, Xiangian He, Quang Vinh Nguyen, Wenjing Jia, Maolin Huang
PublisherIEEE
Pages167-172
Number of pages6
ISBN (Print)9781424423576
DOIs
Publication statusPublished - 8 Aug 2008
EventIEEE 8th International Conference on Computer and Information Technology - Sydney, Australia
Duration: 8 Jul 200811 Jul 2008
Conference number: 8

Conference

ConferenceIEEE 8th International Conference on Computer and Information Technology
Abbreviated titleCIT2008
CountryAustralia
CitySydney
Period8/07/0811/07/08

Fingerprint

XML
Data structures
Semantics
Internet
Costs
Experiments

Cite this

Dweib, I., Awadi, A., Elrhman, S. E. F., & Lu, J. (2008). Schemaless Approach of Mapping XML Document into Relational Database. In Q. Wu, X. He, Q. V. Nguyen, W. Jia, & M. Huang (Eds.), 2008 8th IEEE International Conference on Computer and Information Technology, CIT 2008, Proceedings (pp. 167-172). [4594668] IEEE. https://doi.org/10.1109/CIT.2008.4594668
Dweib, Ibrahim ; Awadi, Ayman ; Elrhman, Seif Elduola Fath ; Lu, Joan. / Schemaless Approach of Mapping XML Document into Relational Database. 2008 8th IEEE International Conference on Computer and Information Technology, CIT 2008, Proceedings. editor / Qiang Wu ; Xiangian He ; Quang Vinh Nguyen ; Wenjing Jia ; Maolin Huang. IEEE, 2008. pp. 167-172
@inproceedings{70dfa0f411394c7dbdf8ef770d104e7e,
title = "Schemaless Approach of Mapping XML Document into Relational Database",
abstract = "The extensible Markup Language (XML) is used for representing and exchanging data through the Internet, but this technology needs a suitable medium for storing these data. At present, three common technologies can be used to store and retrieve XML documents, i.e., native XML database, Object Oriented Database (OODB) and Relational Database (RDB). This paper describes a general method for mapping XML documents to RDB. The method does not need a DTD or XML schema. And it can be applied as a general solution for any tree data structure and not just for XML data. Also, it can be used for data-centric and document-centric documents. Experiments on this method shows it's ability to maintain document structure at a low cost price and easily, building of the original document is straightforward, performing first level semantic search is achievable either on a single document or on all documents.",
keywords = "XML, books, relational databases, databases, labeling, buildings",
author = "Ibrahim Dweib and Ayman Awadi and Elrhman, {Seif Elduola Fath} and Joan Lu",
year = "2008",
month = "8",
day = "8",
doi = "10.1109/CIT.2008.4594668",
language = "English",
isbn = "9781424423576",
pages = "167--172",
editor = "Qiang Wu and Xiangian He and Nguyen, {Quang Vinh} and Wenjing Jia and Maolin Huang",
booktitle = "2008 8th IEEE International Conference on Computer and Information Technology, CIT 2008, Proceedings",
publisher = "IEEE",

}

Dweib, I, Awadi, A, Elrhman, SEF & Lu, J 2008, Schemaless Approach of Mapping XML Document into Relational Database. in Q Wu, X He, QV Nguyen, W Jia & M Huang (eds), 2008 8th IEEE International Conference on Computer and Information Technology, CIT 2008, Proceedings., 4594668, IEEE, pp. 167-172, IEEE 8th International Conference on Computer and Information Technology, Sydney, Australia, 8/07/08. https://doi.org/10.1109/CIT.2008.4594668

Schemaless Approach of Mapping XML Document into Relational Database. / Dweib, Ibrahim; Awadi, Ayman; Elrhman, Seif Elduola Fath; Lu, Joan.

2008 8th IEEE International Conference on Computer and Information Technology, CIT 2008, Proceedings. ed. / Qiang Wu; Xiangian He; Quang Vinh Nguyen; Wenjing Jia; Maolin Huang. IEEE, 2008. p. 167-172 4594668.

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

TY - GEN

T1 - Schemaless Approach of Mapping XML Document into Relational Database

AU - Dweib, Ibrahim

AU - Awadi, Ayman

AU - Elrhman, Seif Elduola Fath

AU - Lu, Joan

PY - 2008/8/8

Y1 - 2008/8/8

N2 - The extensible Markup Language (XML) is used for representing and exchanging data through the Internet, but this technology needs a suitable medium for storing these data. At present, three common technologies can be used to store and retrieve XML documents, i.e., native XML database, Object Oriented Database (OODB) and Relational Database (RDB). This paper describes a general method for mapping XML documents to RDB. The method does not need a DTD or XML schema. And it can be applied as a general solution for any tree data structure and not just for XML data. Also, it can be used for data-centric and document-centric documents. Experiments on this method shows it's ability to maintain document structure at a low cost price and easily, building of the original document is straightforward, performing first level semantic search is achievable either on a single document or on all documents.

AB - The extensible Markup Language (XML) is used for representing and exchanging data through the Internet, but this technology needs a suitable medium for storing these data. At present, three common technologies can be used to store and retrieve XML documents, i.e., native XML database, Object Oriented Database (OODB) and Relational Database (RDB). This paper describes a general method for mapping XML documents to RDB. The method does not need a DTD or XML schema. And it can be applied as a general solution for any tree data structure and not just for XML data. Also, it can be used for data-centric and document-centric documents. Experiments on this method shows it's ability to maintain document structure at a low cost price and easily, building of the original document is straightforward, performing first level semantic search is achievable either on a single document or on all documents.

KW - XML

KW - books

KW - relational databases

KW - databases

KW - labeling

KW - buildings

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

U2 - 10.1109/CIT.2008.4594668

DO - 10.1109/CIT.2008.4594668

M3 - Conference contribution

AN - SCOPUS:51849098257

SN - 9781424423576

SP - 167

EP - 172

BT - 2008 8th IEEE International Conference on Computer and Information Technology, CIT 2008, Proceedings

A2 - Wu, Qiang

A2 - He, Xiangian

A2 - Nguyen, Quang Vinh

A2 - Jia, Wenjing

A2 - Huang, Maolin

PB - IEEE

ER -

Dweib I, Awadi A, Elrhman SEF, Lu J. Schemaless Approach of Mapping XML Document into Relational Database. In Wu Q, He X, Nguyen QV, Jia W, Huang M, editors, 2008 8th IEEE International Conference on Computer and Information Technology, CIT 2008, Proceedings. IEEE. 2008. p. 167-172. 4594668 https://doi.org/10.1109/CIT.2008.4594668