公开(公告)号：US10762085B2

公开(公告)日：2020-09-01

申请号：US15295256

申请日：2016-10-17

Applicant: salesforce.com, inc.

Inventor： Awais Tariq ,  Rohitashva Mathur ,  Arup Dutta ,  Prem Veeramani ,  Jesse Collins

IPC: G06F7/00 ,  G06F16/2453 ,  G06F16/21 ,  G06F16/22 ,  G06F16/2457 ,  G06F17/00

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.

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

公开(公告)号：US11232102B2

公开(公告)日：2022-01-25

申请号：US15295319

申请日：2016-10-17

Applicant: salesforce.com, inc.

Inventor： Awais Tariq ,  Rohitashva Mathur ,  Arup Dutta ,  Prem Veeramani ,  Jesse Collins

IPC: G06F16/2453 ,  G06F16/21

Abstract: A database query is received at a first time when a database is in a first state. The database query is analyzed to determine whether it has one or more characteristics that fall within a historical top range of database queries. If the database query falls within the historical top range of database queries the query is stored for later query tuning activity. The query is executed against the database in the first state. Query tuning recommendations are generated for stored database queries that fall within the historical top range of database queries. A subsequent request is received at a second time when a database is in a second state. The subsequent database query is executed with at least one of the query tuning recommendations against the database in the second state.

公开(公告)号：US10452630B2

公开(公告)日：2019-10-22

申请号：US15295305

申请日：2016-10-17

Applicant: salesforce.com, inc.

Inventor： Awais Tariq ,  Rohitashva Mathur ,  Arup Dutta ,  Prem Veeramani ,  Jesse Collins

IPC: G06F16/22 ,  G06F16/245 ,  G06F16/9535 ,  G06F16/2453

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.