DB-UML Modeling Tool RoadMap

The following RoadMap shows modeling tool tasks and enhancements organized into categories. After review, this roadmap needs to be re-organized as a release schedule.

Infrastructure

The following infrastructure and standards changes are needed:

Ø       Batch test suite and test procedure documentation.

Ø       Initial set of tests based on PostgreSQL.

Ø       Coding standards (PMD code review)

Ø       I18N review and update.

ArgoUML Integration

Several areas of the tool need better integration with ArgoUML

Ø       The use of critics for the DB-UML language

Ø       Batch testing changes (contribute to ArgoUML)

Ø       Explorer extensions (contribute to ArgoUML)

Ø       Using source generation for SQL;

Ø       Ability to use add pop-up actions to the explorer

Additions to DB_UML language

The following additions are needed to the language:

Ø       index

Ø       check and assert methods

Ø       trigger methods

Ø       domains

SQL/Med Support

Provide DB-UML language elements for foreign databases and foreign tables.  A version of this exists for the ORDB database on an old release of ArgoUML

Ø       Upgrade to ArgoUML 2.4.

Ø       Change terminology to foreign databases and foreign tables.

Ø       Provide catalog update support for foreign tables.

Ø       Table to Foreign Table transformation.

Warehouse Database Support

A language representation needs to be defined to model OLAP entities.  This should be done using the Common Warehouse Meta-Model.  Source generations should be provided to generate cube schemas from OLAP models.  The priority should be Mondrian schemas.

Transformations should also be provided to generate a star schema model from a host schema model for constructing a warehouse database.  And transformations should also be provided to generate OLAP model from a star schema model for constructing cube schemas.