In this article, I look at bridging the requirements between transactional and analytical processing and look particularly at the spider schema as one possible solution. Read more
As I’ve been speaking and training people on Database Lifecycle Management (DLM), I’ve learned one thing. Trying to implement version control, and Continuous Integration (CI), and automated releases of code is hard. The concept is simple, but all of the various processes, tools, and links that need to be connected can be hard. I’ve... Read more
In this short, concise book, Kent Graziano, a guru data modeler, shares his view on ensuring the quality of data models using thorough, frequent reviews done by the whole team. His adamant eagerness to eliminate flaws as early as possible looks like a perfect way to model. But is it always applicable? Read more
The article presents some concepts on how to decompose relations and what can go wrong. These concepts may seem a bit complicated but, on the other hand, they are so basic that you rarely see it written. Still, they are essential for understanding how the normalization process works. One may prepare a perfect meal... Read more
This week at Redgate HQ we’ve been lucky enough to have a visit from Dave Farley, Continuous Delivery evangelist and co-author of the book Continuous Delivery. In one of our discussions we started talking about database unit testing. Pretty soon we realized we both meant something fundamentally different when we called something a database... Read more
Before writing this article, I talked to a group of software engineers who use Hibernate on a daily basis in their work. Some of them work for small companies (up to 20 developers on site) while others are employed in corporations known world-wide that employ over 100,000 IT professionals. This gave me an insight... Read more
In this final article in a four-part series, I complete the design for an online survey database to provide flexibility for multiple surveys, question re-use, multiple choice answers, ordering of questions, conditional jumps in the survey based on responses, and control over the users' access to surveys via groups of survey owners. Read more
Take a closer look at some new features introduced in Vertabelo database modeler in April 2015. Read more
Working on a project to create an application that is focused on analytics, reporting, and especially forecasting, has forced me to recognize the different requirements between transactional and analytical database design. Read more
When writing a blog post on database modeling, you must be prepared that your abstract model doesn't meet the needs of most readers. The reason is simple. Real-life database models are usually created in close relation to specific business and development requirements while the blog models are not. Read more
