Technical
Best Database Tools for 2022
18 Jan 2022
Another successful year is coming to an end. Time to get prepared for 2022! You should equip yourself with the best database tools so that you can outshine your competitors and delight your clients in the coming year. Read on and let’s get ready to take on the challenges in 2022.
Building and maintaining a database is not a simple process; it requires the right database tools. Different activities are included, such as modeling data, developing and managing physical databases, querying, programming, testing, performing administration functions, and making modifications, among others.
Technical
How to Store Temporary Data: Multi-Page Forms
15 Jan 2022
How do you solve the problem of storing temporary data in a database? Imagine a situation when you fill in a multi-page form. What happens if you pause and come back in a few days to finish it? It would be great if the data is saved, and if you can take it up right where you left it.
However, this brings up a question: where should this temporary data be stored?
Technical
How to Define a UNIQUE Key in Vertabelo
13 Jan 2022
Among the many database constraints available to us, the UNIQUE key constraint ensures the uniqueness of data in a column or a set of columns. Read on to find out more about the UNIQUE key constraint and how to define it in Vertabelo.
In this article, we’ll focus on the UNIQUE key constraint. We’ll start with its basic definition and usage and gradually build up to more advanced options. Also, we’ll jump into Vertabelo and create an ER diagram that uses the UNIQUE key constraint.
Technical
7 Tips for Staying Relevant as a Data Modeler
11 Jan 2022
Many people draw boxes connected by lines and think they do data modeling. But we data modelers know our work goes far beyond that. Here are the desired skills in data modeling and important considerations for staying relevant as a data modeler.
Data modelers are essential in many situations. We are called to be part of a software development team in the early stages of a project for building the foundations of a software solution.
Technical
How to Find a Table in a Vertabelo ER Diagram
6 Jan 2022
As a database evolves, ER diagrams can get quite complex, even complicated, if not organized properly. While you can learn how to create logical and physical diagrams and efficiently organize ERD diagrams in Vertabelo, there are some features in Vertabelo that help you better navigate complex diagrams.
One such feature is to find and focus on a table by its name. This simple feature can help you at the time of modeling and as you organize your data model.
Technical
What I Like About Database Modeling
4 Jan 2022
The greatest satisfaction of database modelers is in seeing their creations transformed into efficient repositories of information for business processes. Of course, modeling databases can also have its share of frustrations, but we'll get to that.
What makes building scale models fun? Whether it’s RC cars, airplanes, ships, or a science-fiction spacecraft, scale models allow you to build a miniature representation of huge real-life objects.
I was fascinated by scale models when I was a kid.
Technical
What Is a Database Index, and What Does It Do?
30 Dec 2021
Understand what a database index does and how it can improve SQL query performance.
Modern databases store terabytes or petabytes of data and are a key resource for organizational operations and decision-making. A database index is a special data structure that allows quick access to specific pieces of information without having to read all data stored in a particular table. They ensure database performance in transactional environments.
How Does a Database Index Enhance Access to Information?
Technical
What's the Best ER Diagram Tool for Windows?
28 Dec 2021
Our picks for the top 10 Windows database modeling and ER diagramming tools.
The Windows operating system is one of the world’s most popular. So what are the ten best ERD tools for Windows, and why do we need them? With the diversification of operating systems, very few data modeling software are exclusive to Windows; many are implemented in the (cross-platform) Java programming language or as online tools. But as many people use Windows, it’s good to know which tools work well in a Windows environment.
Technical
How to Define the Order of Items in a Database
25 Dec 2021
What do you do if your data needs to have a defined order? The database itself does not guarantee the order of records unless you explicitly use an ORDER BY clause.
However, you can always use a numeric field to define the order in which the items should be displayed. To avoid duplicate positions, use a UNIQUE constraint on that field.
In the example below, the database stores music albums. Each song on an album has its position that can be set in the seq field of the album_song table.
Technical
How to Model Snowflake External Tables in Vertabelo
23 Dec 2021
There is a lot more data than stored in databases. This raises the question of how to access all the external data from the database. The external tables come to the rescue! Read along to learn more about external tables in Snowflake and how to model them in Vertabelo.
This article focuses on external tables in the Snowflake database. We will first introduce the Snowflake database and the concept of external tables.
