Patents by Inventor Clarence M. Pruet
Clarence M. 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: 9298791Abstract: Techniques are disclosed for adding a key column to a table to be replicated, where the key column stores key values for use in replication. In one embodiment, a request is received to add a table to a replication domain, such that the table is replicated from a first database server to at least a second database server. Key values are generated for both existing records and new records subsequently requested to be inserted into the table, respectively. Each generated key value is unique across the replication domain. Further, the key column may be added to the table without requiring exclusive access to the table.Type: GrantFiled: July 30, 2013Date of Patent: March 29, 2016Assignee: International Business Machines CorporationInventors: Prasad S. Mujumdar, Clarence M. Pruet, III
-
Patent number: 9189534Abstract: 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: GrantFiled: September 12, 2011Date of Patent: November 17, 2015Assignee: International Business Machines CorporationInventors: Rajesh G. Naicken, Clarence M. Pruet, III, Konduru I. Rajakumar
-
Patent number: 8862544Abstract: Provided are techniques for replication in a grid based environment. Grid control structures, including a grid command structure, are created. At an authorized node in a grid of nodes, a Data Definition Language (DDL) operation is received, the DDL operation is inserted into the grid command structure, and the DDL operation is propagated from the authorized node to one or more other nodes in the grid of nodes at the end of a transaction that inserted the DDL operation into the grid command structure.Type: GrantFiled: September 13, 2012Date of Patent: October 14, 2014Assignee: International Business Machines CorporationInventors: Nagaraju Inturi, Clarence M. Pruet, III
-
Patent number: 8688634Abstract: A method and system for providing convergence of data copies in asynchronous data replication in a database system, includes: labeling rows, a copy of identification and propagation controls. In applying 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: GrantFiled: February 27, 2004Date of Patent: April 1, 2014Assignee: International Business Machines CorporationInventors: Kevin S. Beyer, Elizabeth B. Hamel, Bruce G. Lindsay, Clarence M. Pruet, III
-
Publication number: 20130318043Abstract: Techniques are disclosed for adding a key column to a table to be replicated, where the key column stores key values for use in replication. In one embodiment, a request is received to add a table to a replication domain, such that the table is replicated from a first database server to at least a second database server. Key values are generated for both existing records and new records subsequently requested to be inserted into the table, respectively. Each generated key value is unique across the replication domain. Further, the key column may be added to the table without requiring exclusive access to the table.Type: ApplicationFiled: July 30, 2013Publication date: November 28, 2013Inventors: Prasad S. MUJUMDAR, Clarence M. PRUET, III
-
Patent number: 8566280Abstract: Provided are techniques for replication in a grid based environment. Grid control structures, including a grid command structure, are created. At an authorized node in a grid of nodes, a Data Definition Language (DDL) operation is received, the DDL operation is inserted into the grid command structure, and the DDL operation is propagated from the authorized node to one or more other nodes in the grid of nodes at the end of a transaction that inserted the DDL operation into the grid command structure.Type: GrantFiled: May 31, 2011Date of Patent: October 22, 2013Assignee: International Business Machines CorporationInventors: Nagaraju Inturi, Clarence M. Pruet, III
-
Patent number: 8554730Abstract: Techniques are disclosed for adding a key column to a table to be replicated, where the key column stores key values for use in replication. In one embodiment, a request is received to add a table to a replication domain, such that the table is replicated from a first database server to at least a second database server. Key values are generated for both existing records and new records subsequently requested to be inserted into the table, respectively. Each generated key value is unique across the replication domain. Further, the key column may be added to the table without requiring exclusive access to the table.Type: GrantFiled: July 29, 2011Date of Patent: October 8, 2013Assignee: International Business Machines CorporationInventors: Prasad S. Mujumdar, Clarence M. Pruet, III
-
Publication number: 20130031051Abstract: Techniques are disclosed for adding a key column to a table to be replicated, where the key column stores key values for use in replication. In one embodiment, a request is received to add a table to a replication domain, such that the table is replicated from a first database server to at least a second database server. Key values are generated for both existing records and new records subsequently requested to be inserted into the table, respectively. Each generated key value is unique across the replication domain. Further, the key column may be added to the table without requiring exclusive access to the table.Type: ApplicationFiled: July 29, 2011Publication date: January 31, 2013Applicant: International Business Machines CorporationInventors: Prasad S. Mujumdar, Clarence M. Pruet, III
-
Publication number: 20130006934Abstract: Provided are techniques for replication in a grid based environment. Grid control structures, including a grid command structure, are created. At an authorized node in a grid of nodes, a Data Definition Language (DDL) operation is received, the DDL operation is inserted into the grid command structure, and the DDL operation is propagated from the authorized node to one or more other nodes in the grid of nodes at the end of a transaction that inserted the DDL operation into the grid command structure.Type: ApplicationFiled: September 13, 2012Publication date: January 3, 2013Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: Nagaraju Inturi, Clarence M. Pruet, III
-
Publication number: 20120310886Abstract: Provided are techniques for replication in a grid based environment. Grid control structures, including a grid command structure, are created. At an authorized node in a grid of nodes, a Data Definition Language (DDL) operation is received, the DDL operation is inserted into the grid command structure, and the DDL operation is propagated from the authorized node to one or more other nodes in the grid of nodes at the end of a transaction that inserted the DDL operation into the grid command structure.Type: ApplicationFiled: May 31, 2011Publication date: December 6, 2012Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: Nagaraju Inturi, Clarence M. Pruet, III
-
Patent number: 7890455Abstract: A system and method to ensure a low-latency read of log records from a Database Management System (“DBMS”) in asynchronous log-based database replication capture from a blocking log read Application Programming Interface (“API”). The system may include a replication server with a log read module to initialize a log read thread. The reading module of the log read thread may read a predefined number of DBMS log records. A log flush module of the log flush thread may be executed by the log read thread and waits for a read complete notification. The update module, in response to a log flush thread time out, may also generate a plurality of loggable transactions such that a number of log records in an internal API log satisfies a DBMS threshold and unblocks the DBMS API. Therefore, the latency time may be constant, low, and predictable ensuring an accurate replication capture.Type: GrantFiled: May 28, 2008Date of Patent: February 15, 2011Assignee: International Business Machines CorporationInventors: Serge Bourbonnais, Daniel B. Morales, Clarence M. Pruet, Jonathan W. Wierenga, Tyrone C. Yu
-
Publication number: 20090300073Abstract: A system and method to ensure a low-latency read of log records from a Database Management System (“DBMS”) in asynchronous log-based database replication capture from a blocking log read Application Programming Interface (“API”). The system may include a replication server with a log read module to initialize a log read thread. The reading module of the log read thread may read a predefined number of DBMS log records. A log flush module of the log flush thread may be executed by the log read thread and waits for a read complete notification. The update module, in response to a log flush thread time out, may also generate a plurality of loggable transactions such that a number of log records in an internal API log satisfies a DMBS threshold and unblocks the DBMS API. Therefore, the latency time may be constant, low, and predictable ensuring an accurate replication capture.Type: ApplicationFiled: May 28, 2008Publication date: December 3, 2009Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: SERGE BOURBONNAIS, DANIEL B. MORALES, CLARENCE M. PRUET, JONATHAN W. WIERENGA, TYRONE C. YU