CE-06.01

Title: 

Mapping ER/SQL Schema into XML Schema

Author(s): 

Navdeep Singh Sandhu

Oral Defence Date: 

07/03/2006

Location: 

TH 331

Committee: 

Professor Marguerite Murphy, Professor Dragutin Petkovic

Abstract: 

Data is stored and processed in different formats. Organizations and institutions around the world are facing difficulties in transferring data between these heterogeneous data stores. It is important to have a seamless way to integrate data without worrying about the underlying data format. We propose an integrated system where a relational database is used to store and query data and XML (Extensible Markup Language) is used to transfer data between various data stores. As a result we have a system with the best technology: the reliability of relational databases and the flexibility of XML. The goal of this project is to implement a new ER Design Tools XML data bus architecture, which uses W3C XML Schema for sharing and transmitting data. This project extends the current SFSU ER Design Tool implementation by adding new functionality that maps Entity Relationship and Relational schema to equivalent XML schema. These mappings are based on the new ISO/OSI SQL-XML Standard. This strategy gives users the flexibility of keeping their legacy relational database management systems (RDBMS) as well as the functionality of porting them to XML Schema for seamless future upgrades and data transfers between various data sources. The new mappings work by accepting a user entered Entity Relationship (ER) schema and automatically converting it into an equivalent XML schema using the mapping rules. Correct execution is demonstrated using a set of examples.

Keywords: 

ER, XML, Schema, DBMS, ISO

Copyright: 

Navdeep Singh Sandhu