Patents by Inventor Shawn J. Baranczyk
Shawn J. Baranczyk 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: 11163771Abstract: A sequence object manager provides a sequence object with a dynamic cache block size that indicates a block size of values to be added to the sequence object when the cache values are exhausted. The dynamic block size allows the sequence object manager to optimize performance and storage space depending on applications using the sequence object. The dynamically block size is set and maintained by the sequence object manager based on observed performance and historical trends of the applications. A seed value may be provided by the user to initially set the dynamic block size.Type: GrantFiled: September 4, 2018Date of Patent: November 2, 2021Assignee: International Business Machines CorporationInventors: Rafal P. Konik, Robert J. Bestgen, Shawn J. Baranczyk, Roger A. Mittelstadt
-
Patent number: 10929397Abstract: A query is received. Based on statistics for a database, a first query access plan is generated for executing the query on the database. A first result set for the query is obtained by implementing the first query access plan on the database. Based on at least one trend in the statistics, a target time after which implementing the first query access plan will fail a set of criteria is forecasted. In response to the forecasting and based on the statistics, a replacement query access plan is generated prior to the target time. After the target time, a second result set for the query is obtained by implementing the replacement query access plan rather than the first query access plan.Type: GrantFiled: February 20, 2018Date of Patent: February 23, 2021Assignee: International Business Machines CorporationInventors: Shawn J. Baranczyk, Rafal P. Konik, Roger A. Mittelstadt, Brian R. Muras
-
Publication number: 20200073869Abstract: A sequence object manager provides a sequence object with a dynamic cache block size that indicates a block size of values to be added to the sequence object when the cache values are exhausted. The dynamic block size allows the sequence object manager to optimize performance and storage space depending on applications using the sequence object. The dynamically block size is set and maintained by the sequence object manager based on observed performance and historical trends of the applications. A seed value may be provided by the user to initially set the dynamic block size.Type: ApplicationFiled: September 4, 2018Publication date: March 5, 2020Inventors: Rafal P. Konik, Robert J. Bestgen, Shawn J. Baranczyk, Roger A. Mittelstadt
-
Patent number: 10534790Abstract: Systems, methods, and computer program products to perform an operation comprising receiving, by a database management system (DBMS) from an application, a request specifying to generate a global temporary table (GTT) of a first format, identifying a first GTT, of a plurality of GTTs stored by the DBMS, that has a second format, different than the first format, modifying the first GTT such that at least a portion of the modified first GTT is of the first format, and providing the modified first GTT to the application.Type: GrantFiled: October 20, 2016Date of Patent: January 14, 2020Assignee: International Business Machines CorporationInventors: Shawn J. Baranczyk, Rafal P. Konik, Roger A. Mittelstadt, Brian R. Muras
-
Patent number: 10169411Abstract: A query is received. Based on statistics for a database, a first query access plan is generated for executing the query on the database. A first result set for the query is obtained by implementing the first query access plan on the database. Based on at least one trend in the statistics, a target time after which implementing the first query access plan will fail a set of criteria is forecasted. In response to the forecasting and based on the statistics, a replacement query access plan is generated prior to the target time. After the target time, a second result set for the query is obtained by implementing the replacement query access plan rather than the first query access plan.Type: GrantFiled: April 1, 2015Date of Patent: January 1, 2019Assignee: International Business Machines CorporationInventors: Shawn J. Baranczyk, Rafal P. Konik, Roger A. Mittelstadt, Brian R. Muras
-
Patent number: 10152510Abstract: Disclosed aspects relate to query hint learning in a database management system. A hint in a first query is detected by the database management system. The first query has a first signature. A second query is received by the database management system. The second query has a second signature. A determination is made by the database management system that the second signature correlates with the first signature. A query plan is established by the database management system. The query plan is based on the second query and uses the hint in the first query. In response to receiving the second query, the database management system processes the query plan.Type: GrantFiled: March 20, 2016Date of Patent: December 11, 2018Assignee: International Business Machines CorporationInventors: Shawn J. Baranczyk, Rafal P. Konik, Roger A. Mittelstadt, Brian R. Muras
-
Patent number: 10152509Abstract: Disclosed aspects relate to query hint learning in a database management system. A hint in a first query is detected by the database management system. The first query has a first signature. A second query is received by the database management system. The second query has a second signature. A determination is made by the database management system that the second signature correlates with the first signature. A query plan is established by the database management system. The query plan is based on the second query and uses the hint in the first query. In response to receiving the second query, the database management system processes the query plan.Type: GrantFiled: September 23, 2015Date of Patent: December 11, 2018Assignee: International Business Machines CorporationInventors: Shawn J. Baranczyk, Rafal P. Konik, Roger A. Mittelstadt, Brian R. Muras
-
Patent number: 10133779Abstract: Disclosed aspects relate to query hint management for a database management system. With respect to a hint for a query, a set of hint profile data is established. The database management system detects a triggering event. Based on the set of hint profile data, the database management system determines to perform a hint action in response to the triggering event. Performance of the hint action is initiated.Type: GrantFiled: January 3, 2016Date of Patent: November 20, 2018Assignee: International Business Machines CorporationInventors: Shawn J. Baranczyk, Rafal P. Konik, Roger A. Mittelstadt, Brian R. Muras
-
Patent number: 10055459Abstract: Disclosed aspects relate to query hint management for a database management system. With respect to a hint for a query, a set of hint profile data is established. The database management system detects a triggering event. Based on the set of hint profile data, the database management system determines to perform a hint action in response to the triggering event. Performance of the hint action is initiated.Type: GrantFiled: November 9, 2015Date of Patent: August 21, 2018Assignee: International Business Machines CorporationInventors: Shawn J. Baranczyk, Rafal P. Konik, Roger A. Mittelstadt, Brian R. Muras
-
Publication number: 20180189351Abstract: A query is received. Based on statistics for a database, a first query access plan is generated for executing the query on the database. A first result set for the query is obtained by implementing the first query access plan on the database. Based on at least one trend in the statistics, a target time after which implementing the first query access plan will fail a set of criteria is forecasted. In response to the forecasting and based on the statistics, a replacement query access plan is generated prior to the target time. After the target time, a second result set for the query is obtained by implementing the replacement query access plan rather than the first query access plan.Type: ApplicationFiled: February 20, 2018Publication date: July 5, 2018Inventors: Shawn J. Baranczyk, Rafal P. Konik, Roger A. Mittelstadt, Brian R. Muras
-
Patent number: 9990396Abstract: A query is received. Based on statistics for a database, a first query access plan is generated for executing the query on the database. A first result set for the query is obtained by implementing the first query access plan on the database. Based on at least one trend in the statistics, a target time after which implementing the first query access plan will fail a set of criteria is forecasted. In response to the forecasting and based on the statistics, a replacement query access plan is generated prior to the target time. After the target time, a second result set for the query is obtained by implementing the replacement query access plan rather than the first query access plan.Type: GrantFiled: February 3, 2015Date of Patent: June 5, 2018Assignee: International Business Machines CorporationInventors: Shawn J. Baranczyk, Rafal P. Konik, Roger A. Mittelstadt, Brian R. Muras
-
Publication number: 20180113921Abstract: Systems, methods, and computer program products to perform an operation comprising receiving, by a database management system (DBMS) from an application, a request specifying to generate a global temporary table (GTT) of a first format, identifying a first GTT, of a plurality of GTTs stored by the DBMS, that has a second format, different than the first format, modifying the first GTT such that at least a portion of the modified first GTT is of the first format, and providing the modified first GTT to the application.Type: ApplicationFiled: October 20, 2016Publication date: April 26, 2018Inventors: Shawn J. BARANCZYK, Rafal P. KONIK, Roger A. MITTELSTADT, Brian R. MURAS
-
Patent number: 9846599Abstract: Techniques are provided for managing a database cursor threshold. One embodiment provides a method that includes setting a database cursor threshold, for a first database job of a plurality of database jobs, to a first value. Generally, the cursor threshold defines the maximum number of database cursors that are permitted to be open at a time in a database system. One or more system resources of the database system are monitored, and upon detecting that a current state of the one or more system resources satisfies predefined criteria, embodiments set the database cursor threshold to a second value.Type: GrantFiled: October 31, 2016Date of Patent: December 19, 2017Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: Shawn J. Baranczyk, Rafal P. Konik, Roger A. Mittelstadt, Brian R. Muras
-
Publication number: 20170132284Abstract: Disclosed aspects relate to query hint management for a database management system. With respect to a hint for a query, a set of hint profile data is established. The database management system detects a triggering event. Based on the set of hint profile data, the database management system determines to perform a hint action in response to the triggering event. Performance of the hint action is initiated.Type: ApplicationFiled: January 3, 2016Publication date: May 11, 2017Inventors: Shawn J. Baranczyk, Rafal P. Konik, Roger A. Mittelstadt, Brian . Muras
-
Publication number: 20170132286Abstract: Disclosed aspects relate to query hint management for a database management system. With respect to a hint for a query, a set of hint profile data is established. The database management system detects a triggering event. Based on the set of hint profile data, the database management system determines to perform a hint action in response to the triggering event. Performance of the hint action is initiated.Type: ApplicationFiled: November 9, 2015Publication date: May 11, 2017Inventors: Shawn J. Baranczyk, Rafal P. Konik, Roger A. Mittelstadt, Brian R. Muras
-
Publication number: 20170083575Abstract: Disclosed aspects relate to query hint learning in a database management system. A hint in a first query is detected by the database management system. The first query has a first signature. A second query is received by the database management system. The second query has a second signature. A determination is made by the database management system that the second signature correlates with the first signature. A query plan is established by the database management system. The query plan is based on the second query and uses the hint in the first query. In response to receiving the second query, the database management system processes the query plan.Type: ApplicationFiled: September 23, 2015Publication date: March 23, 2017Inventors: Shawn J. Baranczyk, Rafal P. Konik, Roger A. Mittelstadt, Brian R. Muras
-
Publication number: 20170083828Abstract: Disclosed aspects relate to query hint learning in a database management system. A hint in a first query is detected by the database management system. The first query has a first signature. A second query is received by the database management system. The second query has a second signature. A determination is made by the database management system that the second signature correlates with the first signature. A query plan is established by the database management system. The query plan is based on the second query and uses the hint in the first query. In response to receiving the second query, the database management system processes the query plan.Type: ApplicationFiled: March 20, 2016Publication date: March 23, 2017Inventors: Shawn J. Baranczyk, Rafal P. Konik, Roger A. Mittelstadt, Brian R. Muras
-
Publication number: 20160342646Abstract: Disclosed aspects include managing a query cursor. Based on a first query having a first Structured Query Language (SQL) syntax, a first query cursor is established. A second query is detected. The second query has a second SQL syntax which differs from the first SQL syntax. Based on a relationship of the second query with respect to the first query cursor, a determination is made to use the first query cursor to provide a valid results-set for the second query. Using the first query cursor, the valid results-set for the second query is provided.Type: ApplicationFiled: May 20, 2015Publication date: November 24, 2016Inventors: Shawn J. Baranczyk, Rafal P. Konik, Roger A. Mittelstadt, Brian R. Muras
-
Publication number: 20160342652Abstract: Disclosed aspects include managing a query cursor. Based on a first query having a first Structured Query Language (SQL) syntax, a first query cursor is established. A second query is detected. The second query has a second SQL syntax which differs from the first SQL syntax. Based on a relationship of the second query with respect to the first query cursor, a determination is made to use the first query cursor to provide a valid results-set for the second query. Using the first query cursor, the valid results-set for the second query is provided.Type: ApplicationFiled: August 24, 2015Publication date: November 24, 2016Inventors: Shawn J. Baranczyk, Rafal P. Konik, Roger A. Mittelstadt, Brian R. Muras
-
Publication number: 20160224688Abstract: A query is received. Based on statistics for a database, a first query access plan is generated for executing the query on the database. A first result set for the query is obtained by implementing the first query access plan on the database. Based on at least one trend in the statistics, a target time after which implementing the first query access plan will fail a set of criteria is forecasted. In response to the forecasting and based on the statistics, a replacement query access plan is generated prior to the target time. After the target time, a second result set for the query is obtained by implementing the replacement query access plan rather than the first query access plan.Type: ApplicationFiled: February 3, 2015Publication date: August 4, 2016Inventors: Shawn J. Baranczyk, Rafal P. Konik, Roger A. Mittelstadt, Brian R. Muras