Introducing a number of posts on database design.
A System’s Database Design is like the Foundation to a Building
Database Design is one of the most critical areas in databases. It is like the foundation to your house. If you have a bad foundation, you either cannot build at all. Or, you have to do all kinds of things to compensate for the bad foundation.
A great example of a bad foundation is the leaning tower of Pisa.
The tower was not built with the right foundation for the local clay. Three floors were built, and the tower began to lean because of the weight of the building. Rather than tearing down the structure and building it again properly, they just decided to wait 100 years for the clay to settle. And then they built four more floors, parallel to the ground, attempting to compensate for the bad angle of the foundation! But more problems arose.
Read the rest of this entry »