Development of a Web-Based System for Scientific Publication Data Management Using NoSQL Architecture

Abstract

This study developed a web-based system for managing scientific publication data using a NoSQL architecture (MongoDB) and an Extract, Load, Transform (ELT) approach. The website allows users to easily access, manage, and visualize data through an interactive interface built with React.js on the frontend and Express.js on the backend. The system supports data input via CSV uploads and manual form submissions, with all data stored in MongoDB Atlas. Data transformation is handled using the Aggregation Pipeline, which performs normalization, validation, and upsert operations to ensure consistency and prevent duplication. Functional testing was conducted on 503 real publication records, while performance testing used 1,000 dummy records. The results show that the system can support up to 20 concurrent users with an average response time of 4,792 ms and no errors. Overall, the website offers a flexible and integrated solution for managing scientific publications in higher education institutions.