Schema design is something that is very important to any application where data is to be stored and retrieved. It is also a topic that is often debated, controversial and discarded as something simple to be done during development. However, Proper planning BEFORE development is done will help save a lot of time down the road.
Over my last 15 years in application development, I have been refining techniques, best practices and conventions with regard to designing database schemas so that they can be used in real world enterprise solutions. In this article I will discuss some things I have learned so far and share my opinions and experiences.
(more…)