Patents by Inventor Sowmya Kameswaran

Sowmya Kameswaran 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).

  • Publication number: 20240037115
    Abstract: Technology for routing queries in a system with a plurality of nodes (for example online analytical processing sub-systems) where each node has an associated replicated local database and a local latency value and replication velocity values. The workload balancing for incoming received queries among and between the plurality of nodes is based, at least in part, on consideration of latency values and/or replication velocity values for the various nodes. The best node to handle a given query is thereby selected and the query is routed to the selected node for response.
    Type: Application
    Filed: July 29, 2022
    Publication date: February 1, 2024
    Inventors: Manogari Nogi Simanjuntak, Sowmya KAMESWARAN, Daniel Martin, JIA HENG ZHONG
  • Patent number: 11886437
    Abstract: Methods, computer program products, and systems are presented.
    Type: Grant
    Filed: December 8, 2021
    Date of Patent: January 30, 2024
    Assignee: International Business Machines Corporation
    Inventors: Daniel Martin, Sowmya Kameswaran, Vassil Radkov Dimov, Christian Michel, Manogari Nogi Simanjuntak
  • Publication number: 20230177054
    Abstract: Methods, computer program products, and systems are presented.
    Type: Application
    Filed: December 8, 2021
    Publication date: June 8, 2023
    Inventors: Daniel MARTIN, Sowmya KAMESWARAN, Vassil Radkov DIMOV, Christian MICHEL, Manogari Nogi SIMANJUNTAK
  • Publication number: 20230086203
    Abstract: A method, computer program product, and system include a processor(s) obtaining a query request from an application via a source database management system to a target database management system, where the query request comprises a query and a query timestamp indicating a last update to table(s) in the source database management system referenced in the query request. The processor(s) determines a table update timestamp indicating a last time when the table(s) in the source database management system referenced in the query request was replicated to the target database management system. The processor(s) generates an indicator where the indicator represent a difference between the query timestamp and the table update timestamp. The processor(s) executes the query in the target database management system. The processor(s) transmit a query result and the indicator to the source database management system.
    Type: Application
    Filed: September 15, 2021
    Publication date: March 23, 2023
    Inventors: Daniel Martin, Jia Heng Zhong, Sowmya Kameswaran, Manogari Nogi Simanjuntak
  • Patent number: 11163792
    Abstract: A computer-implemented method, system, and non-transitory computer program product for work assignment for parallelized database synchronization. Data changes to a source database are identified from a change log for the source database. The data changes are batched into data change chunks of data changes. An estimated processing cost for processing of each of the data change chunks to apply the data changes in the data change chunks to a target database is determined. A priority queue in which the data change chunks are identified in order of estimated processing cost is generated. Each data change chunk identified in the priority queue is assigned to a processing thread in a plurality of processing threads for processing in order by estimated processing cost from higher estimated processing cost to lower estimated processing cost to apply the data changes in the data change chunks to the target database.
    Type: Grant
    Filed: May 29, 2019
    Date of Patent: November 2, 2021
    Assignee: International Business Machines Corporation
    Inventors: Jia Heng Zhong, Daniel Martin, Sowmya Kameswaran, Manogari Nogi Simanjuntak
  • Patent number: 11093477
    Abstract: A method, system, and program product for enabling multiple source database coherency is provided. The method includes detecting an incoming query to be executed with respect to an accelerator server. An initial timestamp of the incoming query is analyzed and additional timestamps of database tables referenced by the incoming query are retrieved. It is determined that each timestamp of the additional timestamps is reached with respect to a corresponding replication engine and target data from the database tables is synchronized with source data of a source database. In response, the incoming query is accelerated for execution with respect to a target database management system.
    Type: Grant
    Filed: March 17, 2020
    Date of Patent: August 17, 2021
    Assignee: International Business Machines Corporation
    Inventors: Daniel Martin, Jia Heng Zhong, Sowmya Kameswaran, Manogari Nogi Simanjuntak
  • Publication number: 20200380011
    Abstract: A computer-implemented method, system, and non-transitory computer program product for work assignment for parallelized database synchronization. Data changes to a source database are identified from a change log for the source database. The data changes are batched into data change chunks of data changes. An estimated processing cost for processing of each of the data change chunks to apply the data changes in the data change chunks to a target database is determined. A priority queue in which the data change chunks are identified in order of estimated processing cost is generated. Each data change chunk identified in the priority queue is assigned to a processing thread in a plurality of processing threads for processing in order by estimated processing cost from higher estimated processing cost to lower estimated processing cost to apply the data changes in the data change chunks to the target database.
    Type: Application
    Filed: May 29, 2019
    Publication date: December 3, 2020
    Inventors: Jia Heng Zhong, Daniel Martin, Sowmya Kameswaran, Manogari Nogi Simanjuntak
  • Patent number: 10691658
    Abstract: Loading a set of data into a target database management system (DBMS) from a source DBMS to increase workload performance and decrease resource usage is provided. Using a size and a change rate of tables eligible to be offloaded to the target DBMS, a total central processor unit (CPU) cost corresponding to loading the set of data into to the target DBMS and workload cost savings corresponding to executing one or more workloads on the target DBMS is determined based on a set of one or more load strategies. The total CPU cost is compared with the workload cost savings of each load strategy. An optimal load strategy is selected based on comparing the total CPU cost with the workload cost savings of each load strategy. The set of data is automatically loaded into to the target DBMS from the source DBMS in accordance with the selected optimal load strategy.
    Type: Grant
    Filed: May 9, 2018
    Date of Patent: June 23, 2020
    Assignee: International Business Machines Corporation
    Inventors: Sowmya Kameswaran, Peter Bendel
  • Publication number: 20190347342
    Abstract: Loading a set of data into a target database management system (DBMS) from a source DBMS to increase workload performance and decrease resource usage is provided. Using a size and a change rate of tables eligible to be offloaded to the target DBMS, a total central processor unit (CPU) cost corresponding to loading the set of data into to the target DBMS and workload cost savings corresponding to executing one or more workloads on the target DBMS is determined based on a set of one or more load strategies. The total CPU cost is compared with the workload cost savings of each load strategy. An optimal load strategy is selected based on comparing the total CPU cost with the workload cost savings of each load strategy. The set of data is automatically loaded into to the target DBMS from the source DBMS in accordance with the selected optimal load strategy.
    Type: Application
    Filed: May 9, 2018
    Publication date: November 14, 2019
    Inventors: Sowmya Kameswaran, Peter Bendel