City University of Hong Kong
DSpace
 

CityU Institutional Repository >
4_Student Final Year Projects >
Electronic Engineering - Undergraduate Final Year Projects >

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

Title: Transaction translation from Xquery to SQL
Authors: Wong, Wing Nam
Department: Department of Electronic Engineering
Issue Date: 2007
Supervisor: Supervisor: Dr. Fong, Anthony S S.; Assessor: Dr. Leung, Andrew C S
Abstract: Extensible Markup Language (XML) is widely known for its powerful data formatting and exchanging. XML data is readability in different systems. Taking its advantage, the demand of using XML for data-transport and data-transformation is increased, publishing existing business data as XML format is essential. However, most businesses’ data is still stored in well-established relational database format. The main differences between XML database and relational database are their query languages. For XML database, XML querying language (XQuery) is used to access XML documents whereas structured query language (SQL) is used to process data stored in relational database. This creates the need for a system that can combine the best of both technologies for increasing the effectiveness and efficiency for handling both types of data at the same time. This project aims to investigate the feasibility of Transaction translation from XQuery to SQL. Firstly, the fundamental translation is based on the schema translation, mapping XML schema to relational database schema should be done. Secondly, implement a prototype of a designed algorithm for automatically translating XQuery into SQL. Finally, verify the equality and accuracy between XML documents and the relational database after performing the transaction translation.
Appears in Collections:Electronic Engineering - 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