Posts by
Redgate Data Modeler
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
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
Redgate Data Modeler