Patents by Inventor Ganesh MAGANTI

Ganesh MAGANTI 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: 11995061
    Abstract: Mapping of database partitions to available nodes. Metric information related to the partitions of the database are stored. One or more metrics associated with the partitions are gathered. A plurality of potential mappings of partitions to nodes are evaluated. One of the potential mappings of partitions to nodes to result in improved metric distribution among the nodes and the partition moves are within a pre-selected move constraint is selected. The selected potential mapping is implemented by moving one or more partitions between one or more nodes.
    Type: Grant
    Filed: September 8, 2021
    Date of Patent: May 28, 2024
    Assignee: Salesforce, Inc.
    Inventors: Robert Weber, Prateek Mathur, Pratheesh Ezhapilly Chennen, Sachin Mody, Ganesh Maganti
  • Patent number: 11436223
    Abstract: Systems, methods, and computer-readable media for pinning query execution plans are described. A database system may obtain a query, and determine a organization identifier and/or user identifier associated with the query. The database system may identify an optimized plan among a set of query plans that correspond with the query, and may generate a query execution plan based on the query and the optimized plan. The database system may determine a pinned plan that is associated with the optimized plan, and may generate a query execution plan based on the pinned plan when the pinned plan is associated with the optimized plan and corresponds with the organization identifier and/or the user identifier. The database system may generate a query execution plan using optimization functions when the pinned plan is not associated with the pinned plan, or the organization identifier and/or the user identifier. Other embodiments may be described and/or claimed.
    Type: Grant
    Filed: January 30, 2017
    Date of Patent: September 6, 2022
    Assignee: SALESFORCE, INC.
    Inventors: RamaLinga Raju Penmetsa, Prem Veeramani, Jeffrey Lallana Freschl, Jesse Collins, Ganesh Maganti
  • Publication number: 20210406242
    Abstract: Mapping of database partitions to available nodes. Metric information related to the partitions of the database are stored. One or more metrics associated with the partitions are gathered. A plurality of potential mappings of partitions to nodes are evaluated. One of the potential mappings of partitions to nodes to result in improved metric distribution among the nodes and the partition moves are within a pre-selected move constraint is selected. The selected potential mapping is implemented by moving one or more partitions between one or more nodes.
    Type: Application
    Filed: September 8, 2021
    Publication date: December 30, 2021
    Inventors: Robert Weber, Prateek Mathur, Pratheesh Ezhapilly Chennen, Sachin Mody, Ganesh Maganti
  • Patent number: 11126608
    Abstract: Mapping of database partitions to available nodes. Metric information related to the partitions of the database are stored. One or more metrics associated with the partitions are gathered. A plurality of potential mappings of partitions to nodes are evaluated. One of the potential mappings of partitions to nodes to result in improved metric distribution among the nodes and the partition moves are within a pre-selected move constraint is selected. The selected potential mapping is implemented by moving one or more partitions between one or more nodes.
    Type: Grant
    Filed: January 31, 2018
    Date of Patent: September 21, 2021
    Assignee: salesforce.com, inc.
    Inventors: Robert Weber, Prateek Mathur, Pratheesh Ezhapilly Chennen, Sachin Mody, Ganesh Maganti
  • Publication number: 20190236174
    Abstract: Mapping of database partitions to available nodes. Metric information related to the partitions of the database are stored. One or more metrics associated with the partitions are gathered. A plurality of potential mappings of partitions to nodes are evaluated. One of the potential mappings of partitions to nodes to result in improved metric distribution among the nodes and the partition moves are within a pre-selected move constraint is selected. The selected potential mapping is implemented by moving one or more partitions between one or more nodes.
    Type: Application
    Filed: January 31, 2018
    Publication date: August 1, 2019
    Inventors: Robert Weber, Prateek Mathur, Pratheesh Ezhapilly Chennen, Sachin Mody, Ganesh Maganti
  • Publication number: 20180218040
    Abstract: Systems, methods, and computer-readable media for pinning query execution plans are described. A database system may obtain a query, and determine a organization identifier and/or user identifier associated with the query. The database system may identify an optimized plan among a set of query plans that correspond with the query, and may generate a query execution plan based on the query and the optimized plan. The database system may determine a pinned plan that is associated with the optimized plan, and may generate a query execution plan based on the pinned plan when the pinned plan is associated with the optimized plan and corresponds with the organization identifier and/or the user identifier. The database system may generate a query execution plan using optimization functions when the pinned plan is not associated with the pinned plan, or the organization identifier and/or the user identifier. Other embodiments may be described and/or claimed.
    Type: Application
    Filed: January 30, 2017
    Publication date: August 2, 2018
    Applicant: salesforce.com, inc.
    Inventors: RamaLinga Raju PENMETSA, Prem VEERAMANI, Jeffrey Lallana FRESCHL, Jesse COLLINS, Ganesh MAGANTI