Systems and methods for applying an analytical model to performance analysis

Patent metadata

Field	Value
Publication number	US-9477692-B2
Application number	US-201313756154-A
Country	US
Kind code	B2
Filing date	Jan 31, 2013
Priority date	Oct 1, 2012
Publication date	Oct 25, 2016
Grant date	Oct 25, 2016

Abstract

Aspects of the present disclosure describe systems and methods for providing active session history data to users for use in database performance analysis. In various aspects, active session history data obtained from monitoring a database and/or database system over a period of time may be segmented into multiple dimensions. The segmented data may be subsequently provide and/or displayed on one or more interfaces, such as a graphical user interface, to users. The interface may visualize the dimensional ASH data in a variety of ways, such as through icons, graphs, charts, histograms, temporal delineations, treemaps, etc.

First claim

What is claimed is:

1. A method comprising:
capturing, using at least one processor, according to a pre-defined time period, a plurality of samples of active session data, each sample of the plurality of samples corresponding to a respective interval of time having a length of the pre-defined time-period, at least one sample of the plurality of samples identifying a respective set of sessions within a database that are active during the respective interval of time;
generating, using the at least one processor, a stored record for the at least one sample, the stored record for the at least one sample segmenting attributes of the respective set of sessions into a plurality of dimensions, the stored record for the at least one sample associating a first session in the respective set of sessions with a first dimension value for a first dimension of the plurality of dimensions and a second session in the respective set of sessions with a second dimension value for the first dimension of the plurality of dimensions;
receiving a selection of the first dimension of the plurality of dimensions: and
generating analytic data that characterizes the first dimension of the plurality of dimensions based, at least in part, on an occurrence of the first dimension value and the second dimension value in the stored record for the at least one sample.

2. The method of claim 1 , further comprising generating a user-interface including a first set of one or more selectable components for selecting at least one dimension of the plurality of dimensions and a second set of one or more selectable components for filtering aggregation results based on dimension values associated with the first dimension.

3. The method of claim 1 , wherein the first dimension value corresponds to a first sub-dimension of the first dimension and the second dimension value corresponds to a second sub-dimension of the first dimension.

4. The method of claim 1 , wherein the analytic data includes a graphical user-interface that includes one or more of a histogram or a treemap that compares different dimension values for the first dimension.

5. The method of claim 1 , wherein generating the analytic data that characterizes the first dimension based, at least in part, on an occurrence of the first dimension value and the second dimension value in the stored record for the at least one sample comprises:
performing a first aggregation based, at least in part, on how many samples within a target timeframe include the first dimension value;
performing a second aggregation based, at least in part, on how many sample within the target timeframe include the second dimension value;
generating, within a visualization for the first dimension, a first display region that corresponds to the first dimension value and has a first size based, at least in part, on the first aggregation; and
generating, within the visualization for the first dimension, a second display region that corresponds to the second dimension value and has a second size based, at least in part, no the second aggregation.

6. The method of claim 1 , wherein the stored record for the at least one sample associates the first session in the respective set of sessions with a third dimension value for a second dimension of the plurality of dimensions and the second session in the respective set of sessions with a fourth dimension value for the second dimension of the plurality of dimensions.

7. The method of claim 1 , wherein the analytic data compares how much database time or resources are consumed by active sessions having the first dimension value with how much database time or resources are consumed by active sessions having the second dimension value.

8. The method of claim 1 , further comprising storing a dimensional hierarchy for the plurality of dimensions, the dimensional hierarchy including a set of nodes and a set of edges; each node in the set of nodes corresponding to a respective dimension in the plurality of dimensions, each edge in the set of edges corresponding to a respective relationship between two dimensions in the dimensional hierarchy.

9. A system for providing information comprising:
a storage system;
at least one processor in operable communication with the storage system, the at least one processor to:
capture, according to a pre-defined time period, a plurality of samples of active session data, each sample of the plurality of samples corresponding to a respective interval of time having a length of the pre-defined time-period, at least one sample of the plurality of samples identifying a respective set of sessions within a database that are active during the respective interval of time;
generate a stored record for the at least one sample, the stored record for the at least one sample segmenting attributes of the respective set of sessions into a plurality of dimensions, the stored record for the at least one sample associating a first session in the respective set of sessions with a first dimension value for a first dimension of the plurality of dimensions and a second session in the respective set of sessions with a second dimension value for the first dimension of the plurality of dimensions;
receive a selection of the first dimension of the plurality of dimensions: and
generate analytic data that characterizes the first dimension of the plurality of dimensions based, at least in part, on an occurrence of the first dimension value and the second dimension value in the stored record for the at least one sample.

10. The system of claim 9 , wherein the at least one processor is further configured to generate a user-interface including a first set of one or more selectable components for selecting at least one dimension of the plurality of dimensions and a second set of one or more selectable components for filtering aggregation results based on dimension values associated with the first dimension.

11. The system of claim 9 , wherein the first dimension value corresponds to a first sub-dimension of the first dimension and the second dimension value corresponds to a second sub-dimension of the first dimension.

12. The system of claim 9 , wherein the analytic data includes a graphical user-interface that includes one or more of a histogram or a treemap that compares different dimension values for the first dimension.

13. A non-transitory computer readable medium storing instructions executable by a processor, the instructions comprising:
instructions which, when executed by one or more hardware processors, cause capturing, according to a pre-defined time period, a plurality of samples of active session data, each sample of the plurality of samples corresponding to a respective interval of time having a length of the pre-defined time-period, at least one sample of the plurality of samples identifying a respective set of sessions within a database that are active during the respective interval of time;
instructions which, when executed by one or more hardware processors, cause generating, using the at least one processor, a stored record for the at least one sample, the stored record for the at least one sample segmenting attributes of the respective set of sessions into a plurality of dimensions, the stored record for the at least one sample associating a first session in the respective set of sessions with a first dimension value for a first dimension of the plurality of dimensions and a second session in the respective set of sessions with a second dimension value for the first dimension of the plurality of dimensions
instructions which, when executed by one or more hardware processors, cause receiving a selection of the first d

Assignees

• Oracle Int Corp

Inventors

• Beresniewicz John
• Wexler Stephen
• Belknap Peter
• Su Hsiao-Te
• Kini Ameet

Classifications

• G06F2201/80

  Database-specific techniques · CPC title

• G06F16/21 Primary

  Design, administration or maintenance of databases · CPC title

• G06F16/217

  Database tuning (G06F16/2282 takes precedence; database performance monitoring G06F11/3409) · CPC title

• G06F11/321 Primary

  Display for diagnostics, e.g. diagnostic result display, self-test user interface · CPC title

• G06F17/30306

  Physics · mapped topic