Masters Theses

Abstract

"eXtensible Mark Language(XML) has already become the industry standard for exchange and representation of data. The ability of XML to provide semantics to the data it holds finds its purpose in many applications over diverse industries from petroleum to biology. While most of the existing data is stored and maintained in traditional databases there is a need for transformation of data from the database to represent them as XML views. The issues which are important are (a) how to convert data from a flat relational database into hierarchical and semi-structured XML data and (b) how to reflect updates on the XML view in the databases. Hence, the problem of creating XML views from the Relational model and updating relational databases through XML views has become a primal issue and the center of attention for the research community.

The aim of this thesis is to create completely automated application which efficiently creates an XML view of the relational database using only the XML schema and the Database schema as input. A one to one mapping is done between the data in the database and the XML; the relation between data is maintained. Using this application the performance of other algorithms proposed related to this thesis are evaluated in creating XML views and the results are discussed. The thesis then provides a novel approach for updating the relational database based on the changes in the XML document with the help of XML change detection tools. The changes in XML provided by the change detection tool are converted into SQL queries to update the database"--Abstract, page iii.

Advisor(s)

Sanjay Kumar Madria

Committee Member(s)

Bih-Ru Lea
Vincent (Wen-Bin) Yu

Department(s)

Computer Science

Degree Name

M.S. in Computer Science

Publisher

University of Missouri--Rolla

Publication Date

Spring 2007

Pagination

viii, 51 pages

Note about bibliography

includes bibliographical references (pages 48-50)

Rights

© 2007 Janarthanan Eindhal, All rights reserved.

Document Type

Thesis - Restricted Access

File Type

text

Language

English

Subject Headings

Relational databases -- Management
XML (Document markup language)

Thesis Number

T 9128

Print OCLC #

173618384

Share My Thesis If you are the author of this work and would like to grant permission to make it openly accessible to all, please click the button above.

Share

 
COinS