Temporally-aware evaluative score
First Claim
Patent Images
1. A method of processing a performance query to a dimensionally-modeled fact collection by processing dimension coordinates that exist within a dimensional data model, wherein facts of the dimensionally-modeled fact collection are accessible according to the dimensional data model and wherein the dimension coordinates have a first particular grain (“
- finer grain”
) that is finer than a second particular grain (“
coarser grain”
), the method to determine an evaluative score for a particular value at the finer grain (“
finer grain value”
) based on performance facts for dimension coordinates associated with the particular finer grain value, the method comprising;
determining at least one performance parameter, relative to a particular value at the coarser grain (“
coarser grain value”
), against which to measure the performance facts associated with the finer grain value, including processing temporal relationships of finer grain values to coarser grain values for the dimension coordinates, wherein processing the temporal relationships of finer grain values to coarser grain values includes processing data indicative of how relationships of the finer grain values to coarser grain values change over time and, based thereon, processing performance facts based on performance facts for dimension coordinates having the particular coarser grain value;
determining the evaluative score for the particular finer grain value based on performance facts of dimension coordinates having the particular finer grain value, in view of the at least one determined performance parameter;
wherein processing the temporal relationships of finer grain values to coarser grain values includes performing one or both of unfettering and disambiguation to account for a changing relationship of grains so that the evaluative score is adjusted to provide a different type of evaluation score than a score based on a static relationship of grain values;
said disambiguation comprising remapping the correspondence of fine-grained entities to coarser-grained entities when required to remove an ambiguity in how a fine grained entity maps to a coarser grained entity; and
said unfettering comprising re-expressing the constraint in terms of finer-grained entities of dimension coordinates satisfying an original, coarser-grained constraint when required to account for a time changing relationship between finer grains and coarser grains.
3 Assignments
0 Petitions
Accused Products
Abstract
A method includes processing a performance query to a dimensional data model by processing dimension coordinates that exist within the dimensional data model, wherein the dimension coordinates have a first particular grain (“finer grain”) that is finer than a second particular grain (“coarser grain”), the method to determine an evaluative score for a particular finer grain value based on performance facts for dimension coordinates associated with the particular finer grain value. Performance parameters are determined relative to a particular coarser grain value, against which to measure the performance facts associated with the finer grain value, including processing the temporal relationships of finer grain values to coarser grain values for the dimension coordinates. The evaluative score is determined for the particular finer grain value based on performance facts of dimension coordinates having the particular finer grain value, in view of the determined performance parameters.
43 Citations
15 Claims
-
1. A method of processing a performance query to a dimensionally-modeled fact collection by processing dimension coordinates that exist within a dimensional data model, wherein facts of the dimensionally-modeled fact collection are accessible according to the dimensional data model and wherein the dimension coordinates have a first particular grain (“
- finer grain”
) that is finer than a second particular grain (“
coarser grain”
), the method to determine an evaluative score for a particular value at the finer grain (“
finer grain value”
) based on performance facts for dimension coordinates associated with the particular finer grain value, the method comprising;determining at least one performance parameter, relative to a particular value at the coarser grain (“
coarser grain value”
), against which to measure the performance facts associated with the finer grain value, including processing temporal relationships of finer grain values to coarser grain values for the dimension coordinates, wherein processing the temporal relationships of finer grain values to coarser grain values includes processing data indicative of how relationships of the finer grain values to coarser grain values change over time and, based thereon, processing performance facts based on performance facts for dimension coordinates having the particular coarser grain value;determining the evaluative score for the particular finer grain value based on performance facts of dimension coordinates having the particular finer grain value, in view of the at least one determined performance parameter; wherein processing the temporal relationships of finer grain values to coarser grain values includes performing one or both of unfettering and disambiguation to account for a changing relationship of grains so that the evaluative score is adjusted to provide a different type of evaluation score than a score based on a static relationship of grain values; said disambiguation comprising remapping the correspondence of fine-grained entities to coarser-grained entities when required to remove an ambiguity in how a fine grained entity maps to a coarser grained entity; and said unfettering comprising re-expressing the constraint in terms of finer-grained entities of dimension coordinates satisfying an original, coarser-grained constraint when required to account for a time changing relationship between finer grains and coarser grains. - View Dependent Claims (2, 3, 4, 5)
- finer grain”
-
6. A computer program product for processing a performance query to a dimensionally-modeled fact collection by processing dimension coordinates that exist within a dimensional data model, wherein facts of the dimensionally-modeled fact collection are accessible according to the dimensional data model and wherein the dimension coordinates have a first particular grain (“
- finer grain”
) that is finer than a second particular grain (“
coarser grain”
), the method to determine an evaluative score for a particular value at the finer grain (“
finer grain value”
) based on performance facts for dimension coordinates associated with the particular finer grain value, the computer program product comprising at least one computer-readable medium having computer program instructions stored therein which are operable to cause at least one computing device to;determine at least one performance parameter, relative to a particular value at the coarser grain (“
coarser grain value”
), against which to measure the performance facts associated with the finer grain value, including processing temporal relationships of finer grain values to coarser grain values for the dimension coordinates, wherein processing the temporal relationships of finer grain values to coarser grain values includes processing data indicative of how relationships of the finer grain values to coarser grain values change over time and, based thereon, processing performance facts based on performance facts for dimension coordinates having the particular coarser grain value; anddetermine the evaluative score for the particular finer grain value based on performance facts of dimension coordinates having the particular finer grain value, in view of the at least one determined performance parameter; wherein processing the temporal relationships of finer grain values to coarser grain values includes performing one or both of unfettering and disambiguation to account for a changing relationship of grains so that the evaluative score is adjusted to provide a different type of evaluation score than a score based on a static relationship of grain values; said disambiguation comprising remapping the correspondence of fine-grained entities to coarser-grained entities when required to remove an ambiguity in how a fine grained entity maps to a coarser grained entity; and said unfettering comprising re-expressing the constraint in terms of finer-grained entities of dimension coordinates satisfying an original, coarser-grained constraint when required to account for a time changing relationship between finer grains and coarser grains. - View Dependent Claims (7, 8, 9, 10)
- finer grain”
-
11. A computer system configured to process a performance query to a dimensionally-modeled fact collection by processing dimension coordinates that exist within a dimensional data model, wherein facts of the dimensionally-modeled fact collection are accessible according to the dimensional data model and wherein the dimension coordinates have a first particular grain (“
- finer grain”
) that is finer than a second particular grain (“
coarser grain”
), the method to determine an evaluative score for a particular value at the finer grain (“
finer grain value”
) based on performance facts for dimension coordinates associated with the particular finer grain value, the computer system configured to;determine performance parameters, relative to a particular coarser grain value, against which to measure the performance facts associated with the finer grain value, including processing the temporal relationships of finer grain values to coarser grain values for the dimension coordinates; and determine the evaluative score for the particular finer grain value based on performance facts of dimension coordinates having the particular finer grain value, in view of the determined performance parameters; wherein processing the temporal relationships of finer grain values to coarser grain values includes performing one or both of unfettering and disambiguation to account for a changing relationship of grains so that the evaluative score is adjusted to provide a different type of evaluation score than a score based on a static relationship of grain values; said disambiguation comprising remapping the correspondence of fine-grained entities to coarser-grained entities when required to remove an ambiguity in how a fine grained entity maps to a coarser grained entity; and said unfettering comprising re-expressing the constraint in terms of finer-grained entities of dimension coordinates satisfying an original, coarser-grained constraint when required to account for a time changing relationship between finer grains and coarser grains. - View Dependent Claims (12, 13, 14, 15)
- finer grain”
Specification
-
- Resources
Litigation Campaign Assessment
Thank you for your request. You will receive a custom alert email when the Litigation Campaign Assessment is available.
×
-
Current AssigneeNICE Systems Technologies Inc. (Nice Ltd)
-
Original AssigneeMerced Systems Incorporated (Nice Ltd)
-
InventorsDampier, Todd O.
-
Primary Examiner(s)Alam; Shahid A
-
Assistant Examiner(s)LAWSON, DONALD L
-
Application NumberUS11/860,275Publication NumberTime in Patent Office1,499 DaysField of Search707/723, 707/725US Class Current707/723CPC Class CodesG06F 16/24556 Aggregation; Duplicate elim...G06F 16/2477 Temporal data queriesG06F 16/283 Multi-dimensional databases...G06N 5/02 Knowledge representation; S...
