×

Methods and systems for calculating and retrieving analytic data

  • US 9,940,385 B2
  • Filed: 09/29/2016
  • Issued: 04/10/2018
  • Est. Priority Date: 03/04/2013
  • Status: Active Grant
First Claim
Patent Images

1. A data management system for calculating and retrieving analytic data includes a computing device coupled to a database, 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 calendar data structure within the database comprising a calendar-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; and

    a fact-analyzer module configured to;

    calculate the aggregated value from the database based at least in part on the measure-data element, the collection-data element, and the calendar-data element, wherein the calendar-data element defines a time range for the calculation;

    store the aggregated value, wherein the fact-data element further includes a link to the calendar-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 and element, the collection-data element, and the calendar-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, collection data structure, and calendar 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 all claims
  • 1 Assignment
Timeline View
Assignment View
    ×
    ×