Database Modeling tools

PowerDesigner

PowerDesigner is arguably the industry’s leading data modelling tool. Its features include: fully integrated models, different modelling techniques that cater to both an IT-centric audience and non IT-centric. It also supports a powerful metadata repository and various output formats. It has a nice and polished user interface with easily readable help documentation aiding the user to quickly solve ad hoc problems.

PowerDesigner

Tool Description as in http://www.datasciencecentral.com/profiles/blogs/top-6-data-modeling-tools

Image Credit: http://www.datasciencecentral.com/profiles/blogs/top-6-data-modeling-tools

download-PowerDesigner

ER/Studio

ER/Studio is data architecture and database design software developed by Embarcadero Technologies. ER/Studio is compatible with 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 assets. In 2015, Embarcaero Technologies was acquired by database and infrastructure management software company IDERA, Inc. Since the acquisition by IDERA, Inc., ER/Studio has been renamed to ER/Studio Data Architect with updated features.

ERStudio

Tool Description as in https://en.wikipedia.org/wiki/ER/Studio

Image Credit: https://www.idera.com/er-studio-data-architect-software

download-ER/Studio

Sparx Enterprise Architect

Enterprise Architect is a visual platform for designing and constructing software systems, for business process modeling, and for more generalized modeling purposes. Enterprise Architect is based on the latest UML® 2.5 specification (see www.omg.org). UML defines a visual language that is used to model a particular domain or system (either proposed or existing). Enterprise Architect is a progressive tool that covers all aspects of the development cycle, providing full traceability from the initial design phase through to deployment, maintenance, testing and change control.

Sparx-Enterprise-Architect

Tool Description as in http://www.sparxsystems.com.au/enterprise-architect/index.html

Image Credit: http://www.sparxsystems.com.au/enterprise-architect/index.html

download-Sparx-Enterprise-Architect

Oracle SQL Developer Data Modeler

Oracle SQL Developer Data Modeler is a free graphical tool that enhances productivity and simplifies data modeling tasks. Using Oracle SQL Developer Data Modeler users can create, browse and edit, logical, relational, physical, multi-dimensional, and data type models. The Data Modeler provides forward and reverse engineering capabilities and supports collaborative development through integrated source code control. The Data Modeler can be used in both traditional and in Cloud environments.

Oracle-SQL-Developer-Data-Modeler

Tool Description as in http://www.oracle.com/technetwork/developer-tools/datamodeler/overview/index.html

Image Credit: http://www.datasciencecentral.com/profiles/blogs/top-6-data-modeling-tools

download-Oracle-SQL-Developer Data-Modeler

CA ERwin

Erwin Data Modeler (erwin) is a software tool for data modeling (data requirements analysis, database design, etc.) of custom developed information systems, including databases of transactional systems and data marts. erwin’s data modeling engine is based upon the IDEF1X method, although it now supports diagrams displayed with information engineering notation as well. Logic Works stylised “erwin” from an abbreviation of “Entity Relationships” and Microsoft’s “Windows”.

CA-ERwin

Tool Description as in https://en.wikipedia.org/wiki/Erwin_Data_Modeler

Image Credit: http://www.datasciencecentral.com/profiles/blogs/top-6-data-modeling-tools

download-CA-ERwin

IBM – InfoSphere Data Architect

IBM InfoSphere Data Architect is a collaborative enterprise data modeling and design solution that can simplify and accelerate integration design for Business Intelligence, Master Data Management and Service-Oriented Architecture initiatives. Data Architect enables you to work with users at every step of the data design process, from project management to application design to data design. The tool helps to align processes, services, applications, and data architectures.

IBM-InfoSphere-Data-Architect

Tool Description as in https://www.ibm.com/in-en/marketplace/infosphere-data-architect

Image Credit: http://www.datasciencecentral.com/profiles/blogs/top-6-data-modeling-tools

download-IBM-InfoSphere-Data-Architect

Archi

The Archi modelling tool is targeted toward all levels of Enterprise Architects and Modellers. It provides a low cost to entry solution to users who may be making their first steps in the ArchiMate modelling language, or who are looking for a free, cross-platform ArchiMate modelling tool for their company or institution and wish to engage with the language within a TOGAF or other Enterprise Architecture framework.

Archi

Tool Description as in https://www.archimatetool.com/

Image Credit: https://www.archimatetool.com/

download-Archi

BiZZdesign Architect

BiZZdesign Enterprise Studio is the collaborative business design platform that offers powerful, integrated modeling across multiple disciplines. It provides all the capabilities needed to seamlessly plan, track and execute change in a single software platform.

BiZZdesign-Architect

Tool Description as in http://www.bizzdesign.com/enterprise-studio

Image Credit: http://iea.wikidot.com/bizzdesign-architect

download-BiZZdesign-Architect

Database Deployment Manager

Database Deployment Manager (DDM) is an open source desktop oriented multi-platform database design tool that allows database administrators and/or programmers to create database structures (using an object oriented methodology) and deploy them into an existing database.

Database-Deployment-Manager

Tool Description as in https://en.wikipedia.org/wiki/Database_Deployment_Manager

Image Credit: https://en.wikipedia.org/wiki/Database_Deployment_Manager#/media/File:Database_Deployment_Manager_screen-shot.jpeg

download-Database-Deployment-Manager

Database Workbench

MySQL Workbench is a unified visual tool for database architects, developers, and DBAs. MySQL Workbench provides data modeling, SQL development, and comprehensive administration tools for server configuration, user administration, backup, and much more. MySQL Workbench is available on Windows, Linux and Mac OS X.

Database-Workbench

Tool Description as in https://www.mysql.com/products/workbench/

Image Credit: https://www.mysql.com/products/workbench/

download-Database-Workbench

Useful Videos

BiZZdesign Architect

Source:BiZZdesign France

Sparx Enterprise Architect

Source:philippeback

ER/Studio

Source:IDERA Software

Leave a Reply

Your email address will not be published. Required fields are marked *