Posts by
Redgate Data Modeler
As an SQL consultant, I often work with others to create new database models from scratch or modify existing schemas. Aside from the technical aspects, collaborations on database models can be tricky. Moving from environment to environment poses its own challenges: security restrictions sometimes prevent direct access to SQL instances, and technical resources from... Read more
The development release of MySQL 5.7 definitely introduces some exciting changes to the world of database management systems. Is it worth giving a try? Let's have a closer look at a few brand-new features that may help you decide to do so. Read more
In the third part of our series on Data Vault modeling, we will get into the details of how we prepare the Data Vault tables for business user access. Read more
People love to communicate. We often joke that any software system always evolves into a messaging system. This article will explain the system requirements and step by step approach to design a data model for a messaging system. Read more
“Information is the lifeblood of any organization…” We hear a lot of statements like this, or about an “information age,” or an “information economy.” When we agree with belief that amplifies the importance of information in the world today, we have to consider how to make that all-important information secure. The database professional has... Read more
In my last post, we looked at the need for an Agile Data Engineering solution, issues with some of the current data warehouse modeling approaches, the history of data modeling in general, and Data Vault specifically. This time we get into the technical details of what the Data Vault Model looks like and how... Read more
Data modeling is an essential step in the process of creating any complex software. It helps developers understand the domain and organize their work accordingly. In this article, which begins a new series devoted to database modeling, we’ll try to convince you why you should include it in your projects and what it looks... Read more
Normal forms for relations is a required topic of a database curriculum. Even if at some point you decide to abandon them, you should know what you are doing and how to pay a price for that. Read more
Storing sales data properly and later combining it can lead to creating a predictive model with a high rate of accuracy. This new series of articles analyzes a database design for recording sales, starting with a simple example of a database model for sales in a coffee shop. Read more
A good database design can be created by following a few simple rules. Here is my subjective list of nine tips for better data modeling. Read more
Redgate Data Modeler