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.
Amazon DocumentDB (with MongoDB compatibility) is a fast, scalable, highly available, and fully managed document database service that supports MongoDB workloads.… Read the rest
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.
Amazon DocumentDB (with MongoDB compatibility) is a fast, scalable, highly available, and fully managed document database service that supports MongoDB workloads.… Read the rest
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.
In this article we will show how to connect to Cosmos DB (API for MongoDB) and how to visualize an existing database structure.
Azure Cosmos DB API for MongoDB allows you to use Cosmos DB in a way as if it were a MongoDB database.… Read the rest
Several tools can be used to visualize existing GraphQL schemas. Some of them allow you to browse the structure in the form of a hierarchical tree. Moon Modeler, on the other hand, offers the ability to visually model new GraphQL schemas and also automatically create diagrams from existing sources.
Before we show how to make a diagram of your GraphQL schema, let’s take a look at how to easily create a brand new GraphQL schema diagram.… Read the rest
In Moon Modeler you can
In this section, you will learn how to import a GraphQL schema from an online source and how to modify the visualization. The StarLink schema, available at https://api.spacex.land/graphql/… Read the rest
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:
A crow’s foot graphics represents “many” or “infinite”.… Read the rest
You can manually write SQL scripts in your favorite SQL editor and execute individual SQL commands directly on the connected database. However, another option is to use a data modeling tool in which you design the database structure visually, using an ER diagram.… Read the rest
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).
But what is the advantage of data modeling when we talk about noSQL databases?… Read the rest
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: