Storing binary files in a relational database is not very efficient. The process of saving and retrieving the files from a database is generally much slower than using file storage. Also, it is a good idea to keep your database as small as possible. If the database is huge, backups become very large and difficult to manage. Instead of keeping large files in the database, we recommend putting them on disk or in a file storage service (such as S3 in AWS).
Picking the right type for a column is important, but the best choice is not always obvious. A common beginner mistake is to use a floating point type to store financial values. It is very important not to use floating point types (such as REAL, DOUBLE PRECISION, etc.) to store financial data. Calculations performed on floating point types can be inaccurate, which is unacceptable when working with business-related data. If you’re dealing with money, approximations are not sufficient!
Have you ever wondered what to do if you need help with Vertabelo? Find the available options here. The first place to look for help is the Vertabelo documentation. You can find it at https://www.vertabelo.com/documentation. It provides detailed information on managing your documents, logical data modeling, physical data modeling, and SQL scripts. There’s also a FAQ section on our site to help you quickly get answers to common questions. If you cannot find a solution in the FAQs or the documentation, visit our support site at https://support.
Sometimes you need to perform actions that you can’t directly model in Vertabelo. For example, you might want to define functions or stored procedures, add users, or set permissions for objects such as tables or views. This can be done using additional SQL scripts. Here’s how. Open your model. On the right, you can see the Model properties menu. Click Additional SQL scripts. You can set scripts to run at the beginning or end of a create script or at the beginning or end of a drop script.
What if you have a DDL script (i.e. an SQL script that defines data structures) and you would like to visualise it by creating a model of the database? This can be done in Vertabelo by importing the SQL script. Open your model. Click on the model name in the upper-left corner. Click Import and Import from SQL. A new window will appear. Click Browse to add a file from your computer.
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.
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.
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.
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).
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.