Development and Capability Evaluation of a Firebase-Based Pharmacy Inventory System Using COBIT 2019
Abstract
Pharmacy inventory control systems require proper and timely data management to be able to supply medicines and function as such. The study conceptualized and tested a Firebase-based system of pharmacy inventory control. The system was conceptualized in the web and Android platforms with the key objectives of enabling real-time synchronization, tracking, and reporting functionalities. Capability measurement from utilizing the COBIT 2019 method was utilized in evaluating system governance and operational performance. Four key processes are BAI03 (Identification and Build of Managed Solutions), DSS01 (Managed Operations), DSS02 (Managed Service Requests and Managed Incidents), and MEA01 (Managed Performance Monitoring) were chosen shortlisted and mapped to system indicators. Seven pharmacy employees were subjected to the assessment with a Likert-scale questionnaire. The results showed that three processes attained Capability Level 4 (Predictable) and one attained Capability Level 5 (Optimizing), i.e., the system performs predictably and allows continuous improvement. Weakness points despite deployment of the system with proof of handling data with ease and responsiveness were the fact that the sample size of respondents was small and one pharmacy only had it deployed. Much more must be done to experiment with the system in different environments and explore integration with third-party platforms for further scalability and adherence to governance.
Downloads
References
M. Elarbi, O. Ayadi, M. Masmoudi, and F. Masmoudi, “Drug-inventory-management-model for a multi-echelon pharmaceutical supply-chain: case study of the Tunisian pharmaceutical supply-chain,” Supply Chain Forum: An International Journal, vol. 22, no. 1, pp. 44–56, Jan. 2021, doi: 10.1080/16258312.2020.1824532.
M. A. Raza et al., “Artificial Intelligence (AI) in Pharmacy: An Overview of Innovations,” Innov Pharm, vol. 13, no. 2, p. 13, Jul. 2022, doi: 10.24926/iip.v13i2.4839.
M. Lubis, D. O. Handayani, A. Rostiawan, Q. J. Adrian, R. Fauzi, and I. F. Zamzami, “Design Approach in Electronic Health Consultation Application: User Empowerment for Internet Addiction,” in 2021 International Conference Advancement in Data Science, E-learning and Information Systems (ICADEIS), IEEE, Oct. 2021, pp. 1–6. doi: 10.1109/ICADEIS52521.2021.9702064.
F. Atika and D. Irwan, “Pharmacy Inventory System Design Using Agile Methods,” Al’adzkiya International of Computer Science and Information Technology (AIoCSIT) Journal, vol. 1, no. 2, pp. 62–68, Nov. 2020, doi: 10.55311/aiocsit.v1i2.91.
S. Suhirman, A. T. Hidayat, W. A. Saputra, and S. Saifullah, “Website-Based E-Pharmacy Application Development to Improve Sales Services Using Waterfall Method,” International Journal of Advances in Data and Information Systems, vol. 2, no. 2, pp. 114–129, Oct. 2021, doi: 10.25008/ijadis.v2i2.1226.
S. Raut, S. Moharana, S. Sahoo, R. Jena, and P. Patra, “Design and Usage of a Digital E-Pharmacy Application Framework,” in Predictive Analytics in Cloud, Fog, and Edge Computing, Cham: Springer International Publishing, 2023, pp. 91–105. doi: 10.1007/978-3-031-18034-7_6.
R. F. Syafariani, D. Ginanjar, and E. N. Hayati, “Website-Based Information System on Drug Purchases and Sales at Pharmacy,” Jurnal Teknologi Informasi dan Pendidikan, vol. 14, no. 2, pp. 172–177, Feb. 2022, doi: 10.24036/jtip.v14i2.448.
S. I. Ghanem, E. Hamshary, L. Matar, and A. Morsy, “Enhancing Healthcare Service with Firebase Integration and Intelligent Chatbot Deployment,” in 2024 Intelligent Methods, Systems, and Applications (IMSA), IEEE, Jul. 2024, pp. 550–555. doi: 10.1109/IMSA61967.2024.10652750.
M. A. Dhina, G. Hadisoebroto, S. R. Mubaroq, and I. Gustiana, “Implementation of digital performance assessment to measure pharmacy physics laboratory skills,” Momentum: Physics Education Journal, pp. 65–72, Jan. 2021, doi: 10.21067/mpej.v5i1.5146.
N. N. B. Hamid and T. Anwar, “The MedMaps apps: Mobile application for finding, managing and commercialize pharmacy,” in 2017 6th ICT International Student Project Conference (ICT-ISPC), IEEE, May 2017, pp. 1–5. doi: 10.1109/ICT-ISPC.2017.8075306.
T. Dharmada, J. Wiratama, and A. Faza, “Leveraging COBIT 2019 Framework for Recommending ERP System Module Development at Cardboard Manufacturing Industry,” Journal of Information Systems and Informatics, vol. 6, no. 2, pp. 1195–1214, Jun. 2024, doi: 10.51519/journalisi.v6i2.764.
B. Y. Fitriyani and A. H. Muhammad, “COBIT 2019 for Enhanced ICT Governance: A Case Study at a Higher Education Institution,” Journal of Information Systems and Informatics, vol. 7, no. 1, pp. 45–62, Mar. 2025, doi: 10.51519/journalisi.v7i1.972.
M. A. Lanure, F. Maulana, and M. Lubis, “Assessment of IT Maturity Level and Roadmap Preparation for Improving Governance Based on COBIT 5 (Case Study: XYZ Company),” in 2022 1st International Conference on Information System & Information Technology (ICISIT), IEEE, Jul. 2022, pp. 31–36. doi: 10.1109/ICISIT54091.2022.9872860.
Y. Guo and Y. Zeng, “The impact of government support on port industry competitiveness: A qualitative exploration,” Journal of Infrastructure, Policy and Development, vol. 8, no. 5, p. 5552, May 2024, doi: 10.24294/jipd.v8i5.5552.
A. Susanto, A. R. Arjuni, W. Ikram, and R. Rismayani, “Android-Based Introduction to Agricultural Crops and Pests,” Journal of Information Systems and Informatics, vol. 4, no. 2, pp. 385–397, Jun. 2022, doi: 10.51519/journalisi.v4i2.263.
U. A. Madaminov and M. R. Allaberganova, “Firebase Database Usage and Application Technology in Modern Mobile Applications,” in 2023 IEEE XVI International Scientific and Technical Conference Actual Problems of Electronic Instrument Engineering (APEIE), IEEE, Nov. 2023, pp. 1690–1694. doi: 10.1109/APEIE59731.2023.10347828.
B. M. Esiefarienrhe and T. J. Moemi, “UML Design of Business Intelligence System for Small-Scale Enterprises,” Journal of Information Systems and Informatics, vol. 6, no. 1, pp. 495–513, Mar. 2024, doi: 10.51519/journalisi.v6i1.672.
P. K. Ayuningtyas, D. Atmodjo WP, and P. Rachmadi, “Performance And Functional Testing With The Black Box Testing Method,” International Journal of Progressive Sciences and Technologies, vol. 39, no. 2, p. 212, Jul. 2023, doi: 10.52155/ijpsat.v39.2.5471.
A. Maspupah, “Literature Review: Advantages and Disadvantages of Black Box and White Box Testing Methods,” Jurnal Techno Nusa Mandiri, vol. 21, no. 2, pp. 151–162, Sep. 2024, doi: 10.33480/techno.v21i2.5776.
P. Germanakos, Z. Lekkas, C. Amyrotos, and P. Andreou, “Proposing a Perceived Expertise Tool in Business Data Analytics,” in Adjunct Proceedings of the 29th ACM Conference on User Modeling, Adaptation and Personalization, New York, NY, USA: ACM, Jun. 2021, pp. 142–149. doi: 10.1145/3450614.3462236.
S. Abbasnasab Sardareh, G. T. L. Brown, and P. Denny, “Comparing four contemporary statistical software tools for introductory data science and statistics in the social sciences,” Teach Stat, vol. 43, no. S1, Jul. 2021, doi: 10.1111/test.12274.
R. Tezza and G. L. Vargas, “Scale to measure usability in Mobile Crowd Sensing (MCS) applications,” Journal of Statistics and Management Systems, vol. 25, no. 3, pp. 501–520, Apr. 2022, doi: 10.1080/09720510.2021.1878631.
L. M. Tonetto, C. L. P. Copetti, P. Brust-Renck, C. de Lima Amorim, L. P. Kowalski, and G. B. de Carvalho, “Assessing user experience with services: measuring subjective well-being in oncology hospitals,” BMC Health Serv Res, vol. 25, no. 1, p. 796, Jun. 2025, doi: 10.1186/s12913-025-12965-6.
B. V. Tulus and A. R. Tanaamah, “Design of Information Technology Governance in Educational Institutions Using COBIT 2019 Framework,” Journal of Information Systems and Informatics, vol. 5, no. 1, pp. 31–43, Feb. 2023, doi: 10.51519/journalisi.v5i1.408.
K. Leonardo and R. Latuperissa, “Information Technology Governance Design in Trading Companies Using the COBIT 2019 Framework,” Journal of Information Systems and Informatics, vol. 6, no. 3, pp. 1466–1483, Sep. 2024, doi: 10.51519/journalisi.v6i3.798.
Abstract views: 1039 times
Download PDF: 308 times
Copyright (c) 2025 Journal of Information Systems and Informatics
This work is licensed under a Creative Commons Attribution 4.0 International License.
- I certify that I have read, understand and agreed to the Journal of Information Systems and Informatics (Journal-ISI) submission guidelines, policies and submission declaration. Submission already using the provided template.
- I certify that all authors have approved the publication of this and there is no conflict of interest.
- I confirm that the manuscript is the authors' original work and the manuscript has not received prior publication and is not under consideration for publication elsewhere and has not been previously published.
- I confirm that all authors listed on the title page have contributed significantly to the work, have read the manuscript, attest to the validity and legitimacy of the data and its interpretation, and agree to its submission.
- I confirm that the paper now submitted is not copied or plagiarized version of some other published work.
- I declare that I shall not submit the paper for publication in any other Journal or Magazine till the decision is made by journal editors.
- If the paper is finally accepted by the journal for publication, I confirm that I will either publish the paper immediately or withdraw it according to withdrawal policies
- I Agree that the paper published by this journal, I transfer copyright or assign exclusive rights to the publisher (including commercial rights)
