MySQL for the Internet of Things

Authors: Bell, Charles

Download source code
  • MySQL for the Internet of Things helps you manage and query and benefit from the increasing amounts of data generated by everyday devices that are connected to the Internet.

Buy this book

eBook $9.99
$19.99 (listprice)
price for USA (gross)
valid through November 28, 2017
  • ISBN 978-1-4842-1293-6
  • Digitally watermarked, DRM-free
  • Included format: PDF, EPUB
  • ebooks can be used on all reading devices
  • Immediate eBook download after purchase
Softcover $12.50
$29.99 (listprice)
price for USA
valid through November 28, 2017
  • ISBN 978-1-4842-1294-3
  • Free shipping for individuals worldwide
  • Usually dispatched within 3 to 5 business days.
About this book

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



About the authors

Charles Bell conducts research in emerging technologies. He is a member of the Oracle MySQL Development team and is the team lead for the MySQL Utilities team. He lives in a small town in rural Virginia with his loving wife. He received his Doctor of Philosophy in Engineering from Virginia Commonwealth University in 2005. Dr. Bell is an expert in the database field and has extensive knowledge and experience in software development and systems engineering. His research interests include 3D printers, microcontrollers, three-dimensional printing, database systems, software engineering, and sensor networks. He spends his limited free time as a practicing Maker focusing on microcontroller projects and refinement of three-dimensional printers. Dr. Bell maintains a blog on his research projects and many other interests. You can find his blog at http://drcharlesbell.blogspot.com/.

Reviews

“What is great about the book is its bipartite structure of theory and praxis, which leads to a better understanding of the subject matter. … For each chapter with programming examples, the reader can find the source code on the publisher’s website. All of these features make the book a solid primer for working with MySQL when building IoT solutions and very enjoyable to read.” (Klaus K. Obermeier, Computing Reviews, March, 2017)

“This book would be of interest to researchers and practitioners in the field of the Internet of Things (IoT). … the book outlines how IoT works, what hardware is currently available for IoT systems, the different approaches to how IoT data is stored and transmitted, the nature of MySQL, the differences between low-cost and high-availability IoT systems, and how the technologies can be used in practice.” (Mark Taylor, Computing Reviews, November, 2016)


Table of contents (8 chapters)

Buy this book

eBook $9.99
$19.99 (listprice)
price for USA (gross)
valid through November 28, 2017
  • ISBN 978-1-4842-1293-6
  • Digitally watermarked, DRM-free
  • Included format: PDF, EPUB
  • ebooks can be used on all reading devices
  • Immediate eBook download after purchase
Softcover $12.50
$29.99 (listprice)
price for USA
valid through November 28, 2017
  • ISBN 978-1-4842-1294-3
  • Free shipping for individuals worldwide
  • Usually dispatched within 3 to 5 business days.

Services for this book

Loading...

Bibliographic Information

Bibliographic Information
Book Title
MySQL for the Internet of Things
Authors
Copyright
2016
Publisher
Apress
Copyright Holder
Charles Bell
eBook ISBN
978-1-4842-1293-6
DOI
10.1007/978-1-4842-1293-6
Softcover ISBN
978-1-4842-1294-3
Edition Number
1
Number of Pages
XV, 335
Number of Illustrations and Tables
92 b/w illustrations
Topics