Category: Data

Data

Converting conceptual/logical to physical data model

It’s easy to find information on the Internet about what a relational database is, what relationships exist, what is normalization. In this article, I will try to raise the subject of the conceptual data model and its conversion into a physical model. Some students will find this knowledge useful in completing the database subject in …

Data, General

A few thoughts about normalization and N+1 problem

bulbs

N+1 problem Recently I was optimizing some methods that were using Entity Framework to get some entities from database. I’ve put Stopwatch and started to measure performance gain. Saying that the query was not optimal is not enough. It was terrible. What drew my attention the most was the fact that after the query finished, …