This book introduces the problems facing Internet of Things developers and explores current technologies and techniques to help you manage, mine, and make sense of the data being collected through the use of the world’s most popular database on the Internet – My SQL.
The Io T is poised to change how we interact with and perceive the world around us, and the possibilities are nearly boundless. As more and more connected devices generate data, we will need to solve the problem of how to collect, store, and make sense of Io T data by leveraging the power of database systems.
The book begins with an introduction of the My SQL database system and storage of sensor data. Detailed instructions and examples are provided to show how to add database nodes to Io T solutions including how to leverage My SQL high availability, including examples of how to protect data from node outages using advanced features of My SQL.
The book closes with a comparison of raw and transformed data showing how transformed data can improve understandability and help you cut through a clutter of superfluous data toward the goal of mining nuggets of useful knowledge.
In this book, you’ll learn to:
- Understand the crisis of vast volumes of data from connected devices
- Transform data to improve reporting and reduce storage volume
- Store and aggregate your Io T data across multiple database servers
- Build localized, low-cost My SQL database servers using small and inexpensive computers
- Connect Arduino boards and other devices directly to My SQL database servers
- Build high availability My SQL solutions among low-power computing devices
Daftar Isi
1. The Internet of Things and Data.- 2. How IOT Data is Stored.- 3. Hardware for IOT Devices and Data Collection.- 4. Data Transformation.- 5. My SQL Primer.- 6. Building Low-Cost My SQL Database Nodes.- 7. High Availability IOT Solutions.- 8. Demonstration of Techniques