Introduction to Seminar Topic on Database Recovery:
Any place where we can store or retrieve the data is called a database. Often we come across the crashing of a database, i.e. the database gets corrupted or the data would be lost due to some reasons. This crashing of databases would lead to a huge loss in money, time and energy. The process called database recovery refers to the correction or restoring a particular database to a position it has been previously in.
Database crashes can happen on various occasions namely:
- Hardware error
- Software error
- Logical errors
- Media failure
- Malware or virus attacks
In any cases the database must be restored to a perfect running consistent mode and database management system or DBMS plays a huge part in maintaining the reliability of each and every database concerned. DBMS also ensures the consistency of a database structure even if it is subjected to bugs and errors.
These crashes can be generalized into many categories such as system crash, error on the part of the user, carelessness of the user, corruption of data due to some external factors, processing failure, some bugs in application software, network or media failure, natural disasters etc.
Algorithms are used in recovering a database and follow the ACID rule of the DBMS. The recovery algorithms as it is called would work first during the normal process of transaction and make sure that important info exists to recover in failure. This algorithm would help in restoring the database to a consistent level. For managing databases distributed across multiple computers in a network, distributed database management system is used. A database administrator would be present to manage all the problems related to the database. Multiple entity relationships are clustered into a single entity and this process is called entity clustering and this leads to a better secured system.
Download CSE Seminar Report on Database Recovery.