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

公开(公告)号：US09811444B2

公开(公告)日：2017-11-07

申请号：US14817550

申请日：2015-08-04

Applicant: salesforce.com, inc.

Inventor： Jeffrey Lallana Freschl ,  Kiran Hariharan Nair

IPC: G06F11/36 ,  G06F17/30

CPC classification number: G06F11/3668 ,  G06F11/3409 ,  G06F11/3664 ,  G06F17/30306 ,  G06F17/30557

Abstract: A test system registers a series of tests that reference different software enhancements added to an application within a database system. The test system enables individual software enhancements referenced by the tests and then runs log lines through the application to produce test structured query language (SQL). The database system compares the test SQL with baseline SQL produced by the application without enabling the software enhancements. The database system executes the test SQL and captures performance metrics when the test SQL is different from the baseline SQL. Comparing SQL results avoids processing and capturing performance metrics for log lines not affected by the software enhancements. Incrementally running the log lines with one software enhancement enabled at a time also allows the test system to isolate the performance impact of individual software enhancements on the database system.