System archiving and purge (a seven-year initialisation, then an annual cycle)
Client: Randstad — Services sector.
Archiving and purging a business-critical PeopleSoft production database across 7 years of history, to restore performance and prepare the future of the IS.
Context
- A problem for users: delayed opening of the production database (night batch).
- Stabilising exponential operating costs.
- Sustaining and preparing the future of the IS (Exadata, upgrade).
- Archiving of the production database had become critical.
Levers
- 55% of the records held in the database archived.
- Go-live in three 10-hour windows.
- Optimised go-live to limit downtime.
- Modelling of the entire scope and business models across all archiving years.
- A project delivered with limited resources.
Approach
- Visibility over the system and its data model, including customisation history.
- Database integrity audit.
- A clear methodology, from the initial phase to go-live.
- Archiving campaigns over 7 years, with archiving, purge and restore tests.
- Support for users during acceptance phases.
Results
Systnaps is able to give us visibility over our system and its data model, including the history of our customisation.
— Nicolas Faret, Randstad
- Performance: 445 GB of data processed in 8 hours, i.e. 3 years of activity.
- A major archiving effort, transparent to users.
- Teams made autonomous for future campaigns.
- Command of the system's evolution and greater agility.