Generating Nested XML Documents with Dtd from Relational Views

Converting relational database into XML is increasing daily for publishing and exchanging data on the web. Most of the current approaches and tools for generating XML documents from relational database generate flat XML documents that contain data redundancy which leads to produce a massive data on...

Full description

Saved in:

Bibliographic Details
Main Author:	Ahmed, Mohammed Nasser
Format:	Thesis
Language:	English English
Published:	2008
Subjects:	Relational databases XML (Document markup language) Document markup languages
Online Access:	http://psasir.upm.edu.my/id/eprint/5257/1/FSKTM_2008__12.pdf
Tags:	Add Tag No Tags, Be the first to tag this record!

id	my-upm-ir.5257
record_format	uketd_dc
spelling	my-upm-ir.52572013-05-27T07:21:31Z Generating Nested XML Documents with Dtd from Relational Views 2008 Ahmed, Mohammed Nasser Converting relational database into XML is increasing daily for publishing and exchanging data on the web. Most of the current approaches and tools for generating XML documents from relational database generate flat XML documents that contain data redundancy which leads to produce a massive data on the web. Other approaches assume that the relational database for generating nested XML documents is normalized. In addition, these approaches have problem that lies in the difficult of how to specify the parent elements from the children elements in the nested XML document. Moreover, most of the current approaches and tools do not generate nested XML documents automatically. They require the user to specify the constraints and the schema of the target document. This research proposes an approach to automatically generate nested XML documents from flat relational database views that are unnormalized. The research aims to reduce data redundancy and storage sizes for the generated XML documents. The proposed approach consists of three steps. The first step is converting flat relational view into nested relational view. The second is generating DTD from the nested relational view. The third is generating nested XML document from the nested relational view. The proposed approach is evaluated and compared to other approaches such as NeT, CoT, and Cost-Based and tools such as Allora, Altova, and DbToXml with respect to two measurements: data redundancy and storage size of the document. The first measurement includes several parameters that are number of data values, elements, attributes, and tags. Based on the results of comparing the proposed approach to several other approaches and tools, the proposed approach is more efficient for reducing data redundancy and storage size of XML documents. It can reduce data redundancy and storage size by approximately 50% and 55%, respectively. Relational databases XML (Document markup language) Document markup languages 2008 Thesis http://psasir.upm.edu.my/id/eprint/5257/ http://psasir.upm.edu.my/id/eprint/5257/1/FSKTM_2008__12.pdf application/pdf en public phd doctoral Universiti Putra Malaysia Relational databases XML (Document markup language) Document markup languages Computer Science and Information Technology English
institution	Universiti Putra Malaysia
collection	PSAS Institutional Repository
language	English English
topic	Relational databases XML (Document markup language) Document markup languages
spellingShingle	Relational databases XML (Document markup language) Document markup languages Ahmed, Mohammed Nasser Generating Nested XML Documents with Dtd from Relational Views
description	Converting relational database into XML is increasing daily for publishing and exchanging data on the web. Most of the current approaches and tools for generating XML documents from relational database generate flat XML documents that contain data redundancy which leads to produce a massive data on the web. Other approaches assume that the relational database for generating nested XML documents is normalized. In addition, these approaches have problem that lies in the difficult of how to specify the parent elements from the children elements in the nested XML document. Moreover, most of the current approaches and tools do not generate nested XML documents automatically. They require the user to specify the constraints and the schema of the target document. This research proposes an approach to automatically generate nested XML documents from flat relational database views that are unnormalized. The research aims to reduce data redundancy and storage sizes for the generated XML documents. The proposed approach consists of three steps. The first step is converting flat relational view into nested relational view. The second is generating DTD from the nested relational view. The third is generating nested XML document from the nested relational view. The proposed approach is evaluated and compared to other approaches such as NeT, CoT, and Cost-Based and tools such as Allora, Altova, and DbToXml with respect to two measurements: data redundancy and storage size of the document. The first measurement includes several parameters that are number of data values, elements, attributes, and tags. Based on the results of comparing the proposed approach to several other approaches and tools, the proposed approach is more efficient for reducing data redundancy and storage size of XML documents. It can reduce data redundancy and storage size by approximately 50% and 55%, respectively.
format	Thesis
qualification_name	Doctor of Philosophy (PhD.)
qualification_level	Doctorate
author	Ahmed, Mohammed Nasser
author_facet	Ahmed, Mohammed Nasser
author_sort	Ahmed, Mohammed Nasser
title	Generating Nested XML Documents with Dtd from Relational Views
title_short	Generating Nested XML Documents with Dtd from Relational Views
title_full	Generating Nested XML Documents with Dtd from Relational Views
title_fullStr	Generating Nested XML Documents with Dtd from Relational Views
title_full_unstemmed	Generating Nested XML Documents with Dtd from Relational Views
title_sort	generating nested xml documents with dtd from relational views
granting_institution	Universiti Putra Malaysia
granting_department	Computer Science and Information Technology
publishDate	2008
url	http://psasir.upm.edu.my/id/eprint/5257/1/FSKTM_2008__12.pdf
_version_	1747810385604378624

Generating Nested XML Documents with Dtd from Relational Views

Similar Items