Patents by Inventor Shantan Kethireddy
Shantan Kethireddy 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: 10956447Abstract: Technical solutions are described for determining data replication cost for a data server. In an example, a method for estimating the data replication cost includes receiving an identification of a source table and an identification of a target table for the data replication. The method further includes receiving a selection of a data replication scheme to be used to replicate the data. A costing system that implements the method determines the data replication cost, based on a conversion cost for conversion of the data from the source table to the target table, and a transfer cost for transfer of the data from the source table to the target table. The costing system communicates the data replication cost to an administrator.Type: GrantFiled: November 12, 2019Date of Patent: March 23, 2021Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: Jason K. Arnold, Henry E. Calzaretta, Shantan Kethireddy, Dylan S. Murphy
-
Publication number: 20200311079Abstract: A method, system and computer program product for providing workload isolation in a hybrid database system, by: performing a workload in a separate workload isolation system of the hybrid database system, wherein the separate workload isolation system manages data copied from one or more source systems of the hybrid database system and stored on one or more data hubs managed by the separate workload isolation system, and the workload enters the source systems and is re-routed from the source systems to the separate workload isolation system in order to isolate the source systems from the workload being performed by the separate workload isolation system using the data hubs.Type: ApplicationFiled: March 29, 2019Publication date: October 1, 2020Inventors: Shantan Kethireddy, Ruiping Li, Nogi Simanjuntak, Ying Zeng
-
Publication number: 20200081901Abstract: Technical solutions are described for determining data replication cost for a data server. In an example, a method for estimating the data replication cost includes receiving an identification of a source table and an identification of a target table for the data replication. The method further includes receiving a selection of a data replication scheme to be used to replicate the data. A costing system that implements the method determines the data replication cost, based on a conversion cost for conversion of the data from the source table to the target table, and a transfer cost for transfer of the data from the source table to the target table. The costing system communicates the data replication cost to an administrator.Type: ApplicationFiled: November 12, 2019Publication date: March 12, 2020Inventors: JASON K. ARNOLD, HENRY E. CALZARETTA, SHANTAN KETHIREDDY, DYLAN S. MURPHY
-
Patent number: 10565597Abstract: Aspects include obtaining a pattern that describes an event in a natural language format. The pattern that describes the event is converted into at least one identified pattern key value pair. A database transaction is monitored and converted into a least one database transaction key value pair. A similarity score is calculated by scoring similarities between the identified pattern key value pair(s) and the database transaction key value pair(s). Based on similarity score meeting a threshold, an alert is output to indicate that the database transaction matches the pattern that describes the event.Type: GrantFiled: June 15, 2017Date of Patent: February 18, 2020Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: Henry E. Calzaretta, Shantan Kethireddy, Brian R. Muras, Timothy P. Winkler
-
Patent number: 10552847Abstract: Aspects include obtaining a pattern that describes an event in a natural language format. The pattern that describes the event is converted into at least one identified pattern key value pair. A database transaction is monitored and converted into a least one database transaction key value pair. A similarity score is calculated by scoring similarities between the identified pattern key value pair(s) and the database transaction key value pair(s). Based on similarity score meeting a threshold, an alert is output to indicate that the database transaction matches the pattern that describes the event.Type: GrantFiled: March 23, 2017Date of Patent: February 4, 2020Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: Henry E. Calzaretta, Shantan Kethireddy, Brian R. Muras, Timothy P. Winkler
-
Patent number: 10552453Abstract: Technical solutions are described for determining data replication cost for a data server. In an example, a method for estimating the data replication cost includes receiving an identification of a source table and an identification of a target table for the data replication. The method further includes receiving a selection of a data replication scheme to be used to replicate the data. A costing system that implements the method determines the data replication cost, based on a conversion cost for conversion of the data from the source table to the target table, and a transfer cost for transfer of the data from the source table to the target table. The costing system communicates the data replication cost to an administrator.Type: GrantFiled: November 25, 2015Date of Patent: February 4, 2020Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: Jason K. Arnold, Henry E. Calzaretta, Shantan Kethireddy, Dylan S. Murphy
-
Patent number: 10423620Abstract: A central relational database management system (RDBMS) is operatively interconnected to one or more back-end database systems. A set of different query criteria specified for each of different types of queries for a mixed query workload is evaluated. At least one remote derived source of data requested by at least one of the different types of queries is dynamically created using at least one of the one or more back-end database systems that supports remote processing of the at least one of the different types of queries.Type: GrantFiled: April 22, 2017Date of Patent: September 24, 2019Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: Gary W. Crupi, Shantan Kethireddy, Ruiping Li, David R. Trotter
-
Patent number: 10397314Abstract: A system, method and program product for providing latency management for use with a database management system. A system is disclosed having: a system for capturing and storing a maximum latency (ML) whenever a derived source is created from a source data; a system for determining a difference between a last refresh timestamp of the source data and the last refresh timestamp of the derived source in response to a query; and a system for causing the source data to be used in response to the difference being greater than the ML, and for causing the derived source to be used in response to the difference being less than the ML.Type: GrantFiled: November 24, 2015Date of Patent: August 27, 2019Assignee: International Business Machines CorporationInventors: Jason K. Arnold, Henry E. Calzaretta, Gary W. Crupi, Shantan Kethireddy, Dylan S. Murphy
-
Publication number: 20180307728Abstract: A central relational database management system (RDBMS) is operatively interconnected to one or more back-end database systems. A set of different query criteria specified for each of different types of queries for a mixed query workload is evaluated. At least one remote derived source of data requested by at least one of the different types of queries is dynamically created using at least one of the one or more back-end database systems that supports remote processing of the at least one of the different types of queries.Type: ApplicationFiled: April 22, 2017Publication date: October 25, 2018Inventors: Gary W. Crupi, Shantan Kethireddy, Ruiping Li, David R. Trotter
-
Publication number: 20180276684Abstract: Aspects include obtaining a pattern that describes an event in a natural language format. The pattern that describes the event is converted into at least one identified pattern key value pair. A database transaction is monitored and converted into a least one database transaction key value pair. A similarity score is calculated by scoring similarities between the identified pattern key value pair(s) and the database transaction key value pair(s). Based on similarity score meeting a threshold, an alert is output to indicate that the database transaction matches the pattern that describes the event.Type: ApplicationFiled: June 15, 2017Publication date: September 27, 2018Inventors: Henry E. Calzaretta, Shantan Kethireddy, Brian R. Muras, Timothy P. Winkler
-
Publication number: 20180276683Abstract: Aspects include obtaining a pattern that describes an event in a natural language format. The pattern that describes the event is converted into at least one identified pattern key value pair. A database transaction is monitored and converted into a least one database transaction key value pair. A similarity score is calculated by scoring similarities between the identified pattern key value pair(s) and the database transaction key value pair(s). Based on similarity score meeting a threshold, an alert is output to indicate that the database transaction matches the pattern that describes the event.Type: ApplicationFiled: March 23, 2017Publication date: September 27, 2018Inventors: Henry E. Calzaretta, Shantan Kethireddy, Brian R. Muras, Timothy P. Winkler
-
Publication number: 20170147672Abstract: Technical solutions are described for determining data replication cost for a data server. In an example, a method for estimating the data replication cost includes receiving an identification of a source table and an identification of a target table for the data replication. The method further includes receiving a selection of a data replication scheme to be used to replicate the data. A costing system that implements the method determines the data replication cost, based on a conversion cost for conversion of the data from the source table to the target table, and a transfer cost for transfer of the data from the source table to the target table. The costing system communicates the data replication cost to an administrator.Type: ApplicationFiled: November 25, 2015Publication date: May 25, 2017Inventors: Jason K. Arnold, Henry E. Calzaretta, Shantan Kethireddy, Dylan S. Murphy
-
Publication number: 20170149870Abstract: A system, method and program product for providing latency management for use with a database management system. A system is disclosed having: a system for capturing and storing a maximum latency (ML) whenever a derived source is created from a source data; a system for determining a difference between a last refresh timestamp of the source data and the last refresh timestamp of the derived source in response to a query; and a system for causing the source data to be used in response to the difference being greater than the ML, and for causing the derived source to be used in response to the difference being less than the ML.Type: ApplicationFiled: November 24, 2015Publication date: May 25, 2017Inventors: Jason K. Arnold, Henry E. Calzaretta, Gary W. Crupi, Shantan Kethireddy, Dylan S. Murphy
-
Patent number: 9563538Abstract: Methods, systems, and products are provided for code path tracking. Embodiments include identifying an instrumented trace point in software code to be path tracked; identifying a function executed at the instrumented trace point in the software code; identifying parameters for the function executed at the instrumented trace point; and recording a description of the function, the parameters, and the result of the execution of the function using the parameters.Type: GrantFiled: April 10, 2012Date of Patent: February 7, 2017Assignee: International Business Machines CorporationInventors: Robert J. Bestgen, Robert D. Driesch, Jr., Wei Hu, Shantan Kethireddy, Edward J. Miller, Andrew P. Passe, Ulrich Thiemann
-
Patent number: 9411861Abstract: A method, apparatus and program product are provided for performing a query of a database. A database query is received, which includes first and second operations respectively configured to generate first and second disjoint results sets from a dataspace. The database query is analyzed to identify a set of attributes from the dataspace that are used by at least one of the first and second operations in the database query. During execution of the database query, a plurality of records from the dataspace is iteratively processed in a single pass, including, for each of the plurality of records, processing such record by retrieving the plurality of attributes for such record from the dataspace and performing each of the first and second operations on the record using the retrieved attributes for such record to build the first and second disjoint results sets.Type: GrantFiled: December 21, 2007Date of Patent: August 9, 2016Assignee: International Business Machines CorporationInventors: Robert Joseph Bestgen, David Glenn Carlson, Robert Victor Downer, Shantan Kethireddy
-
Patent number: 9189047Abstract: Embodiments of the invention provide techniques for optimizing database queries for energy efficiency. In general, a query optimizer is configured to compare energy requirements of query plans, and to select a query plan requiring minimal energy to execute. In one embodiment, the query optimizer may also compare time performance of the query plans, and may select a query plan by matching to a user preference for a relative priority between energy requirements and time performance.Type: GrantFiled: May 8, 2008Date of Patent: November 17, 2015Assignee: International Business Machines CorporationInventors: Robert J. Bestgen, Wei Hu, Shantan Kethireddy, Andrew P. Passe, Ulrich Thiemann
-
Patent number: 9063982Abstract: A query facility for database queries dynamically determines whether selective portions of a database table are likely to benefit from separate query execution strategies, and constructs an appropriate separate execution strategies accordingly. Preferably, the database contains at least one relatively large table comprising multiple partitions, each sharing the definitional structure of the table and containing a different respective discrete subset of the table records. The query facility compares metadata for different partitions to determine whether sufficiently large differences exist among the partitions, and in appropriate cases selects one or more partitions for separate execution strategies. Preferably, partitions are ranked for separate evaluation using a weighting formula which takes into account: (a) the number of indexes for the partition, (b) recency of change activity, and (c) the size of the partition.Type: GrantFiled: January 24, 2013Date of Patent: June 23, 2015Assignee: International Business Machines CorporationInventors: Robert Joseph Bestgen, Shantan Kethireddy, Jeffrey Wayne Tenner
-
Patent number: 9047135Abstract: A qualitative resource assignment wizard receives qualitative information for a logical partition (LPAR) and calculates computer resource assignments for the LPAR based on the qualitative information and a set of conversion functions. For example, the qualitative resource assignment wizard may calculate a processing unit assignment, a memory assignment, and an I/O slot assignment for the LPAR. The qualitative information may be input by a user, for example, utilizing a graphical user interface (GUI). In one embodiment, the conversion functions are calculated during a training phase, in which a user periodically provides qualitative information while resource usage data is gathered. The wizard may reside in a hardware management console (HMC) or other administrative console and/or may be a component of a hypervisor or other partition management code.Type: GrantFiled: January 22, 2010Date of Patent: June 2, 2015Assignee: International Business Machines CorporationInventors: Stephanie A. Foege, Andres Gonzalez, Jr., Shantan Kethireddy, Meryl Lo, Annita Tomko
-
Patent number: 8935231Abstract: A query optimizer optimizes a query to a partitioned database table by determining common characteristics of the partitions and generating a virtual maintained temporary index that spans multiple partitions. Using the virtual maintained temporary index allows the query optimizer to generate an access plan based on the virtual maintained temporary index, which relieves the optimizer from having to individually optimize access to each partition for partitions that share common characteristics.Type: GrantFiled: May 14, 2008Date of Patent: January 13, 2015Assignee: International Business Machines CorporationInventors: Robert Joseph Bestgen, Robert Victor Downer, Shantan Kethireddy
-
Patent number: 8452756Abstract: A database query optimizer includes an access plan storage mechanism that stores execution detail corresponding to a query statement in an access plan cache. By storing execution detail in the access plan cache along with the query statement, the execution detail is available when needed to debug database problems, even after a problem occurs. The execution detail stored in the access plan cache may be mined and analyzed after-the-fact, producing a very powerful tool for debugging database problems. Snapshots of the execution detail may also be created by a user. In addition, the user may setup autonomic snapshots and comparisons so that a user may be alerted from a degradation in database performance between two snapshots.Type: GrantFiled: November 9, 2006Date of Patent: May 28, 2013Assignee: International Business Machines CorporationInventors: Mark John Anderson, Robert Joseph Bestgen, Daniel E. Beuch, Curtis Neal Boger, James Michael Flanagan, Scott Forstie, Shantan Kethireddy, Thomas Owen McKinley, Michael Donald Pfeifer