Technical
Manage Database Model Changes Easily With the New Model Explorer in Vertabelo
14 Jul 2022
Learn about Model Explorer, a new feature in Vertabelo Database Modeler.
Have you noticed that a new feature has been introduced to Vertabelo Database Designer? In this article, we take a deep dive into Model Explorer, an innovative way of managing your database models.
In short, Model Explorer allows for a comprehensive overview of the model and bulk editing of multiple elements at once. At this time, the functionality is available only for the physical model, but in the future, it will also be implemented in the logical model.
Technical
What Is a Database Schema?
12 Jul 2022
A database schema is used to define the structure of the tables and the relationships among them, the data types, and the constraints in a relational database. Sometimes, the word schema is synonymous with the entire database. In this article, we go through the concepts that define a database schema and how these concepts are represented in Vertabelo.
A database schema is the logical ordering and organizing of the elements and the data in a database.
Technical
Top 7 Database Schema Design Tools
5 Jul 2022
Database schema design tools are essential in your toolkit if you are a database professional. Your database development journey begins with these tools. Let's read on to find out the top database schema design tools.
This article lists my top database schema design tools with their key features. These tools are important since we start our database development journey with data modeling using a database design tool.
Data modeling is a step-by-step process of arranging data entities in an information system, starting from concepts up to building your physical database.
Technical
Where to Find Database Diagram Examples
28 Jun 2022
This article discusses various sources of database model examples you can use as a starting point for your data models.
Having a variety of database diagram examples on hand is very useful. This is true whether you are starting your career in database design or consider yourself a seasoned database professional.
It is a good idea to use existing database model examples as a starting point, rather than to try to reinvent the wheel.
Technical
Let's Create a Database Design for a Library System!
21 Jun 2022
Learn how to design a database from scratch for a library system. Try your hand at database design!
Are you interested in a job as a database designer? Imagine that we are planning to develop a software application to manage a local library. You need a library database model! The database designer needs to gather business requirements from the client and decide what data needs to be stored and how.
Technical
A Beginner’s Guide to Database Security
16 Jun 2022
How do database pros guard against data breaches? A quick overview of database security essentials: authentication, encryption, user access, and more.
Some time ago, I came across WIRED's article on the data breach at Vastaamo, a Finnish mental health provider network. It read like a cyberthriller: someone hacking into a massive database of patients' deepest, darkest secrets and using them to blackmail the company, the individual patients, and the community as a whole.
Technical
How to Create a Database Diagram from a DDL
14 Jun 2022
A database diagram, aka ER diagram, is a certain type of flowchart used in database design. It describes the entities and how they relate to one another. Vertabelo lets you create an ER diagram for your database by importing a DDL file. Read on to find out more.
This article introduces what a DDL file is and why ER diagrams are an essential tool in the database development process. In the end, I’ll show you how to import a DDL file into Vertabelo to get an ER diagram of your database.
Technical
What is the Difference Between a Database Designer and Data Analyst?
7 Jun 2022
Database designers work with data structures and data flows, while data analysts extract insights from huge amounts of data. Both careers have similarities and differences, and pros and cons. Read along to decide which one is the best fit for you.
Do you like data, but find it hard to decide how you prefer to work with it? You have (at least) two paths to choose from: be the one who designs the structures to store and process the information, or be the one who analyzes large volumes of data in order to extract the truths hidden in them.
Technical
What Is the Best Design for an Address Database Model?
31 May 2022
Find out how to build an address data model for different business needs.
Address modeling in a database can be tricky: what's the best way to split the data (street, city, state, etc.)? Is normalization more critical than performance? What ERD and data modeling tools do I use? When should I use domain acronyms and values ? Will the address structure meet all the business needs? Are these decisions the best for the project?
Technical
How to Put Tables in a Vertabelo Data Model Into a Particular Schema
24 May 2022
There is more to a database structure than just tables. Tables are logically divided into groups and stored in database schemas. Read along to find out how to include schemas in your ER diagram using Vertabelo.
A database consists of one or more database schemas, and a database schema consists of one or more tables. A good data modeling tool helps you set them all up. In this article, you’ll see how to create database schemas in Vertabelo and assign tables to them.
