Technical
A Complete Guide to Database Diagram Symbols
15 Nov 2022
A complete guide to the symbols shown in entity-relationship diagrams (ERDs).
Although data modeling became a necessity around the 1970s, there was no standard way to model databases or business processes. Many solutions were proposed and discussed, but none were widely adopted.
Peter Chen is credited with creating the ER (entity-relationship) model, which introduced a way of mapping data model elements (which would become database elements) and their relationships. This model can serve as the diagram as well as the documentation for a database project.
Technical
Best Practices for Database Schema Name Conventions
8 Nov 2022
Assigning names to objects in your database is not a trivial task. This list of best practices for naming conventions in data modeling will help you do it the right way.
The task of designing a database schema is similar to that of creating the plans of a building. Both are carried out by making drawings in an abstract, theoretical framework. But they must be done with the understanding that these drawings will later become robust structures that support large constructions – in one case, constructions made of solid materials; in the other, constructions made of data.
Technical
Top 7 Database Diagram Tools for Linux
1 Nov 2022
What is the best database diagram tool for Linux? This post will help you find out – and potentially save you time, frustration, and money!
Data modeling is a crucial component of any database development project. Your database project could fail if you move forward without a suitable data model. You can learn more about why you need data modeling here.
It's crucial to select the best ER diagram tool for your project.
Technical
Designing an Amazon Redshift Data Model Using Vertabelo
25 Oct 2022
See how Vertabelo can help you design a database diagram for Redshift.
This article will show you how to use Vertabelo as a database modeling tool for Redshift. It allows you to design and implement a database model in a simple way. (Vertabelo also supports other database management systems, but in this article we’ll focus on the Amazon Redshift DBMS).
What Is Amazon Redshift? Amazon Redshift is a Cloud-based, data warehouse oriented implementation of PostgreSQL database engine designed and offered by Amazon.
Technical
A Detailed Guide to Database Schema Design
18 Oct 2022
When you don't have a guide, certain tasks seem more difficult than they really are. In this article, I offer you a complete database design guide so you won’t get lost when trying to build a robust and effective database.
A database schema is basically an abstract concept. Even so, it’s better to think of it as a practical tool that helps you create structures to turn large amounts of data into something useful.
Technical
What Is a Database Diagram?
11 Oct 2022
A database diagram is essentially an abstract graphical representation of the structure of a database. It can be used both as a tool to assist in the design of a database and as a document that shows the structure of an existing database.
You can think of a database diagram as a poster that you stick on a wall for programmers to look at when they need to know the name of a table or column.
Technical
Top 8 Most Useful Database Tools for SQL Server
4 Oct 2022
Is creating complex SQL Server databases a challenge? Read on and discover our top SQL Server database tools.
In this modern era, databases have become essential. So, database development has become a most common and vital part of the software development world. Microsoft SQL Server plays a significant role here; it’s one of the most popular Database Management Systems (DBMS) among database developers.
This article will discuss 8 of the most useful database tools for SQL Server developers.
Technical
Create an Online Data Model in 4 Steps
20 Sep 2022
Learn how to use four simple steps and a data modeling tool to create a database diagram online.
Creating database diagrams (aka data modeling) is an essential part of modern database development projects. A good data model is to a database what a strong foundation is to a skyscraper. Due to the availability of modern data modeling tools, this has become a straightforward process.
What Is Data Modeling? Data modeling is the process of identifying and graphically representing the data elements and entities along with their attributes, relationships, operations, etc.
Technical
Export SQL DDL From MySQL Workbench for Importing Into Vertabelo
6 Sep 2022
Do you have an existing database model you would like to work with in Vertabelo? If so, you've come to the right place!
In this article, you learn how to export a DDL file from MySQL Workbench and import it into our modeling tool. We also take a look at other ways to import an existing database schema into Vertabelo and organize existing tables.
How to Export a DDL File From MySQL Workbench First, let's see how to export an existing database.
Technical
The Ten Best Database Diagram Tools for SQL Server
30 Aug 2022
Understand the best SQL Server modeling tools for your needs based on differences in features and the value for the money.
In this article, we discuss ten database diagram tools for SQL Server. Creating robust database models is critical in ensuring the database meets the needs.
Microsoft SQL Server, or SQL Server, is one of the most used proprietary relational databases. It supports various applications, business intelligence, and analytics in corporate IT environments.
