Techniques for providing application contextual information

Patent metadata

Field	Value
Publication number	US-10467117-B2
Application number	US-201715421354-A
Country	US
Kind code	B2
Filing date	Jan 31, 2017
Priority date	Jan 31, 2017
Publication date	Nov 5, 2019
Grant date	Nov 5, 2019

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. In an environment having at least one database and at least one application, a method comprising:
generating, with the 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 have at least one application context field;
sending, from the database to the application, a session identifier corresponding to a session to be monitored;
sending, from the application to the database, information to be stored in the database with the session identifier, wherein the information comprises at least time spent in one or more components of the environment for events corresponding to the database context identifiers;
correlating database logs and application logs using at least the session identifier, wherein the database logs and the application logs indicate time spent in the one or more components for events corresponding to the session identifier.

2. The method of claim 1 wherein the correlating the database logs and the application logs using at least session identifier comprises at least sending an application stack from the application to 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 diagnostic information from multiple levels within the environment.

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

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

7. A non-transitory computer-readable medium having stored thereon instructions that, when executed by one or more processors, cause the one or more processors, in an environment having at least one database and at least one application, to:
generate, with the 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 have at least one application context field;
send, from the database to the application, a session identifier corresponding to a session to be monitored;
send, from the application to the database, information to be stored in the database with the session identifier, wherein the information comprises at least time spent in one or more components of the environment for events corresponding to the database context identifiers;
correlate database logs and application logs using at least the session identifier, wherein the database logs and the application logs indicate time spent in the one or more components for events corresponding to the session identifier.

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

9. The non-transitory computer-readable medium of claim 8 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.

10. The non-transitory computer-readable medium of claim 8 wherein the application stack further includes encapsulated diagnostic information from multiple levels within the environment.

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

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

13. A system comprising:
a physical memory device;
one or more hardware processors coupled with the physical memory device, the one or more hardware processors configurable to generate, with the 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 have at least one application context field, to send, from the database to the application, a session identifier corresponding to a session to be monitored, to send, from the application to the database, information to be stored in the database with the session identifier, wherein the information comprises at least time spent in one or more components of the environment for events corresponding to the database context identifiers, to correlate database logs and application logs using at least the session identifier, wherein the database logs and the application logs indicate time spent in the one or more components for events corresponding to the session identifier.

14. The system of claim 13 wherein the correlating the database logs and the application logs using at least session identifier comprises at least sending an application stack from the application to the database.

15. The system of claim 14 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.

16. The system of claim 14 wherein the application stack further includes encapsulated diagnostic information from multiple levels within the environment.

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

18. The system of claim 13 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/302

  where the computing system component is a software system · CPC title

• G06F11/3075 Primary

  the data filtering being achieved in order to maintain consistency among the monitored data, e.g. ensuring that the monitored data belong to the same timeframe, to the same system or component · CPC title

• G06F11/0778

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

• G06F11/0784 Primary

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

• G06F11/3433

  for load management (allocation of a server based on load conditions G06F9/505; load rebalancing G06F9/5083; redistributing the load in a network by a load balancer H04L67/1029) · CPC title