公开(公告)号：US10901991B2

公开(公告)日：2021-01-26

申请号：US15011277

申请日：2016-01-29

Applicant: salesforce.com, inc.

Inventor： Jesse Collins ,  Jaikumar Bathija ,  John F. O'Brien

IPC: G06F16/2453 ,  G06F16/2458

Abstract: Techniques and structures for tuning database queries. Actual statistics associated with data stored are retrieved from at least one memory device. The data is associated with one or more tenants of the multi-tenant database system. The actual statistics include at least one type of statistic maintained for the data. A subset of the actual statistics is selected based on a data trait targeted for optimization. A statistical value is calculated for each actual statistic from the subset of actual statistics across one or more tenants having the data trait targeted for optimization. An optimal query plan is determined based on the original query and the calculated statistical values.

公开(公告)号：US20210294802A1

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

申请号：US17157842

申请日：2021-01-25

Applicant: salesforce.com, inc.

Inventor： Jesse Collins ,  Jaikumar Bathija ,  John F. O'Brien

IPC: G06F16/2453

Abstract: Techniques and structures for tuning database queries. Actual statistics associated with data stored are retrieved from at least one memory device. The data is associated with one or more tenants of the multi-tenant database system. The actual statistics include at least one type of statistic maintained for the data. A subset of the actual statistics is selected based on a data trait targeted for optimization. A statistical value is calculated for each actual statistic from the subset of actual statistics across one or more tenants having the data trait targeted for optimization. An optimal query plan is determined based on the original query and the calculated statistical values.

公开(公告)号：US20160147835A1

公开(公告)日：2016-05-26

申请号：US15011277

申请日：2016-01-29

Applicant: salesforce.com, inc.

Inventor： Jesse Collins ,  Jaikumar Bathija ,  John F. O'Brien

IPC: G06F17/30

CPC classification number: G06F16/24542 ,  G06F16/2453 ,  G06F16/2462

Abstract: Techniques and structures for tuning database queries. Actual statistics associated with data stored are retrieved from at least one memory device. The data is associated with one or more tenants of the multi-tenant database system. The actual statistics include at least one type of statistic maintained for the data. A subset of the actual statistics is selected based on a data trait targeted for optimization. A statistical value is calculated for each actual statistic from the subset of actual statistics across one or more tenants having the data trait targeted for optimization. An optimal query plan is determined based on the original query and the calculated statistical values.

Abstract translation: 调整数据库查询的技术和结构。 从至少一个存储设备检索与存储的数据相关联的实际统计。 数据与多租户数据库系统的一个或多个租户相关联。 实际统计数据包括为数据维护的至少一种类型的统计信息。 基于针对优化的数据特征选择实际统计的子集。 针对具有针对优化的数据特征的一个或多个承租人从实际统计子集中的每个实际统计量计算统计值。 基于原始查询和计算的统计值确定最优查询计划。