Technical
How to Import a Vertabelo XML File into Vertabelo
18 Sep 2021
Sometimes it’s useful to generate a model based on a saved configuration. Vertabelo models can be exported as XML files; later on, these files can be imported back to Vertabelo to create a model. This can be helpful, e.g. for backups.
Open your model. Click on the model name in the upper-left corner. Click Import and then Import from XML.
Click Browse to choose a file from your computer.
Technical
Database-Related Jobs and the Differences Between Them
16 Sep 2021
Find out who’s who in the database department and decide which role you most identify with.
In small companies, there is usually only one database job. The person in that position may be an architect one day, a designer the next day, a programmer another day, an administrator the day after that, and sometimes even an analyst or even a data scientist. If you’re planning to work in a small company, you should get used to the idea that you’ll be known as “the database guy/gal” and you’ll have to do a little bit of everything.
Technical
How to Get an Academic Account in Vertabelo
14 Sep 2021
Vertabelo has three types of paid accounts for businesses and professionals to choose from: Basic, Premium, and Team. We also offer a free Premium-level account for students and teachers called the Academic account. It’s part of our commitment to support the education community.
Access to an Academic account enables both students and teachers to use Vertabelo for relevant courses, tests, demos, etc. without any cost.
How do you know if you’re eligible for an Academic account?
Technical
Vertabelo Document Types
11 Sep 2021
There are various document types in Vertabelo: folders, physical data models, logical data models, and SQL scripts. What do they do, and how can you tell them apart visually?
Go to your drive. In the right panel, you’ll find folders, which are designated by this icon . Folders can contain documents or other folders.
Inside folders you can place: logical data models, physical data models and SQL scripts.
Technical
What Is a Primary Key?
9 Sep 2021
Keys are one of the most vital features in a relational database. Among the many types of keys, the primary key is widely used and appreciated. Let’s find out what kinds of primary keys are available, what a primary key does, and how to use it in a table.
In this article, you’ll learn all about primary keys in relational databases. The topics we’ll cover include:
An overview of relational database keys.
Technical
Vertabelo Feature: Google BigQuery Support
7 Sep 2021
Cloud databases are becoming more and more popular. That’s why Vertabelo has added support for Google BigQuery, one of the most popular cloud databases. BigQuery is an enterprise data warehouse that enables the storing and very fast processing of huge data sets. It can be useful in data analytics, machine learning, and other areas.
If you’re working with multiple Cloud databases, check out our articles on Amazon Redshift and how to model a Redshift database in Vertabelo.
Technical
How to Add a View to a Data Model in Vertabelo
4 Sep 2021
Views are essential in cases where we want to save our SQL query and then refer to its data using SELECT * FROM VIEW_NAME. In short, views allow us to save complex queries for future use. So, how can we add them to a data model?
On the left panel, right-click Views and click Add view. Alternatively, you can also click this icon on the top menu bar or use the keyboard shortcut (simply type 5).
Technical
What Is Data Modeling?
2 Sep 2021
Have you ever wondered how data modeling works?
Data modeling is the process of creating a data model. A data model can be thought of as a blueprint that describes the structure and internal relationships in a database. It is meant to demonstrate how objects within the database interact with each other to fulfill the prescribed business logic.
Since relational databases are composed of tables, a data model is a diagram that illustrates the relationship between these tables.
Technical
The 11 Worst Database Naming Conventions I’ve Seen in Real Life
31 Aug 2021
What – I can’t just let it be called Table_1?
After decades of working with databases, I’ve come across all kinds of naming conventions in database modeling, with varying degrees of usefulness. Some conventions are a great help when working with a database. Others are just a big headache.
When designing a data model, object names’ readability is an important consideration. A robot might not agree to this, as all names are equally easy for a robot to remember and to locate in a complicated SQL script.
Technical
Vertabelo Feature: Snowflake Support
26 Aug 2021
Vertabelo Feature: Snowflake Support Cloud and analytical databases are very popular and are becoming more important. Snowflake has been one of the most popular feature requests on our support page and a much-anticipated database for Vertabelo support. We are happy to announce that Snowflake databases can now be designed with Vertabelo!
In this article, we’ll explain how to create a physical ER diagram for a Snowflake database in Vertabelo. Remember that you can also choose to create a logical ER diagram first and then use that to generate a physical ER diagram.
