Browse Prior Art Database

Concurrency Control in a Set Oriented Database Production Rule System

IP.com Disclosure Number: IPCOM000121692D
Original Publication Date: 1991-Sep-01
Included in the Prior Art Database: 2005-Apr-03
Document File: 2 page(s) / 60K

Publishing Venue

IBM

Related People

Cochrane, RJ: AUTHOR [+3]

Abstract

Disclosed is a production rule system in the database environment that allows users to specify database operations that are performed automatically when certain events occur and/or conditions are met. In the Starburst Rule System, a set-oriented rule system, was designed and implemented meaning that rules are triggered by, can refer to, and can perform sets of changes to the database. When a user creates a rule on a particular table, the user must specify: 1. which operations on that table trigger the rule (insert, delete, and/or update); 2. an SQL condition to be checked when the rule is triggered; 3. a sequence of SQL actions to be performed if the condition is true; and 4. relative priority between this rule and other previously created rules. Users also may alter or drop existing rules.

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

Concurrency Control in a Set Oriented Database Production Rule System

      Disclosed is a production rule system in the database
environment that allows users to specify database operations that are
performed automatically when certain events occur and/or conditions
are met.  In the Starburst Rule System, a set-oriented rule system,
was designed and implemented meaning that rules are triggered by, can
refer to, and can perform sets of changes to the database.  When a
user creates a rule on a particular table, the user must specify:
      1.   which operations on that table trigger the rule (insert,
delete, and/or update);
      2.   an SQL condition to be checked when the rule is triggered;
      3.   a sequence of SQL actions to be performed if the condition
is true; and
      4.   relative priority between this rule and other previously
created rules.
Users also may alter or drop existing rules.

      To fully integrate a set-oriented production rule system into a
multi-user database system, the rule system must enforce concurrency
control for every transaction that includes any form of rule
definition, i.e., for every transaction that creates rules, drops
rules, and/or alters rules.  The concurrency control mechanism must
enforce three forms of consistency:
      1.   intra-transaction consistency, which specifies that rules
relevant to a transaction remain consistent throughout the
transaction;
      2.   inter-tran...