New Meta-Schema for New ER Design Tools – Front End


Rohit Kataria

Oral Defence Date: 

Thursday, December 13, 2007 - 12:00


TH 210


12:00 PM


Professors Marguerite Murphy & Hui Yang


Some commonly used models for data storage are Entity Relationship (ER) model, Relational model, Spreadsheet model and the Object Data Management Group (ODMG) model. The ER Design Tools, used as instructional software by CSC675/730 students at San Francisco State University (SFSU), map and convert these popular data models into one another. The tools have a user interface that allows students to create ER schemas by entering various entities, attributes and relationships. The tools convert the ER schema to a number of different types of application schemas like Relational schema, ODMG schema and Spreadsheet schema. This project is developed with the overall goal to release the ER design tools as Open Source software. The first step of this project involved designing and developing new and complete meta-schemas for the ER, Relational, ODMG and the Spreadsheet models. The meta-schemas lay the foundation for the re-implemented software, since the mapping rules for each of the application schema above are implemented on top of the corresponding meta-schema. Other contributions of this project include adapting the existing process of accepting user’s input and obtaining application schemas and instantiating these using the new meta-schemas. After mapping has been processed at the server, this project re-implements display of application schemas as 2-D Relational schema, 2-D Spreadsheet schema and textual ODMG schema. All of the new software is fully operational and behaves as expected.

Rohit Kataria

Meta-schema, XML, Entity-Relationship, Relational, Spreadsheet, ODMG.