Базы данных для временных рядов

  • Published on
    30-Jul-2015

  • View
    286

  • Download
    3

Embed Size (px)

Transcript

1. .. dnamiot@gmail.com 2015 2. SQL NoSQL 3. : M2M, IoT INSERT ( ) 4. - window , () 5. - T A1 A2 A3 An 1 X NULL X NULL NULL NUL 2 X X NULL X X X 5 X X X X X NULL 7 NULL X X X X X 9 X X X X NULL NULL 6. T MEASUREMENTS 1 { A1: VALUE1, A3:VALUE3 } 5 { A2: VALUE2, A3:VALUE3 } 7 { A5: VALUE5, A6:VALUE6, A7:VALUE7 } 9 { A1: VALUE1, A2:VALUE2 } 7. : data engine 8. SQL : Vertica SELECT item, slice_time, ts_first_value(price, 'const') price FROM ts_test WHERE price_time BETWEEN timestamp '2015-04-01 07:00' AND timestamp '2015-04-01 07:30' TIMESERIES slice_time AS '1 minute' OVER (PARTITION BY item ORDER BY price_time) ORDER BY item, slice_time, price; 9. SQL : window functions SELECT id_sensor, name_sensor, temperature, avg(temperature) OVER (ORDER BY id_sensor ROWS BETWEEN 1 PRECEDING AND 1 FOLLOWING) FROM temperature_table; 10. NoSQL 11. Cassandra 12. SenML 13. Lambda Architecture 14. V : Volume, Velocity, Variety : Velocity

Recommended

View more >