MySQL Workbench – Next-generation visual database design application

Visual database design is very essential. Almost every web application needs database. And by designing visual representation, relation of tables makes an developer easy to understand on the database. There are many tools to design database like DBDesigner, SQLYog. Recently I found another application that is called MySQL Workbench. It can be used to efficiently design, manage and document database schemata. After using it’s functionality, I found this is a really good tool for design database specially for MySQL.

It is available as both, open source and commercial editions. The Community (OSS) Edition is available from this page under the free software/opensource GNU General Public License (commonly known as the “GPL”)

Download MySQL Workbench

MySQL Model Overview Page:

wb_model_table_editor_small1This screenshot shows the MySQL Model Overview page. It is the central starting point of any MySQL Workbench project and allows the creation and management of diagrams, schemata and their objects, scripts and more.

EER Diagram

wb_diagam_zoomed_out_small1Each Workbench model can hold several EER Diagrams that visualize different parts of the catalog. The diagram can be freely scaled to fit the screen size.

Modeling Tools:

wb_diagam_fk_pick_columns_small1MySQL Workbench supports sophisticated modeling tools that help you create database schemata most efficiently.

Notation Styles:

notations_smallA number of different notation styles are available at your disposal. Aside from the default crow foot style, you can also switch to the classic style or one that has been modeled after Microsoft Access, called the “Connect To Column” style. These two are demonstrated in the next screen shot. But that is still not all MySQL Workbench has to offer. There is also the UML and the IDEF1X style too.

Designer Canvas:
wb_diagam_fk_highlight_small1

Utilizing a special canvas for drawing EER Diagrams enables for high speed rendering and display effects to highlight important information. For systems capable of providing proper OpenGL support hardware rendering will be enabled in the future, giving even more power to the designer for better user expericence.

Reference:
http://dev.mysql.com/workbench/
http://dev.mysql.com/workbench/?page_id=35

About these ads

One Response to “MySQL Workbench – Next-generation visual database design application”

  1. Naseer Ahmad Says:

    Thanks a lot for such a nice sharing…


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

%d bloggers like this: