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: Hybrid data modeling techniques for XML schema definition with data semantics preservation
Other Titles: Hun he zi liao mo shi hua ji qiao yong yu jie ceng shi de jia gou yu yan ji bao cun zi liao yu yi
Authors: Cheung, San Kuen (張新權)
Department: Dept. of Computer Science
Degree: Doctor of Philosophy
Issue Date: 2006
Publisher: City University of Hong Kong
Subjects: Data structures (Computer science)
Database design
XML (Document markup language)
Notes: CityU Call Number: QA76.9.D26 C446 2006
Includes bibliographical references (leaves 217-231)
Thesis (Ph.D.)--City University of Hong Kong, 2006
xiv, 248 leaves : ill. ; 30 cm.
Type: Thesis
Abstract: XML Schema Definition (XSD) has gained currency in most web applications and is now becoming a standard of logical schema for exchanging information. XSD is complex, however, and requires a lot of knowledge of defining data semantics. The XML model also lacks data modeling techniques for the efficient development of business applications; therefore, users must be provided data modeling techniques for generating an XSD from different sources. First method ― “Relational-to-XSD Data Modeling” ― was developed such that a relational schema could be translated into an XSD through an Extended Entity Relationship (EER) Model. The EER model can be mapped into XSD using forward engineering and the data semantics of participation, cardinality, generalization, aggregation, categorization, n-ary, and u-ary relationships are preserved. The benefit is that it provides a general modeling technique for re-engineering from a Relational Model to an XML Model. The method can be validated by using information capacity recovery after schema translation. Second method ― “XBL-to-XSD Data Modeling” ― was developed using a higher level language tool (XSD-Builder) to generate an XSD automatically. The XSD-Builder consists of an XML Tree Model, an XSD-Builder Language, an XSD-Translator, and an XSD. The XBL is constructed using the conceptual information extracted from an XML Tree Model. An XML Tree Model consists of hierarchical nodes representing all elements within an XSD. The XBL is specified by the users and can be processed by XSD-Translator to generate the XSD. It is a user-friendly and well-formed language for specifying the data semantics of an XSD. Data modeling techniques can be validated by recovering the relational schema, EER Model, and XML Tree Model from the generated XSD in prototyping. The contributions of proposed methodologies of creating an XSD can be summarized in two sources: Source 1 - In an existing relational database, a relational schema can be mapped into an XSD through EER model by recovering their data semantics. Source 2 - Users design an XML Tree Model, which can be implemented by an XSD-Builder Language to generate a required XSD automatically. Two sources can also specify 14 major types of data semantics such as cardinality, specialization, generalization, participation, aggregation, categorization, u-ary and n-ary. The results are two feasible data modeling techniques that can be applied as case tools for designing an XSD. Additionally, XML Tree Model, XSD, EER Model and Relational Schema can be used interchangeably upon the users’ confirmation of data semantic constraints.
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