Re-categorization of aggregate data as detail data and automated re-categorization based on data usage context
First Claim
1. A computer-implemented method for processing at least one subset of data in a dataset, comprising:
- automatically determining whether a portion of aggregate data is to be re-categorized from detail data to aggregate data based on both a data usage context that indicates how the data is currently being used, processed or requested and the current scope of at lease one associated aggregation query;
based on the determination, re-categorizing at least one subset of data in the dataset from an aggregate data designation to a detail data designation stored on a computer readable storage medium by explicitly reclassifying the subset'"'"'s data designation from aggregate data to detail data, the detail data comprising base level database data, the aggregate data comprising a combination of one or more portions of detail data, the aggregate data designation being mutually exclusive to the detail data designation, the re-categorizing including automatically re-categorizing the at least one subset of data from the aggregate data designation to the detail data designation based on an analysis of the usage of the at least one subset of data in an operation performed on the dataset, the usage including a user'"'"'s usage of the at least one subset of data, wherein the analysis analyzes the user'"'"'s usage of the data subset to determine how the user used the data subset;
performing an aggregation query across the detail data, the query being configured to return only detail data, wherein the aggregate data that would have otherwise been excluded from the results of the aggregation query is included in the result of the aggregation query because the aggregate data'"'"'s classification was changed from aggregate to detail ; and
applying one or more aggregate calculation functions on top of at least a portion of pre-aggregated data, such that the pre-aggregated data is treated in the same way as detail data in the aggregate calculation functions.
2 Assignments
0 Petitions
Accused Products
Abstract
A data access system which includes the capability to categorize subsets of the data in the data store, query result or other source of data as aggregate data or as detail data and also the ability to explicitly re-categorize the aggregate data as detail data, e.g., as part of execution of one or more processes on the data, so that operations that apply to detail data also apply to the re-categorized aggregate data. Additionally, automatic processes are provided for re-categorizing aggregate data as detail data based on data usage context, i.e., based upon how data in the data store is to be manipulated, processed and/or presented according to queries, commands, etc. received by the data store. Calculation of aggregations on top of already pre-aggregated data is enabled, and merging of designated aggregate data with detail data provides increased flexibility in a final dataset.
-
Citations
20 Claims
-
1. A computer-implemented method for processing at least one subset of data in a dataset, comprising:
-
automatically determining whether a portion of aggregate data is to be re-categorized from detail data to aggregate data based on both a data usage context that indicates how the data is currently being used, processed or requested and the current scope of at lease one associated aggregation query; based on the determination, re-categorizing at least one subset of data in the dataset from an aggregate data designation to a detail data designation stored on a computer readable storage medium by explicitly reclassifying the subset'"'"'s data designation from aggregate data to detail data, the detail data comprising base level database data, the aggregate data comprising a combination of one or more portions of detail data, the aggregate data designation being mutually exclusive to the detail data designation, the re-categorizing including automatically re-categorizing the at least one subset of data from the aggregate data designation to the detail data designation based on an analysis of the usage of the at least one subset of data in an operation performed on the dataset, the usage including a user'"'"'s usage of the at least one subset of data, wherein the analysis analyzes the user'"'"'s usage of the data subset to determine how the user used the data subset; performing an aggregation query across the detail data, the query being configured to return only detail data, wherein the aggregate data that would have otherwise been excluded from the results of the aggregation query is included in the result of the aggregation query because the aggregate data'"'"'s classification was changed from aggregate to detail ; and applying one or more aggregate calculation functions on top of at least a portion of pre-aggregated data, such that the pre-aggregated data is treated in the same way as detail data in the aggregate calculation functions. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13)
-
-
14. A computerized method for analyzing a request for at least one operation to be performed on at least one subset of data of a dataset, comprising:
-
receiving a request for at least one operation to be performed on at least one field of the dataset stored on a computer readable storage medium; automatically determining whether a portion of aggregate data of the dataset is to be re-categorized from detail data to aggregate data based on both a data usage context that indicates how the data is currently being used, processed or requested and the current scope of at least one associated aggregation query; based on the determination, automatically re-classifying the at least one subset of data from aggregate type data to detail type data based on the analyzing and automatic detection based on usage of the at least one field, the detail data comprising base level database data, the aggregate data comprising a combination of one or more portions of detail data, the usage including a user'"'"'s usage of the at least one subset of data, wherein the analysis analyzes the user'"'"'s usage of the data subset to determine how the user used the data subset; performing an aggregation query across the detail data, the query being configured to return only detail data, wherein the aggregate data that would have otherwise been excluded from the results of the aggregation query is included in the result of the aggregation query because the aggregate data'"'"'s classification was changed from aggregate to detail ; and applying one or more aggregate calculation functions on top of at least a portion of pre-aggregated data, such that the pre-aggregated data is treated in the same way as detail data in the aggregate calculation functions. - View Dependent Claims (15, 16, 17, 18)
-
-
19. A computer readable storage medium comprising computer executable instructions for interfacing with a data store, comprising:
-
means for receiving a request for at least one operation to be performed on at least one field of at least one dataset of the data store; means for automatically determining whether a portion of aggregate data is to be re-categorized from detail data to aggregate data based on both a data usage context that indicates how the data is currently being used, processed or requested and the current scope of at lease one associated aggregation query; means for automatically re-categorizing the aggregate data in the at least one dataset from aggregate data to non-aggregate data based on the determination by explicitly reclassifying the subset'"'"'s data designation from aggregate data to detail data based on an output from the means for analyzing, the detail data comprising base level database data, the aggregate data comprising a combination of one or more portions of detail data, the usage including a user'"'"'s usage of the at least one subset of data, wherein the analysis analyzes the user'"'"'s usage of the data subset to determine how the user used the data subset; and means for performing an aggregation query across the detail data, the query being configured to return only detail data, wherein the aggregate data that would have otherwise been excluded from the results of the aggregation query is included in the result of the aggregation query because the aggregate data'"'"'s classification was changed from aggregate to detail ; and means for applying one or more aggregate calculation functions on top of at least a portion of pre-aggregated data, such that the pre-aggregated data is treated in the same way as detail data in the aggregate calculation functions. - View Dependent Claims (20)
-
Specification