×

Transforming timeseries and non-relational data to relational for complex and analytical query processing

  • US 9,529,875 B2
  • Filed: 01/13/2014
  • Issued: 12/27/2016
  • Est. Priority Date: 01/13/2014
  • Status: Expired due to Fees
First Claim
Patent Images

1. A method for transforming time series data into data that is accessible by a data warehouse, implemented by a computing processor, the method comprising:

  • identifying, by the computing processor, a time series database, wherein the time series database comprises a column representing data collected from at least one source, wherein the column contains at least one array for storing the collected data, wherein the at least one array in a row grows larger in the time series database as new data is collected instead of adding a new row as the new data is collected, wherein the collected data is time series data;

    creating, by the computing processor, a virtual view of the time series data table by transforming the collected data that is inaccessible by the data warehouse into time series data that is accessible by the data warehouse by representing the collected data from the time series database as at least one standard relational table in the virtual view, the virtual view presented as a virtual table, the virtual view stored the at least one standard relational table as an in-memory storage structure without any intermediate storage, wherein the time series data is not stored in the at least one standard relational table;

    grouping, by the computing processor, the time series data in the virtual view into a plurality of virtual partitions according to time intervals, wherein the time intervals are defined by a user, wherein each of the plurality of virtual partitions is across a data time range, wherein the data time range comprises at least one time interval, wherein each of the plurality of virtual partitions has a respective partition time range that spans the at least one time interval, the virtual partitions created to optimize loading of the collected new data into the data warehouse by incrementally refreshing the collected new data according to a respective partition time range associated with each of the plurality of virtual partitions, wherein the virtual partitions allow the time series data in the virtual view to be incrementally refreshed according to the at least one time interval whereas the time series data in the virtual view otherwise could not be incrementally refreshed; and

    displaying time series data that corresponds to a corresponding time interval by displaying a subset of the plurality of virtual partitions that span the corresponding time interval.

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