SQL AND NODE.JS-BASED BACKEND SUBSYSTEM DEVELOPMENT FOR THE UPT LOGISTIK ITB WAREHOUSE MANAGEMENT SYSTEM (WMS)

• Main Author: Davin Dzimar, Muhammad
• Format: Final Project
• Language: Indonesia
• Online Access: https://digilib.itb.ac.id/gdl/view/85130
• Institution: Institut Teknologi Bandung

With effectiveness and efficiency in mind, UPT Logistik ITB, as the services and goods procurement unit for Bandung Institute of Technology (ITB), plans to develop a Warehouse Management System (WMS) for their newly-built warehouse. Absent of any warehousing automation, the WMS that comprises both hardware components and information system is aimed to minimize inconsistencies and potential human errors in the warehouse management activities. The solution for the aforementioned information system itself is divided into two main subsystems: a web app user interface as the frontend and a web server that connects to a database as the backend. The web server that is developed for the backend subsystem is connected to the web app user interface on the frontend and also to the hardware components of the WMS through protocols based on HTTP (HyperText Transfer Protocol). The server itself provides data-related services while being connected to a relational database that runs on an SQL (Structured Query Language) database managements system. All of it is packaged into a final product in the form of a server that is implemented using an ecosystem of tools and framework based on the Node.js technology. On the functional side of things, the resulting solution can fulfill almost every service group that is expected and can be adjusted to the scope and specifications of the warehouse management activities. On the other hand, the data transfer performance reaches a level that is close to being production-ready. However, optimization can still be done to achieve speedier data transfer performance to better fulfill the requests being processed.