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.
Technical
The Difference Between Entities and Attributes in a Data Model
17 May 2022
The entity-relationship model is composed of different elements. The most important types of elements are the entities and their attributes. In this article, we go into detail about the distinction between them, the role they play in a data model, and the steps to create them in Vertabelo.
What Is Data Modeling? Data modeling is carried out by a database architect or database modeler. It is the process of creating a diagram that lists the set of data structures that are going to be the data backbone of a software application.
Technical
When to Choose SQL vs. NoSQL Databases for Your Project
10 May 2022
NoSQL databases promise flexibility and performance benefits for certain use cases. But is it worth leaving behind the relational database comfort zone that guarantees consistency and organization? Read on and find the answers to the NoSQL vs. SQL database debate.
We probably all agree on the most basic definition of what a database is: a repository of information organized in such a way as to make it easy to update, search, and read.
