AWS Amazon DocumentDB

In this article, we will explain how to connect to AWS Amazon DocumentDB in Moon Modeler 4.6.6 and how to automatically create an ER diagram of an existing database.

What is AWS DocumentDB?

Amazon DocumentDB (with MongoDB compatibility) is a fast, scalable, highly available, and fully managed document database service that supports MongoDB workloads.… Read the rest

AWS Amazon DocumentDB

Note: this article is old. Please see the latest version at AWS Amazon DocumentDB

In this article, we will explain how to connect to AWS Amazon DocumentDB in Moon Modeler 4.6 and how to automatically create an ER diagram of an existing database.

What is AWS DocumentDB?

Amazon DocumentDB (with MongoDB compatibility) is a fast, scalable, highly available, and fully managed document database service that supports MongoDB workloads.… Read the rest

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

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

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

NoSQL data modeling

Data modeling is the process of visually creating a graphical representation of a system or database. In the case of relational databases, we can mention the creation of entity-relational diagrams in which entities, attributes and relationships between entities are displayed. (Read more information about ER diagrams).

Advantages of data modeling

  • Fewer design and development errors
  • Easy and fast design, especially in the early stages of development
  • Better communication between team members
  • Time saving
  • Lower development costs
  • and many others

MongoDB schema design and noSQL database modeling

But what is the advantage of data modeling when we talk about noSQL databases?… Read the rest

Mongoose schema design

Quick start guide for Mongoose schema design in Moon Modeler.

  1. New project
  2. Mongoose schema design – schemata
  3. Mongoose schema design – nested types
  4. Embedded documents, schema and references
  5. Code generation

1. New project

To create a new project, click the New item on toolbar and select Mongoose project type.

Mongoose project


Later you can edit the project and choose colors for background, lines and footer.… Read the rest

Generating MongoDB schema validation scripts

To generate a MongoDB schema validation script from your project, click the Script icon on the main toolbar. A preview of the script will appear in the modal form.

Click the Save Scripts button and select a location to save the files.

Script generation

The Overwrite existing files option allows you to ignore existing scripts and overwrite them without displaying a warning.… 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, Cosmos DB API for MongoDB or AWS Amazon DocumentDB. To manage your database connections, click the Connections button on the main toolbar.

Connections - main toolbar

Then click the button Create a new connection to open a modal form.… Read the rest

Quick links

Free Trial Buy Now!

Blog categories