Question

Row Column Generated Data New Aeay Random Number (0-1) Multiply 100 Subset Rows Sub-Amey Add Insert Into Aray Subset Column Sub-Amay Add aj Figure 3.4 Block Diagram of Task 3

Answer 1

Using MYSQL for storing data doe ant mean that we have to change the methods of collecting data or learn new features. All the existing knowledge can be used to store IOT data. MYSQL database system provide a perfect solution for storing Iota data and making it available for later use. These technologies with different approaches are easier to query, are less rigid, or are better suited to different types of data. So you don’t need to learn anything new or change your methods of collecting.

Internet of things devices is those devices that connect wirelessly to a network and have the ability to transmit data. These may be categorized as:

• Data collector-it is a sensor that collect data from some event
• Data aggregator-it received information from data collector and aggregates it to store
• Actionable device-it involves features such as moving a sensor, operating locks, etc.
• Database server-it stores the data so that it can be retrieved for later use
• IOT services-it is a computer system which enables all above devices to function