公开(公告)号：US20170039128A1

公开(公告)日：2017-02-09

申请号：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.

Abstract translation: 测试系统注册了一系列测试，该测试引用了数据库系统中添加到应用程序中的不同软件增强功能。 测试系统可以实现测试引用的各种软件增强功能，然后通过应用程序运行日志行以生成测试结构化查询语言（SQL）。 数据库系统将测试SQL与应用程序生成的基准SQL进行比较，而不启用软件增强功能。 当测试SQL与基准SQL不同时，数据库系统执行测试SQL并捕获性能指标。 比较SQL结果可避免处理和捕获不受软件增强影响的日志行的性能指标。 通过一次启用的一个软件增强功能增加运行日志行也允许测试系统隔离单个软件增强对数据库系统的性能影响。

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