The Mogwai ERDesigner is a entity relation modeling tool such as ERWin and co. The only difference is that it is Open Source and does not cost anything. It was designed to make database modeling as easy as it can be and to support the developer in the whole development process, from database design to schema and code generation. This tool was also designed to support a flexible plug in architecture, to extend the system simply by installing a new plug in. This way, everybody can implement new features and tools to make ERDesigner fit the requirements.
* is based on Java and can be run on Windows and Unix systems
* has a powerfull WYSIWYG for physical database design
* handles tables, relations, indexes and comments
* supports subject areas
* supports MySQL, oracle, Microsoft SQLServer and Postgres
* creates the SQL DDL statements for schema creation
* has an integrated schema version control system
* can generate schema migration scripts for every change
* stores the database definition as XML files for further processing
* can export the database schema as GIF, BMP, JPEG or SVG files
* has an integrated reverse engineering module for existing schemas
* it is based on GPL license
* support is available by authors and newsgroups
Need to design, visualize or document your database?
ModelRight 3 can reverse engineer your existing database to give you a graphical view of it, generate all the SQL statements to create the database, or synchronize your database model with the database to keep your design up to date.
Do you need to control the most detailed aspects of your database?
ModelRight 3 has more complete and in-depth support for your database’s (Oracle, SQL Server, MySQL or any via ODBC) most advanced features.
Open System Architect (OSA) is an application used for modelling a system. OSA currently supports data modelling (physical and logical) with UML in the works. The unique thing about OSA is that it is an Open Source product licensed under the General Public License (GPL). The free factor makes OSA particularly interesting for students but OSA is powerful enough to compare favourably with products costing thousands of dollars.
OSA is sponsored by CodeByDesign (the originally developer of OSA) and by Source Forge (they host the community collaboration environment for OSA).
What is schema?
In MySQL, physically, a schema is synonymous with a
database. You can substitute the keyword schema instead of
database in MySQL SQL syntax, for example using create schema instead of
Some other database products draw a distinction. For example, in the
Oracle Database product, a schema represents only a part of a
database: the tables and other objects owned by a single user.
What is a Data Model?
A data model is an abstract model, that documents and organizes the
enterprise data for communication between developers. Most of the times
a data model is reprensented in a diagram. A data model is used as a
plan for developing software, specifically how data is stored and
accessed. A data model of your database can support the analysis,
design, documentation and migration of underlying database structures.
How to design database/schema?
In software engineering, data modeling is the process of creating a data
model for an information system. This is done by applying formal data
There are many tools which can help you with modeling such as SQLDBM.
SqlDBM initially started out with inbuilt support for Microsoft’s SQL
But of course, due to large number of requests for MySQL support from
our users, we have been working hard to expand our product.
And now, we are very proud to announce that SqlDBM offers support for
MySQL – one of the most popular open-source databases in the world.
必赢365net手机版，You can now model and design your MySQL database/s directly on SqlDBM .
And of course, you can take advantage of and adapt SqlDBM features into
your MySQL database such as Subject Areas, Relationships, Diagrams, View
SQLDBM offers you an easy, convenient way to design your database
absolutely anywhere on any browser, working away without need for any
extra database engine or database modelling tools or apps. Use SQLDBM to
design and manage both large and small databases and data models on the
fly. All while incorporating any needed database rules and objects such
as database keys, schemas, indexes, column constraints and