ABSTRACT
In database management system (DBMSs), data is must have recovery when it due to some problem, issue or error. Data recovery is a way to retrieve our data that loss because of system failure or system crash, transaction error. The big problem is in the database itself. It is might be crash within transaction data. When the main database is failed, it can’t sure that every single data already in backup server or not. Different server have different amount of data in it that caused by the system failure. To recover the database server, its will takes a long time and based on the amount of data loss. At this time, data from database is completely unavailable and the processing capability is reduced or eliminated for the processors involved in the recovery process. The importance of data recovery is it can recover data in the database system that already lost cause by system failure. There are so many technique database server that will help as a backup to our main database system. By implement the transaction log in database server, data recovery is more efficient because it need to do logging each of data.
PROJECT BACKGROUND
The data recovery technology’s basic theory and relevant technical background knowledge given and on the basis of the understanding of documents recovery principles. One of the solution to ensure our data is always available is by doing data recovery of that database server or system after it failed. Recovery should cover all this problem and avoid the possibility of having to duplicate the work manually. Duplicate the data is the one of backup plan but it is possible when we duplicate the data, the data that already duplicate having a problem that caused data loss. So, by doing recovery, data loss can be avoid.
In addition, database is a computerized record-keeping system in which have a huge amount of information that stored in a structured so that it easy to retrieve it back. Transaction log is define as a recovery techniques that applies log records to ensure the consistent and the updates of the data.Log is the way to keeps track of individual transaction updates including database which is permanent store for the data pages. By doing logging file, the availability of the data is higher when one of the server failure because it will record each data in the main server. The basic way to recover our data is by duplicate normally each of our information to other disk or server. While, when using transaction log, there are more systematic way to recover the data loss in database server.
PROBLEM STATEMENT
- DATABASE CRASH
- DISASTER
- CORRUPTED TRANSACTIONS
OBJECTIVE
PROPOSE. PROPOSE A FRAMEWORK FOR DATA RECOVERY BY USING TRANSACTION LOG
|
DESIGNDESIGN A FRAMEWORK FOR DATA RECOVERY BY USING TRANSACTION LOG FILE
|
IMPLEMENTIMPLEMENT AND TEST DATA RECOVERY IN BY USING TRANSACTION LOG
|
FRAMEWORK
TECHNIQUES
Transaction log backups
1.Tracking all the log in the database
2.Recovery is more accurate
3.Can retrieve the database with consistency
1.Tracking all the log in the database
2.Recovery is more accurate
3.Can retrieve the database with consistency
RESULT
CONCLUSIONS
Data recovery by using transaction log backups can provide consistency and reliability of data and it’s also provide point-in-time recovery.Data is accurate as the original data and the latest update.
STUDENT PROFILE
SYAHIRAH NABILAH BINTI RASIDOUN
Student ID: BTBL15040945 Supervisor: P.M DR. ZARINA BINTI MOHAMAD Course : Bachelor of Computer Science Network Security(Hons) Institution: Universiti Sultan Zainal Abidin, Terengganu(UniSZA) Contact number: 012-3008462 Email: [email protected] |