商品描述
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 - MySQL.
The IoT 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 IoT data by leveraging the power of database systems.
The book begins with an introduction of the MySQL database system and storage of sensor data. Detailed instructions and examples are provided to show how to add database nodes to IoT solutions including how to leverage MySQL high availability, including examples of how to protect data from node outages using advanced features of MySQL.
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 IoT data across multiple database servers
- Build localized, low-cost MySQL database servers using small and inexpensive computers
- Connect Arduino boards and other devices directly to MySQL database servers
- Build high availability MySQL solutions among low-power computing devices
商品描述(中文翻譯)
這本書介紹了物聯網 (IoT) 開發者面臨的問題,並探討當前的技術和技術,以幫助您管理、挖掘並理解通過全球最受歡迎的資料庫 - MySQL 收集的數據。
物聯網即將改變我們與周圍世界的互動和感知方式,可能性幾乎是無窮無盡的。隨著越來越多的連接設備生成數據,我們需要解決如何收集、存儲和理解物聯網數據的問題,並利用資料庫系統的力量。
本書首先介紹 MySQL 資料庫系統及感測器數據的存儲。提供詳細的指導和範例,展示如何將資料庫節點添加到物聯網解決方案中,包括如何利用 MySQL 的高可用性,並提供如何使用 MySQL 的高級功能來保護數據免受節點故障的範例。
本書最後比較了原始數據和轉換後的數據,顯示轉換後的數據如何改善可理解性,並幫助您在雜亂的冗餘數據中找到有用知識的精華。
在這本書中,您將學習到:
- 理解來自連接設備的大量數據危機
- 轉換數據以改善報告並減少存儲量
- 在多個資料庫伺服器上存儲和聚合您的物聯網數據
- 使用小型且便宜的計算機構建本地化、低成本的 MySQL 資料庫伺服器
- 將 Arduino 板和其他設備直接連接到 MySQL 資料庫伺服器
- 在低功耗計算設備之間構建高可用性的 MySQL 解決方案