ANALISA PENGARUH LOG TRANSAKSI PADA SISTEM KOMPUTER MENGGUNAKAN ALGORITMA RECOVERY BERBASIS LOG

Abstract

This study aims to melakukakan analysis of the effect of the transaction log on a computer based system
either on a single system tired, and two tiered through simulated transactions bank system with technology
client / server to get a log of transactions on the database system Microsoft Windows SQL Server 2008 R2
management studio a data base. Methods or algorithms are used to analyze the transaction log on the system
used is a log-based recovery algorithm.The results based on the analysis, showed that the use of query local
database and query the database using sotere procedure to get the transaction log for troubleshooting
transactions on the database system via a user interface is built to help job database administrator (DBA),
much more good compared with conventional systems. Based on the experiments that the log of transactions
to be controlled, in-undo, Re-do, or Rolled-Back, even deleted if no longer required automatically to maintain
the scalability of computer users in the future, by setting the growth of a standard database from 10% to >
32%, and the establishment of a maintenance schedule to ensure that the reserve database is always available
and up to date.