Comparison of data modeling tools

Comparison of data modeling tools

This article is a comparison of data modeling tools which are notable, including standalone, conventional data modeling tools and modeling tools supporting data modeling as part of a larger modeling environment.

General

Tool Creator Target Business Size License Supported Database Platforms Supported OSs Standalone or bundled into a larger toolkit Launch Date
CA ERwin Data Modeler CA Technologies SMBs and enterprises Commercial (Free, limited, community edition available) Access, IBM DB2, Informix, Ingres, MySQL, Oracle, Progress, MS SQL Server, Sybase, Teradata All versions of Windows Standalone 1992?
Database Visual Architect Visual Paradigm SMBs and enterprises Commercial IBM DB2, Firebird, Progress OpenEdge, Cache, MS SQL Server, MySQL, HSQLDB, SQLite, Oracle, PostgreSQL, Sybase Windows, Linux, MAC OS Standalone (or as part of an UML modeling environment) Unknown
dbConstructor DBDeveloper Solutions SMBs Commercial Oracle, MS SQL Server, MySQL, Access All versions of Windows Standalone Unknown
DbSchema Wise Coders Solutions SMBs Commercial MySQL, PostgreSQL, MS SQL Server, Derby, Firebird, Oracle, IBM DB2, Informix, HSql, Pointbase, Mimer, Pervasive, Sybase All versions of Windows Standalone 2005
DbWrench Database Design Nizana Systems SMBs Commercial MS SQL Server, Oracle, PostgreSQL, MySQL Windows, Linux, Mac Standalone 2005
DeZign for Databases Datanamic SMBs and enterprises Commercial MS SQL Server, MySQL, Oracle, IBM DB2, Firebird, InterBase, Informix, MS Access, SQLite, PostgreSQL, Sybase, Paradox All versions of Windows Standalone 1999
Enterprise Architect Sparx Systems SMBs and enterprises Commercial IBM DB2, Firebird, InterBase, Informix, Ingres, Access, MS SQL Server, MySQL, SQLite, Oracle, PostgreSQL, Sybase All versions of Windows Data modeling is supported as part of a complete modeling platform. 2000
ER/Studio Embarcadero SMBs and enterprises Commercial Access, IBM DB2, Informix, MySQL, Oracle, PostgreSQL, MS SQL Server All versions of Windows Standalone 1998
D-Softs Database Compare [[1]] [MS SQL Server] Commercial MS SQL Server All versions of Windows Standalone
IBM InfoSphere Data Architect IBM Enterprises Commercial IBM DB2, Informix, Oracle, Sybase, MS SQL Server, MySQL, Teradata Linux, Windows Standalone Unknown
MicroOLAP Databaser Designer MicroOLAP SMBs Commercial MySQL, PostgreSQL All versions of Windows Standalone 2003
MySQL Workbench MySQL (An Oracle Company) SMBs - personal Commercial MySQL Linux, Windows, MAC OS Standalone 2006
Online Data Modeler JenaSoft SMBs - personal Commercial MS SQL Server, MySQL, PostgreSQL, Oracle, SQLite, MS Access Online Standalone 2011
Open ModelSphere Grandite SMBs - personal Commercial and free edition available MS SQL Server, MySQL Online Part of modeling environment with UML support 2010
Oracle SQL Developer Data Modeler Oracle Enterprises Free Oracle, MS SQL Server, IBM DB2 All versions of Windows Standalone Unknown
PowerDesigner Sybase SMBs and enterprises Commercial MS SQL Server, Oracle, PostgreSQL, MySQL, IBM DB2, Informix All versions of Windows Standalone 1996
SQL Power Architect SQLPower Software SMBs Commercial and free community edition PostgreSQL, Oracle, MS SQL Server Windows Standalone 2004
Toad Data Modeler Quest Software SMBs and enterprises Commercial (Free, limited, community edition available) Access, IBM DB2, Informix, MySQL, Oracle, PostgreSQL, MS SQL Server All versions of Windows Standalone 2005 (before this date known as CaseStudio)
XCase Resolution Software Ltd SMBs and enterprises Commercial MS SQL Server, Oracle, PostgreSQL, MySQL, IBM DB2 All versions of Windows Standalone 1996
Tool Creator Target Business Size License Supported Database Platforms Supported OSs Standalone or bundled into a larger toolkit Launch Date

Features

Tool Supported data models (conceptual, logical, physical) Supported notations Forward engineering Reverse engineering Model/database comparison and synchronization Teamwork/repository
CA ERwin Data Modeler Conceptual, logical, physical IDEF1X, IE (Crows feet), and more Yes Yes Update database and/or update model Workgroup edition provides collaboration
Database Visual Architect Physical Crows feet Yes Yes Update database and/or update model Additional product Teamwork Server for collaboration.
dbConstructor Physical Crows feet Yes Yes Update database No
DbSchema Physical Crows feet Yes Yes Compare to database and generate alter database script (update existing model not supported). No
DbWrench Database Design Physical Crows feet Yes Yes Update database and/or update model No
DeZign for Databases Logical, physical IDEF1X, IE (Crows feet) Yes Yes Update database and/or update model Not directly. Merge functionality available.
Enterprise Architect Conceptual, Logical & Physical + MDA transform Logical to Physical IDEF1X, UML DDL, Information Engineering & ERD Yes Yes Update database and/or update model Provides several methods for collaboration (CVS, database, merge)
ER/Studio Conceptual, logical, physical IDEF1X, IE (Crows feet) Yes Yes Update database and/or update model Additional ER/Studio Repository for collaboration
IBM InfoSphere Data Architect Conceptual, logical, physical IDEF1X, IE (Crows feet), and more Yes Yes Update database and/or update model Yes
MicroOLAP Databaser Designer Physical Crows feet Yes Yes Update database with alter scripts No
MySQL Workbench Physical IE (Crows feet) Yes Yes Update database and/or update model No
Navicat Conceptual, physical IE (Crows feet) Yes Yes Update database and/or update model No
Online Data Modeler Logical, physical IDEF1X (incomplete) Yes Yes Update database (update model unknown) Unknown
Open ModelSphere Logical, physical IDEF1X, IE (Crows feet), and more Yes Yes Update database and/or update model No
Oracle SQL Developer Data Modeler Logical, physical IDEF1X, IE (Crows feet), and more Yes Yes Update database and/or update model Unknown
PowerDesigner Conceptual, logical, physical IDEF1X, IE (Crows feet), and more Yes Yes Update database and/or update model Yes
SQL Power Architect Physical IDEF1X, IE (Crows feet), and more Yes Yes Compare models and generate alter script No
Toad Data Modeler Logical, physical IDEF1X, IE (Crows feet), and more Yes Yes Update database and/or update model Yes
XCase Physical IDEF1X, IE (Crows feet), and more Yes Yes Update database and/or update model Not directly. Merge functionality available.
Tool Supported data models (conceptual, logical, physical) Supported notations Forward engineering Reverse engineering Model/database comparison and synchronization Teamwork/repository

See also


Wikimedia Foundation. 2010.

Игры ⚽ Нужен реферат?

Look at other dictionaries:

  • Data modeling — The data modeling process. The figure illustrates the way data models are developed and used today. A conceptual data model is developed based on the data requirements for the application that is being developed, perhaps in the context of an… …   Wikipedia

  • Comparison of code generation tools — This article compares variable metamodel code generation tools[clarification needed]. Fixed metamodel code generation tools, such as UML tools, are excluded (see List of UML tools). Name Creator OS First public release Latest stable version… …   Wikipedia

  • 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. This article is neither all inclusive nor necessarily up to… …   Wikipedia

  • Comparison of EDA software — Comparison of Electronic Design Automation (EDA) software Contents 1 Free and Open Source Software (FOSS) 2 Proprietary software 3 Comparison of EDA packages 4 See …   Wikipedia

  • Data mining — Not to be confused with analytics, information extraction, or data analysis. Data mining (the analysis step of the knowledge discovery in databases process,[1] or KDD), a relatively young and interdisciplinary field of computer science[2][3] is… …   Wikipedia

  • Modeling and Simulation: Conceptual Modeling Overview — Contents 1 Introduction 2 Techniques 2.1 Data Flow Modeling 2.2 Entity Relationship Modeling 2.3 …   Wikipedia

  • Comparison of business integration software — This article is a comparison of business integration and business process automation software. Contents 1 General 1.1 Scope 1.2 General information 2 Compatibility and intero …   Wikipedia

  • Data dictionary — Not to be confused with Dictionary (data structure). A data dictionary, or metadata repository, as defined in the IBM Dictionary of Computing, is a centralized repository of information about data such as meaning, relationships to other data,… …   Wikipedia

  • Data analysis — Analysis of data is a process of inspecting, cleaning, transforming, and modeling data with the goal of highlighting useful information, suggesting conclusions, and supporting decision making. Data analysis has multiple facets and approaches,… …   Wikipedia

  • Data Vault Modeling — is a database modeling method that is designed to provide historical storage of data coming in from multiple operational systems. It is also a method of looking at historical data that, apart from the modeling aspect, deals with issues such as… …   Wikipedia

Share the article and excerpts

Direct link
… Do a right-click on the link above
and select “Copy Link”