Pattern detection for tenant-specific performance data

Patent metadata

Field	Value
Publication number	US-11995140-B2
Application number	US-202217821429-A
Country	US
Kind code	B2
Filing date	Aug 22, 2022
Priority date	Sep 20, 2021
Publication date	May 28, 2024
Grant date	May 28, 2024

Abstract

Methods, systems, apparatuses, and computer program products are described. A database system may store data logs tracking performance data for multiple tenants of the database system. The database system may receive, via a user interface of a user device, a user input indicating a request to perform an analysis of performance data associated with one of the multiple tenants. The request may indicate a time period and a performance metric for the analysis. The database system may execute a query based on the analysis. The query may execute on a subset of the data logs associated with the tenant and the performance metric. The system may analyze a result of the query to determine one or more entities that affected the performance metric during the time period. The system may transmit an indication of the one or more entities for display at the user interface.

First claim

What is claimed is:

1. A method for data processing, comprising:
storing, within a database system, one or more data logs that include performance data associated with a plurality of tenants of the database system;
receiving, via a user interface of a user device, a user input indicating a request to perform an analysis of performance data associated with a tenant of the plurality of tenants, wherein the request indicates a time period and a performance metric for the analysis;
executing, by the database system, a query in response to the request, wherein the query is executed on a subset of the one or more data logs associated with the tenant and the performance metric;
analyzing, by the database system, a result of the query to determine one or more entities that affected the performance metric during the time period; and
transmitting, by the database system, an indication of the analysis for display on the user interface of the user device, the analysis comprising a tenant-specific visualization of changes to the performance metric during the time period, identifiers of the one or more entities affecting the performance metric during the time period, and a suggested action to remediate or improve the performance of the database system based on the performance metric.

2. The method of claim 1 , wherein executing the query comprises:
transmitting, to a service supported by the database system, instructions to execute the query on the subset of the one or more data logs, wherein the service is configured to execute queries for the tenant of the database system.

3. The method of claim 1 , further comprising:
transmitting, for display at the user interface of the user device, a subset of the performance data associated with the tenant, wherein the request to perform the analysis is received after displaying the subset of the performance data at the user interface of the user device.

4. The method of claim 3 , further comprising:
transmitting, for display at the user interface of the user device, an indication of a suggested analysis for the subset of the performance data, wherein the request to perform the analysis is received in response to displaying the indication of the suggested analysis.

5. The method of claim 1 , further comprising:
transmitting, for display at the user interface of the user device, an indication of a metric type associated with the performance metric, a timestamp associated with execution of the query, a start time of the analysis, an end time of the analysis, a completion status of the analysis, or a combination thereof.

6. The method of claim 1 , wherein transmitting the indication of the one or more entities comprises:
transmitting, for display at the user interface of the user device, an indication of one or more user identifiers, device identifiers, user actions, data objects, or data records that have affected the performance metric during the time period.

7. The method of claim 1 , wherein the performance metric comprises a processing time, a quantity of processing resources, a quantity of memory resources, an error type, or a combination thereof.

8. An apparatus for data processing, comprising:
at least one processor;
at least one memory coupled with the at least one processor; and
instructions stored in the at least one memory and executable by the at least one processor to cause the apparatus to:
store, within a database system, one or more data logs that include performance data associated with a plurality of tenants of the database system;
receive, via a user interface of a user device, a user input indicating a request to perform an analysis of performance data associated with a tenant of the plurality of tenants, wherein the request indicates a time period and a performance metric for the analysis;
execute, by the database system, a query in response to the request, wherein the query is executed on a subset of the one or more data logs associated with the tenant and the performance metric;
analyze, by the database system, a result of the query to determine one or more entities that affected the performance metric during the time period; and
transmit, by the database system, an indication of the analysis for display on the user interface of the user device, the analysis comprising a tenant-specific visualization of changes to the performance metric during the time period, identifiers of the one or more entities affecting the performance metric during the time period, and a suggested action to remediate or improve the performance of the database system based on the performance metric.

9. The apparatus of claim 8 , wherein to execute the query, the instructions are executable by the at least one processor to cause the apparatus to:
transmit, to a service supported by the database system, instructions to execute the query on the subset of the one or more data logs, wherein the service is configured to execute queries for the tenant of the database system.

10. The apparatus of claim 8 , wherein the instructions are further executable by the at least one processor to cause the apparatus to:
transmit, for display at the user interface of the user device, a subset of the performance data associated with the tenant, wherein the request to perform the analysis is received after displaying the subset of the performance data at the user interface of the user device.

11. The apparatus of claim 10 , wherein the instructions are further executable by the at least one processor to cause the apparatus to:
transmit, for display at the user interface of the user device, an indication of a suggested analysis for the subset of the performance data, wherein the request to perform the analysis is received in response to displaying the indication of the suggested analysis.

12. The apparatus of claim 8 , wherein the instructions are further executable by the at least one processor to cause the apparatus to:
transmit, for display at the user interface of the user device, an indication of a metric type associated with the performance metric, a timestamp associated with execution of the query, a start time of the analysis, an end time of the analysis, a completion status of the analysis, or a combination thereof.

13. The apparatus of claim 8 , wherein to transmit the indication of the one or more entities, the instructions are executable by the at least one processor to cause the apparatus to:
transmit, for display at the user interface of the user device, an indication of one or more user identifiers, device identifiers, user actions, data objects, or data records that have affected the performance metric during the time period.

14. The apparatus of claim 8 , wherein the performance metric comprises a processing time, a quantity of processing resources, a quantity of memory resources, an error type, or a combination thereof.

15. A non-transitory computer-readable medium storing code for data processing, the code comprising instructions executable by at least one processor to:
store, within a database system, one or more data logs that include performance data associated with a plurality of tenants of the database system;
receive, via a user interface of a user device, a user input indicating a request to perform an analysis of performance data associated with a tenant of the plurality of tenants, wherein the request indicates a time period and a performance metric for the analysis;
execute, by the database system, a query in response to the request, wherein the query is executed on a subset of the one or more data logs associated with the tenant and the performance metric;

Assignees

• Salesforce Inc

Inventors

• Viswanathan Vivek
• Hardikar Amol Suresh
• Lalwani Karishma Kishore
• Patel Alok K
• Herrick Jackson Zee
• Teyer Paymon

Classifications

• G06F16/9538 Primary

  Presentation of query results · CPC title

• G06F11/079

  Root cause analysis, i.e. error or fault diagnosis (in a hardware test environment G06F11/22; in a software test environment G06F11/36) · CPC title

• G06F11/323

  Visualisation of programs or trace data · CPC title

• G06F11/3409

  for performance assessment · CPC title

• G06Q10/10

  Office automation; Time management · CPC title