Techniques for providing application contextual information

Patent metadata

Field	Value
Publication number	US-11023346-B2
Application number	US-201916673773-A
Country	US
Kind code	B2
Filing date	Nov 4, 2019
Priority date	Jan 31, 2017
Publication date	Jun 1, 2021
Grant date	Jun 1, 2021

Abstract

Techniques for providing application contextual information. One or more sets of database context identifiers corresponding to events that occur within the database are generated by the database. The one or more sets of database context identifiers have at least one application context field. A session identifier corresponding to a session to be monitored is sent from the application to the database. Information to be stored in the database with the session identifier is sent to the database. Database logs and application logs are correlated using at least the session identifier.

First claim

What is claimed is:

1. A method comprising:
generating, with a database, one or more sets of database context identifiers corresponding to events that occur within the database, wherein the one or more sets of database context identifiers encapsulate lower-level error details;
generating, with the database, a session universal unique identifier (UUID), the session UUID to be included in each request message for the corresponding session;
sending, from the database to an application, a session UUID corresponding to a session to be monitored;
receiving, from the application by the database, information to be stored in the database with the session UUID;
maintaining, with the database, a database log having information corresponding to transactions involving the database, wherein at least one session UUID is associated with each database transaction; and
correlating, with the database, context information in the database log and context information from at least one application log corresponding to the application using at least the session UUID and the database context identifiers.

2. The method of claim 1 wherein the correlating the database log and the application log using at least session UUID and the database context identifiers comprises further utilizing at least an application stack from the application by the database.

3. The method of claim 2 wherein the correlating database logs and application logs using at least session identifier further comprises at least sending a stack trace from the database to the application.

4. The method of claim 2 wherein the application stack further includes encapsulated time-spent information from multiple levels within the environment.

5. The method of claim 1 wherein the context identifiers provide context information to identify a logical positioning within the environment of a corresponding component.

6. A non-transitory, computer readable medium having stored thereon instructions that, when executed by one or more processors, are configurable to cause the one or more processors to:
generate, with the one or more processors, one or more sets of database context identifiers corresponding to events that occur within the database, wherein the one or more sets of database context identifiers encapsulate lower-level error details;
generate, with the one or more processors, a session universal unique identifier (UUID), the session UUID to be included in each request message for the corresponding session;
send, with the one or more processors to an application, a session UUID corresponding to a session to be monitored;
receive, with the one or more processors from the application, information to be stored in the database with the session UUID;
maintain, with the one or more processors, a database log having information corresponding to transactions involving the database, wherein at least one session UUID is associated with each database transaction; and
correlate, with the one or more processors, context information in the database log and context information from at least one application log corresponding to the application using at least the session UUID and the database context identifiers.

7. The non-transitory, computer readable medium of claim 6 wherein the correlating the database log and the application log using at least session UUID and the database context identifiers comprises further utilizing at least an application stack from the application by the database.

8. The non-transitory, computer readable medium of claim 7 wherein the correlating database logs and application logs using at least session identifier further comprises at least sending a stack trace from the database to the application.

9. The non-transitory, computer readable medium of claim 7 wherein the application stack further includes encapsulated time-spent information from multiple levels within the environment.

10. The non-transitory, computer readable medium of claim 6 wherein the context identifiers provide context information to identify a logical positioning within the environment of a corresponding component.

11. A system comprising:
a memory system;
one or more hardware processors coupled with the memory system, the one or more hardware processors configurable to generate one or more sets of database context identifiers corresponding to events that occur within the database, wherein the one or more sets of database context identifiers encapsulate lower-level error details, to generate a session universal unique identifier (UUID) to be included in each request message for the corresponding session, to send to an application, a session UUID corresponding to a session to be monitored, to receive from the application, information to be stored in the database with the session UUID, to maintain a database log having information corresponding to transactions involving the database, wherein at least one session UUID is associated with each database transaction, and to correlate context information in the database log and context information from at least one application log corresponding to the application using at least the session UUID and the database context identifiers.

12. The system of claim 11 wherein the correlating the database log and the application log using at least session UUID and the database context identifiers comprises further utilizing at least an application stack from the application by the database.

13. The system of claim 12 wherein the correlating database logs and application logs using at least session identifier further comprises at least sending a stack trace from the database to the application.

14. The system of claim 12 wherein the application stack further includes encapsulated time-spent information from multiple levels within the environment.

15. The system of claim 11 wherein the context identifiers provide context information to identify a logical positioning within the environment of a corresponding component.

Assignees

• Salesforce Com Inc

Inventors

• Wilding Mark

Classifications

• G06F11/0784 Primary

  Routing of error reports, e.g. with a specific transmission path or data flow · CPC title

• G06F11/3452

  Performance evaluation by statistical analysis · CPC title

• G06F11/0778

  Dumping, i.e. gathering error/state information after a fault for later diagnosis · CPC title

• G06F11/3476

  Data logging (G06F11/14, G06F11/2205 take precedence) · CPC title

• G06F2201/80

  Database-specific techniques · CPC title