1 / 11

E-R Modeler: A Database Modeling Toolkit for Eclipse

E-R Modeler: A Database Modeling Toolkit for Eclipse. Hui Wu wuh -at- cis.uab.edu http://www.cis.uab.edu/wuh Academic Advisor : Dr. Jeff Gray gray -at- cis.uab.edu http://www.gray-area.org University of Alabama at Birmingham Department of Computer & Information Sciences. Motivation.

sfackler
Download Presentation

E-R Modeler: A Database Modeling Toolkit for Eclipse

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. E-R Modeler: A Database Modeling Toolkit for Eclipse Hui Wu wuh -at- cis.uab.edu http://www.cis.uab.edu/wuh Academic Advisor : Dr. Jeff Gray gray -at- cis.uab.edu http://www.gray-area.org University of Alabama at Birmingham Department of Computer & Information Sciences

  2. Motivation • Enhance DB Modeling Capability of Eclipse • Provide capabilities such as XML and DDL generation, DB connection as well as DB schema creation • Support reverse engineering of existing databases

  3. E-R Modeler Architecture

  4. System Design – Primary Function Modules • Diagram editor • A UML-style diagramming tool to construct and modify E-R models. • Outline view and Property view • Communicate and synchronize with the drawing Canvas to display the outline, composition and properties of entities and relationships • File IO • Store/load the E-R diagram to/from a binary file • Store the internal data structure (entities, attributes, primary keys and relationships, etc) into an XML file

  5. System Design – Primary Function Modules (cont’d) • Data Definition Language (DDL) generation • Load the XML file as a DOM tree and traverse the DOM tree • Generate physical DDL based on the underlying database • DB table generation • Connect to the underlying database (Access/SQL Server/SQL Plus) • Execute the physical DDL to create database schema

  6. Implementation – What extension points we extent • perspectives – framework • newWizards – new project & files • editors – diagram & XML & SQL editor • actionSets – toolbar actions • propertyPages – property view • preferencePages – color changing of characters in the XML editor • toc – online help

  7. The E-R Modeler Framework Diagram editor Model explorer DB connection Dialog Model outline view Modelproperty view

  8. Future Work • Implement support for reverse engineering • Provide automatic layout support • Support for additional file types • Enrich ER object types like weak entity • Add extension-points for other plug-ins to build on

  9. Credits Leading Developers: Song Zhou, Chris Xu Supporting Programmers: Hui Wu, Yuehua Lin, Jing Zhang, Juanqin Wang Advisors: Dr. Jeff Gray, Dr. Barrett Bryant

  10. Demo

  11. Thanks

More Related