Data Scale Management
Being aware of the possible negative impacts of uncontrolled data growth early in the design cycle is important. It is important to resist the urge to add every last bit of detail to the application in the quest to support any reporting need that might ever occur. Know the reporting requirements of the application before you start designing it. This is the only way the designer will be able to answer the question "do we really need that level of detail….?"
With this knowledge in hand, there are two key design methods for limiting growth: