Patents by Inventor Samar T. Desai
Samar T. Desai 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: 10747743Abstract: Upgrading a database while the database is accessible to applications. Specifically, the database upgrade is performed selectively as per demand from system catalog tables. With this on-demand technique, the upgrade of a database is run on a need basis to upgrade, over time, all the catalog objects.Type: GrantFiled: June 30, 2016Date of Patent: August 18, 2020Assignee: International Business Machines CorporationInventors: Samar T. Desai, Dattatreya Govindappanavar, Prashant N. Kapse
-
Patent number: 10592492Abstract: One or more processors receive operational data. The operational data includes two or more fields that contain an identical type of data as two or more fields within a master table. One or more processors generate a plurality of first unique identifiers from the two or more fields within the operational data and the master table. One or more processors determine a match between a pair of the plurality of first unique identifiers. The match is between a first unique identifier included in a operational data record and a first unique identifier included in a master table record. One or more processors determine a second unique identifier from the master table record. One or more processors generate an operational table record that includes the second unique identifier and at least a portion of the operational data.Type: GrantFiled: June 24, 2016Date of Patent: March 17, 2020Assignee: International Business Machines CorporationInventors: Vaibhav S. Dantale, Samar T. Desai
-
Patent number: 10459916Abstract: A method for updating a plurality of database statistics during a query execution is provided. The method may include receiving a compiled query. The method may also include determining if the received compiled query requires at least one table scan operation on a full table to resolve the received compiled query. The method may further include determining if a plurality of table statistics associated with the full table has not been updated within a pre-defined time-period, whereby the determining is based on the determination that the received compiled query requires at least one table scan operation on the full table to resolve the received compiled query. The method may additionally include collecting a plurality of statistics associated with the full table based on the determination that the plurality of table statistics associated with the full table has not been updated within the pre-defined time-period.Type: GrantFiled: July 31, 2015Date of Patent: October 29, 2019Assignee: International Business Machines CorporationInventors: Samar T. Desai, Dattatreya Govindappanavar, Mahadev Khapali, Mohan Narayanswamy
-
Patent number: 10089347Abstract: Upgrading a database while the database is accessible to applications. Specifically, the database upgrade is performed selectively as per demand from system catalog tables. With this on-demand technique, the upgrade of a database is run on a need basis to upgrade, over time, all the catalog objects.Type: GrantFiled: September 22, 2017Date of Patent: October 2, 2018Assignee: International Business Machines CorporationInventors: Samar T. Desai, Dattatreya Govindappanavar, Prashant N. Kapse
-
Publication number: 20180113910Abstract: A method includes receiving a database query, analyzing system and session level variables to provide one or more identified variables, wherein each of the one or more identified variables corresponds to a system level variable or session level variable, determining if an optimizer changes setting is enabled, wherein the optimizer changes setting dictates whether or not existing variable values will be adjusted, identifying a selected value corresponding to each identified variable according to a cost analysis responsive to determining the optimizer changes setting is enabled, setting each identified variable to the corresponding selected value, and executing the received database query according to the one or more identified values. A computer program product and computer system corresponding to the method are also disclosed.Type: ApplicationFiled: December 28, 2017Publication date: April 26, 2018Inventors: Samar T. Desai, Dattatreya Govindappanavar, Kapish Kumar
-
Publication number: 20180096033Abstract: A method includes receiving a database query, analyzing system and session level variables to provide one or more identified variables, wherein each of the one or more identified variables corresponds to a system level variable or session level variable, determining if an optimizer changes setting is enabled, wherein the optimizer changes setting dictates whether or not existing variable values will be adjusted, identifying a selected value corresponding to each identified variable according to a cost analysis responsive to determining the optimizer changes setting is enabled, setting each identified variable to the corresponding selected value, and executing the received database query according to the one or more identified values. A computer program product and computer system corresponding to the method are also disclosed.Type: ApplicationFiled: October 4, 2016Publication date: April 5, 2018Inventors: Samar T. Desai, Dattatreya Govindappanavar, Kapish Kumar
-
Publication number: 20180096034Abstract: A method includes receiving a database query, analyzing system and session level variables to provide one or more identified variables, wherein each of the one or more identified variables corresponds to a system level variable or session level variable, determining if an optimizer changes setting is enabled, wherein the optimizer changes setting dictates whether or not existing variable values will be adjusted, identifying a selected value corresponding to each identified variable according to a cost analysis responsive to determining the optimizer changes setting is enabled, setting each identified variable to the corresponding selected value, and executing the received database query according to the one or more identified values. A computer program product and computer system corresponding to the method are also disclosed.Type: ApplicationFiled: December 7, 2017Publication date: April 5, 2018Inventors: Samar T. Desai, Dattatreya Govindappanavar, Kapish Kumar
-
Publication number: 20180004792Abstract: Upgrading a database while the database is accessible to applications. Specifically, the database upgrade is performed selectively as per demand from system catalog tables. With this on-demand technique, the upgrade of a database is run on a need basis to upgrade, over time, all the catalog objects.Type: ApplicationFiled: June 30, 2016Publication date: January 4, 2018Inventors: Samar T. Desai, Dattatreya Govindappanavar, Prashant N. Kapse
-
Publication number: 20180004793Abstract: Upgrading a database while the database is accessible to applications. Specifically, the database upgrade is performed selectively as per demand from system catalog tables. With this on-demand technique, the upgrade of a database is run on a need basis to upgrade, over time, all the catalog objects.Type: ApplicationFiled: September 22, 2017Publication date: January 4, 2018Inventors: Samar T. Desai, Dattatreya Govindappanavar, Prashant N. Kapse
-
Publication number: 20170371908Abstract: One or more processors receive operational data. The operational data includes two or more fields that contain an identical type of data as two or more fields within a master table. One or more processors generate a plurality of first unique identifiers from the two or more fields within the operational data and the master table. One or more processors determine a match between a pair of the plurality of first unique identifiers. The match is between a first unique identifier included in a operational data record and a first unique identifier included in a master table record. One or more processors determine a second unique identifier from the master table record. One or more processors generate an operational table record that includes the second unique identifier and at least a portion of the operational data.Type: ApplicationFiled: June 24, 2016Publication date: December 28, 2017Inventors: Vaibhav S. Dantale, Samar T. Desai
-
Publication number: 20170371907Abstract: One or more processors receive operational data. The operational data includes two or more fields that contain an identical type of data as two or more fields within a master table. One or more processors generate a plurality of first unique identifiers from the two or more fields within the operational data and the master table. One or more processors determine a match between a pair of the plurality of first unique identifiers. The match is between a first unique identifier included in a operational data record and a first unique identifier included in a master table record. One or more processors determine a second unique identifier from the master table record. One or more processors generate an operational table record that includes the second unique identifier and at least a portion of the operational data.Type: ApplicationFiled: January 25, 2017Publication date: December 28, 2017Inventors: Vaibhav S. Dantale, Samar T. Desai
-
Publication number: 20170031987Abstract: A method for updating a plurality of database statistics during a query execution is provided. The method may include receiving a compiled query. The method may also include determining if the received compiled query requires at least one table scan operation on a full table to resolve the received compiled query. The method may further include determining if a plurality of table statistics associated with the full table has not been updated within a pre-defined time-period, whereby the determining is based on the determination that the received compiled query requires at least one table scan operation on the full table to resolve the received compiled query. The method may additionally include collecting a plurality of statistics associated with the full table based on the determination that the plurality of table statistics associated with the full table has not been updated within the pre-defined time-period.Type: ApplicationFiled: July 31, 2015Publication date: February 2, 2017Inventors: Samar T. Desai, Dattatreya Govindappanavar, Mahadev Khapali, Mohan Narayanswamy
-
Patent number: 9430530Abstract: A method for determining and providing aggregate functions is provided. The method may include scanning database tables. The method may further include determining the aggregate functions. Additionally, the method may include storing the determined aggregate functions on system catalog tables. The method may also include providing indications that the stored determined aggregate functions are valid. The method may further include receiving database queries. The method may also include, determining whether the stored determined aggregate functions are valid. The method may further include, in response to the stored determined aggregate functions being valid, retrieving the stored determined aggregate functions from the system catalog tables. The method may also include, in response to the stored determined aggregate functions being invalid, re-scanning the database tables. The method may further include determining the aggregate functions based on the re-scanned database tables.Type: GrantFiled: November 24, 2015Date of Patent: August 30, 2016Assignee: International Business Machines CorporationInventors: Samar T. Desai, Dattatreya Govindappanavar