Time series database processing system

Abstract

Systems and methods are provided for improved time series databases and time series operations. A time series service responds to requests from external devices. The external devices request time series data and submit time series queries. The time series service generates planned and efficient time series queries from the initial queries. The time series service performs operations such as unit conversion, interpolation, and performing operations on time series data. The time series service can identify which time series database to query from and/or cause data to be populated into a time series database from a data pipeline system.

1 . (canceled) 
     
     
         2 . A computing system comprising:
 a non-transitory computer storage medium configured to store metadata associated with time series; and   one or more hardware computer processors programmed, via executable code instructions, to cause the computing system to:
 receive a time series expression to be applied to a first time series and a second time series; 
 determine a first time unit associated with the first time series; 
 determine a second time unit associated with the second time series, wherein the first time unit is different from the second time unit; 
 determine a first interpolation operation to apply to at least a first portion of the first time series; 
 apply the first interpolation operation to the first portion of the first time series to generate an interpolated first time series; and 
 apply the time series expression to the interpolated first time series and the second time series. 
   
     
     
         3 . The computing system of  claim 2 , wherein the one or more hardware computer processors are programmed, via the executable code instructions, to cause the computing system to:
 determine the first time unit from first metadata associated with the first time series; and   determine the second time unit from second metadata associated with the second time series.   
     
     
         4 . The computing system of  claim 2 , wherein the one or more hardware computer processors are programmed, via the executable code instructions, to cause the computing system to:
 determine that the first time unit and the second time unit are different.   
     
     
         5 . The computing system of  claim 4 , wherein the one or more hardware computer processors are programmed, via the executable code instructions, to cause the computing system to:
 determine to apply the first interpolation operation in response to determining that the first time unit and the second time unit are different.   
     
     
         6 . The computing system of  claim 2 , wherein applying the first interpolation operation comprises:
 identifying a first set of timestamps from the first time series and a second set of timestamps from the second time series;   determining, based on the first and second sets of timestamps, a set of common timestamps; and   generating the interpolated first time series based on the set of common timestamps.   
     
     
         7 . The computing system of  claim 6 , wherein the set of common timestamps comprises a time unit matching second time unit. 
     
     
         8 . The computing system of  claim 2 , wherein the one or more hardware computer processors are programmed, via the executable code instructions, to cause the computing system to:
 apply a second interpolation operation to a second portion of the first time series to generate the interpolated first time series.   
     
     
         9 . The computing system of  claim 8 , wherein types of the respective first and second interpolation operations are based on characteristics of the respective first and second portions of the first time series. 
     
     
         10 . The computing system of  claim 2 , wherein the first interpolation operation comprises at least one of: a none interpolation operation, a nearest interpolation operation, a previous interpolation operation, a next interpolation operation, a linear interpolation operation, or a polynomial interpolation operation. 
     
     
         11 . The computing system of  claim 2 , wherein determining the first interpolation operation is based on receiving one or more interpolation configuration parameters. 
     
     
         12 . The computing system of  claim 2 , wherein the one or more hardware computer processors are programmed, via the executable code instructions, to cause the computing system to:
 determine a granularity of the first and second time series is different; and   apply normalization operation to at least a portion of at least one of the first time series or the second time series.   
     
     
         13 . The computing system of  claim 12 , wherein applying the normalization operation comprises applying a scaling function to timestamps of the at least one of the first time series or the second time series. 
     
     
         14 . A computerized method, performed by a computing system having one or more hardware computer processors and one or more non-transitory computer readable storage device storing software instructions executable by the computing system to perform the computerized method, the computerized method comprising:
 receiving a time series expression to be applied to a first time series and a second time series;   determining a first time unit associated with the first time series;   determining a second time unit associated with the second time series, wherein the first time unit is different from the second time unit;   determining a first interpolation operation to apply to at least a first portion of the first time series;   applying the first interpolation operation to the first portion of the first time series to generate an interpolated first time series; and   applying the time series expression to the interpolated first time series and the second time series.   
     
     
         15 . The computerized method of  claim 14  further comprising:
 determining the first time unit from first metadata associated with the first time series; and 
 determining the second time unit from second metadata associated with the second time series. 
 
     
     
         16 . The computerized method of  claim 14  further comprising:
 determining that the first time unit and the second time unit are different. 
 
     
     
         17 . The computerized method of  claim 16  further comprising:
 determining to apply the first interpolation operation in response to determining that the first time unit and the second time unit are different. 
 
     
     
         18 . The computerized method of  claim 14 , wherein applying the first interpolation operation comprises:
 identifying a first set of timestamps from the first time series and a second set of timestamps from the second time series;   determining, based on the first and second sets of timestamps, a set of common timestamps; and   generating the interpolated first time series based on the set of common timestamps.   
     
     
         19 . The computerized method of  claim 18 , wherein the set of common timestamps comprises a time unit matching second time unit. 
     
     
         20 . The computerized method of  claim 14  further comprising:
 applying a second interpolation operation to a second portion of the first time series to generate the interpolated first time series. 
 
     
     
         21 . The computerized method of  claim 20 , wherein types of the respective first and second interpolation operations are based on characteristics of the respective first and second portions of the first time series.