Reasons why I LOVE my job…
Reason #4: It is possible to solve a problem long before you even encounter it
Sometimes, in the kind of job that I do, it is actually possible to solve a problem long before we actually experience it. This has happened quote a number of times, and again very recently.
It suddenly came to my realization that we had to normalize our database as much as possible, and that the current DB structure wasn’t properly normalized. But then, we also needed to generate reports from data that was dynamic. For instance, we need to track sales of an item and the price of that item changed over time. Only a de-normalized database can afford this.
After the normalization process had begone, I realized the the current DB structure already solved the problem! It was such a relieve, you know, because when the DB structure was created, we didn’t have that in mind nor did we imagine the need for this. Still, it felt so good to realize 🙂