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
In this post, we take a big step forward in engineering the database development process by looking at Continuous Integration (CI) for your database and the characteristics of a software pipeline that begins to implement a repeatable process. This is the S3 stage, named for, and characterized by, the use of CI. S3 –... Read more
In my last post, I looked at the first stage of our maturity model, the Manual level. In this post we move to the S2 level, which is characterized by the use of a formal Version Control System (VCS) and process. S2 – Automated Version Control Many software development organizations have implemented a VCS... Read more
At Redgate Software, we’ve been trying to build tools that help developers work with software better. One of our areas of focus in the last few years has been streamlining database development and deployment. To help customers migrate to a smoother workflow and a better engineered software development pipeline, we’ve built our own maturity... Read more
One of the ways in which many software development teams have tried to improve the quality of their output is by examining what has worked in other organizations and projects in the past. They look to experiment with new techniques and ideas, and implement those items that work. This practice has allowed Agile, Scrum,... 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
