CE-08.11

Title: 

NetBeans Module to Map ER Schema Into EJB 3.0 Java Persistence

Author(s): 

Zheng Xu

Oral Defence Date: 

11/19/2008

Location: 

SCI 241

Committee: 

Professors Marguerite Murphy & Arno Puder

Abstract: 

The Entity Relationship (ER) Design Tool, which is used as instructional software by CSC675 students at San Francisco State University (SFSU), maps and converts popular data models into each other. This tool offers a graphical user interface that allows users to create ER schema by designing entities, attributes and relationships; and then converts the ER schema into various types of equivalent application schema, such as Relational Schema, XML-Schema and ODMG Object Model Schema. In this report, we present a modification to the existing ER Design Tool to translate from an ER schema into the Java Persistence API, which is the key to using Enterprise Java Beans (EJB) 3.0. The new ER Design Tool allows users to design a database entity relationship schema visually, and then to automatically generate all of the Java persistence code for an EJB 3.0 application (based on the equivalent relational schema). This new version of the ER Design Tool makes the EJB 3.0 application development cycle much shorter, and lets students focus more on application logic and less on implementation details. Both the Client and Server of the new ER Design Tool are based on the newest ER Design Tool Meta-schemas and the standard Java Persistence XML Schema. This is accomplished by using a single set of shared libraries generated by JAXB, resulting in implementation code that is cleaner and easier to maintain. The newly developed ER Design Tool is fully operational and meets requirements.

Keywords: 

Entity, Relationship, Java, Persistence, EJB, JAXB, XML, Schema

Copyright: 

Zheng Xu