[Sept 2020] Combining the Power of IoT & Time-Series
IoT devices and systems collect relentless streams of data – but how do we separate signals from noise and turn this information into action? #Timeseries data analysis to the rescue!
This month’s speakers will share how they’ve architected their data stacks, what they’ve learned along the way (plus any best practices or things to avoid), and demo their projects to inspire fellow #IoT enthusiasts.
You’ll learn how Andy Meira (Grillo founder) and team have built an #opensource earthquake early-warning platform, using tools like TimescaleDB, Grafana, and Docker, that’s currently used all around the world to provide communities with seconds – or even minutes! – of advance warning (and time to take precautionary measures) before any shaking is felt.
From there, Mario Ishikawa (PackIOT CTO) breaks down best practices and advice for modeling data from machines. You’ll hear how he’s configured TimescaleDB to suit his needs, plus how (and why) to use things like JSONB, narrow v. wide tables, materialized views, and continuous aggregates across various use cases.
Handy bookmarks of the main parts of the session:
[00:50]: Session roadmap & agenda
[1:53]: Opening remarks & welcome (plus info about Timescale) – Prashant Sridharan, Timescale VP Marketing & Developer Relations
[3:01]: OpenEEW: Low-latency IoT earthquake early warning systems – Andy Meira, Grillo founder
[8:22]: Grillo AWS and open source project reference architecture overview
[10:46]: OpenEEW overview and demo(s)
[25:03]: Modeling machine data: Optimizing an IIoT time-series database – Mario Ishikawa, PackIOT CTO
[27:18]: What’s IIoT?
[29:04]: Why should we worry about our data model?
[31:28]: Data model #1: Narrow tables
[37:25]: Data model #2: Wide tables
[39:20]: Data model #3: JSONB
[41:29]: Data model comparison and final thoughts
Resources:
– Get Andy’s slides: https://tsdb.co/grillo-slides
– Learn more about Grillo: https://grillo.io/
– Get involved with the OpenEEW project (GitHub): https://www.github.com/openeew
– See OpenEEW community info, documentation, and more: https://www.openeew.com
– Follow Grillo on Twitter: https://twitter.com/grilloalerta
– Get Mario’s slides: https://tsdb.co/packIOT-slides
– Learn more about PackIOT: https://packiot.com/
– Follow Mario on Twitter: https://twitter.com/marioishikawa
– Learn more about TimescaleDB (Docs): https://tsdb.co/timescaledb-docs-hub
– Sign up for a free Timescale Cloud account (incl $300 in free credits): https://tsdb.co/try-timescale-cloud-free
– Join TimescaleDB Developer Slack: https://slack.timescale.com/
linux foundation
