City University of Hong Kong
DSpace
 

CityU Institutional Repository >
4_Student Final Year Projects >
Computer Science - Undergraduate Final Year Projects >

Please use this identifier to cite or link to this item: http://hdl.handle.net/2031/418

Title: Data conversion from relational to XML using JDOM and XML schema definition
Authors: Ng, Siu Wah
Department: Department of Computer Science
Issue Date: 2005
Supervisor: Dr. Fong Joseph. First Reader: Dr. Wang Philips. Second Reader: Prof. Chan Y K
Abstract: Relational database plays a vital role in companies because of its well expression of relationship and huge amount of investment on it. For Extensible Markup Language (XML), it becomes popular in industries because it can build a standard for data exchange on the internet. So, there should have a solution for consolidating two databases system so that companies can use both database in a convenience way without duplicate investment. Data conversion between relational database and XML database is one of the solutions. It can build a middle ware to perform the data conversion from relational database to XML documents under fast and convenience environment. However, the storing format of two databases is different. Moreover, there are many different data semantics among relational tables. So, data cannot be simply converted. In my project, I handled six data semantics including participation, cardinality, aggregation, generalization, categorization and n-ary relationship. The relational schema will be translated to XML schema definition (XSD) with correct data constraints. Then, based on the XSD, relational data translated to a JDOM tree which is represented as XML document and then inserted into XML database.
Appears in Collections:Computer Science - Undergraduate Final Year Projects

Files in This Item:

File SizeFormat
fulltext.html164 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