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…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…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 Redgate Data Modeler 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…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…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…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…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…Read more