City University of Hong Kong

CityU Institutional Repository >
3_CityU Electronic Theses and Dissertations >
ETD - Dept. of Computer Science  >
CS - Doctor of Philosophy  >

Please use this identifier to cite or link to this item:

Title: Bidirectional transformation between relational data and XML document with semantic preservation and incremental maintenance
Other Titles: Guan lian shi zi liao yu ke kuo zhan biao shi yu yan wen jian de shuang xiang zhuan huan zhi yu yi bao cun ji di zeng geng xin
Authors: Wong, Hing Kwok (王卿國)
Department: Dept. of Computer Science
Degree: Doctor of Philosophy
Issue Date: 2005
Publisher: City University of Hong Kong
Subjects: Relational databases
XML (Document markup language)
Notes: CityU Call Number: QA76.76.H94 W665 2005
Includes bibliographical references (leaves 218-226)
Thesis (Ph.D.)--City University of Hong Kong, 2005
xviii, 228 leaves : ill. ; 30 cm.
Type: Thesis
Abstract: XML has become the standard for interchanging data between web applications because of its modeling flexibility. Meanwhile, relational databases are currently by far the most commonly used type of databases, and can be found in most organizations. As a result, there are good reasons for using both XML and database technologies together. Relational databases provide strong management and security features while XML, being plain text, can easily be sent across a network using different platforms. With relational databases as a standard data storage format, and with XML as a standard data exchange mechanism, we have an ideal partnership to store and serve data for creating loosely coupled, networked applications. In recent years, a considerable amount of research has been done on translating relational data into XML documents and vice versa. However, one of the biggest problems is that most of the similar work focused only on the structure aspects and largely neglected the semantic constraints and correctness in the translation. Invalid transformations produce incomplete and inconsistent pictures that cause damage to organizations. We purpose a semantic knowledge preservation methodology such that data semantic constraints are preserved during transformation to ensure a correct relational schema. The proposed methodology, XTOPO (XML Topology) is a general, dynamic and efficient tool for publishing relational data as XML documents and storing XML back into relational format. Relational data is translated into XML structure according to the relational data semantic. An XML document is decomposed into tables on the basis of its tree structure and stored in a relational database. Also, we propose two ways for storage of an XML document: with schema and without schema. An application of XTOPO is to replicate an XML database. A relational database and its replicate counterpart XML database can be processed in parallel for both internal data processing computing and external data transmission on the Internet. In summary, this thesis shows a mechanism for combining the translation between XML documents and relational database into a general methodology. The proposed methodology captures data semantics and dependency constraints into a knowledge-based repository. The data transformation can be performed from relational database to XML document and vice versa. The contribution of this thesis includes feasibility of converting data between relational and XML with data semantic preservation, and possible maintenance of a replicate XML database with incremental changes. The application of the methodology is B2B and B2C data exchange for the information highway on the Internet.
Online Catalog Link:
Appears in Collections:CS - Doctor of Philosophy

Files in This Item:

File Description SizeFormat
fulltext.html157 BHTMLView/Open
abstract.html157 BHTMLView/Open

Items in CityU IR are protected by copyright, with all rights reserved, unless otherwise indicated.


Valid XHTML 1.0!
DSpace Software © 2013 CityU Library - Send feedback to Library Systems
Privacy Policy · Copyright · Disclaimer