公开(公告)号：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.

公开(公告)号：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.