Patents by Inventor Clarence Pruet

Clarence Pruet 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).

  • Publication number: 20060190504
    Abstract: A method, system and article of manufacture maintain the original order of a sequence of transactions originating from a source database and being replicated to a target database. A lockable object is associated with each transaction of the sequence of transactions from the source database. Each transaction has one or more transactional events. The transactions of the sequence of transactions have an order. The order is a commit order of the transactions in the source database. The lockable object is based on the commit order. A lock is attempted to be obtained on one or more lockable objects associated with one or more transactions of the sequence of transactions which precede a particular transaction of the sequence of transactions. In response to being unable to obtain the lock, the one or more transactional events of the one or more transactions which precede the particular transaction are serially processed.
    Type: Application
    Filed: February 18, 2005
    Publication date: August 24, 2006
    Applicant: International Business Machines Corporation
    Inventor: Clarence Pruet
  • Publication number: 20060190503
    Abstract: A method, system and article of manufacture implementing the method repairs a table. A replication environment has a first replicate comprising a source table on a source server and a target table on a target server. The source server transmits replication data from the source server with repair data from the source server to the target table in accordance with a commit order of the replication data and the repair data. The target server applies the repair data and the replication data to the target table based on the commit order.
    Type: Application
    Filed: February 18, 2005
    Publication date: August 24, 2006
    Inventors: Rajesh Naicken, Clarence Pruet, Konduru Rajakumar
  • Publication number: 20060190498
    Abstract: A method, system and article of manufacture provide a replication-only trigger in a database management system. The database management system has a source server and a target server. At least one replication-only trigger which is associated with a replication operation is registered. The replication-only trigger is associated with a stored procedure. The stored procedure is invoked in response to an occurrence of the replication operation in replicating data from the source server to the target server.
    Type: Application
    Filed: February 18, 2005
    Publication date: August 24, 2006
    Applicant: International Business Machines Corporation
    Inventor: Clarence Pruet
  • Publication number: 20060190497
    Abstract: A method, system and article of manufacture of replication are provided. A first replicate comprises a plurality of participants. The first replicate replicates one or more columns of a table. Replication data is transformed between a first local dictionary format and a first common dictionary format at a first participant of the plurality of participants. The replication data is transported in the first common dictionary format among the plurality of participants of the first replicate. The replication data is applied to a table on at least one other participant.
    Type: Application
    Filed: February 18, 2005
    Publication date: August 24, 2006
    Inventors: Nagaraju Inturi, Clarence Pruet
  • Publication number: 20050193024
    Abstract: A method and system for providing convergence of data copies in asynchronous data replication in a database system, includes: labeling rows of a plurality of table copies with a monotonic number, a copy identification, and propagation controls; asynchronously capturing at least one labeled change to any row of any of the plurality of table copies from a database recovery log; determining that the captured change is to be communicated to others of the plurality of table copies; communicating the captured change to the others of the plurality of table copies; and applying the communicated change to the others of the plurality of table copies, where the plurality of table copies converge to a same state. In applying the communicated changes, conflicting changes are identified and resolved. In this manner, convergence of data copies in asynchronous data replication is provided, and processing and storage costs are significantly reduced.
    Type: Application
    Filed: February 27, 2004
    Publication date: September 1, 2005
    Inventors: Kevin Beyer, Elizabeth Hamel, Bruce Lindsay, Clarence Pruet