Author: Lisandro Fernigrini

Lisandro is a Database Architect from Rosario, Argentina. With almost 20 years of experience in Oracle and SQL Server, among other database engines, he currently works as Sr. Data Engineer on OZ Digital Consulting. He is also a member of both the Oracle ACE program and the Argentina Oracle User Group. In his free time, he enjoys watching his soccer team (Rosario Central) with his two sons.

How to Generate a Snowflake Database Model DDL

In this article, we will see how to use Vertabelo to create a Snowflake DDL script. We’ll start from a data model created online and walk you through the process of generating the SQL script that will create the physical database. Vertabelo is a powerful yet easy-to-use data modeling tool that can help you create database models for many database engines, including Snowflake. What Is Snowflake? Snowflake is a Cloud-based Database-as-a-Service designed by former Oracle engineers.

Designing an Amazon Redshift Data Model Using Vertabelo

See how Vertabelo can help you design a database diagram for Redshift. This article will show you how to use Vertabelo as a database modeling tool for Redshift. It allows you to design and implement a database model in a simple way.  (Vertabelo also supports other database management systems, but in this article we’ll focus on the Amazon Redshift DBMS). What Is Amazon Redshift? Amazon Redshift is a Cloud-based, data warehouse oriented implementation of PostgreSQL database engine designed and offered by Amazon.

Database Design for Online Survey Systems

In this article, we review the steps for creating a database design for an online survey system using Vertabelo Data Modeler. Learn how to create a logical database model, add all the entities and relationships required, and then transform it into a physical database model by generating the SQL scripts to implement it on your database of choice. This article explains the tasks to create a database model for an online survey system, step by step.

Where to Find Database Diagram Examples

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.

Database Design for Multi-Language Applications

While some software systems are used by a limited number of users speaking the same language, most organizations need to unify and centralize their applications to be used by people speaking different languages all around the world. Multilanguage databases present an additional level of difficulty in designing and implementing data models. In this article, we suggest some approaches for dealing with this challenge. What Information Do We Need to Store in Multiple Languages?

How to Store Login Data in a Database

Figuring out authentication is part of a secure data storage strategy. Find out how to store auth data safely in your database. Almost every application requires user authentication; that is why authentication data storage is a common feature of database and application design. Special attention is needed to ensure data is kept secure and to avoid breaches that can compromise sensitive information. Do I Need Authentication or Authorization? Although both words are frequently used in a similar way, they do not mean the same thing.

5 Examples of a UNIQUE Constraint in a Relational Database

5 Examples of a UNIQUE Constraint in a Relational Database UNIQUE constraints help guarantee your data model integrity. This article walks you through 5 examples of UNIQUE constraints in a relational database. Relational databases allow us to define different kinds of constraints (like UNIQUE) to implement integrity rules and ensure that data complies with them. UNIQUE constraints guarantee that no duplicate information is entered in a column (or that no set of columns has the same combination of values).

What Are the Different Types of Database Constraints?

Database constraints are a key feature of database management systems. They ensure that rules defined at data model creation are enforced when the data is manipulated ( inserted, updated, or deleted) in a database. Constraints allow us to rely on the database to ensure integrity, accuracy, and reliability of the data stored in it. They are different from validations or controls we define at application or presentation layers; nor do they depend on the experience or knowledge of the users interacting with the system.

What Is a Database Index, and What Does It Do?

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?

8 Advantages of an Online ER Diagram Tool

ER diagram tools are a key component in software development. Whether you are designing a new system or feature from scratch or analyzing and applying changes to an existing solution, you need an ERD modeling program. Using an online ERD diagram tool allows you to start working immediately, without worrying about installation and setup. Plus, online ERD tools enable quick collaboration and easy access to your data models. You may have heard the phrase “a picture is worth a thousand words”.