Browse Prior Art Database

ERROR DETECTION AND CORRECTION USING INNER NETWORK AUDITS

IP.com Disclosure Number: IPCOM000007523D
Original Publication Date: 1995-Nov-01
Included in the Prior Art Database: 2002-Apr-03
Document File: 2 page(s) / 113K

Publishing Venue

Motorola

Related People

Renee Carter: AUTHOR [+3]

Abstract

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.

This text was extracted from a PDF file.
At least one non-text object (such as an image or picture) has been suppressed.
This is the abbreviated version, containing approximately 50% of the total text.

Page 1 of 2

0 M

MOTOROLA Technical Developments

ERROR DETECTION AND CORRECTION USING INNER NETWORK AUDITS

by Renee Carter, J. Allan Toogood and Richard 0. Lee

BACKGROUND

  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.

  Inner network audits also run once a week to verify data consistency across the redundant databases. Each database manager verifies data con- sistency for the data it owns using check sums. If inconsistent data is found, the master database man- ager sends the other database a new copy of the data. When the audit completes, the administrator assigned to maintain the database is sent Email informing him ofany inconsistencies found and fixed.

  Because the users need access to the data at all times, database problems must be found and corrected quickly. Sometimes users cannot connect to the database, or the server and client lose com- munication midway through a transaction because of network or machine problems. So that t...