ERROR DETECTION AND CORRECTION USING INNER NETWORK AUDITS
Original Publication Date: 1995-Nov-01
Included in the Prior Art Database: 2002-Apr-03
Inner network audits check for and correct incon- sistencies on a multi-master redundant database. The database manager consists of two or more servers running on workstations connected to the peer to peer network at Motorola locations worldwide. Bach workstation has a copy of the data present on the other workstations. Database clients also running on workstations connected to the peer to peer net- work communicate with the database servers to per- form database transactions. Each server owns or is considered the master for a subset of the data. Each server updates only data it owns and is responsible for sending all ofits updates to the other databases, PROBLEM DEFINITION AND SOLUTION It is important for the redundant databases to stay synchronized at all times. Synchronization prob- lems may occur when a database manager cannot send a remote database updated data because of net- work or machine problems. Each database manager keeps track ofall updates it cannot send to the other databases. Once an hour, an inner network audit tries to resend all data not previously sent to the other databases. In addition, when a database server initializes it requests all updates from the other databases before it begins processing requests from users. Thus, the newly initialized database has the latest data horn the other databases before processing user requests.