MongoDB schema design

Quick start guide for MongoDB schema design in Moon Modeler.

How to get started with MongoDB schema design?

The following text explains how to design a new database structure for MongoDB.

1. Create a new Project

To create a new project in Moon Modeler click the New item on the toolbar.… Read the rest

Heroku Postgres and ER diagrams

How to create ER diagram of PostgreSQL database running in Heroku? With Moon Modeler, the process is simple. Just create a database connection, retrieve the information from Heroku Postgres and create a project containing the ER diagram. But let’s start one step at a time.

What is Heroku and Heroku Postgres?

Read the rest
MongoDB indexes

MongoDB indexes

When you create a new index for MongoDB collection in Moon Modeler, the Index Assistant window will appear.

index assistant for mongodb indexes

Indexes can be defined easily. Just select the fields, either from the drop down element:

mongodb index creation

or by typing the field name directly. The auto-completion feature is available for you.

fields in mongodb index

Click the Add button to insert the field to the index.… Read the rest

Crow’s foot notation in ER diagram

Use crows foot notation to represent relationships between entities in an entity relational diagram. Entities are connected by lines, and symbols at the beginning or end of the line describe cardinality.

Relationship types and cardinality:

Symbols in crow’s foot notation

A crow’s foot graphics represents “many” or “infinite”.… Read the rest

MongoDB ER diagram graphics

Settings for MongoDB ER diagram graphics can be defined on two levels in Moon Modeler. On a project level and on a selected object level.

Project graphics

Click the MongoDB ER diagram area to make sure no object is selected. Then change the colors in section Graphics. Alternatively, edit Project properties and specify settings on tab Graphics of the modal form.… Read the rest

What is Entity Relationship Diagram (ERD)?

Entity relationship diagram describes the structure of the database. The entity relationship diagram shows entities (tables in relational databases) and relationships between tables that exist in the database. For a good database design, it is very important to have an entity relationship diagram.

In an entity relationship diagram, the basic elements are:

  • Entities (tables)
  • Attributes (table columns)
  • Relationships (relationships between tables)

Why create entity relational diagrams?

Read the rest
Generated SQL script

Forward engineering

When it comes to forward engineering in Moon Modeler, it’s about generating the resulting script for the selected target platform.

In the case of relational databases such as PostgreSQL, MariaDB, MySQL or SQLite, it is the resulting SQL script. For MongoDB it is possible to generate a schema validation script and for platforms like Mongoose or GraphQL it is schema definition scripts.… Read the rest

Quick links

Free Trial Buy Now!

Blog categories