Browse Prior Art Database

Shared Read-Only Data in a Relational Database

IP.com Disclosure Number: IPCOM000121187D
Original Publication Date: 1991-Jul-01
Included in the Prior Art Database: 2005-Apr-03
Document File: 1 page(s) / 37K

Publishing Venue

IBM

Related People

Haderle, DJ: AUTHOR [+5]

Abstract

A process is disclosed to allow multiple relational database management systems to share data across one or more central electronic complexes (CECs).

This text was extracted from an ASCII text file.
This is the abbreviated version, containing approximately 100% of the total text.

Shared Read-Only Data in a Relational Database

      A process is disclosed to allow multiple relational database
management systems to share data across one or more central
electronic complexes (CECs).

      In this process, one subsystem is designated the "owner" of the
database.  The owner is the only subsystem that can perform write
operations against the database.  All other subsystems connecting to
the database can perform only read operations against the database.
Because global resource serialization (GRS) is used to maintain
integrity of the data, the owner can only update data when no other
subsystems are connected.  Likewise, no subsystem may read the data
while the owner has a read-write connection to the database.

      Prior to this, users wanting to share data across multiple CECs
had to either use a distributed facility, or maintain multiple copies
of the data.  With Shared Read-Only Data, users will be able to
access accurate and up-to-date versions of the data without the
overhead associated with the use of the distributed facility.

      Additional processes insure that the consistency and integrity
of the data is always maintained.  For example, the read only
subsystems cannot access data if it is logically inconsistent (as a
result of an error on the owning subsystem, for example).

      Disclosed anonymously.