Methods and Systems for Calculating and Retrieving Analytic Data

摘要

A data management system for calculating and retrieving analytic data involves a computing device coupled to a database. The system includes a measure data structure within the database including a measure-data element, a collection data structure within the database including a collection-data element, and a fact data structure within the database, and configured to store a fact-data element which includes an aggregated value, a link to the measure-data element, and a link to the collection-data element. The system also includes 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. 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.

主权项

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, and a link to the collection-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; andstore the aggregated value and links to the measure-data element and the collection-data element in the fact-data element.