Architecture and Design Patterns applied to the Project Management System integrator with MySQL Database
DOI:
https://doi.org/10.5281/zenodo.19866244Keywords:
Software Architecture, Design Patterns, MySQL Database, Integration ProjectsAbstract
This article presents the architecture and design patterns applied to the Integrative Projects Management System (SGPI), developed for the Multiplatform Software Development course at Fatec. The system was designed in response to storage limitations imposed by the partnership with Microsoft. The solution adopts layered architecture with separation of responsibilities among presentation, business logic, and data persistence. Three Design Patterns were implemented: Factory Method for user profile creation, Facade for report generation, and Observer for notification management. Persistence uses MySQL Database, allowing efficient storage of documents, presentations, and videos. The backend was developed in Node.js with Express.js, following software engineering best practices to ensure scalability, security, and maintainability. The research demonstrates how software architecture contributes to robust and evolutionary academic systems.
Downloads
References
BASS, Len; CLEMENTS, Paul; KAZMAN, Rick. Software architecture in practice. 2. ed. Boston: Addison-Wesley, 1997.
GAMMA, Erich; HELM, Richard; JOHNSON, Ralph; VLISSIDES, John. Design patterns: elements of reusable object-oriented software. Boston: Addison-Wesley, 1994.
MARTIN, Robert C. Clean architecture: a craftsman's guide to software structure and design. Boston: Prentice Hall, 2017.
SOMMERVILLE, Ian. Software engineering. 10. ed. Boston: Pearson, 2019.
SEARS, Russell; VAN INGEN, Catharine; GRAY, Jim. To BLOB or Not To BLOB: Large Object Storage in a Database or a Filesystem? Microsoft Research Technical Report MSR-TR-2006-45. Microsoft Research, 2006. Disponível em: https://www.microsoft.com/en-us/research/wp-content/uploads/2006/04/tr-2006-45.pdf Acesso em: 10 out. 2025.
NIELSEN, Jakob. Response Times: The 3 Important Limits. Nielsen Norman Group, 2010. Disponível em: https://www.nngroup.com/articles/response-times-3-important-limits/. Acesso em: 30 out. 2025.
HUANG, H.; LI, B. Design and implementation of student management system of integrated programmable device programming system. Scientific Reports, v. 14, n. 11873, maio 2024. DOI: 10.1038/s41598-024-62844-z.
SHAPIRO, Michael; MILLER, Ethan L. Managing Databases with Binary Large Objects. Conference on Mass Storage Systems (MSS), 1999. Disponível em: https://ethanmiller.org/files/pubs/mss99.pdf Acesso em: 10 out. 2025.
CASCIARO, Mario; MAMMINO, Luciano. Node.js Design Patterns: Design and implement production-grade Node.js applications using proven patterns and techniques. 4. ed. Birmingham: Packt Publishing, 2024.
ORACLE CORPORATION. MySQL 8.0 Reference Manual. Oracle, 2024. Disponível em: https://dev.mysql.com/doc/refman/8.0/en/. Acesso em: 30 out. 2025.
BAUMANN, Peter; HAHN, Karsten; MERTICARIU, George. A comparative benchmark of large objects in relational databases. In: PROCEEDINGS OF THE VLDB ENDOWMENT, 2008. Disponível em: https://www.researchgate.net/publication/221524812_A_comparative_benchmark_of_large_objects_in_relational_databases. Acesso em: 30 out. 2025.
Downloads
Published
How to Cite
Issue
Section
License
Copyright (c) 2026 Kaique Caitano Dos Santos, Diego Marques Da Costa, Luiz Carlos Gimenes F. De Souza, Nicole Lisboa De Carvalho, Vinicius De Morais Crepaldi, Sirley Ambrosia Vitoria Addão
This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.
Engetec em Revisa © 2024 by Fatec da Zona Leste is licensed under CC BY-NC-SA 4.0
Copyright Policy
By submitting a manuscript for publication in EnGeTec em Revista, the authors agree, in advance and unrestrictedly, to the following terms:
- The authors retain the copyright and grant EnGeTec em Revista the right of first publication of the manuscript, without any financial burden, and renounce any other remuneration for its publication in EnGeTec em Revista.
- When submitted to EnGeTec em Revista, the manuscript is automatically licensed under the Creative Commons Attribution License, which allows the sharing of the work with acknowledgment of authorship and initial publication in EnGeTec em Revista.
- Authors are authorized to enter into additional contracts separately, for non-exclusive distribution of the version of the work published in EnGeTec em Revista (publish in repositories or as a book chapter), with acknowledgment of the initial publication in EnGeTec em Revista, provided that such agreement does not imply an endorsement of the content of the manuscript or of the new vehicle by EnGeTec em Revista.
- Authors are allowed and encouraged to publish and distribute their work online, in institutional repositories, for example after the editorial process is completed.
- The authors warrant that they have obtained proper permission from their employers for the transfer of rights under this agreement, if those employers own any copyright in the manuscript. In addition, the authors assume any and all responsibility for possible infringements of the copyright of these employers, exempting EnGeTec em Revista from any and all liability in this regard.
- The authors assume all responsibility for the content of the work, including the due and necessary authorizations for data disclosure. collected and results obtained, exempting EnGeTec em Revista from any and all responsibility in this regard.
