TIME-SERIES DATABASES

Question 1

TIME SERIES DEFINITION

Answer 1

collection of observations or data points obtained by repeated measure over time

measurements often happen in equal intervals

measurement is well defined (who measures what)

time is an illusion, any sequence can be seen as a time series

Question 2

USE CASES

Answer 2

Computer system monitoring
Finance
IOT
Industry 
Agriculture
...

Question 3

DEFINITION OF TIME SERIES DATA

Answer 3

sequence of numbers representing the measurements of a variable at time intervals

• identifiable by a source name or id and a metric name or id
• possibly associated with tags
• raw data is immutable, unique and sortable

Question 4

CONVENTIONNAL DATABASE APPROACH

Answer 4

series_id + timestamp + value

Question 5

CONVENTIONAL DATABASES ISSUES

Answer 5

• scalability issues (# of sensors? frequency?)

- query/analysis/transformation (expressivity issues, perf)