MySQL for the Internet of Things

Charles Bell

  • 出版商: Apress
  • 出版日期: 2016-02-11
  • 售價: $1,710
  • 貴賓價: 9.5$1,625
  • 語言: 英文
  • 頁數: 344
  • 裝訂: Paperback
  • ISBN: 1484212940
  • ISBN-13: 9781484212943
  • 相關分類: MySQLSQL物聯網 IoT
  • 海外代購書籍(需單獨結帳)

商品描述

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



商品描述(中文翻譯)

本書介紹了物聯網開發者面臨的問題,並探討了當前的技術和技巧,以幫助您管理、挖掘和理解通過使用全球最流行的互聯網數據庫 - MySQL 收集的數據。

物聯網有望改變我們與周圍世界的互動和感知方式,其可能性幾乎無限。隨著越來越多的連接設備生成數據,我們需要解決如何通過利用數據庫系統的強大功能來收集、存儲和理解物聯網數據的問題。

本書首先介紹了MySQL數據庫系統和儲存感測器數據的方法。提供了詳細的指示和示例,展示了如何將數據庫節點添加到物聯網解決方案中,包括如何利用MySQL高可用性,以及如何使用MySQL的高級功能保護數據免受節點故障的影響。

本書最後通過比較原始數據和轉換後的數據,展示了轉換後的數據如何提高可理解性,幫助您從大量冗餘數據中提取有用的知識。

在本書中,您將學到以下內容:
- 理解來自連接設備的大量數據的危機
- 轉換數據以改善報告並減少存儲容量
- 在多個數據庫服務器上存儲和聚合物聯網數據
- 使用小型且價格低廉的計算機構建本地化、低成本的MySQL數據庫服務器
- 將Arduino板和其他設備直接連接到MySQL數據庫服務器
- 在低功耗計算設備之間構建高可用性的MySQL解決方案