Patents by Inventor John B. Tobler
John B. Tobler 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: 10210198Abstract: According to one embodiment of the present invention, a system for processing a database query stores one or more result sets for one or more first database queries in a data store. The system receives a second database query and compares the second database query to the one or more first database queries to determine presence of a corresponding result set in the data store for the second database query. The system provides the corresponding result set from the data store for the second database query based on the comparison. Embodiments of the present invention further include a method and computer program product for processing a database query in substantially the same manners described above.Type: GrantFiled: February 14, 2017Date of Patent: February 19, 2019Assignee: International Business Machines CorporationInventors: Arthur Marais, Christopher J. Munson, Nigel G. Slinger, John B. Tobler
-
Patent number: 10127269Abstract: According to one embodiment of the present invention, a system for processing a database query stores one or more result sets for one or more first database queries in a data store. The system receives a second database query and compares the second database query to the one or more first database queries to determine presence of a corresponding result set in the data store for the second database query. The system provides the corresponding result set from the data store for the second database query based on the comparison. Embodiments of the present invention further include a method and computer program product for processing a database query in substantially the same manners described above.Type: GrantFiled: February 14, 2017Date of Patent: November 13, 2018Assignee: International Business Machines CorporationInventors: Arthur Marais, Christopher J. Munson, Nigel G. Slinger, John B. Tobler
-
Publication number: 20180225148Abstract: In an embodiment, a method of resource pre-configuration includes obtaining, at a target system, configuration information about a resource that is predicted to be used by a transaction which will be executed on the target system. The resource is configured, at the target system, based on the configuration information. The configuring is before the transaction requests use of the resource.Type: ApplicationFiled: April 10, 2018Publication date: August 9, 2018Inventors: Daniel Kozin, Meichi M. Lin, Nigel G. Slinger, John B. Tobler, Wen Jie Zhu
-
Patent number: 9990231Abstract: In an embodiment, a method of resource pre-configuration includes obtaining, at a target system, configuration information about a resource that is predicted to be used by a transaction which will be executed on the target system. The resource is configured, at the target system, based on the configuration information. The configuring is before the transaction requests use of the resource.Type: GrantFiled: June 4, 2015Date of Patent: June 5, 2018Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: Daniel Kozin, Meichi M. Lin, Nigel G. Slinger, John B. Tobler, Wen Jie Zhu
-
Patent number: 9917885Abstract: According to one embodiment of the present invention, a system compares database transactions to corresponding performance information to identify conforming database transactions with an acceptable deviation from the performance information and outlier database transactions beyond the acceptable deviation from the performance information. The system aggregates information from a threshold quantity of conforming database transactions into an aggregated record, wherein the threshold quantity is dynamically adjusted, and generates a record for each outlier database transaction, wherein conditions for identifying the outlier database transactions are dynamically adjusted. Embodiments of the present invention further include a method and computer program product for managing database transactions in substantially the same manners described above.Type: GrantFiled: July 30, 2013Date of Patent: March 13, 2018Assignee: International Business Machines CorporationInventors: John J. Campbell, Daniel Kozin, Nigel G. Slinger, John B. Tobler
-
Patent number: 9774662Abstract: According to one embodiment of the present invention, a system compares database transactions to corresponding performance information to identify conforming database transactions with an acceptable deviation from the performance information and outlier database transactions beyond the acceptable deviation from the performance information. The system aggregates information from a threshold quantity of conforming database transactions into an aggregated record, wherein the threshold quantity is dynamically adjusted, and generates a record for each outlier database transaction, wherein conditions for identifying the outlier database transactions are dynamically adjusted. Embodiments of the present invention further include a method and computer program product for managing database transactions in substantially the same manners described above.Type: GrantFiled: September 22, 2014Date of Patent: September 26, 2017Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: John J. Campbell, Daniel Kozin, Nigel G. Slinger, John B. Tobler
-
Publication number: 20170154070Abstract: According to one embodiment of the present invention, a system for processing a database query stores one or more result sets for one or more first database queries in a data store. The system receives a second database query and compares the second database query to the one or more first database queries to determine presence of a corresponding result set in the data store for the second database query. The system provides the corresponding result set from the data store for the second database query based on the comparison. Embodiments of the present invention further include a method and computer program product for processing a database query in substantially the same manners described above.Type: ApplicationFiled: February 14, 2017Publication date: June 1, 2017Inventors: Arthur Marais, Christopher J. Munson, Nigel G. Slinger, John B. Tobler
-
Publication number: 20170153979Abstract: According to one embodiment of the present invention, a system for processing a database query stores one or more result sets for one or more first database queries in a data store. The system receives a second database query and compares the second database query to the one or more first database queries to determine presence of a corresponding result set in the data store for the second database query. The system provides the corresponding result set from the data store for the second database query based on the comparison. Embodiments of the present invention further include a method and computer program product for processing a database query in substantially the same manners described above.Type: ApplicationFiled: February 14, 2017Publication date: June 1, 2017Inventors: Arthur Marais, Christopher J. Munson, Nigel G. Slinger, John B. Tobler
-
Patent number: 9613097Abstract: According to one embodiment of the present invention, a system for processing a database query stores one or more result sets for one or more first database queries in a data store. The system receives a second database query and compares the second database query to the one or more first database queries to determine presence of a corresponding result set in the data store for the second database query. The system provides the corresponding result set from the data store for the second database query based on the comparison. Embodiments of the present invention further include a method and computer program product for processing a database query in substantially the same manners described above.Type: GrantFiled: November 24, 2014Date of Patent: April 4, 2017Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: Arthur Marais, Christopher J. Munson, Nigel G. Slinger, John B. Tobler
-
Patent number: 9613096Abstract: According to one embodiment of the present invention, a system for processing a database query stores one or more result sets for one or more first database queries in a data store. The system receives a second database query and compares the second database query to the one or more first database queries to determine presence of a corresponding result set in the data store for the second database query. The system provides the corresponding result set from the data store for the second database query based on the comparison. Embodiments of the present invention further include a method and computer program product for processing a database query in substantially the same manners described above.Type: GrantFiled: March 4, 2014Date of Patent: April 4, 2017Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: Arthur Marais, Christopher J. Munson, Nigel G. Slinger, John B. Tobler
-
Patent number: 9495199Abstract: Management is provided for threads of a database system that is subject to a plurality of disparate bottleneck conditions for resources. A monitor thread retrieves, from a first thread, first monitor data for first bottleneck condition of a first type. The monitor thread compares the first monitor data to a trigger level for the first bottleneck condition and then determines, in response to the comparison of the first monitor data to the trigger level, a potential source of the first bottleneck condition. A potential blocker thread is identified based upon the potential source of the first bottleneck condition. The monitor thread retrieves, from the potential blocker thread, second monitor data for a second type of bottleneck condition that is different from the first type of bottleneck condition. Based upon monitor data, a blocking thread is identified, and a particular blocking solution is applied to the blocking thread.Type: GrantFiled: August 26, 2013Date of Patent: November 15, 2016Assignee: International Business Machines CorporationInventors: Nigel G. Slinger, John B. Tobler, Wen Jie Zhu
-
Patent number: 9495201Abstract: Management is provided for threads of a database system that is subject to a plurality of disparate bottleneck conditions for resources. A monitor thread retrieves, from a first thread, first monitor data for first bottleneck condition of a first type. The monitor thread compares the first monitor data to a trigger level for the first bottleneck condition and then determines, in response to the comparison of the first monitor data to the trigger level, a potential source of the first bottleneck condition. A potential blocker thread is identified based upon the potential source of the first bottleneck condition. The monitor thread retrieves, from the potential blocker thread, second monitor data for a second type of bottleneck condition that is different from the first type of bottleneck condition. Based upon monitor data, a blocking thread is identified, and a particular blocking solution is applied to the blocking thread.Type: GrantFiled: June 5, 2014Date of Patent: November 15, 2016Assignee: International Business Machines CorporationInventors: Nigel G. Slinger, John B. Tobler, Wen Jie Zhu
-
Patent number: 9396218Abstract: According to one embodiment of the present invention, a system inserts data into a database object. The system associates the database object with a parameter specifying materialization of data for the database object. The system inserts data into the database object and materializes the data in accordance with the parameter to provide access to the data from the database object, wherein the parameter specifies a portion of the data to be materialized upon insertion. Embodiments of the present invention further include a method and computer program product for inserting data into a database object in substantially the same manners described above.Type: GrantFiled: September 16, 2013Date of Patent: July 19, 2016Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: Daniel Kozin, Meichi M. Lin, Arthur Marais, Nigel G. Slinger, John B. Tobler, Wen J. Zhu
-
Patent number: 9390111Abstract: According to one embodiment of the present invention, a system inserts data into a database object. The system associates the database object with a parameter specifying materialization of data for the database object. The system inserts data into the database object and materializes the data in accordance with the parameter to provide access to the data from the database object, wherein the parameter specifies a portion of the data to be materialized upon insertion. Embodiments of the present invention further include a method and computer program product for inserting data into a database object in substantially the same manners described above.Type: GrantFiled: June 4, 2014Date of Patent: July 12, 2016Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: Daniel Kozin, Meichi M. Lin, Arthur Marais, Nigel G. Slinger, John B. Tobler, Wen J. Zhu
-
Patent number: 9286328Abstract: According to one embodiment of the present invention, a system includes a processor to copy an object of a database system. The system determines one or more portions of the object that are active and reside within a buffer pool of the database system, and copies the determined portions of the object from the buffer pool. Remaining portions of the object that are non-active are copied from database storage. A copy of the object is created from the copied object portions. Embodiments of the present invention further include a method and program product for copying an object of a database system in substantially the same manner described above.Type: GrantFiled: July 19, 2013Date of Patent: March 15, 2016Assignee: International Business Machines CorporationInventors: Daniel Kozin, Arthur Marais, Nigel G. Slinger, John B. Tobler
-
Publication number: 20150378829Abstract: In an embodiment, a method of resource pre-configuration includes obtaining, at a target system, configuration information about a resource that is predicted to be used by a transaction which will be executed on the target system. The resource is configured, at the target system, based on the configuration information.Type: ApplicationFiled: June 4, 2015Publication date: December 31, 2015Inventors: Daniel Kozin, Meichi M. Lin, Nigel G. Slinger, John B. Tobler, Wen Jie Zhu
-
Patent number: 9134975Abstract: Source code of a computer program is compiled by a compiler to generate object code. During compilation of the source code, for each function of the source code compiled, an identifier indicating the function can be entered into a module entry point list. An update for the compiler is received. Responsive to receiving the compiler update, a determination is made, by processing the module entry point list, whether any of the functions of the source code were compiled at least one compiler module to be changed by the compiler update. Responsive to determining that at least one of the functions of the source code was compiled by a compiler module to be changed by the compiler update, a determination is made that the source code of the computer program is a candidate to be recompiled with an updated version of the compiler having the compiler update applied.Type: GrantFiled: August 22, 2014Date of Patent: September 15, 2015Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: Thomas A. Beavin, David R. Moy, Terence P. Purcell, John B. Tobler, Nigel G. Slinger
-
Publication number: 20150254245Abstract: According to one embodiment of the present invention, a system for processing a database query stores one or more result sets for one or more first database queries in a data store. The system receives a second database query and compares the second database query to the one or more first database queries to determine presence of a corresponding result set in the data store for the second database query. The system provides the corresponding result set from the data store for the second database query based on the comparison. Embodiments of the present invention further include a method and computer program product for processing a database query in substantially the same manners described above.Type: ApplicationFiled: November 24, 2014Publication date: September 10, 2015Inventors: Arthur Marais, Christopher J. Munson, Nigel G. Slinger, John B. Tobler
-
Publication number: 20150254294Abstract: According to one embodiment of the present invention, a system for processing a database query stores one or more result sets for one or more first database queries in a data store. The system receives a second database query and compares the second database query to the one or more first database queries to determine presence of a corresponding result set in the data store for the second database query. The system provides the corresponding result set from the data store for the second database query based on the comparison. Embodiments of the present invention further include a method and computer program product for processing a database query in substantially the same manners described above.Type: ApplicationFiled: March 4, 2014Publication date: September 10, 2015Applicant: International Business Machines CorporationInventors: Arthur Marais, Christopher J. Munson, Nigel G. Slinger, John B. Tobler
-
Publication number: 20150081745Abstract: According to one embodiment of the present invention, a system inserts data into a database object. The system associates the database object with a parameter specifying materialization of data for the database object. The system inserts data into the database object and materializes the data in accordance with the parameter to provide access to the data from the database object, wherein the parameter specifies a portion of the data to be materialized upon insertion. Embodiments of the present invention further include a method and computer program product for inserting data into a database object in substantially the same manners described above.Type: ApplicationFiled: June 4, 2014Publication date: March 19, 2015Inventors: Daniel Kozin, Meichi M. Lin, Arthur Marais, Nigel G. Slinger, John B. Tobler, Wen J. Zhu