Posts by
Redgate Data Modeler
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
The First Normal Form (1NF) is exceptional. The other normal forms (2NF, 3NF, BCNF) talk about functional dependencies and 1NF has nothing to do with functional dependencies. Moreover, we have precise definitions for other normal forms and there is no generally accepted definition of 1NF. Read more
Death and taxes – add “software problems” to that list of the inevitable. There is always a new issue, a new failure, a new key opportunity that an organization must address. And to avoid repeating the problems, or to revise your prior fixes, it is critical to capture the problems accurately and... Read more
Redgate Data Modeler