 |
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.
| |
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.
| Tool | Creator | Target Business Size | License | Supported Database Platforms | Supported OSs | Standalone or bundled into a larger toolkit | Launch Date |
|---|---|---|---|---|---|---|---|
| Astah | Change Vision | Enterprises | Proprietary | MySQL, Oracle, | Windows, macOS, Linux | Standalone | 2006 |
| Database Workbench | Upscene Productions | SMBs and enterprises | Proprietary | MS SQL Server, MySQL, Oracle, Firebird, InterBase, SQL Anywhere, NexusDB, MariaDB | Windows, Linux and FreeBSD (both through Wine) | Standalone | 2001 |
| DbSchema | Wise Coders GmbH | SMBs and enterprises | Proprietary | MS SQL Server, MySQL, Oracle, Firebird, InterBase, SQL Anywhere, NexusDB, MariaDB, SQLite, PostgreSQL, Sybase | Windows, Linux, macOS | Standalone | 2018 |
| Enterprise Architect | Sparx Systems | SMBs and enterprises | Proprietary | IBM Db2, Firebird, InterBase, Informix, Ingres, Access, MS SQL Server, MySQL, SQLite, Oracle, PostgreSQL, Sybase | Windows, Linux (Wine), macOS (via CrossOver) | Data modeling is supported as part of a complete modeling platform. | 2000 |
| ER/Studio | Embarcadero (acquired by IDERA) | SMBs and enterprises | Proprietary | Access, Snowflake, Microsoft Azure IBM Db2, Informix, Hitachi HiRDB, Firebird, Interbase, MySQL, MS SQL Server, Netezza, Oracle, PostgreSQL, Sybase, Teradata, Visual Foxpro and others via ODBC/ANSI SQL | Windows | Standalone | 1998 |
| Erwin Data Modeler | Logic Works (now Quest) | SMBs and enterprises | Proprietary | Access, IBM Db2, Informix, MySQL, MS SQL Server, Netezza, Oracle, PostgreSQL, Sybase, and others via ODBC/ANSI SQL | Windows | Standalone | 1998 |
| MagicDraw | No Magic | Enterprises, SMBs, personal | Proprietary | MS SQL Server, Oracle, MySQL, PostgreSQL, IBM Db2 | Windows, Linux, macOS | Standalone | 1995 |
| SQL Server Management Studio | Microsoft | Unknown | Proprietary | MS SQL Server | Windows | Standalone | 2005 |
| ModelRight | ModelRight | Enterprises, SMBs, personal | Proprietary | Access, MS SQL Server, Oracle, MySQL, PostgreSQL, IBM Db2 | Windows | Standalone | 2005 |
| MySQL Workbench | MySQL (An Oracle Company) | SMBs - personal | Proprietary or GPL | MySQL | Linux, Windows, macOS | Standalone | 2006 |
| Navicat Data Modeler | PremiumSoft | SMBs and enterprises | Proprietary | MySQL, MS SQL Server, PostgreSQL, Oracle, SQLite | Windows, macOS, Linux | Standalone | 2012 |
| NORMA Object-Role Modeling | Terry Halpin | SMBs and enterprises | CPL | MySQL, MS SQL Server, PostgreSQL, Oracle, IBM Db2 | Windows | Visual Studio Extension | 2005 |
| Open ModelSphere | Grandite | Enterprises - SMBs - personal | GNU GPL3 | MS SQL Server, MySQL, PostgreSQL, Oracle, IBM Db2 | Windows, macOS, Linux | Standalone with Data, UML, and process modeling | 2008 |
| Oracle SQL Developer Data Modeler | Oracle | Enterprises | Proprietary | Oracle, MS SQL Server, IBM Db2 | Cross-platform | Standalone | 2009 |
| PowerDesigner | SAP | SMBs and enterprises | Proprietary | Access, Greenplum, Apache Hive, HP Neoview, IBM Db2, Informix, Ingres, Interbase, MySQL, Netezza, NonStop SQL, Oracle, PostgreSQL, Red Brick Warehouse, SAP business Suite, SAP Hana, SAP Adaptive Server Enterprise, SAP IQ, SAP SQL Anywhere, MS SQL Server, Teradata | Windows | Standalone | 1989 |
| Software Ideas Modeler | Dusan Rodina | Enterprises, SMBs, personal | Proprietary | MS SQL Server, MySQL | Windows | Standalone | 2009 |
| SQLyog | Webyog, Inc. | Enterprises, SMBs, personal | Proprietary | MySQL, MariaDB | Windows and Linux (using Wine) | Standalone | 2001 |
| Toad Data Modeler | Quest Software | SMBs and enterprises | Proprietary | Access, IBM Db2, Informix, MySQL, MariaDB, PostgreSQL, MS SQL Server, SQLite, Oracle | Windows | Standalone | 2005 (before this date known as CaseStudio) |
| Tool | Creator | Target Business Size | License | Supported Database Platforms | Supported OSs | Standalone or bundled into a larger toolkit | Launch Date |
| Tool | Supported data models (conceptual, logical, physical) | Supported notations | Forward engineering | Reverse engineering | Model/database comparison and synchronization | Teamwork/repository |
|---|---|---|---|---|---|---|
| Database Workbench | Conceptual, logical, physical | IE (Crow’s foot) | Yes | Yes | Update database and/or update model | No |
| Enterprise Architect | Conceptual, Logical & Physical + MDA Transform of Logical to Physical | IDEF1X, UML DDL, Information Engineering & ERD | Yes | Yes | Update database and/or update model | Multi-user collaboration using File, DBMS or Cloud Repository (or transfer via XMI, CVS/TFS or Difference Merge). |
| ER/Studio | Logical, physical, ETL | IDEF1X, IE (Crow’s feet) | Yes | Yes | Update database and/or update model | ER/Studio Repository and Team Server (formerly Portal/CONNECT) for web based publishing collaboration and model management, with Business Glossary as standard. |
| MagicDraw | Conceptual, Logical & Physical + MDA Transform of Logical to Physical | IDEF1X, UML DDL, Information Engineering & ERD | Yes | Yes | Update database and/or update model | Multi-user collaboration using File, DBMS or (transfer via XMI, CVS/TFS or Difference Merge). |
| MySQL Workbench | Physical | IDEF1X, IE (Crow’s feet), UML, and more | Yes | Yes | Update database and/or update model | No |
| Navicat Data Modeler | Conceptual, Logical & Physical | IE (Crow’s foot) | Yes | Yes | Update database and/or update model | No |
| NORMA Object-Role modeling | Conceptual (ORM), Logical, Physical | ORM, Relational(Crow’s foot option), Barker | Yes | Yes | Update database and/or update model | No |
| Open ModelSphere | Conceptual, Logical, physical | IDEF1X, IE (Crow’s foot), and more | Yes | Yes | Update database and/or update model | No |
| Oracle SQL Developer Data Modeler | Logical, physical | Barker, IE (Crow’s foot), and Bachman | Yes | Yes | Update database and/or update model | Yes |
| PowerDesigner | Conceptual, logical, physical | IDEF1X, IE (Crow’s foot), and more | Yes | Yes | Update database and/or update model | Yes |
| Software Ideas Modeler | Conceptual, logical, physical | IDEF1X, IE (Crow’s foot), UML and more | Yes | Yes | Update database and/or update model | Yes |
| Toad Data Modeler | Logical, physical | IDEF1X, IE (Crow’s foot), and more | Yes | Yes | Update database and/or update model | Yes |
Vector graphics are a form of computer graphics in which visual images are created directly from geometric shapes defined on a Cartesian plane, such as points, lines, curves and polygons. The associated mechanisms may include vector display and printing hardware, vector data models and file formats, as well as the software based on these data models. Vector graphics are an alternative to raster or bitmap graphics, with each having advantages and disadvantages in specific situations.
Computer-aided design (CAD) is the use of computers to aid in the creation, modification, analysis, or optimization of a design. This software is used to increase the productivity of the designer, improve the quality of design, improve communications through documentation, and to create a database for manufacturing. Designs made through CAD software help protect products and inventions when used in patent applications. CAD output is often in the form of electronic files for print, machining, or other manufacturing operations. The terms computer-aided drafting (CAD) and computer-aided design and drafting (CADD) are also used.
Meta-analysis is the statistical combination of the results of multiple studies addressing a similar research question. An important part of this method involves computing an effect size across all of the studies; this involves extracting effect sizes and variance measures from various studies. Meta-analyses are integral in supporting research grant proposals, shaping treatment guidelines, and influencing health policies. They are also pivotal in summarizing existing research to guide future studies, thereby cementing their role as a fundamental methodology in metascience. Meta-analyses are often, but not always, important components of a systematic review procedure. For instance, a meta-analysis may be conducted on several clinical trials of a medical treatment, in an effort to obtain a better understanding of how well the treatment works.
A digital elevation model (DEM) or digital surface model (DSM) is a 3D computer graphics representation of elevation data to represent terrain or overlaying objects, commonly of a planet, moon, or asteroid. A "global DEM" refers to a discrete global grid. DEMs are used often in geographic information systems (GIS), and are the most common basis for digitally produced relief maps. A digital terrain model (DTM) represents specifically the ground surface while DEM and DSM may represent tree top canopy or building roofs.
In computing, online analytical processing, or OLAP, is an approach to quickly answer multi-dimensional analytical (MDA) queries. OLAP is part of the broader category of business intelligence, which also encompasses relational databases, report writing and data mining. Typical applications of OLAP include business reporting for sales, marketing, management reporting, business process management (BPM), budgeting and forecasting, financial reporting and similar areas, with new applications emerging, such as agriculture.
Creo Parametric, formerly known, together with Creo Elements/Pro, as Pro/Engineer and Wildfire, is a solid modeling or CAD, CAM, CAE, and associative 3D modeling application, running on Microsoft Windows.
Microsoft Visio is a diagramming and vector graphics application and is part of the Microsoft 365 family. The product was first introduced in 1992 by former American software company Visio Corporation, and its latest version is Visio 2021. Microsoft acquired the assets of Visio Corporation in 2000. A lightweight version of Visio is now included with all commercial SKU of Microsoft 365 and is known as Visio in Microsoft 365. It has two other subscription based SKUs. Visio Plan 1 includes the Visio web app whereas Visio Plan 2 provides access to both the web app and the Desktop application.
BRL-CAD is a constructive solid geometry (CSG) solid modeling computer-aided design (CAD) system. It includes an interactive geometry editor, ray tracing support for graphics rendering and geometric analysis, computer network distributed framebuffer support, scripting, image-processing and signal-processing tools. The entire package is distributed in source code and binary form.
In marketing, lead generation is the process of creating consumer interest or inquiry into the products or services of a business. A lead is the contact information and, in some cases, demographic information of a customer who is interested in a specific product or service.
Editing documents, program code, or any data always risks introducing errors. Displaying the differences between two or more sets of data, file comparison tools can make computing simpler, and more efficient by focusing on new data and ignoring what did not change. Generically known as a diff after the Unix diff utility, there are a range of ways to compare data sources and display the results.
Urchin was a web statistics analysis program that was developed by Urchin Software Corporation. Urchin analyzed web server log file content and displayed the traffic information on that website based upon the log data. Sales of Urchin products ended on March 28, 2012.
Jmol is computer software for molecular modelling chemical structures in 3-dimensions. Jmol returns a 3D representation of a molecule that may be used as a teaching tool, or for research e.g., in chemistry and biochemistry.
Data Design System AS (DDS) supplies the construction industry with software tools for building information modelling (BIM).
Database administration is the function of managing and maintaining database management systems (DBMS) software. Mainstream DBMS software such as Oracle, IBM Db2 and Microsoft SQL Server need ongoing management. As such, corporations that use DBMS software often hire specialized information technology personnel called database administrators or DBAs.
Flow to HDL tools and methods convert flow-based system design into a hardware description language (HDL) such as VHDL or Verilog. Typically this is a method of creating designs for field-programmable gate array, application-specific integrated circuit prototyping and digital signal processing (DSP) design. Flow-based system design is well-suited to field-programmable gate array design as it is easier to specify the innate parallelism of the architecture.
The following tables compare general and technical information for a number of available database administration tools. Please see individual product articles for further information. This article is neither all-inclusive nor necessarily up to date.
Computer security software or cybersecurity software is any computer program designed to influence information security. This is often taken in the context of defending computer systems or data, yet can incorporate programs designed specifically for subverting computer systems due to their significant overlap, and the adage that the best defense is a good offense.
The following outline is provided as an overview of and topical guide to software:
LIMDEP is an econometric and statistical software package with a variety of estimation tools. In addition to the core econometric tools for analysis of cross sections and time series, LIMDEP supports methods for panel data analysis, frontier and efficiency estimation and discrete choice modeling. The package also provides a programming language to allow the user to specify, estimate and analyze models that are not contained in the built in menus of model forms.
The Open Neural Network Exchange (ONNX) [] is an open-source artificial intelligence ecosystem of technology companies and research organizations that establish open standards for representing machine learning algorithms and software tools to promote innovation and collaboration in the AI sector. ONNX is available on GitHub.