Browse Prior Art Database

Updating Loosely-Coupled SQL/DS Databases

IP.com Disclosure Number: IPCOM000102519D
Original Publication Date: 1990-Nov-01
Included in the Prior Art Database: 2005-Mar-17
Document File: 2 page(s) / 66K

Publishing Venue

IBM

Related People

Talley, TM: AUTHOR

Abstract

The Remote SQL/DS Update facility is a set of service machines and data formats allowing applications to update remote SQL/DS databases using RSCS spool files. The facility provides a transfer mechanism that can be used to implement distributed database applications.

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

Updating Loosely-Coupled SQL/DS Databases

       The Remote SQL/DS Update facility is a set of service
machines and data formats allowing applications to update remote
SQL/DS databases using RSCS spool files.  The facility provides a
transfer mechanism that can be used to implement distributed database
applications.

      An SQL Peer Group is a set of VM nodes which forward database
changes to each other whenever a change is made to the database on
one of the peer nodes.  The SQL Peer Groups are defined via a table
in the SQL database.  A node may participate in multiple SQL Peer
Groups.  Members within an SQL Peer Group exchange information by
sending updates to one another via "SQL Peer Group" spool files.  A
VM service machine, called a Database Server, propagates changes to
all peer Database Server userids listed in the peer table.  The peer
table lists the application group name, service machine userid, and
node for all Database Servers.  The application group name is used to
identify all the Database Servers participating in updates for a
particular application.

      If the SQL Peer Group file is not from a peer Database Server,
the update is assumed to be from a database user. The request is
validated to insure the issuing user is authorized for the command
(described more fully below), the commands in the file are processed,
then a copy of the file is propagated to each peer Database Server
defined in the peer table.

      All SQL Peer Group files (i.e., commands to be issued by a
Database Server) have the na...