Database Schema Representation and Conversion Using XML

Document Type



Dr. Jagadeesh Nandigam, nandigaj@gvsu.edu

Embargo Period



Allmost all enterprises depend on relational databases as a core infrastructure for storing and retrieving large amounts of data. Relational database management systems provide high-level, declarative access to these databases via Structured Query Language (SQL). Though there is an ANSI standard for SQL, various vendors do not fully comply with the standard. This has lead to a proliferation of SQL dialects * Oracle dialect, Microsoft SQL Server dialect, DB2 dialect, etc. SQL vendors disagree about data types, rounding and truncation, vendor-defined functions, and temporal data model among other things. DBAs and developers who work with multiple databases spend unproductive hours trying to learn the differences in SQL dialects to make their applications portable.

This project is aimed at developing an application for mitigating the above portability problems. The application provides a GUI to create a generic database schema and convert the generic schema to a database specific schema. It can also take a pre-existing generic schema instance written in XML and converts it to a database specific schema. This application is developed using XML technologies on the .NET platform.

This document is currently not available here.