Browse Prior Art Database

Database Recovery Using a Transaction Log File

IP.com Disclosure Number: IPCOM000040084D
Original Publication Date: 1987-Sep-01
Included in the Prior Art Database: 2005-Feb-01

Publishing Venue

IBM

Related People

Authors:
Caraballo, JF Collins, WM Kemmerer, TR Mariano, MH Todd, RL [+details]

Abstract

This article describes recovering a critical database automatically with a transaction log after the master has been destroyed. The automatic parts inventory (API) system consists of several personal computers in a network environment that has a master computer database and slaves attached. The master computer database is retained in the random-access memory (RAM) and a backup version on a disk media. As transactions are being received at the master station, it broadcasts the transaction to the slave station to keep the databases at all stations identical. Refer to Fig. 1 which shows this configuration. It illustrates that the current master is the input crane. If this station becomes disabled, any of the other stations then can become the master station by changing the station table.