Patents by Inventor Rafal P. Konik
Rafal P. Konik 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: 11704216Abstract: Each of one or more commit cycles may be associated with a predicted number of updates. A statistics collection time for a database table can be determined by estimating a sum of predicted updates included in one or more commit cycles. Whether the estimated sum of predicted updates is greater than a first threshold may be determined. In addition, a progress point for a first one of the commit cycles can be determined. A time to collect statistics may be selected based on the progress point of the first commit cycle.Type: GrantFiled: May 23, 2019Date of Patent: July 18, 2023Assignee: International Business Machines CorporationInventors: Rafal P. Konik, Roger A. Mittelstadt, Brian R. Muras, Chad A. Olstad
-
Patent number: 11487760Abstract: Disclosed aspects relate to query plan management associated with a shared pool of configurable computing resources. A query, which relates to a set of data located on the shared pool of configurable computing resources, is detected. A virtual machine includes the set of data. With respect to the virtual machine, a set of burden values of performing a set of asset actions is determined. Based on the set of burden values, a query plan to access the set of data is established. Using at least one asset action of the set of asset actions, the query plan is processed.Type: GrantFiled: October 9, 2020Date of Patent: November 1, 2022Assignee: International Business Machines CorporationInventors: Rafal P. Konik, Roger A. Mittelstadt, Brian R. Muras
-
Patent number: 11354313Abstract: Disclosed aspects relate to transforming a user-defined table function (UDTF) to a derived table in a database management system (DBMS). It may be detected by the DBMS that a query indicates the UDTF. A derived table may be constructed from the UDTF. The derived table may be derived from a set of statements of the UDTF. The derived table may be introduced to the query to fulfill the UDTF. A query plan may be generated for the query by the DBMS. The query plan may be generated in response to introducing the derived table in the query.Type: GrantFiled: September 10, 2019Date of Patent: June 7, 2022Assignee: Alibaba Group Holding LimitedInventors: Craig S. Aldrich, Stephanie A. Burrichter, Scott P. Hanson, Rafal P. Konik, Roger A. Mittelstadt, Jane A. Vold
-
Patent number: 11250002Abstract: A structured query language (SQL) query is configured to present a selected portion of a result set to a user interface. The selected portion of the result set can be based on an offset criteria appended to the SQL query. The offset criteria determines a location of a first presented instance of the selected portion of the result set. The offset criteria is configured to determine the location of the first presented instance of the selected portion of the result set independent of a number of instances appearing between a first instance of the result set and the first presented instance of the selected portion of the result set.Type: GrantFiled: July 19, 2019Date of Patent: February 15, 2022Assignee: International Business Machines CorporationInventors: Rafal P. Konik, Roger A. Mittelstadt, Brian R. Muras, Chad A. Olstad
-
Patent number: 11204926Abstract: A tuple manager of a database system processes partial tuples from a streaming application and stores them in a database. The partial tuples may include a large object (LOB) that arrives at the database at a different time than the rest of the corresponding tuple. A tuple manager stores partial tuples and uses a partial tuples index to track the partial tuples and coordinate recombination of corresponding partial tuples. The database allows queries to be run on the partial data before the tuples are reconstructed allowing faster access to potentially important data before the arrival and processing of a partial tuple such as an LOB.Type: GrantFiled: October 31, 2018Date of Patent: December 21, 2021Assignee: International Business Machines CorporationInventors: Rafal P. Konik, Jessica R. Eidem, Jingdong Sun, Roger A. Mittelstadt
-
Patent number: 11176506Abstract: A blockchain configuration may require constant and large amounts of resources to maintain a growing structure. One example method of operation may include receiving blockchain transactions and creating a blockchain block, identifying miner devices to process the blockchain block, identifying expenses associated with each of the miner devices, selecting an optimal cost miner device among the miner devices based on the identified expenses associated with each of the miner devices, and assigning the optimal cost miner device to solve the blockchain block.Type: GrantFiled: October 14, 2016Date of Patent: November 16, 2021Assignee: International Business Machines CorporationInventors: Rafal P. Konik, Roger A. Mittelstadt, Brian R. Muras, Chad A. Olstad
-
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: 11163809Abstract: A method, system, and computer program product to manage a database is disclosed. The method, system, and computer program product may include structuring the database to have a first table having an index and a second table. A first key of the first table may be related to a second key of the second table. The method, system, and computer program product may include creating an entry locator in the index. The method, system, and computer program product may include maintaining an association between the second key of the second table and the entry locator of the index.Type: GrantFiled: June 10, 2019Date of Patent: November 2, 2021Assignee: International Business Machines CorporationInventors: Rafal P. Konik, Roger A. Mittelstadt, Brian R. Muras, Mark W. Theuer
-
Patent number: 11099960Abstract: Each of one or more commit cycles may be associated with a predicted number of updates. A statistics collection time for a database table can be determined by estimating a sum of predicted updates included in one or more commit cycles. Whether the estimated sum of predicted updates is greater than a first threshold may be determined. In addition, a progress point for a first one of the commit cycles can be determined. A time to collect statistics may be selected based on the progress point of the first commit cycle.Type: GrantFiled: May 23, 2019Date of Patent: August 24, 2021Assignee: International Business Machines CorporationInventors: Rafal P. Konik, Roger A. Mittelstadt, Brian R. Muras, Chad A. Olstad
-
Patent number: 11042873Abstract: Systems and methods for providing automatic fork protection including determining that a transaction having fork protection was included in a first block that was appended to a blockchain, that a hash of the first block was validated, that a consensus decision was made by validator nodes approving the first block for addition to the blockchain, that a second block was appended to the blockchain after the first block, that the second block comprises a hash that is not based on the first block, that the first block was on a first fork and the second block was on a second fork, that the blockchain was resolved in favor of the second fork, and that the transaction failed as a result of the blockchain being resolved in favor of the second fork. The method including compensating a party that submitted the failed transaction based on the fork protection.Type: GrantFiled: December 3, 2018Date of Patent: June 22, 2021Assignee: International Business Machines CorporationInventors: Rafal P. Konik, Roger A. Mittelstadt, Brian R. Muras, Chad A. Olstad
-
Publication number: 20210152491Abstract: Techniques and apparatus for prioritizing tuples for processing in a distributed programming environment are provided. One technique includes identifying a plurality of tuples available for processing by an operator. At least a first set of the plurality of tuples are processed according to a first type of priority. In response to detecting that a set of conditions associated with processing the plurality of tuples according to a second type of priority are satisfied, at least a second set of the plurality of tuples are processed according to the second type of priority.Type: ApplicationFiled: November 14, 2019Publication date: May 20, 2021Inventors: Jingdong SUN, Jessica R. EIDEM, Roger A. MITTELSTADT, Rafal P. KONIK
-
Patent number: 10965750Abstract: Dynamic connections between processing elements of a streaming application are managed in a distributed manner by the processing elements to increase efficiency and performance of real-time connection updates. A streams application management service includes a connection manager that notifies all processing elements when a job with a new processing element is submitted. Each processing element dynamically maintains its own connections based on one or more of the following conditions: connection data received from the streams management service, and a behavior change of the processing element. Then the processing element reports connection updates to the connection manager in the streams management service. The connection manager may store updated connection information in the connection data.Type: GrantFiled: September 27, 2018Date of Patent: March 30, 2021Assignee: International Business Machines CorporationInventors: Rafal P. Konik, Jingdong Sun, Jessica R. Eidem, Roger A. Mittelstadt
-
Publication number: 20210081420Abstract: Disclosed aspects relate to query plan management associated with a shared pool of configurable computing resources. A query, which relates to a set of data located on the shared pool of configurable computing resources, is detected. A virtual machine includes the set of data. With respect to the virtual machine, a set of burden values of performing a set of asset actions is determined. Based on the set of burden values, a query plan to access the set of data is established. Using at least one asset action of the set of asset actions, the query plan is processed.Type: ApplicationFiled: October 9, 2020Publication date: March 18, 2021Inventors: Rafal P. Konik, Roger A. Mittelstadt, Brian R. Muras
-
Patent number: 10938561Abstract: A public operator processes data streams from multiple operators in different streaming applications to reduce resource costs and increase efficiency in a streaming system. The public operator uses tuple level security with a unique key for each streaming application to securely process the data streams. A stream security module (SSM) manages encryption to and from the public operators to insure other streaming applications with access to the shared public operator don't have access to data of other applications that may belong to other customers or users. The stream security module may be incorporated into the streams manager of a streaming system.Type: GrantFiled: June 21, 2018Date of Patent: March 2, 2021Assignee: International Business Machines CorporationInventors: Jingdong Sun, Roger A. Mittelstadt, Jessica R. Eidem, Rafal P. Konik
-
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
-
Patent number: 10909122Abstract: Method, system, and computer program product are provided to guarantee no tuple loss and/or corruption in a real-time data streaming environment. In some embodiments, a stream of tuples is sent from an entry operator to downstream operator(s), and, at the entry operator, a mark is placed on each tuple in the stream of tuples. In an embodiment where the stream of tuples includes first, second, and subsequent tuple(s), for example, the mark may comprise a tuple-unique number and a tuple-data hash of data contained in the tuple, and the mark on the second and each subsequent tuple may further comprise a link-back hash associated with the immediately preceding tuple in the stream of tuples. In some embodiments, the link-back hash is used to check whether a tuple is lost or received out of order, and the tuple-data hash is used to check whether a received tuple is corrupt.Type: GrantFiled: November 9, 2018Date of Patent: February 2, 2021Assignee: International Business Machines CorporationInventors: Roger A. Mittelstadt, Rafal P. Konik, Jessica R. Eidem, Jingdong Sun
-
Patent number: 10896177Abstract: A computer-implemented method for determining a query execution plan based on transaction state may include determining that a first set of database values in a database table are in a committed transaction state and that a second set of database values in the database table are in an uncommitted transaction state. In response to the determining, the first set of database values may have a first set of statistics generated and the second set of database values may have a second set of statistics generated. The first and second set of statistics may be for use in determining a query execution plan.Type: GrantFiled: April 23, 2018Date of Patent: January 19, 2021Assignee: International Business Machines CorporationInventors: Rafal P. Konik, Roger A. Mittelstadt, Brian R. Muras, Chad A. Olstad
-
Patent number: 10885033Abstract: Disclosed aspects relate to query plan management associated with a shared pool of configurable computing resources. A query, which relates to a set of data located on the shared pool of configurable computing resources, is detected. A virtual machine includes the set of data. With respect to the virtual machine, a set of burden values of performing a set of asset actions is determined. Based on the set of burden values, a query plan to access the set of data is established. Using at least one asset action of the set of asset actions, the query plan is processed.Type: GrantFiled: January 9, 2019Date of Patent: January 5, 2021Assignee: International Business Machines CorporationInventors: Rafal P. Konik, Roger A. Mittelstadt, Brian R. Muras
-
Patent number: 10846291Abstract: Disclosed aspects relate to transforming a user-defined table function (UDTF) to a derived table in a database management system (DBMS). It may be detected by the DBMS that a query indicates the UDTF. A derived table may be constructed from the UDTF. The derived table may be derived from a set of statements of the UDTF. The derived table may be introduced to the query to fulfill the UDTF. A query plan may be generated for the query by the DBMS. The query plan may be generated in response to introducing the derived table in the query.Type: GrantFiled: April 18, 2019Date of Patent: November 24, 2020Assignee: Alibaba Group Holding LimitedInventors: Craig S. Aldrich, Stephanie A. Burrichter, Scott P. Hanson, Rafal P. Konik, Roger A. Mittelstadt, Jane A. Vold
-
Patent number: 10810267Abstract: An approach is described of structuring resources among a plurality of resources in a system architecture. A method pertaining to such approach may include accessing a knowledge base including attributes relevant to the plurality of resources. The attributes of the knowledge base may include concepts and logical relationships associated with the concepts. The method further may include, responsive to receiving at least one resource to be processed with respect to the plurality of resources, extracting characteristics from the at least one resource based upon the attributes of the knowledge base, and storing the extracted characteristics in a repository. The method further may include, responsive to an application request, creating a URI structure representing at least one matching resource among the plurality of resources that corresponds to the application request.Type: GrantFiled: October 12, 2016Date of Patent: October 20, 2020Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: David S. Charron, Kyle E. Gilbertson, Rafal P. Konik, Nicholas T. Lawrence