Multidimensional repositories for problem discovery and capacity planning of database applications
First Claim
Patent Images
1. A computer implemented method, comprising the steps of:
- sampling operational characteristics of a component to obtain data reflecting performance of the component;
storing the data into a storage according to an organization including at least a time dimension and a component dimension;
wherein the time dimension is a list of time intervals that comprises first time intervals that correspond to a coarser level of granularity and second time intervals that correspond to a finer level of granularity, wherein the first time intervals correspond to longer time periods than the second time intervals;
wherein each time interval of the first time intervals corresponds to a plurality of the second time intervals;
wherein all of the second time intervals have a same fixed length;
wherein the time dimension is a hierarchical dimension in which the first time intervals and the second time intervals have a hierarchical relationship with respect to each other;
wherein the component dimension is a list of values that comprises first values that correspond to a coarser level of component granularity and second values that correspond to a finer level of component granularity, wherein the first values correspond to first component elements that include second component elements corresponding to the second values;
wherein each value of the first values corresponds to a plurality of the second values;
wherein the component dimension is a hierarchical dimension in which the first values and the second values have a hierarchical relationship with respect to each other; and
performing an operation on the data in the storage, wherein the operation is one of a drill down operation that involves transforming the data at the coarser level of granularity to the data at the finer level of granularity, or a rollup operation that involves transforming the data at the finer level of granularity to the data at the coarser level of granularity;
wherein performing the operation on the data in the storage further comprises performing one of a drill down operation that involves transforming the data at the coarser level of component granularity to the data at the finer level of component granularity, or a rollup operation that involves transforming the data at the finer level of component granularity to the data at the coarser level of component granularity;
wherein the steps of the method are performed by one or more computing devices.
0 Assignments
0 Petitions
Accused Products
Abstract
A distributed decision support system is described for use in the area of problem discovery and capacity planning for database applications. The use of data navigation, particularly drill down, roll up, and pivot for application management tasks are described. The system presents data collected from components of an application server system by various cartridges to users in a way that facilitates the identification of problems in the application server system and provides for an efficient way to do capacity planning of such systems.
-
Citations
32 Claims
-
1. A computer implemented method, comprising the steps of:
-
sampling operational characteristics of a component to obtain data reflecting performance of the component; storing the data into a storage according to an organization including at least a time dimension and a component dimension; wherein the time dimension is a list of time intervals that comprises first time intervals that correspond to a coarser level of granularity and second time intervals that correspond to a finer level of granularity, wherein the first time intervals correspond to longer time periods than the second time intervals; wherein each time interval of the first time intervals corresponds to a plurality of the second time intervals; wherein all of the second time intervals have a same fixed length; wherein the time dimension is a hierarchical dimension in which the first time intervals and the second time intervals have a hierarchical relationship with respect to each other; wherein the component dimension is a list of values that comprises first values that correspond to a coarser level of component granularity and second values that correspond to a finer level of component granularity, wherein the first values correspond to first component elements that include second component elements corresponding to the second values; wherein each value of the first values corresponds to a plurality of the second values; wherein the component dimension is a hierarchical dimension in which the first values and the second values have a hierarchical relationship with respect to each other; and performing an operation on the data in the storage, wherein the operation is one of a drill down operation that involves transforming the data at the coarser level of granularity to the data at the finer level of granularity, or a rollup operation that involves transforming the data at the finer level of granularity to the data at the coarser level of granularity; wherein performing the operation on the data in the storage further comprises performing one of a drill down operation that involves transforming the data at the coarser level of component granularity to the data at the finer level of component granularity, or a rollup operation that involves transforming the data at the finer level of component granularity to the data at the coarser level of component granularity; wherein the steps of the method are performed by one or more computing devices. - View Dependent Claims (2, 3, 4, 5, 6, 21, 22, 23, 24)
-
-
7. A computer readable storage medium storing one or more sequences of instructions which instructions, when executed by one or more processors, cause the one or more processors to carry out the steps of:
-
sampling operational characteristics of a component to obtain data reflecting performance of the component; storing the data into a storage according to an organization including at least a time dimension and a component dimension; wherein the time dimension is a list of time intervals that comprises first time intervals that correspond to a coarser level of granularity and second time intervals that correspond to a finer level of granularity, wherein the first time intervals correspond to longer time periods than the second time intervals; wherein each time interval of the first time intervals corresponds to a plurality of the second time intervals; wherein all of the second time intervals have a same fixed length; wherein the time dimension is a hierarchical dimension in which the first time intervals and the second time intervals have a hierarchical relationship with respect to each other; wherein the component dimension is a list of values that comprises first values that correspond to a coarser level of component granularity and second values that correspond to a finer level of component granularity, wherein the first values correspond to first component elements that include second component elements corresponding to the second values; wherein each value of the first values corresponds to a plurality of the second values; wherein the component dimension is a hierarchical dimension in which the first values and the second values have a hierarchical relationship with respect to each other; and performing an operation on the data in the storage, wherein the operation is one of a drill down operation that involves transforming the data at the coarser level of granularity to the data at the finer level of granularity, or a rollup operation that involves transforming the data at the finer level of granularity to the data at the coarser level of granularity; wherein performing the operation on the data in the storage further comprises performing one of a drill down operation that involves transforming the data at the coarser level of component granularity to the data at the finer level of component granularity, or a rollup operation that involves transforming the data at the finer level of component granularity to the data at the coarser level of component granularity. - View Dependent Claims (8, 9, 10, 11, 12, 25, 26, 27, 28)
-
-
13. An apparatus comprising:
-
a processor; a memory, connected to the processor by a bus; and one or more stored sequences of instructions which, when executed by the processor, cause the processor to carry out the steps of; sampling operational characteristics of a component to obtain data reflecting performance of the component; storing the data into a storage according to an organization including at least a time dimension and a component dimension; wherein the time dimension is a list of time intervals that comprises first time intervals that correspond to a coarser level of granularity and second time intervals that correspond to a finer level of granularity, wherein the first time intervals correspond to longer time periods than the second time intervals; wherein each time interval of the first time intervals corresponds to a plurality of the second time intervals; wherein all of the second time intervals have a same fixed length; wherein the time dimension is a hierarchical dimension in which the first time intervals and the second time intervals have a hierarchical relationship with respect to each other; wherein the component dimension is a list of values that comprises first values that correspond to a coarser level of component granularity and second values that correspond to a finer level of component granularity, wherein the first values correspond to first component elements that include second component elements corresponding to the second values; wherein each value of the first values corresponds to a plurality of the second values; wherein the component dimension is a hierarchical dimension in which the first values and the second values have a hierarchical relationship with respect to each other; and performing an operation on the data in the storage, wherein the operation is one of a drill down operation that involves transforming the data at the coarser level of granularity to the data at the finer level of granularity, or a rollup operation that involves transforming the data at the finer level of granularity to the data at the coarser level of granularity; wherein performing the operation on the data in the storage further comprises performing one of a drill down operation that involves transforming the data at the coarser level of component granularity to the data at the finer level of component granularity, or a rollup operation that involves transforming the data at the finer level of component granularity to the data at the coarser level of component granularity. - View Dependent Claims (14, 15, 16, 17, 18, 29, 30, 31, 32)
-
-
19. An apparatus, comprising:
-
a mechanism for sampling operational characteristics of a component hosting at least one application to obtain data reflecting performance of the component; a mechanism for storing the data into a storage according to an organization including at least a time dimension and a component dimension; wherein the time dimension is a list of time intervals that comprises first time intervals that correspond to a coarser level of granularity and second time intervals that correspond to a finer level of granularity, wherein the first time intervals correspond to longer time periods than the second time intervals; wherein each time interval of the first time intervals corresponds to a plurality of the second time intervals; wherein all of the second time intervals have a same fixed length; wherein the time dimension is a hierarchical dimension in which the first time intervals and the second time intervals have a hierarchical relationship with respect to each other; wherein the component dimension is a list of values that comprises first values that correspond to a coarser level of component granularity and second values that correspond to a finer level of component granularity, wherein the first values correspond to first component elements that include second component elements corresponding to the second values; wherein each value of the first values corresponds to a plurality of the second values; wherein the component dimension is a hierarchical dimension in which the first values and the second values have a hierarchical relationship with respect to each other; and a mechanism for performing an operation on the data in the storage, wherein the operation is one of a drill down operation that involves transforming the data at the coarser level of granularity to the data at the finer level of granularity, or a rollup operation that involves transforming the data at the finer level of granularity to the data at the coarser level of granularity; wherein the mechanism for performing the operation on the data in the storage further comprises a mechanism for performing one of a drill down operation that involves transforming the data at the coarser level of component granularity to the data at the finer level of component granularity, or a rollup operation that involves transforming the data at the finer level of component granularity to the data at the coarser level of component granularity.
-
-
20. A system, comprising:
-
an application server system that includes a set of application server components that host at least one application; data collection components operatively coupled to the set of application server components, wherein the data collection components sample operational characteristics of an application server component to obtain data reflecting performance of the component, and wherein the performance data includes at least one measure that reflects performance of the application server component; data storage components for storing the data according to an organization including at least a time dimension and a component dimension; wherein the time dimension is a list of time intervals that comprises first time intervals that correspond to a coarser level of granularity and second time intervals that correspond to a finer level of granularity, wherein the first time intervals correspond to longer time periods than the second time intervals; wherein each time interval of the first time intervals corresponds to a plurality of the second time intervals; wherein all of the second time intervals have a same fixed length; wherein the time dimension is a hierarchical dimension in which the first time intervals and the second time intervals have a hierarchical relationship with respect to each other; wherein the component dimension is a list of values that comprises first values that correspond to a coarser level of component granularity and second values that correspond to a finer level of component granularity, wherein the first values correspond to first component elements that include second component elements corresponding to the second values; wherein each value of the first values corresponds to a plurality of the second values; wherein the component dimension is a hierarchical dimension in which the first values and the second values have a hierarchical relationship with respect to each other; and data access components operatively coupled to the data storage components for retrieving the data and performing an operation on the data in the storage, wherein the operation is one of a drill down operation that involves transforming the data at the coarser level of granularity to the data at the finer level of granularity, or a rollup operation that involves transforming the data at the finer level of granularity to the data at the coarser level of granularity; wherein performing the operation on the data in the storage further comprises performing one of a drill down operation that involves transforming the data at the coarser level of component granularity to the data at the finer level of component granularity, or a rollup operation that involves transforming the data at the finer level of component granularity to the data at the coarser level of component granularity.
-
Specification