Archiving and purging old data
In the end, if you want to seriously reduce the effective size of a database (after using all innovations on the infrastructure level) is to move data out of the database on to something else. This is a bit against Oracle’s preferred approach as they propose to hold as much of the application data in the database for as long as possible (I wonder why…)
We could separate all archiving methods into two categories:
- Methods that don’t change the RDBMS representation and just move tables or records to a different location in the same or different database;
- Methods that convert database records into something else and remove it from the database layer completely