Posts by
Redgate Data Modeler
Modern applications have plenty of authentication features beside registration and login. In this article we will take a look at how to design the database for two such features: email confirmation and password recovery. Read more
The art of designing a good database is like swimming. It is relatively easy to start and difficult to master. If you want to learn to design databases, you should for sure have some theoretic background, like knowledge about database normal forms and transaction isolation levels. But you should also practice as much as... Read more
In this next article in the series on designing a database model for an online discussion forum, I continue to add features to the model. Firstly, I will enhance the post table. Then, I will deal with post categories and up/downvoting functionality. Read more
How difficult is it to program a user login function for an application? Novice developers think it's very easy. Experienced developers know better: it is the most sensitive process in your application. Errors in login screens can lead to serious security issues. In this article we take a look at how to store authentication... Read more
Many think that a database modeler’s only job is to create an entity relationship diagram (ERD). Little do they know that data modeling goes way beyond just drawing lines and boxes. In this article, I reflect on the real tasks of a data modeler. Read more
Even though Vertabelo doesn’t provide a direct conversion of a data model from one database engine to another, this can be easily done in a few simple steps. In this article we will show you how to migrate your Entity Relationship Diagram between two different database engines using the example of a data model... Read more
Continuing my series of articles on designing a database model for an online discussion forum, I will add some more advanced features to my initial concept. Firstly, I will enhance the user details which are stored in our model, adding not only some new personal data but also simple user’s roles and statuses. Then,... Read more
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
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
Redgate Data Modeler