Devgems Data Modeler is a 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...

 software targeting multiple database systems (MS SQL Server, Firebird

Firebird (database server)

Firebird is an open source SQL relational database management system that runs on Linux, Windows, and a variety of Unix. The database forked from Borland's open source edition of InterBase in 2000, but since Firebird 1.5 the code has been largely rewritten ....

, and others). 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

• Reverse engineering of existing databases.
• SQL (DDL) scripts generation to create databases.
• Version control and Alter SQL generation.
• Visual structure comparison.
• Target multiple RDBMS.

Ribbon interface

Devgems Data Modeler is one of the first database design and modeling software to provide the Ribbon Interface

Ribbon (computing)

In GUI-based application software, a ribbon is an interface where a set of toolbars are placed on tabs in a tab bar. Recent releases of some Microsoft applications have embraced this form with a modular ribbon as their main interface. The Ribbon is a contextual interface that offers functionality...

.

Competitors

Similar software tools that are competitors are CA ERwin Data Modeler

CA ERwin Data Modeler

CA ERwin Data Modeler is a software tool for data modeling of custom developed information systems, including databases of transactional systems and data marts...

, ER/Studio

ER/Studio

ER/Studio is data architecture and database design software developed by Embarcadero Technologies. It works across multiple database platforms and is used by data architects, data modelers, database administrators and business analysts to create and manage database designs, document and reuse data...

, 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...

, DeZign for Databases

DeZign for Databases

DeZign for Databases is a database design and data modeling tool for multiple database platforms . It can be used to create, maintain and document new or existing database systems. The tool uses Entity-relationship diagram...

, among others.

See also

• Computer-aided software engineering
  Computer-aided software engineering
  Computer-aided software engineering is the scientific application of a set of tools and methods to a software system which is meant to result in high-quality, defect-free, and maintainable software products...
  
  
• Relational Model
  Relational model
  The relational model for database management is a database model based on first-order predicate logic, first formulated and proposed in 1969 by Edgar F...
  
  
• Data modeling
  Data modeling
  Data modeling in software engineering is the process of creating a data model for an information system by applying formal data modeling techniques.- Overview :...
  
  
• RDBMS
• Comparison of database tools
  Comparison of database tools
  The following tables compare general and technical information for a number of available database administrator tools. Please see individual product articles for further information...
  
  
• SQL Programming Tool
  SQL Programming Tool
  In the field of software, SQL programming tools provide platforms for database administrators and application developers to perform daily tasks efficiently and accurately....
  
  

External links

• Official page
• Product feature list