Muutke küpsiste eelistusi

MySQL for the Internet of Things 1st ed. [Pehme köide]

  • Formaat: Paperback / softback, 335 pages, kaal: 6467 g, 92 Illustrations, black and white, 1 Paperback / softback
  • Ilmumisaeg: 11-Feb-2016
  • Kirjastus: APress
  • ISBN-10: 1484212940
  • ISBN-13: 9781484212943
Teised raamatud teemal:
  • Pehme köide
  • Hind: 34,97 €*
  • * hind on lõplik, st. muud allahindlused enam ei rakendu
  • Tavahind: 41,14 €
  • Säästad 15%
  • Raamatu kohalejõudmiseks kirjastusest kulub orienteeruvalt 3-4 nädalat
  • Kogus:
  • Lisa ostukorvi
  • Tasuta tarne
  • Tellimisaeg 2-4 nädalat
  • Lisa soovinimekirja
MySQL for the Internet of Things 1st ed.Suurem pilt
  • Formaat: Paperback / softback, 335 pages, kaal: 6467 g, 92 Illustrations, black and white, 1 Paperback / softback
  • Ilmumisaeg: 11-Feb-2016
  • Kirjastus: APress
  • ISBN-10: 1484212940
  • ISBN-13: 9781484212943
Teised raamatud teemal:
Püsilink: https://www.kriso.ee/db/9781484212943.html
Märksõnad:
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 worlds 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

Arvustused

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 publishers 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 usedin practice. (Mark Taylor, Computing Reviews, November, 2016)

About the Author xiii
About the Technical Reviewer xv
Acknowledgments xvii
Introduction xix
Chapter 1 The Internet of Things and Data
1(28)
IOT Solutions
2(9)
IOT Is More Than Just Connected to the Internet
3(3)
IOT Services
6(1)
Example IOT Solutions
7(4)
What Is IOT Data?
11(5)
IOT Predictions: Data Overload?
16(4)
Addressing IOT Devices
16(3)
IOT and Big Data
19(1)
IOT Security
20(8)
Common Security Threats
23(2)
Securing IOT Solutions
25(3)
Summary
28(1)
Chapter 2 Hardware for IOT Solutions
29(50)
Microcontrollers
29(33)
What Is an Arduino?
30(1)
Arduino Models
31(5)
Arduino Clones
36(9)
Arduino Tutorial
45(7)
Additional Arduino Hardware
52(10)
Low-Powered Computing Platforms
62(10)
Arduino Hybrids
63(3)
Computer Boards
66(6)
Sensors
72(5)
Analog Sensors
73(1)
Digital Sensors
73(1)
Storing Sensor Data
74(1)
Examples of Sensors
74(3)
Computer Systems
77(1)
Summary
78(1)
Chapter 3 How IOT Data Is Stored
79(22)
Distributed IOT
80(2)
Data Collectors
81(1)
Data Collectors with Storage
81(1)
Actionable Device
81(1)
Data Aggregators
81(1)
Database Server
82(1)
Local On-Device Storage
82(8)
Local Storage on the Raspberry Pi
83(2)
Local Storage on the Arduino
85(5)
Passing the Buck to Aggregators
90(2)
Database Storage
92(4)
Benefits
93(1)
Techniques
94(1)
Considerations
95(1)
Distributed IOT Network Best Practices
96(3)
Node Placement
96(1)
Data Storage
97(2)
Presentation
99(1)
Summary
99(2)
Chapter 4 Data Transformation
101(40)
Making Sense of IOT Data
102(4)
What Is Being Observed?
102(1)
Is There Another Way to Make the Observation?
102(1)
How Often Do You Need to Record the Observation?
103(1)
What Type of Data Does the Sensor Produce?
104(1)
Are There Interpretations Needed for the Observation Data?
104(1)
What Level of Accuracy Do You Need?
105(1)
What Is the Lifetime of the Data?
105(1)
Annotation
106(28)
Recording the Sensor Name or Adding Notes
107(3)
Recording the Date and Time
110(6)
Data Type Transformations
116(7)
Adding Derived or Calculated Data
123(7)
Data Interpretations
130(4)
Aggregation
134(6)
Data from Multiple Sensors
134(3)
Data from Multiple Nodes
137(2)
Aggregate Calculations
139(1)
Summary
140(1)
Chapter 5 MySQL Primer
141(54)
Getting Started
141(16)
How Do I Use MySQL?
142(2)
How to Get and Install MySQL
144(13)
How Data Is Stored and Retrieved
157(7)
How and Where MySQL Stores Data
158(6)
Common MySQL Commands and Concepts
164(12)
MySQL Commands
164(7)
MySQL Concepts
171(5)
Planning Database Storage for IOT Data
176(17)
Example 1 Plant-Monitoring System
176(15)
Recommendations and Best Practices
191(2)
Summary
193(2)
Chapter 6 Building Low-Cost MySQL Data Nodes
195(56)
Introducing the Raspberry Pi
195(11)
Noble Origins
197(1)
Models
198(2)
A Tour of the Board
200(1)
Required Accessories
201(1)
Recommended Accessories
202(1)
Where to Buy
203(3)
Raspberry Pi Tutorial
206(9)
Choosing a Boot Image (Operating System)
206(6)
Booting Up
212(3)
MySQL Installation and Setup
215(10)
Partitioning and Formatting the Drive
216(2)
Setting Up Automatic Drive Mounting
218(2)
Installing MySQL Server
220(5)
Other Platforms
225(5)
BeagleBone Black
225(1)
pcDuino
226(1)
Intel Galileo
227(3)
MySQL Clients: How to Connect and Save Data
230(1)
Introducing Connector/Arduino
230(19)
Introducing Connector/Python
242(7)
Summary
249(2)
Chapter 7 High Availability IOT Solutions
251(22)
What Is High Availability?
251(2)
High Availability Options for IOT Solutions with MySQL
253(3)
Recovery
253(1)
Redundancy
254(1)
Scaling
255(1)
Fault Tolerance
255(1)
High Availability Techniques
256(15)
Backup and Recovery
256(8)
MySQL Replication Primer
264(6)
Fault Tolerance in IOT Nodes
270(1)
Summary
271(2)
Chapter 8 Demonstration of High Availability Techniques
273(38)
MySQL Replication Techniques
273(18)
Transaction Processing
274(2)
Advanced Replication with Global Transaction Identifiers
276(6)
Replication and Database Maintenance Tips
282(3)
Example: Scaling Applications
285(6)
High Availability IOT Nodes
291(19)
Example: Redundant Data Collectors
291(9)
Example: Fault-Tolerant Data Collector
300(10)
Summary
310(1)
Index 311
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/.