In the words of the Summit system owner:
“PuriPhi is on the way to take away one third of our current data and reunite ten years of archived database snapshots.
It allows us to rethink our view of historical data and it will greatly improve our daily testing environment and regular audit requests”
Context:
Our client has a 1.6Tb Summit database, replicated across 30 environments for production, test and development. The existing infrastructure was unable to support the future growth of the database. Previous purging of the production database had resulted in multiple historical snapshot copies being maintained, with an inability to easily combine the data for reporting.
Goal:
To reduce the live database size and present all data (live, newly archived AND previously deleted data) in a single Summit environment, compatible with data model updates. Maintain the live database at a reduced size according to specific archiving requirements.
Solution:
PuriPhi was installed and configured to archive matured and cancelled trades and historical market data more than 415 days old. Even without considering any of the other data types that PuriPhi supports, 500Gb of data was removed from the production database. The PuriPhi solution presented the archived and production data, seamlessly combined with no loss of functionality through the usual and familiar Summit GUI.
Benefits: