Database archiving
In computer science, database archiving refers to processes to ensure long-term availability of the required data in relation to database systems .
This includes, on the one hand, simple backup / recovery procedures that are provided by most database management systems. On the other hand, this also includes application-oriented database archiving.
An application-oriented database archiving has the following characteristic properties:
- Archiving of logical data granules: The data extracts to be archived can be selected individually on the basis of the respective data model.
- User initiation: An archiving process can be event-driven or explicitly initiated by a user.
- Data outsourcing: The operational data is physically separated from the archived data.
- Archive access: Access to the archived data must be explicitly requested if necessary. Then the data is returned to the original database.
Differentiation between backup and archiving
The term database archiving does not include the backup / recovery procedure for all authors. The aim of archiving is completely different from that of a backup. While the short-term and fast availability of current data is in the foreground when backing up a database, the aim of database archiving is the long-term, manufacturer-independent storage of structured data. Another aim of database archiving is to relieve the productive database, which can only be achieved if the archived data is removed from the database. This also relieves the backup of the database and the required recovery times in the event of an error can be adhered to more easily.
See also
literature
- Axel Herbst: Application-oriented DB archiving . Springer, Berlin 1997, ISBN 3-540-63209-3
- Ralf Schaarschmidt: Archiving in database systems . Teubner, Stuttgart 2001, ISBN 3-519-00325-2
- Stefan Brandl, Dr. Peter Keller-Marxer: Long-term Archiving of Relational Databases with Chronos (PDF file; 454 kB). Edinburgh 2007