Shulou(Shulou.com)06/01 Report--

Original: Mo Sky Wheel (https://www.modb.pro/db/6499)

Introduction: database modeling is an indispensable link in software design. How well the database is built is related to the expansion of the whole system, performance optimization and later maintenance. Correct and coherent data flow can play a decisive role in making fast and flexible decisions for business users. Therefore, the establishment of the correct data flow and data structure can ensure the best results. We have summarized 12 database modeling tools, hoping to provide some help to database practitioners!

PowerDesignerPowerDesigner, the leader of data modeling industry, is the leader of data modeling industry at present. Features include a complete integrated model and differentiated modeling requirements that include IT-centric and non-IT-centric modeling. Support for a very powerful metadata repository and output in various formats. PowerDesigner has an elegant and user-friendly interface and very easy-to-understand help documents to quickly help users solve professional problems. PowerDesigner is the enterprise modeling and design solution of Sybase. Using model-driven approach, combining business with IT can help deploy effective enterprise architecture and provide powerful analysis and design technology for R & D lifecycle management. PowerDesigner supports more than 60 database systems (RDBMS) / versions. PowerDesigner runs on the Microsoft Windows platform and provides the Eclipse plug-in. The main interface is shown in the following figure:

According to Gartner, PowerDesigner accounts for about 30 per cent of the data modeling market. PowerDesigner prices range from $3000 to $7500 (per developer). PowerDesigner supports:

Demand analysis

Object-oriented modeling (provides all views of UML 2.0)

Data modeling (supports mainstream database systems)

Business process Modeling (ProcessAnalyst) supports BPMNPowerDesig ner 12.5 as an enterprise modeling and design solution for Sybase.

The 16.5SP04 version provides support for Greenplum4.2, through which you can configure access to Greenplum series databases and Deepgreen DB.

XML modeling (supports XML Schema and DTD standards)

Data Warehouse Modeling (WarehouseArchitect)

Code generation (supported languages and frameworks include: Java, client, VB .NET, Hibernate, EJB3, NHibernate, JSF, WinForm (.NET and .NET CF), PowerBuilder,...)

Report generation

Enterprise knowledge base

Visual Studio 2005 plug-in

Eclipse plug-in

Database modeling platform and mining tool TipDM

TipDM data mining modeling platform is an open source platform for data mining modeling based on Python engine. TipDM provides a rich number of data analysis and mining modeling components. Users can operate through drag-and-drop without programming basis, and connect data input and output, data preprocessing, mining modeling, model evaluation and other links through a process way to help users quickly establish data mining projects and improve the efficiency of data processing.

Main features:

Based on Python, it is used for data mining modeling.

Use an intuitive drag-and-drop graphical interface to build a data mining workflow without programming.

Supports a variety of data sources, including CSV files and relational databases.

Support online preview of the results of each node in the mining process.

Provide 5 categories a total of 40 algorithm components, including data preprocessing, classification, clustering and other data mining algorithms.

Support to add / edit algorithm components with a high degree of customization.

Provide a large number of publicly available data mining sample projects, one-click creation, fast run.

Provide a comprehensive communication community, provide data mining-related learning resources (data, code, models, etc.).

Database modeling tool PDMan

PDMan is an open source and free database modeling tool, which supports Windows, Mac,Linux and other operating systems, as well as common databases such as MySQL, Oracle, SQLServer,DB2 and so on. PDMan database modeling, automatic generation of documents, automatic synchronization of DDL scripts to the database, data model version management and other practical functions of developers.

PDMan is a database model and database version management tool. The main functions are as follows:

Database modeling

Automatic code generation

Automatic document generation [this small feature involves commercial plug-ins, not open source] (HTML,WORD,PDF generation)

Database version management

PostgreSQL modeling tool pgModeler

PgModeler is a special modeling tool for PostgreSQL database, which is developed using QT and supports Windows, Linux and OS X platforms. Use classic entity relationship diagrams, including PostgreSQL-specific features.

Fully automatic

You can create a model for each table

You can create an initial migration

Keyword declaration, uniqueness and existential constraints

You can create an association

Add a custom test method for CHECK constraints

Intuitive data Modeling tool-ER/Studio

ER/Studio is an intuitive data modeling tool that supports multi-platform environments and is natively integrated to handle big data platforms such as-MongoDB and Hadoop Hive. It can do forward and reverse engineering, and has a "compare merge" function, can output documents such as XML, PNG, JPEG and other formats. The built-in automatic task execution function supports the current popular database platform. ER/Studio is very powerful, with an intuitive interface and good user support, it's easy to get started right away.

ER Master is an Eclipse plug-in for designing ER model diagrams. The functions provided include: import relations from the database to generate ER diagrams, export design drawings, export DDL data definition statements, and so on. Currently, fully supported databases include:-MySQL-PostgreSQL-Oracle (developing)-DB2 (developing)-HSQLDB (developing)-SQLITE (developing)-SQLServer (developing) open source platform-Eclipse data modeling tool IBM-InfoSphere Data Architect

InfoSphere is a very innovative data modeling tool that runs on the open source platform-Eclipse. Infopshere focuses on three main features: efficiency, simplicity, and high integration. InfoSphere can help business users to build logical and physical model diagrams, and then it can be easily used in a variety of different applications and systems. InfoSphere is an end-to-end solution that can be used to build, deploy, and update data models quickly and efficiently. At the same time, it is very easy to integrate other related products of IBM. MySQL Workbench-an ER/ database modeling tool designed by MySQL

MySQL Workbench is an ER/ database modeling tool designed specifically for MySQL. It is the successor to the famous database design tool DBDesigner4. You can use MySQL Workbench to design and create new database diagrams, create database documents, and perform complex MySQL migrations. MySQL Workbench is the next generation of visual database design and management tools, it has both open source and commercial versions. The software supports Windows, macOS and Linux systems. Database modeling SQL Power Architect

SQL Power Architect is a database modeling tool developed by Java, which is especially suitable for application modeling of data warehouse and data Mart. It allows designers to open multiple data source connections at the same time and obtain the model definition directly from the database. It can drag and drop models, tables and columns between different databases.

Features:

Access the source database through JDBC

Connect to multiple source databases simultaneously

Compare data model and database structure and identify differences

Drag and drop source tables and columns into the fence

Remember the source of each column

Generate a visual source-to-target mapping report

Forward / reverse engineer PostgreSQL,Oracle,MS SQL Server, etc.

Save a snapshot of the source data structure in the project so that you can work remotely

All project data is stored in XML format that is easy to parse

OLAP schema modeling: cubes, measures, dimensions, hierarchies and levels

Licensed GPL (version 3)

Enterprise Architect, an enterprise modeling tool

Enterprise Architect is a computer-aided software engineering (CASE) tool for designing and building software systems, business process modeling, and more general modeling. Features:

UML modeling-support for UML2.1

Code engineering-generate code according to the diagram and import the original code to become a UML diagram

Project management procedures-including project plans, task schedules, problem sets, etc.

Document generation and templates-text translation substitutions and custom templates can be used to create the most appropriate document types for different projects

Database modeling-you can import data source structures from ODBC, edit ER diagrams, and generate SQL statements to build tables

Code editing, debugging and running-add compilation scripts, you can use EA as IDE to use version control, online discussion, LAN collaborative development and other functions

Data modeling tool Power*Architect

Power*Architect is a data modeling tool, mainly used in data warehouse and data Mart model design.

Power*Architect allows designers to open multiple concurrent source database connections, create and explore configuration files for source data, discover differences between the two schemas (even if they are on different database platforms), drag and drop source schemas, tables, and columns to the data modeling fence, and forward the project results target database and its associated ETL templates.

Want to know more about databases and cloud technologies?

Come and follow the official websites of "data and Cloud", "Cloud and Enmo", "official account" and "Yunhe Enmo". We look forward to your learning and progress together!

Mo Tianlun Mini Program "DBASK" online Q & A, at any time, welcome to understand and follow!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.