Methods and systems for calculating and retrieving analytic data
First Claim
1. A data management system for calculating and retrieving analytic data includes a computing device coupled to a database including transaction data, the data management system comprising:
- a measure data structure within the database comprising a measure-data element;
a collection data structure within the database comprising a collection-data element;
a fact data structure within the database configured to store a fact-data element, wherein the fact-data element includes an aggregated value, a link to the measure-data element, a link to the collection-data element, a point of view collection identifier identifying a user requesting a calculation associated with each fact-data element, and a reporting collection identifier identifying a particular account associated with each fact-data element; and
a fact-analyzer module configured to;
generate the aggregated value from the transaction data utilizing at least the measure-data element and the collection-data element, wherein the measure-data element defines how the aggregated value is calculated and the collection-data element defines a categorization of the aggregated value;
identify a subject area filter identifying a scope of analysis;
filter the aggregated value based on the subject area filter and the collection data element;
store the aggregated value and links to the measure-data element and the collection-data element in the fact-data element;
receive, from a user, a request for the aggregated value after storing the fact-data element, wherein receiving a request for the aggregated value includes i) identifying the fact-data element using at least the measure-data element and the collection-data element and ii) using a database cross-table operation including a join operation and a decode operation, such that each of the fact data structure, measure data structure, and collection data structure are referenced during the request, and wherein a point of view filter is used during identification of the fact-data element to prevent retrieval of duplicate information and to assure that the aggregated value pertains to the user making the request;
identify the aggregated value from the fact data structure based at least in part on the request; and
output the aggregated value.
1 Assignment
0 Petitions
Accused Products
Abstract
A data management system for calculating and retrieving analytic data involves a computing device coupled to a database. The system includes a plurality of data structures such as database tables. The data structures include a measure data structure including a measure-data element, a collection data structure including a collection-data element, and a fact data structure configured to store a fact-data element including an aggregated value. The aggregated value refers to the result generated by a query computation performed on a transaction database. The system includes a fact-analyzer module configured to generate the aggregated value from the transaction data utilizing the measure-data element and the collection-data element, wherein the measure-data element defines how the aggregated value is calculated. The fact-analyzer module is also configured to store the aggregated value and links to the measure-data element and the collection-data element in the fact-data element.
27 Citations
20 Claims
-
1. A data management system for calculating and retrieving analytic data includes a computing device coupled to a database including transaction data, the data management system comprising:
-
a measure data structure within the database comprising a measure-data element; a collection data structure within the database comprising a collection-data element; a fact data structure within the database configured to store a fact-data element, wherein the fact-data element includes an aggregated value, a link to the measure-data element, a link to the collection-data element, a point of view collection identifier identifying a user requesting a calculation associated with each fact-data element, and a reporting collection identifier identifying a particular account associated with each fact-data element; and a fact-analyzer module configured to; generate the aggregated value from the transaction data utilizing at least the measure-data element and the collection-data element, wherein the measure-data element defines how the aggregated value is calculated and the collection-data element defines a categorization of the aggregated value; identify a subject area filter identifying a scope of analysis; filter the aggregated value based on the subject area filter and the collection data element; store the aggregated value and links to the measure-data element and the collection-data element in the fact-data element; receive, from a user, a request for the aggregated value after storing the fact-data element, wherein receiving a request for the aggregated value includes i) identifying the fact-data element using at least the measure-data element and the collection-data element and ii) using a database cross-table operation including a join operation and a decode operation, such that each of the fact data structure, measure data structure, and collection data structure are referenced during the request, and wherein a point of view filter is used during identification of the fact-data element to prevent retrieval of duplicate information and to assure that the aggregated value pertains to the user making the request; identify the aggregated value from the fact data structure based at least in part on the request; and output the aggregated value. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8)
-
-
9. A method of calculating and retrieving analytic data stored within a computing device in communication with a database, the method comprising the steps of:
-
storing a measure-data element in a measure data structure within the database; storing a collection-data element in a collection data structure within the database; calculating an aggregated value from the database based at least in part on the measure-data element and the collection-data element, wherein the measure-data element defines how the aggregated value is calculated and the collection-data element defines a categorization of the aggregated value; identifying a subject area filter identifying a scope of analysis; filtering the aggregated value based on the subject area filter and the collection data element; storing the aggregated value and links to the measure-data element and the collection-data element in a fact-data element of a fact data structure, wherein the fact-data element includes the aggregated value, a link to the measure-data element, a link to the collection-data element, a point of view collection identifier identifying a user requesting a calculation associated with each fact-data element, and a reporting collection identifier identifying a particular account associated with each fact-data element; receiving a request identifying the fact-data element from the fact data structure after storing the fact-data element, wherein receiving a request identifying the fact-data element comprises i) identifying the fact-data element using at least the measure-data element and the collection-data element and ii) using a database cross-table operation having a join operation and a decode operation, such that each of the fact data structure, measure data structure, and collection data structure are each referenced during the request, and wherein a point of view filter is used during identification of the fact-data element to prevent retrieval of duplicate information and to assure that the aggregated value pertains to the user making the request; and outputting the aggregated value from the fact-data element. - View Dependent Claims (10, 11, 12, 13, 14, 15, 16)
-
-
17. Computer-readable storage media having computer-executable instructions embodied thereon, wherein, when executed by at least one processor, the computer-executable instructions cause the processor to:
-
store a measure-data element in a measure data structure within a database; store a collection-data element in a collection data structure within the database; calculate an aggregated value from the database based at least in part on the measure-data element and the collection-data element, wherein the measure-data element defines how the aggregated value is calculated and the collection-data element defines a categorization of the aggregated value; identify a subject area filter identifying a scope of analysis; filter the aggregated value based on the subject area filter and the collection data element; and store the aggregated value and links to the measure-data element and the collection-data element in a fact-data element of a fact data structure, wherein the fact-data element includes the aggregated value, a link to the measure-data element, a link to the collection-data element, a point of view collection identifier identifying a user requesting a calculation associated with each fact-data element, and a reporting collection identifier identifying a particular account associated with each fact-data element; receive a request identifying the fact-data element from the fact data structure after storing the fact-data element, wherein receiving a request includes i) identifying the fact-data element using at least the measure-data element and the collection-data element and ii) using a database cross-table operation including a join operation and a decode operation, such that each of the fact data structure, measure data structure, and collection data structure are each referenced during the request, and wherein a point of view filter is used during identification of the fact-data element to prevent retrieval of duplicate information and to assure that the aggregated value pertains to the user making the request; and output the aggregated value from the fact-data element. - View Dependent Claims (18, 19, 20)
-
Specification