time series database

Short introduction to time series database.

Transcript

1. ࣌ܥྻσʔλϕʔε 2016.10.5 ASAKO TOYAMA
2. ࣌ܥྻσʔλϕʔε Time series database (TSDB) timestampΛΩʔʹ؅ཧ͢Δσʔλϕʔε ࣌ܥྻͷ๲େͳσʔλΛऩू͠ɺλΠϜϕʔεͷΫΤ ϦʔʹಛԽ͢Δ RDMBS΍Key-Value storeΛΤϯδϯͱͯ͠࢖༻͢Δ ΋ͷ͕ଟ͍
3. • αʔόʔϝτϦοΫεऩूɺղੳ • IoTͷσʔλऩूɺղੳ • גࣜ৘ใऩूɺղੳ etc,… ༻్
4. • IDͱ͔nameͱ͔ͰɺΦϒδΣΫτ͕ߜΕͯ • ࣌ܥྻͰɺόϯόϯσʔλ͕དྷΔ͚ΕͲ • ଈ࣌ʹσʔλϕʔεʹ൓ө͞Εͯ • ͦͷ্ɺϢʔβ͸ɺσʔλϨϯδͰղੳ͍ͨ͠΋ͷ ʹద͢Δ ༻్
5. • InfluxDB • RRDtool • Graphite • OpenTSDB • Kdb+ etc,… ओཁϓϩμΫτ
6. ࠓ·ͰͷdatabaseͰॆ෼͡Όͳ͍ͷʁ ͱɺࢥͬͨΒɺinfluxDBͷϖʔδʹ௕ʑͱϓϩύΨϯμ͕… ElasticSearch ͍͍͔΋ͶɻͰ΋ɺtime series dataʹಛԽ͍ͯ͠ΔΘ ͚Ͱ͸ͳ͍Ͱ͠ΐɻ͔ͩΒɺύϑΥʔϚϯε͕৺഑ΑɻϩάղੳͳΒɺ ElasticSearch +InfluxDBͰɺڞଘͯ͠࢖͏ͷ͸ɺͲ͏ʁ Cassandra ͍͍͔΋ͶɻͰ΋ɺηοςΟϯά͕໘౗͍͘͞Ͱ ͠ΐɻ MongoDB ͍͍͔΋ͶɻͰ΋ɺMongoDBͷύϑΥʔϚϯεΛ௵͞ ͳ͍Α͏σʔλετΞઃܭͱͱΫΤϦʔΛॻ͘ͷ͸ɺ஫ҙ͕ඞཁΑɻ
7. MongoDBͰ΋ɺtime series data ʹ͍ͭͯɺϓϨθϯ͋Γ • MongoDB for Time Series Data Part 1: Setting the Stage for Sensor Management • MongoDB for Time Series Data Part2: Analyzing Time Series Data Using the Aggregation Framework and Hadoop
8. InfluxDBΛ͍ͬͯ͡ΈΔ
9. influxDB docker • https://hub.docker.com/ _/influxdb/
10. ࠓ೔͸͜͜·Ͱ…
11. https://en.wikipedia.org/wiki/ Time_series_database http://db-engines.com/en/ references