Device to Database

Don Coleman

How do you process data from connected devices? This class examines how to build systems to collect, process, store, and visualize data from connected devices. The class will review and discuss real world Internet of Things (IoT) systems using case studies and actual projects. We will build systems using Arduino hardware and open source software. We will discuss how IoT systems are built on commercial cloud infrastructure.

Students will learn about IoT devices and the data pipelines for processing data. They will build an Arduino based device to send and receive data over WiFi using standard protocols like MQTT. Students will write code to move data from MQTT into a database. Students will learn how to query the database and present data as tabular data and graphs. To gain an understanding of an entire IoT system from device to application, we will start at a high level and then drill into each of the pieces — we will:

– Discuss sensor hardware and wireless options (WiFi, Cellular, LoRaWAN, LTE-M, etc) for moving data to the server

– Discuss transport options MQTT, CoAP, AMQP, HTTPS, etc.

– Examine SQL, NoSQL, and Time Series Databases

– Look at tools and techniques for querying and visualizing data.

– Collect and store sensor data using Amazon Web Services (AWS)

Prerequisite:

– Introduction to Physical Computing

– Introduction to Computational Media (suggested)

The class will be a mix of lecture, discussion, and building IoT systems. Real world examples and case studies will be used to demonstrate how IoT can be built.