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

This article will explain in detail what the modeling tools of MySQL database are, and the content of the article is of high quality, so the editor will share it with you for reference. I hope you will have some understanding of the relevant knowledge after reading this article.

Database modeling and design is an indispensable step in the process of software development. a good modeling tool can help us to complete the database design simply and quickly and improve the efficiency of the work. Therefore, today I recommend several free MySQL database modeling tools, first of all, their functional comparisons are given:

ERD refers to entity relation diagram (Entity Relationship Diagram); forward engineering (Forward Enginnering) refers to generating DDL scripts (SQL files) that create database structures from ERD or connecting directly to the database to create physical tables and other objects; reverse engineering (Reverse Enginnering), on the contrary, refers to the generation of data models from SQL scripts or physical databases Schema synchronization refers to comparing the differences of schema structures in ERD and SQL scripts or physical databases, and supporting the synchronization of database structures.

MySQL Workbench

MySQL Workbench is a visualization tool officially provided by MySQL for database architects, developers, and DBA. MySQL Workbench supports data modeling, SQL development and server configuration, user management, performance optimization, database backup and migration, as well as Windows, Linux and Mac OS X platforms.

MySQL Workbench provides an interface for visual design, modeling, script generation, and database management for DBA, developers, and data architects. It provides all the functions that data modelers need to create complex ER models, forward engineering, reverse engineering and schema synchronization, as well as complex change management and document generation functions. The following is a visual design interface:

MySQL Workbench Community Edition can be downloaded and used for free, and a paid enterprise version is also available. As an official dedicated management development tool, MySQL Workbench provides perfect support for MySQL and is recommended for use.

SQL Power Architect

SQL Power Architect is a data modeling tool created by data warehouse designers with many unique features designed specifically for data warehouse architects. SQL Power Architect Community Edition supports Windows, Linux, and Mac OS X platforms, allowing users to reverse engineer existing databases, perform data analysis, and automatically generate ETL metadata.

The main functional features of SQL Power Architect include:

Access a variety of databases through JDBC, including Oracle, MySQL, SQL Server, PostgreSQL, etc.

Connect multiple different database products at the same time, compare the data model and database structure and identify differences

Support for drag-and-drop work

You can remember the source of each field and generate a visual source-target data mapping report

Forward engineering / reverse engineering

According to the data analysis of the existing database, the data size, maximum and minimum value and frequency distribution of each field are obtained.

Support for saving snapshots of source data structures, allowing remote offline design

Automatically generate ETL metadata (Kettle/Pentaho Data Integration)

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

OLAP modeling: Cubes, Measures, Dimensions, Hierarchies, and Levels

Visual mapping report for data lineage tracking.

SQL Power Architect is a powerful database modeling tool, especially suitable for data warehouse design, and the free community version can be downloaded from the official website.

PDMan

PDMan is an open source and free database modeling tool made in China, which is positioned as a free alternative to PowerDesigner. PDMan supports Windows, Linux and Mac OS X platforms and is extremely easy to use and has its own cases.

The main features of PDMan are as follows:

Open source code, free to use

The function is simple, comes with reference cases, and is very easy to use.

Average availability of Windows, Linux, and Mac OS X

Default built-in MySQL, Oracle, SQL Server, PostgreSQL code templates, users can customize other database code templates according to the model

Generate different database DDL statements according to the database dialect template

Generate change DDL statements according to the model and version, and run synchronization to the database directly

Reverse parsing of database, connection to database generation model

Automatically generate data structure documents in HTML, Markdown, Word and PDF formats

The built-in code template generates JavaBean and comes with Chinese comments.

PDMan is based on Node.js development, the source code is hosted on Gitee, and the latest version can be downloaded. PDMan is a very excellent domestic database modeling tool, but the update frequency is not high, and the latest version is v2.1.6 released in May 2019.

RISE

RISE is a free software suite for model-driven information system development that includes the functions needed to build an information model and transform it into a complete solution, including databases, Web services, and documentation. RISE is developed based on Microsoft .NET Framework 4, supports the Windows platform, and includes the following tools:

RISE Editor, graphical modeling tool

Code generators, various code generation tools, including SQL Server, MySQL and PostgreSQL database script generation tools, C #, PHP, AJAX application source code generation tools, etc.

RISE Visual Modeling,Visual Studio extension to integrate database modeling and code generation tools into Visual Studio IDE.

The main features of RISE include:

Complete entity diagram, support for views and indexes, support for model export as pictures

Automatic naming conventions, cascading changes and naming, model refactoring, model consistency, automatic interface generation, model documentation, built-in web service tests

Automated database deployment and web deployment, integrated cloud solutions, centralized server development, support for team collaboration

Support browsing database tables and views, analyze field information, general SQL prompts, support reverse engineering of SQL Server, MySQL, PostgreSQL, Oracle, DB2

Database script generation tool supports SQL Server, MySQL, PostgreSQL, incremental database update, and model supports default data generation.

The application code generation tool supports C #, PHP, SOAP web service, and persistence layer code without a programming foundation.

RISE is a complete suite of information systems engineering for model-driven system development and can be downloaded free of charge from the official website.

GenMyModel

GenMyModel is a browser-based online modeling platform that supports Archimate, BPMN, Flowchart, RDS (Relational Database Modeling), UML and other models. Individuals can use them for free. GenMyModel provides functions such as model verification, online model repository, model version record, SQL code generation and model export pictures.

DB Designer

DB Designer is an online database schema design and modeling tool, which is easy to operate but powerful. It supports forward engineering and reverse engineering of MySQL, SQL Server, PostgreSQL, Oracle and SQLite databases. DB Designer also supports teamwork, work sharing, and exporting pictures or PDF functions.

Dbdiagram.io

Dbdiagram.io is a simple and free online ER drawing tool that creates models by writing code and is designed for developers and data analysts. It generates the data model through a simple custom language and supports forward engineering and reverse engineering of MySQL, PostgreSQL, SQL Server database DDL files, version history, online sharing, exporting pictures or PDF and other functions. Dbdiagram.io offers a free version.

Freedgo

Freedgo is a domestic online drawing and modeling tool that supports mind mapping, ER model, cloud architecture design, UML, network topology map, building plan, business design, flow chart and so on. ER model supports forward engineering and reverse engineering of database DDL files such as MySQL, SQLServer, Oracle, PostgreSQL, as well as image export functions. Freedgo offers a free version for individual users.

The editor introduces eight free MySQL database modeling tools, including client software and online tools. Client software provides powerful and perfect modeling functions; online modeling tools can be used without installation, and the function is relatively simple.

On the MySQL database modeling tools which are shared here, I hope the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.

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.