Patents by Inventor Brian R. Muras

Brian R. Muras 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).

  • DATABASE STATISTICS BASED ON TRANSACTION STATE
    Publication number: 20180046673
    Abstract: 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: Application
    Filed: October 31, 2017
    Publication date: February 15, 2018
    Inventors: Rafal P. Konik, Roger A. Mittelstadt, Brian R. Muras, Chad A. Olstad
  • QUERY GOVERNOR RULES FOR DATA REPLICATION
    Publication number: 20180046691
    Abstract: Embodiments of the present disclosure provide a method, system, and computer program product for managing the execution of a query. The method, system and computer program product include receiving a query to be executed. The query governor calculates an estimated replication time of the received query. The estimated replication time is an estimated duration of time required to replicate changes caused by the query. The query governor determines whether the estimated replication time exceeds the threshold replication time. Responsive to the query governor determining that the estimated replication time does not exceed the threshold replication time, the query governor executes the query against the database in accordance with the instructions.
    Type: Application
    Filed: August 10, 2016
    Publication date: February 15, 2018
    Inventors: Eric L. BARSNESS, Daniel E. BEUCH, Brian R. MURAS, John M. SANTOSUOSSO
  • Database statistics based on transaction state
    Patent number: 9892160
    Abstract: 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: Grant
    Filed: April 7, 2015
    Date of Patent: February 13, 2018
    Assignee: International Business Machines Corporation
    Inventors: Rafal P. Konik, Roger A. Mittelstadt, Brian R. Muras, Chad A. Olstad
  • Generating and accessing a data table
    Patent number: 9886463
    Abstract: An index shared between a plurality of tables is used to access a data sharing space (DSS) storing a set of rows from a base table having a plurality of rows with stored data. First data values of the index are identified in response to a query for a table. A subset of rows is then retrieved from the DSS using the index elements corresponding to the first data values. Second data values and some of the first data values are then identified in response to a second query for a table. A second subset of rows are then retrieved from the DSS using the index elements corresponding to the second data values and some of the first data values and the query is then applied to the subset of rows.
    Type: Grant
    Filed: June 12, 2014
    Date of Patent: February 6, 2018
    Assignee: International Business Machines Corporation
    Inventors: Rafal P. Konik, Roger A. Mittelstadt, Brian R. Muras, Mark W. Theuer
  • QUERY MANAGEMENT BASED ON AMOUNT OF DATA CHANGE
    Publication number: 20180018369
    Abstract: Techniques are described for estimating and managing an amount of data change for query processing. Embodiments of the present disclosure may generally receive a query to be executed and calculate an estimated amount of data change for the received query. If the initial estimated amount of data change for the received query does not exceed a threshold amount of data change, embodiments of the present disclosure may submit the query for execution. If the initial estimated amount of data change for the received query does exceed a threshold amount of data change, embodiments of the present disclosure may halt the execution of the query.
    Type: Application
    Filed: July 14, 2016
    Publication date: January 18, 2018
    Inventors: Eric L. BARSNESS, Daniel E. BEUCH, Brian R. MURAS, John M. SANTOSUOSSO
  • Optimized migration of virtual objects across environments in a cloud computing environment
    Patent number: 9870245
    Abstract: An appliance migration mechanism (AMM) optimizes migration of a live virtual appliance with virtual objects between cloud environments to minimize temporary connections that use significant cloud resources during the migration. The AMM determines a cost of connections of each virtual object in the virtual appliance and produces an order of migration for the virtual objects. The cost of connections of the virtual objects may be determined by the total number of connections and the maximum number of connections. Alternatively the cost of the connections of the virtual objects for migration could be determined by a weighting the costs of the connections where the weighting may consider loading or other factors on the connection.
    Type: Grant
    Filed: December 30, 2014
    Date of Patent: January 16, 2018
    Assignee: Inernational Business Machines Corporation
    Inventors: Bin Cao, Daniel L. Hiebert, Brian R. Muras, Tanveer Zubair
  • Read and delete input/output operation for database management
    Patent number: 9870378
    Abstract: A computer-implemented method for improving database management includes selecting one or more database records that are requested based on a query statement. The one or more database records are read from a first database file. The one or more database records are copied from the first database file and stored to a memory. The one or more database records are deleted from the first database file at substantially the same time as the reading the one or more database records. The reading and the deleting occur through a single read and delete input/output (I/O) operation.
    Type: Grant
    Filed: November 18, 2014
    Date of Patent: January 16, 2018
    Assignee: International Business Machines Corporation
    Inventors: Rafal P. Konik, Roger A. Mittelstadt, Brian R. Muras, Mark W. Theuer
  • Optimized migration of virtual objects across environments in a cloud computing environment
    Patent number: 9870244
    Abstract: An appliance migration mechanism (AMM) optimizes migration of a live virtual appliance with virtual objects between cloud environments to minimize temporary connections that use significant cloud resources during the migration. The AMM determines a cost of connections of each virtual object in the virtual appliance and produces an order of migration for the virtual objects. The cost of connections of the virtual objects may be determined by the total number of connections and the maximum number of connections. Alternatively the cost of the connections of the virtual objects for migration could be determined by a weighting the costs of the connections where the weighting may consider loading or other factors on the connection.
    Type: Grant
    Filed: December 29, 2014
    Date of Patent: January 16, 2018
    Assignee: International Business Machines Corporation
    Inventors: Bin Cao, Daniel L. Hiebert, Brian R. Muras, Tanveer Zubair
  • Intelligently utilizing non-matching weighted indexes
    Patent number: 9864776
    Abstract: System, method, and computer program product to intelligently utilize non-matching weighted objects, by determining that a sort sequence of a query does not match a sort sequence of a shared weight object of a database, modifying the query based on the sort sequence of the query, and executing the modified query to obtain a result set, wherein the result set does not include a set of rows that would have been returned using the shared weight object to process the unmodified query.
    Type: Grant
    Filed: December 12, 2014
    Date of Patent: January 9, 2018
    Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATION
    Inventors: Roger A. Mittelstadt, Brian R. Muras
  • RESULT SET OUTPUT CRITERIA
    Publication number: 20180004814
    Abstract: 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: Application
    Filed: July 1, 2016
    Publication date: January 4, 2018
    Inventors: Rafal P. Konik, Roger A. Mittelstadt, Brian R. Muras, Chad A. Olstad
  • Dynamically deployed virtual machine
    Patent number: 9851994
    Abstract: A virtual machine data handling system includes a data handling system, a hypervisor, and a dynamically deployed virtual machine. The data handling system includes a plurality of physical computing resources (e.g., a processor and a memory). The hypervisor is implemented by the processor and the memory and deploys virtual machines from a master image. The dynamically deployed virtual machine is initially deployed by the hypervisor as a Linked Clone of the master image. The dynamically deployed virtual machine is subsequently dynamically deployed by the hypervisor copying a plurality of virtual memory segments from the master image until the dynamically deployed virtual machine is an independent Full Clone of the master image. The hypervisor may copy the plurality of virtual memory segments from the master image if at least one of the physical resources is operating below a utilization threshold.
    Type: Grant
    Filed: October 2, 2014
    Date of Patent: December 26, 2017
    Assignee: International Business Machines Corporation
    Inventors: Thuy Phuong Christenson, Brian R. Muras, Christopher J. Schaefer
  • Adaptive query cursor management
    Patent number: 9846599
    Abstract: 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: Grant
    Filed: October 31, 2016
    Date of Patent: December 19, 2017
    Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATION
    Inventors: Shawn J. Baranczyk, Rafal P. Konik, Roger A. Mittelstadt, Brian R. Muras
  • Dynamic filter optimization in deep question answering systems
    Patent number: 9846738
    Abstract: Systems, methods, and computer program products to perform an operation comprising providing a plurality of filters in a deep question answering (deep QA) system, wherein each of the filters is configured to remove candidate answers not meeting a set of criteria of each respective filter from further consideration by the deep QA system, determining that a first ordering, of a plurality of orderings of the plurality of filters, is an optimal ordering of the plurality of filters based on a respective filtering metric of each ordering, and configuring the deep QA system to apply the plurality of filters to candidate answers according to the first ordering.
    Type: Grant
    Filed: December 5, 2014
    Date of Patent: December 19, 2017
    Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATION
    Inventors: Mark G. Megerian, Brian R. Muras
  • Managed services coordinator
    Patent number: 9846595
    Abstract: A method is provided for applying tasks. The method can include receiving a plurality of tasks for a plurality of applications, an application of the plurality of applications is hosted by a computing environment utilizing a monitoring agent, and a task is performed for an operation of the application during a first period of time. The method can also include determining a first resource type and a first resource amount from the computing environment for performing the task. The method can also include grouping the plurality of tasks into a set of tasks based on the first resource type, at least two tasks from the set of tasks being performable in parallel during the first period of time. The method can also include determining whether the first resource amount of the first resource type is present in the computing environment during the first period of time.
    Type: Grant
    Filed: September 29, 2015
    Date of Patent: December 19, 2017
    Assignee: International Business Machines Corporation
    Inventors: Bin Cao, Daniel L. Hiebert, Brian R. Muras, Tanveer Zubair
  • MANAGING A MODIFICATION TO A CONSISTENT REGION OF A STREAM COMPUTING ENVIRONMENT
    Publication number: 20170344600
    Abstract: Disclosed aspects relate to managing a stream computing environment. The stream computing environment may have a consistent region that includes a set of stream operators for processing a stream of tuples. An operator modification request with respect to the set of stream operators of the consistent region of the stream computing environment may be received. In response to receiving the operator modification request, a set of tuples of the stream of tuples may be detected in the consistent region. Using the operator modification request, a tuple adjustment action for the set of tuples of the stream of tuples in the consistent region may be determined. Based on the operator modification request, the set of stream operators may be modified. The set of tuples may be processed using the tuple adjustment action.
    Type: Application
    Filed: May 31, 2016
    Publication date: November 30, 2017
    Inventors: Jessica R. Eidem, Brian R. Muras, Jingdong Sun
  • DETECTING MALICIOUS DATA ACCESS IN A DISTRIBUTED ENVIRONMENT
    Publication number: 20170339150
    Abstract: Systems, methods, and computer program products to perform an operation comprising identifying a first access to a first subset of a first database table on a first storage node, of a plurality of storage nodes, identifying a second access to a second subset of the first database table on a second storage node, of the plurality of storage nodes, and performing a predefined operation to restrict access to the first database table on the plurality of storage nodes based on the first and second accesses.
    Type: Application
    Filed: May 20, 2016
    Publication date: November 23, 2017
    Inventors: Eric L. BARSNESS, Daniel E. Beuch, Brian R. Muras, John M. Santosuosso
  • SMART TUPLE CLASS GENERATION FOR MERGED SMART TUPLES
    Publication number: 20170300299
    Abstract: A smart tuple manager includes a mechanism for merging a smart tuple, and for automatically generating one or more classes from existing classes when a smart tuple is merged. When a first smart tuple and a second smart tuple are merged into a new third smart tuple, a class for the third smart tuple is automatically generated from the classes for the first and second smart tuples. The class for the third smart tuple is a superset of the classes for the first and second smart tuples. After a class is automatically generated, new code segments may be added to the class as needed.
    Type: Application
    Filed: April 15, 2016
    Publication date: October 19, 2017
    Inventors: Bin Cao, Jessica R. Eidem, Brian R. Muras, Jingdong Sun
  • SMART TUPLE CLASS GENERATION FOR SPLIT SMART TUPLES
    Publication number: 20170300300
    Abstract: A smart tuple manager includes a mechanism for splitting a smart tuple, and for automatically generating one or more classes from existing classes when a smart tuple is split. When a first smart tuple is split into second and third new smart tuples, classes for the second and third smart tuples are automatically generated from the class for the first smart tuple. The classes for the second and third smart tuples are subsets of the data elements and code segments in the first class. After a class is automatically generated, new code segments may be added to the class as needed.
    Type: Application
    Filed: April 15, 2016
    Publication date: October 19, 2017
    Inventors: Bin Cao, Jessica R. Eidem, Brian R. Muras, Jingdong Sun
  • DEFERRED JOINING OF A STREAM OF TUPLES
    Publication number: 20170293654
    Abstract: Disclosed aspects relate to deferred joining of a stream of tuples. The stream of tuples which is to be processed by a plurality of stream operators is received. The stream of tuples may include both a first set of tuples from a first source and a second set of tuples from a second source. For future utilization with respect to a join operation which indicates to join the first and second sets of tuples, a determination is made to establish a group of tuples. A first stream operator of the plurality of stream operators establishes the group of tuples. The group of tuples has both a first subgroup and a second subgroup. A set of stream operators of the plurality of stream operators processes the group of tuples. In response to processing the group of tuples, the join operation is performed.
    Type: Application
    Filed: April 12, 2016
    Publication date: October 12, 2017
    Inventors: Bin Cao, Jessica R. Eidem, Brian R. Muras, Jingdong Sun
  • Intelligently utilizing non-matching weighted indexes
    Patent number: 9753975
    Abstract: System, method, and computer program product to intelligently utilize non-matching weighted objects, by determining that a sort sequence of a query does not match a sort sequence of a shared weight object of a database, modifying the query based on the sort sequence of the query, and executing the modified query to obtain a result set, wherein the result set does not include a set of rows that would have been returned using the shared weight object to process the unmodified query.
    Type: Grant
    Filed: July 12, 2013
    Date of Patent: September 5, 2017
    Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATION
    Inventors: Roger A. Mittelstadt, Brian R. Muras