An effective archiving strategy can help you streamline your databases to improve database performance and reduce costs associated with expensive upgrades. Archive can archive complex relational data quickly and accurately, while providing access to archived data — referentially intact and complete.
First, create an Archive Request and an Access Definition that provide instructions to archive a set of related data. Archive follows these instructions to extract and save the data, including the metadata that describes tables, columns and relationships. During this process, Archive creates indexes for archived data, according to your instructions.
To streamline your databases for peak efficiency, you can accurately delete all or part of the archived data from the production database.
To answer a customer query, you can search for the appropriate Archive File, using criteria, and browse data in it. You can also search for and restore archived data easily, using a variety of options, specified in a Restore Request. You can restore data to the production database or to another database. If the data model has changed, you can restore archived data to the new model or restore the data to a different database.