Open Framework, Information Management Strategy & Collaborative Governance | Data & Social Methodology - MIKE2.0 Methodology
Wiki Home
Collapse Expand Close

Members
Collapse Expand Close

To join, please contact us.

Improve MIKE 2.0
Collapse Expand Close
Need somewhere to start? How about the most wanted pages; or the pages we know need more work; or even the stub that somebody else has started, but hasn't been able to finish. Or create a ticket for any issues you have found.

DB Designer

From MIKE2.0 Methodology

Share/Save/Bookmark
Jump to: navigation, search
Under construction.png
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.

Contents

Relationship to MIKE2.0

SAFE Architecture

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

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

Comparable Commercial Products

Reference Implementations through MIKE2.0

Wiki Contributors
Collapse Expand Close