公开(公告)号：US11436223B2

公开(公告)日：2022-09-06

申请号：US15419509

申请日：2017-01-30

Applicant: salesforce.com, inc.

Inventor： RamaLinga Raju Penmetsa ,  Prem Veeramani ,  Jeffrey Lallana Freschl ,  Jesse Collins ,  Ganesh Maganti

IPC: G06F16/2453

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.

公开(公告)号：US20210406242A1

公开(公告)日：2021-12-30

申请号：US17469739

申请日：2021-09-08

Applicant: salesforce.com, inc.

Inventor： Robert Weber ,  Prateek Mathur ,  Pratheesh Ezhapilly Chennen ,  Sachin Mody ,  Ganesh Maganti

IPC: G06F16/22 ,  G06F16/21

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.

公开(公告)号：US11126608B2

公开(公告)日：2021-09-21

申请号：US15885654

申请日：2018-01-31

Applicant: salesforce.com, inc.

Inventor： Robert Weber ,  Prateek Mathur ,  Pratheesh Ezhapilly Chennen ,  Sachin Mody ,  Ganesh Maganti

IPC: G06F16/22 ,  G06F16/21

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.

公开(公告)号：US20190236174A1

公开(公告)日：2019-08-01

申请号：US15885654

申请日：2018-01-31

Applicant: salesforce.com, inc.

Inventor： Robert Weber ,  Prateek Mathur ,  Pratheesh Ezhapilly Chennen ,  Sachin Mody ,  Ganesh Maganti

IPC: G06F17/30

CPC classification number: G06F16/2291 ,  G06F16/21

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.