×

Data access using aggregation

  • US 10,366,094 B2
  • Filed: 10/18/2016
  • Issued: 07/30/2019
  • Est. Priority Date: 10/18/2016
  • Status: Active Grant
First Claim
Patent Images

1. A computerized method for accessing information organized by time, the method comprising:

  • reading data from a write data structure in a database;

    aggregating, using one or more hardware processors, the data to generate a plurality of data buckets associated with a corresponding plurality of time windows, wherein a first data bucket of the plurality of data buckets corresponds to a first time window of the plurality of time windows, and a second data bucket of the plurality of data buckets corresponds to a second time window of the plurality of time windows, the second time window being shorter than the first time window;

    storing the plurality of data buckets in a read data structure in the database;

    receiving a time constraint associated with a data query to the database, the time constraint describing a time period;

    selecting the first data bucket for responding to the data query, wherein selecting the first data bucket comprises;

    determining that at least a portion of the first data bucket satisfies the data query; and

    determining that the first time window is a longest time window of the plurality of time windows that is within the time period;

    selecting the second data bucket for responding to the data query, wherein selecting the second data bucket comprises;

    determining that at least a portion of the second data bucket satisfies the data query; and

    determining that the second time window is within the time period, wherein the second time window and the first time window do not overlap; and

    providing a query response to the data query, the query response comprising at least a portion of the first data bucket and at least a portion of the second data bucket.

View all claims
  • 1 Assignment
Timeline View
Assignment View
    ×
    ×