Tuesday, May 6, 2008

Database Design using DB Designer

DBDesigner open source product which stores a projects in xml format.
DBDesigner allows us to graphically design the whole database structures and generate SQL instructions.

Here is list of key features.

* Available on Linux / MS Windows
* User Interfaced based on industry standard layouting software
o Canvas navigation similar to Adobe Illustrator® and Photoshop®
o Palettes (docked / floating) including "Bird Eyes view"
o Available objects include tables, realtions, labels, regions, images
o Extensive Drag'n'drop support
o Extensive Popup-Menu support
o Advanced Editors
o UNLIMITED Undo-/Redo- functions
o Copy-/Cut-/Paste clipboard functions (XML, DDL)
o Align functions

* Design Mode / Query Mode
* Reverse engineering MySQL, Oracle, MSSQL and any ODBC databases
* Userdefined schema-generation
* Model-To-Database syncronisation
* Index support
* Automatic foreign key placement
* Weak entity support
* Standard Inserts storing and sync
* Full documentation capabilities
* Advanced model printing
* Output as image
* All MySQL datatypes with all options
* User defined datatypes
* Database storage, ability to save model within database
* Network-/Multiuser access through database storage
* Version control*
* SQL Query Builder
* SQL Command History
* SQL Command storage within model
* Plugin interface
* Version control only available when using database storage

For more details please refer following link.

Ref. http://www.fabforce.net/dbdesigner4/features.php