Patents Represented by Attorney, Agent or Law Firm Pryor A. Garnett
  • Patent number: 4947320
    Abstract: A method is disclosed for enforcing referential constraints on a record-by-record basis, immediately before or after each record is manipulated and while the record is still accessed, significantly improving the system's performance. Each record is visited only once to do both the constraint checking and the manipulation (insert/update/delete). If the constraint checking fails, then the entire relational operation of which the record manipulation is a part is backed out. For insertions, each record is first inserted 30, and then constraints respective the record are enforced 32,34. For updates, the record is updated 48 after constraints respecting the record's primary key are enforced 40,42, and before constraints respecting its foreign key(s) are enforced 44,46. Deletions are performed 52 before the constraints on the deleted record are enforced 54,56. Cascade deleted 58 are handled recursively 60. The method correctly processes cyclic constraints and self-referencing rows without special handling.
    Type: Grant
    Filed: July 15, 1988
    Date of Patent: August 7, 1990
    Assignee: International Business Machines Corporation
    Inventors: Richard A. Crus, Robert W. Engles, Donald J. Haderle, Howard W. Herron
  • Patent number: 4941102
    Abstract: An apparatus and method for debugging a forward-chaining (rule-based) expert system are disclosed. A single STEP command controls the expert system and automatically presents prefire and postfire displays for observing the system's performance. The debugger alternates between prefire and postfire states. In the prefire state, before the selected rule is fired, the conflict set of rules eligible to be fired, the selected rule to be fired, and the data for that rule are displayed in separate windows. Entry of the STEP command fires the rule and changes the debugger's state to postfire. In the postfire state, the just-fired rule and data updated thereby are displayed. Entry of the STEP command in the postfire state changes the state to prefire and automatically presents the prefire display for the next selected rule.
    Type: Grant
    Filed: September 16, 1988
    Date of Patent: July 10, 1990
    Assignee: International Business Machines Corporation
    Inventors: Michael J. Darnell, Joseph M. Hary, Robert J. Quinn
  • Patent number: 4933848
    Abstract: A method is disclosed for deferring enforcement of referential constraints in large-scale data base operations such as the population or loading of relational tables 10, 12. First, the new rows are loaded in a Data Load phase 24 into the tables, and information on the new rows and their constraints is extracted and sorted 26 into a sorted key data set 68. Any primary indexes 22 required for constraint checking are then updated 28 using the sorted key data set. The new rows are then checked 70 for constraint violations, such violations are rectified 72 to restore the table's referential integrity, and a deletion data set 80 is produced. The deletion data set is merged and sorted 86 with row information 53 stored during loading, and the result is used to copy 88 the new rows violating referential constraints to a separate discard data set 48 where they can be corrected and reloaded into the table. Finally, an error summary report 36 is generated for use in correcting the discard data set.
    Type: Grant
    Filed: July 15, 1988
    Date of Patent: June 12, 1990
    Assignee: International Business Machines Corporation
    Inventors: Donald J. Haderle, Julie A. Watts
  • Patent number: 4878167
    Abstract: A method for writing tagged (partitioned and classified) records from a first log stream to multiple recovery streams and discarding same from said first stream at the termination of the unit of recovery in a transaction-oriented system to permit first log stream reuse.
    Type: Grant
    Filed: June 30, 1986
    Date of Patent: October 31, 1989
    Assignee: International Business Machines Corporation
    Inventors: Kenneth M. Kapulka, Holly A. Rader, Jimmy P. Strickland