DB Designer

From MIKE2.0 Methodology

-> You are here: Category:Information Management Center of Excellence > Metadata Driven Architecture > Database Design > MIKE2:Release Cycle > DB Designer

This article is currently Under Construction. It is undergoing major changes as it is in the early stages of development. Users should help contribute to this article to get it to the point where is ready for a Peer Review.

DB Designer is a database modelling tool that can be used to design conceptual and logical models, create a physical database and maintain this system over time.

Relationship to MIKE2.0

SAFE Architecture

Used to deliver the Data_Modelling sub-component

Overall Implementation Guide

DB Design would be used primarily for the Data Modelling and Implementation Activities of MIKE2.0, which are:

Alignment with Strategic Requirements for Information Development

Review against Technology Selection QuickScan

Product Review

Key Features

Specifically designed to serve as the design tool for the MySQL Database, a popular open source database
Creates a graphical model from an existing database schema
Synchronizes a database schema with updates made to the graphical model
Generates schema ALTER/CREATE scripts

Sample Model in DB Designer

Pros

Relatively easy and straight-forward to use
Great visual representation of a data model
Free
Extensible through Plugin API

Cons

The UI can be somewhat buggy, especially when editing table structures
Generated scripts aren't compatible with all versions of MySQL

Desired Enhancements

Functonality that users of the MIKE2.0 Methodology would like to see added to this product are as follows:

User Valuation Enhancements

Voting scores from MIKE2.0 Contributors on the value of the asset in the context of the overall methodology

Usage

Product Access

Download available from product website

Open Source Licensing

GNU Public License (GPL)

Comparable Commercial Products

Reference Implementations through MIKE2.0