Generic Schema Conversion Code for New ER Design Tools Server


Rahul Kataria

Oral Defence Date: 



HSS 282


Professors Marguerite Murphy & Arno Puder


Models for data storage and manipulation are very important in today’s information overloaded world. The ER Design Tools is a data-modeling tool developed at San Francisco State University to automate the conversion of application schema among data models. This report describes the design and logic for a new implementation of the server side of the ER Design tools. Supported functionality includes mapping an Entity Relationship (ER) schema into a Relational schema, Spreadsheet schema and ODMG schema. All application schemas are represented as Extensible Markup Language (XML) files. Java Architecture for XML Binding (JAXB) is used to convert the XML representation of an ER schema into an aggregation hierarchy, which is traversed by a mapping algorithm before this schema is converted into a Relational, Spreadsheet or ODMG schema. This project is restricted to server-side functionality of the ER Design Tools. Even though the current version of the ER Design Tools already maps the above application schemas, the implementation logic is distributed on both the client and the server side. On the contrary, this project has a clear re-implementation of the mapping rules localized on the server side. The new server is fully operational, demonstrating that our new design is sound and implementation strategy feasible. This work is dedicated to making the ER Design Tools Open Source software.


Entity, Relationship, XML, Relation, Mapping rules, ODMG, Spreadsheet.


Rahul Kataria