visual database (Oracle) designer - plugin detail

A plugin that allows the drawing of merise entity-association diagrams and the visual design of a database using the Oracle database. Once the database has been designed, the SQL commands to create the database structure can be exported.

NetBeans Plugin - visual database (Oracle) designer

Plugin owner:

richard_woodward

Website:

Added:

2009-06-19

License:

COMMON DEVELOPMENT AND DISTRIBUTION LICENSE (CDDL)

Category:

Databases

Downloaded:

9,612 times

Rating:

4.45, by 2 users

Plugin Log

Show log

Download size: 0.40 MB

Last Update: 2011-04-30

What's new in this version

updated: Improved drawing code for associations in merise diagrams updated: colour uniformly implemented and editable from options menu updated: generation of code stops gracefully when mutually referenced tables have been designed.

Verifications for NetBeans versions

6.9

verification PASSED

See verification details

Download size: 0.40 MB

Last Update: 2011-04-30

What's new in this version

Verifications for NetBeans versions

Plugin is not subject to any verification

Introduction

The visual database designer plugin was designed and created to be used with the student engineers at Eseo, école d’ingénieurs. Who as part of their training use the Oracle database. In their second year of the engineer course (BAC+4, equivalent to final year honours degree), they learn SQL and need to design and implement a relational database.
First they need to model the database in merise and in UML to compare and contrast these two separate approaches. Already they use the netbeans plugin for UML, and so we designed a simple drawing package as a plugin for netbeans (using the visual library). This allows the creation of merise entity association diagrams, plus these diagrams can be exported.

To follow up from this, the plugin also allows the ability to visually design the database and table structures using the datatypes that are available in Oracle. Relations between tables can be drawn (only to fields marked as primary keys and as long as the datatypes match). Once completed, the diagram can again be exported to an image file to be printed out, and the plugin can also generate the sql code needed to create the tables on an oracle database.

This plugin, was created predominantly as a proof of concept and to learn the XMLMultiview API. As time permits, this plugin will be extended to offer tighter integration and more functionality. Special thanks goes to Toni Epple and Damir Tesanovic for their tutorials which helped in starting this project.

Using the Plugin

The plugin does not create a new project type, instead it allows users to add two new file types to their projects.

Merise Entity Association Diagrams

This video represents the steps taken to create a simple Merise entity Association Diagram.

Visual SQL Editor

The second file type allows the physical structure of a database to be modeled (including the different data types).

This video represents the steps taken above to create a simple Database using the Visual Database editor.

Richard WOODWARD juin 2009 (updated aout 2009)

[ You have to be logged in to be able to comment. ]

User Comments

Remerciement

un grand merci pour ce plugin qui m'aide beaucoup pour la creation de MCD merise
big thanks for this pluggin very helpful in merise conception
very good job ;)

Posted by funkalee on Dec 20, 2009

Correction

I meant FreeMarker for what NBs uses internally for template stuff.

Posted by err on Sep 07, 2009

Almost exactly what I was looking for

I wanted something simple and easy to learn to assist in the initial creation of a bunch of tables. After that, I'll be manually tuning and working with the sql and JPA tools to customize. A very nice start.

I'm using Derby which has a variety of differences from oracle, but the source code is in the zip file. I haven't looked at the code yet, but I'll probably just hack in the data type names I need. If you had a way, eg in an xml file, to specify the palette contents (and a system property/combo-box to select the one to use) that would be convenient. And of course a way to specify snippets, jMaki's already in NB, for code generation if that ever becomes an issue as this tool develops, but for the simple create I don't see a problem.

A trivial packaging bug, the module "NB 67 Visual Merise Model" is not categorized, should it be "database" like the rest?

Posted by err on Sep 07, 2009