News for hackers. Stuff that matters.
Re:Time series database Graphite seems to be falling into di... by chaotic-good on Monday November 09, 2015 @12:38PM (#10534439)
You can't retrieve original time-series data from SAX storage because of normalization. To query time-series data by content (approximate 1-NN, motif discovery, etc) you need inverted index.
Re:Time series database Graphite seems to be falling into di... by cbsmith on Tuesday November 10, 2015 @11:56AM (#10540473)
The normalized data is the index. It can still be pointing to the raw data. The nice thing is that the index organizes the data in a way that makes it easily (lossless) compressible.
Re:Time series database Graphite seems to be falling into di... by chaotic-good on Wednesday November 11, 2015 @05:35AM (#10545893)
> It can still be pointing to the raw data.

Yep. Each SAX word should be mapped to the list of seriesid:timestamp pairs. This list is often referred as postings list in information retrieval. The resulting data-structure is an inverted index. SAX and iSAX papers describes inverted index variant (really bad one) based on folder structure but one can use convenient IR tools for this.

Re:Time series database Graphite seems to be falling into di... by cbsmith on Wednesday November 11, 2015 @10:09PM (#10551062)
iSAX2 yields a much better inverted index style model.

The thing is, particularly with time series data, a lot of times it is sufficient to at least start with the summary data in the index.