Reverse engineering means retrieving information about the database structure. It is about finding out what objects exist in the database, such as tables, columns, views, procedures, etc., and what relationships exist between these objects. Based on this information, it is possible to draw an ER diagram in which the relationships can be clearly displayed.… Read the rest
Tag: database visualization
Articles related to database visualization in Moon Modeler – a database design tool for both relational and noSQL databases and GraphQL.
Database connections
Moon Modeler allows you to visualize existing relational and noSQL databases. You can connect to your locally running or cloud database. To manage your database connections, click the Connections button on the main toolbar.
Creating a new database connection
Click the button Create a new connection to open a modal form.… Read the rest
Import & Visualization of existing SQLite databases
Connection to SQLite database is not classic, so you will not find the option of this database in the connections section. To visualize an existing SQLite database structure, go to the Projects section and import SQLite from a file.
Select the database file. In this example, we will load the chinook.db… Read the rest
Visualization of existing MySQL databases
All database connections are available in the Connections section. To create a new connection, click the Connections button on the main toolbar, and then click Create New Connection. A new modal form opens. Select MySQL and enter the connection details.
When you are finished, click the Save Connection button.
Your new MySQL connection will appear in the list of all database connections.… Read the rest
Visualization of existing MariaDB databases
All database connections are available in the Connections section. To create a new connection, click the Connections button on the main toolbar, and then click Create New Connection. A new modal form opens. Select MariaDB and enter the connection details.
When you are finished, click the Save Connection button.
Your new MariaDB connection will appear in the list of all database connections.… Read the rest
Database reporting
Creation of HTML reports for your data models
Note: The database reporting and HTML report creation is available only in the Professional edition of Moon Modeler
Key benefits of the generated HTML reports
- HTML and SVG format – high quality format of the graphics and lines.
- Interactive diagrams – click on any item in the diagram to open the detail.
About Moon Modeler – a data modeling tool for relational and noSQL databases
Moon Modeler is a data modeling tool for MongoDB, PostgreSQL, MariaDB, MySQL, SQLite, Mongoose and GraphQL. The software belongs to the data modeling and schema design tools category and can be used to model hierarchical database structures. Embedded documents can be displayed inside MongoDB collections, JSON structures in MariaDB, MySQL, PostgreSQL or SQLite entity relationship diagrams (ERD). … Read the rest
Visualization of existing PostgreSQL databases
All database connections are available in the Connections section. To create a new connection, click the Connections button on the main toolbar, and then click Create New Connection. A new modal form opens. Select PostgreSQL and enter the connection details.
When you are finished, click the Save Connection button.
Your new PostgreSQL connection will appear in the list of all database connections.… Read the rest
Visualization of existing MongoDB databases
Connections and reverse engineering
Moon Modeler allows you to visualize existing MongoDB databases. You can connect to your locally running or cloud-based MongoDB database. To manage your database connections, click the Connections button on the main toolbar.
Then click the button Create a new connection to open a modal form. Select MongoDB from the type dropdown or click the MongoDB icon.… Read the rest
MongoDB schema design
The following text explains how to design a new database structure for MongoDB.
The MongoDB schema design article is divided into the following sections:
- New project
- MongoDB schema design – collections
- MongoDB schema design – documents
- Embedded documents vs References
- Code generation
1. New Project
To create a new project in Moon Modeler click the New item on the toolbar.… Read the rest