RSS Feed for This PostCurrent Article

Open Source Java ER Modeler

Application Ermodeller is a free CASE tool for data modelling which is built in Java. This tool supports conceptual and logical data modelling and in the final step, it allows to create physical model that is specific for particular DBMS.

The basic idea is to support development of database via ER modelling in three levels of abstraction:

  • conceptual
  • logical
  • physical

This separation allows to create database model independent on the particular database system. You may create conceptual model and logical model that are independent on any DBMS. Then, you may generate physical model for each DBMS you will use. Afterwards, physical models allows you to generate SQL data definition for your target DBMS.


  1. Three levels of data modelling
    • Conceptual model
    • Logical model
    • Physical model
  2. Support of multiple DBMS:
    • MySQL
    • PotgreSQL
    • Oracle
    • Pointbase
    • Other systems may be installed via XML definition files
  3. SQL generation to file or directly to database via JDBC
  4. Reverse engineering from DB
  5. Model validation


Trackback URL

Sorry, comments for this entry are closed at this time.