Patents by Inventor Clarence Madison Pruet
Clarence Madison 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).
-
Patent number: 9286346Abstract: A method provides 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: GrantFiled: February 18, 2005Date of Patent: March 15, 2016Assignee: International Business Machines CorporationInventor: Clarence Madison Pruet, III
-
Patent number: 8639677Abstract: A 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: GrantFiled: April 14, 2008Date of Patent: January 28, 2014Assignee: International Business Machines CorporationInventor: Clarence Madison Pruet, III
-
Patent number: 8214353Abstract: A method to replicate data is 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: GrantFiled: February 18, 2005Date of Patent: July 3, 2012Assignee: International Business Machines CorporationInventors: Nagaraju Inturi, Clarence Madison Pruet, III
-
Publication number: 20120005160Abstract: Techniques are provided for resynchronizing instances of a replicated table. In one embodiment, a database server is provided as a member of a plurality of communicatively coupled database servers. Each database server is configured to support a replicating mode of operation and a non-replicating mode of operation. The instances of the replicated table are resynchronized responsive to a user request, without stopping any of the plurality of database servers and without requiring any of the plurality of database servers to operate in the non-replicating mode of operation.Type: ApplicationFiled: September 12, 2011Publication date: January 5, 2012Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: Rajesh Govind Naicken, Clarence Madison Pruet, III, Konduru Israel Rajakumar
-
Patent number: 8037056Abstract: A 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: GrantFiled: February 18, 2005Date of Patent: October 11, 2011Assignee: International Business Machines CorporationInventors: Rajesh Govind Naicken, Clarence Madison Pruet, III, Konduru Israel Rajakumar
-
Patent number: 7680795Abstract: Embodiments of the invention generally relate to data processing systems and more particularly to high availability data processing systems. A primary server may share a storage device with one or more clone systems. Each clone generally replicates the state of the primary server, but relies on the same disk-based storage as the primary server. Thus, the clone systems may provide a shadow of the primary server, ready to take over should the primary server fail. The clone systems may access a log file that includes entries reflecting the actions performed by the primary system. The primary server may flush entries from a log buffer maintained on the primary server to a log file stored on the shared disk-based storage. The primary server may also send a log sequence number to the clone systems, and the clone systems periodically transmit a log sequence number back to the primary server indicating how far through the log file a clone system has progressed.Type: GrantFiled: March 16, 2007Date of Patent: March 16, 2010Assignee: International Business Machines CorporationInventors: Scott David Lashley, Karl Ostner, Clarence Madison Pruet, III, Jinming Xiao
-
Patent number: 7640278Abstract: A partial-blocking consistency point system identifies transaction updates with a consistency point ID associated with a consistency point sequence number, records consistency point data that identify a location of the partial-blocking consistency point, flushes to a non-volatile storage the transaction updates identified with the consistency point sequence number without blocking transaction activity, and hardens to the non-volatile storage the recorded partial-blocking consistency point so that data associated with the recorded partial-blocking consistency point can be recovered. The consistency point sequence number is incremented each time the partial-blocking consistency point is recorded to uniquely identify the partial-blocking consistency point and transaction updates associated with the partial-blocking consistency point. The transaction updates identified with the consistency point sequence number are processed to improve efficiency of the flushing of the transaction updates.Type: GrantFiled: June 28, 2006Date of Patent: December 29, 2009Assignee: International Business Machines CorporationInventors: Scott David Lashley, John Frederic Miller, Clarence Madison Pruet, Daniel Alan Wood
-
Publication number: 20090019094Abstract: Embodiments of the invention relate to data processing systems and more specifically to high availability data processing systems comprising a primary server and a secondary server. The secondary server may receive an update request from a client. The secondary server may perform one or more preliminary operations required for processing of the update request. The secondary server may then redirect a partially processed update operation to the primary server for execution. Therefore, greater load balancing is achieved between the servers and more efficient utilization of secondary server resources is achieved.Type: ApplicationFiled: July 13, 2007Publication date: January 15, 2009Inventors: SCOTT DAVID LASHLEY, Prasad Suresh Mujumdar, Clarence Madison Pruet, III
-
Publication number: 20080228835Abstract: Embodiments of the invention generally relate to data processing systems and more particularly to high availability data processing systems. A primary server may share a storage device with one or more clone systems. Each clone generally replicates the state of the primary server, but relies on the same disk-based storage as the primary server. Thus, the clone systems may provide a shadow of the primary server, ready to take over should the primary server fail. The clone systems may access a log file that includes entries reflecting the actions performed by the primary system. The primary server may flush entries from a log buffer maintained on the primary server to a log file stored on the shared disk-based storage. The primary server may also send a log sequence number to the clone systems, and the clone systems periodically transmit a log sequence number back to the primary server indicating how far through the log file a clone system has progressed.Type: ApplicationFiled: March 16, 2007Publication date: September 18, 2008Inventors: Scott David Lashley, Karl Ostner, Clarence Madison Pruet, Jinming Xiao
-
Publication number: 20080215586Abstract: A 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: ApplicationFiled: April 14, 2008Publication date: September 4, 2008Applicant: International Business Machines CorporationInventor: Clarence Madison Pruet
-
Patent number: 7376675Abstract: A method of maintaining the original order of a sequence of transactions originating from a source database and being replicated to a target database is provided. 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: GrantFiled: February 18, 2005Date of Patent: May 20, 2008Assignee: International Business Machines CorporationInventor: Clarence Madison Pruet, III
-
Publication number: 20080059469Abstract: A method, system and computer program product that synchronize a table are provided. The rows of a source table of a database are scanned. The source table comprises a plurality of rows. The rows that are scanned are locked with at least one lock. At least one scan block comprising at least one row of the rows of the source table is formed. At least one token that is associated with the at least one scan block, respectively, is placed in a log. At least one lock that is associated with the at least one row that is associated with the at least one token is released. In response to encountering one token of the at least one token in the log, the at least one row of the scan block that is associated with the one token are placed in a replication conduit.Type: ApplicationFiled: August 31, 2006Publication date: March 6, 2008Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventor: Clarence Madison Pruet
-
Publication number: 20080005191Abstract: A partial-blocking consistency point system identifies transaction updates with a consistency point ID associated with a consistency point sequence number, records consistency point data that identify a location of the partial-blocking consistency point, flushes to a non-volatile storage the transaction updates identified with the consistency point sequence number without blocking transaction activity, and hardens to the non-volatile storage the recorded partial-blocking consistency point so that data associated with the recorded partial-blocking consistency point can be recovered. The consistency point sequence number is incremented each time the partial-blocking consistency point is recorded to uniquely identify the partial-blocking consistency point and transaction updates associated with the partial-blocking consistency point. The transaction updates identified with the consistency point sequence number are processed to improve efficiency of the flushing of the transaction updates.Type: ApplicationFiled: June 28, 2006Publication date: January 3, 2008Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: Scott David Lashley, John Frederic Miller, Clarence Madison Pruet, Daniel Alan Wood
-
Patent number: 7177886Abstract: In a database apparatus (10), a critical database server (12) includes a primary server (20) supporting a primary database instance and a secondary server (22) supporting a secondary database instance that mirrors the primary database instance. The secondary server (22) generates an acknowledgment signal (60) indicating that a selected critical database transaction (42) is mirrored at the secondary database instance. A plurality of other servers (14, 16, 18) each support a database. A data replicator (30) communicates with the critical database server (12) and the other servers (14, 16, 18) to replicate the selected critical database transaction (42) on at least one of said plurality of other servers (14, 16, 18) responsive to the acknowledgment signal (60).Type: GrantFiled: February 7, 2003Date of Patent: February 13, 2007Assignee: International Business Machines CorporationInventor: Clarence Madison Pruet, III
-
Publication number: 20040158588Abstract: In a database apparatus (10), a critical database server (12) includes a primary server (20) supporting a primary database instance and a secondary server (22) supporting a secondary database instance that mirrors the primary database instance. The secondary server (22) generates an acknowledgment signal (60) indicating that a selected critical database transaction (42) is mirrored at the secondary database instance. A plurality of other servers (14, 16, 18) each support a database. A data replicator (30) communicates with the critical database server (12) and the other servers (14, 16, 18) to replicate the selected critical database transaction (42) on at least one of said plurality of other servers (14, 16, 18) responsive to the acknowledgment signal (60).Type: ApplicationFiled: February 7, 2003Publication date: August 12, 2004Applicant: International Business Machines CorporationInventor: Clarence Madison Pruet