INTERNET OF THINGS TECHNOLOGY 17CS81 Module-1 Notes

 INTERNET OF THINGS TECHNOLOGY 17CS81 Module-1 Notes

 

ALGORITHMS AND DATABASE MANAGEMENT SYSTEMS LABORATORY    

Course Code:  20SCSL16

 

1.       Program to implement Ford-Fulkerson method

2.       Program to implement Naive algorithm.

3.       Program to implement Rabin - Karp algorithm.

4.       Program to implement Boyer – Moore algorithm.

5.       Program to implement Monte Carlo algorithm.

 

1.       Develop a database application to demonstrate storing and retrieving of BLOB and CLOB objects.

a. Write a binary large object (BLOB) to a database as either binary or character (CLOB) data, depending on the type of the field in your data source. To write a BLOB value to the database, issue the appropriate INSERT or UPDATE statement and pass the BLOB value as an input parameter. If your BLOB is stored as text, such as a SQL Server text field, pass the BLOB as a string parameter. If the BLOB is stored in binary format, such as a SQL Server image field, pass an array of type byte as a binary parameter.

 b. Once storing of BLOB and CLOB objects is done, retrieve them and display the results accordingly

program uses MySQL PHP. (installed through XAMPP)

Start Apache and Mysql using XAMPP control

store PHP files in XAMPP/htdocs

Store image file in htdoc folder

db.php

insert.php

listimage.php

Open php file in local browser

database output_images(

imageId

tinyint(3)

imageType

varchar(25)

imageData

mediumblob

 )

 2.       Develop a database application to demonstrate the representation of multi valued attributes, and the use of nested tables to represent complex objects. Write suitable queries to demonstrate their use. Consider Purchase Order Example: This example is based on a typical business activity: managing customer orders. Need to demonstrate how the application might evolve from relational to object-relational, and how you could write it from scratch using a pure object-oriented approach.

 a. Show how to implement the schema -- Implementing the Application under the Relational Model -- using only Oracle's built-in data types. Build an object-oriented application on top of this relational schema using object views

Solution using Oracle 11g Express edition 

 

 

3.        Design and develop a suitable Student Database application by considering appropriate attributes. Couple of attributes to be maintained is the Attendance of a student in each subject for which he/she has enrolled and Internal Assessment Using TRIGGERS, write active rules to do the following:

a.         Whenever the attendance is updated, check if the attendance is less than 85%; if so, notify   

the Head of the Department concerned.

b.        Whenever, the marks in an Internal Assessment Test are entered, check if the marks are

less than 40%; if so, notify the Head of the Department concerned.

 

  

INTERNET OF THINGS TECHNOLOGY

[As per Choice Based Credit System (CBCS) scheme]

(Effective from the academic year 2017 - 2018)

SEMESTER – VIII                                        IA Marks 40                                        Exam Marks 60

Subject Code  17CS81                                                                       Number of Lecture Hours/Week 04

Total Number of Lecture Hours 50                 Exam Hours 03                       CREDITS – 04

Module – 1                                                                                                                              10 Hours

What is IoT, Genesis of IoT, IoT and Digitization, IoT Impact, Convergence of IT and IoT, IoT Challenges, IoT Network Architecture and Design, Drivers Behind New Network Architectures, Comparing IoT Architectures, A Simplified IoT Architecture, The Core IoT Functional Stack, IoT Data Management and Compute Stack.

 

Module – 2                                                                                                                              10 Hours

Smart Objects: The “Things” in IoT, Sensors, Actuators, and Smart Objects, Sensor  Networks, Connecting Smart Objects, Communications Criteria, IoT Access Technologies.

 

Module – 3                                                                                                                              10 Hours

IP as the IoT Network Layer, The Business Case for IP, The need for Optimization, Optimizing IP for IoT, Profiles and Compliances, Application Protocols for IoT, The Transport Layer, IoT Application Transport Methods.

 

Module – 4                                                                                                                              10 Hours

Data and Analytics for IoT, An Introduction to Data Analytics for IoT, Machine Learning, Big Data Analytics Tools and Technology, Edge Streaming Analytics, Network Analytics, Securing IoT, A Brief History of OT Security, Common Challenges in OT Security, How IT and OT Security Practices and Systems Vary, Formal Risk  Analysis Structures: OCTAVE and FAIR, The Phased Application of Security in an Operational Environment

 

Module – 5

IoT Physical Devices and Endpoints - Arduino UNO: Introduction to Arduino, Arduino UNO, Installing the Software, Fundamentals of Arduino Programming.  IoT Physical Devices and Endpoints - RaspberryPi: Introduction to RaspberryPi, About the RaspberryPi Board: Hardware Layout, Operating Systems on RaspberryPi, Configuring RaspberryPi, Programming RaspberryPi with Python, Wireless Temperature Monitoring System Using Pi, DS18B20 Temperature Sensor, Connecting Raspberry Pi via SSH, Accessing Temperature from DS18B20 sensors, Remote access to RaspberryPi, Smart and Connected Cities, An IoT Strategy for Smarter Cities, Smart City IoT Architecture, Smart City Security Architecture, Smart City Use-Case Examples

 

Course Outcomes: After studying this course, students will be able to:

·          Interpret the impact and challenges posed by IoT networks leading to new architectural

  models.

·          Compare and contrast the deployment of smart objects and the technologies to connect them

  to network.

·          Appraise the role of IoT protocols for efficient network communication.

·          Elaborate the need for Data Analytics and Security in IoT.

·          Illustrate different sensor technologies for sensing real world entities and identify the

      applications of IoT in Industry.

Text Books:

 

1. David Hanes, Gonzalo Salgueiro, Patrick Grossetete, Robert Barton, Jerome Henry,"IoT Fundamentals: Networking Technologies, Protocols, and Use Cases for the Internet of Things”, 1 st Edition, Pearson Education (Cisco Press Indian Reprint). (ISBN: 978-9386873743)

2. Srinivasa K G, “Internet of Things”,CENGAGE Leaning India, 2017

Reference Books:

 

1. Vijay Madisetti and ArshdeepBahga, “Internet of Things (A Hands-on-Approach)”,  1 st      

     Edition, VPT, 2014. (ISBN: 978-8173719547) (good illustration with examples for practical IoT approach) 

2. Raj Kamal, “Internet of Things: Architecture and Design Principles”, 1 st Edition,McGraw

    Hill Education, 2017. (ISBN: 978-9352605224)

 AIML module 3 Planning PPT