Open AccessANALISA PENGARUH LOG TRANSAKSI PADA SISTEM KOMPUTER MENGGUNAKAN ALGORITMA RECOVERY BERBASIS LOG
Author(s) -
Fricles Ariwisanto Sianturi
Publication year - 2018
Publication title -
journal of computer networks, architecture and high performance computing
Language(s) - English
Resource type - Journals
ISSN - 2655-9102
DOI - 10.47709/cnapc.v1i1.2
Subject(s) - log shipping , transaction log , computer science , database , undo , database transaction , operating system , web log analysis software , troubleshooting , database server , scalability , nested transaction , schedule , transaction processing , online transaction processing , client–server model , the internet , server , web server , static web page
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.