IoT Based Lab Component
Management System
This presentation introduces our IoT Lab Component
Management System. It solves the problem of
managing many components in IoT labs by offering a
simple, central system. Our goal is to make things more
efficient, and improve decisions using real-time data
and automated tasks. We'll discuss the issues, our
solution, the tech used, how it's built, and the system's
benefits.
By : Ansh Guglani and Kuldeep Sharma
Problem Statement: The Challenges of IoT Lab
Management
Manual Tracking Inventory Inaccuracies Component Loss
Manual com ponent tracking Inventory inaccuracies result in The IoT labs components annual
leads to inefficiencies, project delays, affecting loss is estimated around 5%, due to
wasting approxim ately two approximately 15% of all projects. the components misplacement, and
hours per week per eng ineer. This causes bottlenecks and difficulties in maintaining audit
This tim e could be better missed deadlines. trails, which poses compliance
spent on innovation and issues.
project developm ent.
Solution: An Integrated IoT Lab Component
Management System
Centralized Platform Automated Alerts Streamlined Processes
The system provides a Automated alerts for low The system streamlines the
centralized platform for and expiration dates check-in/check-out process,
trackingcomponents, offering 95% accuracy, minimizing process, reducingprocessing
offeringreal-time inventory risk of project disruptions processingtime by 50%and
inventory updates and reducing to missing components. and improvingresource
reducingstockouts by 20%. utilization by 30%.
20%.
Technology Stack: Powering the
System
1 Frontend: Javascript
HTML, CSS, and Javascript provide a dynamic and responsive
user interface for seamless interaction.
2 Backend: PHP with Laravel
PH P with Laravel offers a scalable A PI for robust
backend functionality.
3 Database: MySQL
MySQL provides flexible data storage, essential for managing
diverse component information.
System Architecture: A Layered Approach
Application Layer
2
PHP backend for business logic.
Presentation Layer
1
HTML, CSS, and Javascript
frontend for user interaction.
Data Layer
3 MySQL for data storage and retrieval.
Database Design: Organized and Efficient
Collection Fields
Components Name, description, quantity, location, status, datasheet URL
Users User ID, name, role, permissions
Transactions Check-in/check-out timestamp, user ID, component ID, quantity
Alerts Alert type, component ID, timestamp, status
The database design includes collections for components, users, transactions, and alerts, with
optimized indexing for fast data retrieval. Relationships are structured to ensure data integrity and
efficient querying.
User Interface (UI): Intuitive and
User-Friendly
1 Dashboard 2 Component
Provides an overview of
Management
inventory status, alerts, Enables users to search,
and usag e statistics. add, edit, and delete
com ponents easily.
3 Transaction Management
Allows users to check-in/check-out components and view
transaction history.
Functionalities: Core Features and Capabilities
Inventory Management Check-in/Check-out Alerting
Tracks com ponent quantity, Manag es com ponent loans and Sends notifications for low stock,
location, and status in real- tim e. returns with ease. expiration dates, and overdue items.
Benefits & Future Scope: Improving Efficiency and
Scalability
Improved Accuracy Reduced Costs Scalability & Future
Integrations
Real-time tracking and alerts have Better com ponent tracking and
have greatly reduced inventory usag e have cut down on loss The system can easily handle more
errors, improving lab efficiency by and waste, lowering components and users as the lab
by minimizing downtime from procurem ent costs. Efficient grows. Future plans include
m issing parts. A utom ated resource allocation also reduces connecting with other lab tools for
helps in m aking inform ed operational expenses. testing and simulation to provide a
complete solution.
Conclusion
A web-based IoT lab management system enhances efficiency by reducing manual errors, improving inventory
tracking, and ensuring better utilization of lab components. It helps in monitoring stock levels, tracking borrowed items,
and minimizing misplacement. However, success depends on proper implementation, user compliance, and addressing
security and connectivity issues.
Thank You.
