Technical Fields in Databases: What Isn't Commonly Discussed
-
-
20 min
We all designed a library or a store database in universities, where we were taught to correctly identify attributes, build data models and bring the DB to normal forms.
But what about fields that are not related to business entity attributes? How often do you use other technical fields beyond the primary and foreign keys? And how frequently have you had to suffer for a long time with a problem in productive operation because you do not understand what happened to the data?
In my talk, I will share several stories about the challenges I have personally encountered and how long and complex their resolutions were. However, at the end of each story, there will be a field that would allow you to avoid these issues.