Database Deployment Manager (DDM) is an open source, freeware, desktop oriented multi-platform database design

Database design

Database design is the process of producing a detailed data model of a database. This logical data model contains all the needed logical and physical design choices and physical storage parameters needed to generate a design in a Data Definition Language, which can then be used to create a database...

 tool that allows database administrators and/or programmers to create database structures (using an object oriented methodology) and deploy them into an existing database. The tool allows creation of diagrams to identify basic relations between the defined structures. DDM right now works with MySQL, plans are to extend it to be able to use more databases.

Features

• Create datatypes that can be used to create columns in a table
• Using Object Oriented modelling create table templates which define the structures of a table and then create instances of the table template which is used to physically create the tables in the database
• Create E-R diagrams between chosen tables, export these as graphics or SVG
• Object oriented / flat modelling of table structures
• Load/Save startup data for tables from CSV files
• Database design validation
• Sql Generation for MySQL and injection in a database

Object Oriented Modelling

This feature allows the creation of database tables following the paradigms of object oriented programming. You can have a base table (called a table template), and you can derive (specialize) tables from it. The specialized table will have the columns inherited from the base table, and also can add new columns to it. In the database table instances are deployed, which are being created based on the table templates, and can be populated with default values. There can be more instance of a table template.

Similar Software

• Quest Software Toad Data Modeler
  Toad Data Modeler
  Toad Data Modeler is a database design tool allowing users to visually create, maintain and document new or existing database systems. It was previously called "CASE Studio 2" before it was acquired from Charonware by Quest Software in 2006...
  
  
• Altova DatabaseSpy
  DatabaseSpy
  DatabaseSpy is a multi-database query, design, and database comparison tool from Altova, the creator of XMLSpy. DatabaseSpy connects to many major relational databases, facilitating SQL querying, database structure design, database content editing, and database comparison and conversion.DatabaseSpy...
  
  
• Devgems Data Modeler
  Devgems Data Modeler
  Devgems Data Modeler is a database design software targeting multiple database systems . It is used by data modelers, database administrators and software developers to create and manage database models and integrate with existing software development tools like CodeGear Delphi.-Key Features:*...