Winston Churchill once remarked, “The further back you can look, the farther forward you can see.” He was clearly stressing the importance of learning and understanding history to make better decisions about the present and set the right direction for the future.
The same reason can be applied to maintain historical data in your database. The data history enables the organization:
To meet compliance/audit requirements.
For Data Analysis and Reporting
To identify patterns and track performance.
To recover from accidental data loss or data corruption.
For the above reasons and more, data modeling to maintain historical data is one of the most critical architectural decisions that drive an organization’s efficiency and “data” well-being.
