公开(公告)号：US20180107714A1

公开(公告)日：2018-04-19

申请号：US15295256

申请日：2016-10-17

Applicant: salesforce.com, inc.

Inventor： Awais Tariq ,  Rohitashva MATHUR ,  Arup DUTTA ,  Prem VEERAMANI ,  Jesse COLLINS

IPC: G06F17/30

CPC classification number: G06F16/24545 ,  G06F16/217 ,  G06F16/221 ,  G06F16/2228 ,  G06F16/24542 ,  G06F16/24544 ,  G06F16/24578

Abstract: Automated query tuning. A database query to be executed against a database is received. The database query is analyzed to determine one or more potential indexes to be evaluated. The one or more potential indexes are evaluated to determine if an optimization utilizing a selected potential index provides improved performance over performing the database query without the selected potential index. The one or more potential indexes are scored based on results of the evaluating. A recommendation of one or more of the potential indexes is provided to a source of the database query.

公开(公告)号：US20180218040A1

公开(公告)日：2018-08-02

申请号：US15419509

申请日：2017-01-30

Applicant: salesforce.com, inc.

Inventor： RamaLinga Raju PENMETSA ,  Prem VEERAMANI ,  Jeffrey Lallana FRESCHL ,  Jesse COLLINS ,  Ganesh MAGANTI

IPC: G06F17/30

CPC classification number: G06F16/24542 ,  G06F16/24547

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.

公开(公告)号：US20180107697A1

公开(公告)日：2018-04-19

申请号：US15295305

申请日：2016-10-17

Applicant: salesforce.com, inc.

Inventor： Awais TARIQ ,  Rohitashva MATHUR ,  Arup DUTTA ,  Prem VEERAMANI ,  Jesse COLLINS

IPC: G06F17/30

CPC classification number: G06F16/2228 ,  G06F16/245 ,  G06F16/24539 ,  G06F16/9535

Abstract: Reverse database query mapping. A database query to be executed on a computing platform against a database managed by the computing platform is received. Query mapping information is stored in a memory system accessible to the one or more processors. A source query corresponding to a query identifier is retrieved in response to statistical analysis. One or more potential indexes are generated for use with the source query, wherein at least one of the one or more potential indexes can function to improve performance of the source query.