Patents by Inventor Robert W. Guse

Robert W. Guse has filed for patents to protect the following inventions. This listing includes patent applications that are pending as well as patents that have already been granted by the United States Patent and Trademark Office (USPTO).

  • Changing table records in a database management system
    Patent number: 6665654
    Abstract: A method and system for updating and deleting records in a tableset T of a family having M tables (M≧1). A set S of N source files (N≧1) are embodied in fileset SA at time tA and in fileset SB at time tB. S is logically associated with T. The family has a common family key KF across the M tables and across the N source files. A Delta program generates a dataset D having non-redundant family keyvalues embodying KF. Each non-redundant family keyvalue is drawn from selected Update or Delete records of SB relative to SA. For Updates, a Trigger program generates fileset &Dgr;S from records of SB having a family key in D, and a Bridge program generates fileset &Dgr;T that includes &Dgr;S data in a form compatible with T. A Load program updates and deletes records in T based on the non-redundant family keyvalues.
    Type: Grant
    Filed: July 3, 2001
    Date of Patent: December 16, 2003
    Assignee: International Business Machines Corporation
    Inventors: Theresa W. Broden, Robert W. Guse, Debra A. Parmeter, Jeffrey G. Willets
  • Changing table records in a database management system
    Publication number: 20030009436
    Abstract: A method and system for updating and deleting records in a tableset T of a family having M tables (M≧1). A set S of N source files (N≧1) are embodied in fileset SA at time tA and in fileset SB at time tB. S is logically associated with T. The family has a common family key KF across the M tables and across the N source files. A Delta program generates a dataset D having non-redundant family keyvalues embodying KF. Each non-redundant family keyvalue is drawn from selected Update or Delete records of SB relative to SA. For Updates, a Trigger program generates fileset &Dgr;S from records of SB having a family key in D, and a Bridge program generates fileset &Dgr;T that includes &Dgr;S data in a form compatible with T. A Load program updates and deletes records in T based on the non-redundant family keyvalues.
    Type: Application
    Filed: July 3, 2001
    Publication date: January 9, 2003
    Applicant: International Business Machines Corporation
    Inventors: Theresa W. Broden, Robert W. Guse, Debra A. Parmeter, Jeffrey G. Willets