Smart Campus Full Stack Project Database Migration by Nadav Gvili
undefined
SMART CAMPUS
FULL STACK PROJECT
DB MIGRAITON
By Nadav Gvili
DESCRIPTION
•
A real-time system with an interactive web interface that allows users to
manage the campus facilities.
•
This projects extends the scope of a previous project to more sensors and
capabilities.
Development Environments and Languages
STAKEHOLDERS
•
Campus Visitors- improving visit’s accessibility and quality.
•
Campus Lessees- fast and accurate management oprations. Improving
organization conditions and lessees’ satisfaction.
•
Organizational Management Level- provides accurate statistics on
organizational habits.
FACILITY MONITORING
ARCHITECTURE SHIFT
Smart-campus-FE
Smart-campus-BE
Smart-campus-modbus
mongoDB
Smart-campus-FE
Smart-campus-BE
Smart-campus-modbus
postgreSQL
•
A new PostgreSQL server was created
•
Data migration with HEVO
mongoDB
with Mongoose package
•
Working with Mongoose package
•
No-SQL syntax
•
JSON Schema convention
Sequelize package
•
Working with Sequelize package
•
Relational DB and SQL syntax
•
Models contain bot Mongoose’s schemas and models
Tables
•
Users
•
User_roles
•
Locations
•
Reports
•
counters
•
chillers
•
Device_types
•
devices
•
Auto_increment
Recommendations
•
The solution showcased in this project can be easily replicated easily to all
fields and future tables.
•
When applying additional sensors to the campus or any SMB it is preferable
to use relational DB topology. This way the data is easily processed to ML
and BI ends.
•
Further ML and BI features should be written in python.
Git
•
Link:
https://git.pblm.tech/smartcity/smart-campus
A real-time system with an interactive web interface for managing campus facilities, extending the scope of a previous project. Stakeholders include campus visitors, lessees, and organizational management, with features like facility monitoring and an architecture shift to PostgreSQL and MongoDB with Mongoose and Sequelize packages. Recommendations focus on easy replication to various fields and future tables, suggesting the use of relational DB topology for ML and BI processing in Python.
Download Presentation
Please find below an Image/Link to download the presentation.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author. Download presentation by click this link. If you encounter any issues during the download, it is possible that the publisher has removed the file from their server.
E N D
Presentation Transcript
SMART CAMPUS FULL STACK PROJECT DB MIGRAITON By Nadav Gvili
DESCRIPTION A real-time system with an interactive web interface that allows users to manage the campus facilities. This projects extends the scope of a previous project to more sensors and capabilities.
STAKEHOLDERS Campus Visitors- improving visit s accessibility and quality. Campus Lessees- fast and accurate management oprations. Improving organization conditions and lessees satisfaction. Organizational Management Level- provides accurate statistics on organizational habits.
FACILITY MONITORING Parking monitor Air pollution Water meter Electricity meter Class occupancy Chiller control Sprinkler control Visitors counter
ARCHITECTURE SHIFT Smart-campus-modbus Smart-campus-FE Smart-campus-BE mongoDB
A new PostgreSQL server was created Data migration with HEVO Smart-campus-modbus Smart-campus-FE Smart-campus-BE postgreSQL
mongoDB with Mongoose package Working with Mongoose package No-SQL syntax JSON Schema convention Connection pool Model Service Schema
Sequelize package Working with Sequelize package Relational DB and SQL syntax Models contain bot Mongoose s schemas and models Connection pool Model Raw Query
Tables Users User_roles Locations Reports counters chillers Device_types devices Auto_increment
Recommendations The solution showcased in this project can be easily replicated easily to all fields and future tables. When applying additional sensors to the campus or any SMB it is preferable to use relational DB topology. This way the data is easily processed to ML and BI ends. Further ML and BI features should be written in python.
Git Link: https://git.pblm.tech/smartcity/smart-campus
