Model Arsitektur Multi-Tenant Berbasis Role-Based Access Control pada Sistem Manajemen Waralaba
Abstract
Franchise Management Systems (FMS) in Micro, Small, and Medium Enterprises (MSMEs) that use a multi-investor model frequently face fundamental issues such as information asymmetry and lack of accountability, mainly due to an inadequate single-owner architecture that hinders investors from validating transaction data. This research applied the Design Science Research (DSR) methodology to design a new FMS architecture model supported by three pillars: a multi-tenant architecture for data isolation, a granular Role-Based Access Control (RBAC) model for separating authority, and a database snapshotting pattern to ensure the integrity of historical data and financial reports. Functional and User Acceptance Testing (UAT) confirmed that the proposed artifact successfully provided real-time data transparency for investors, operational efficiency for branch managers, and centralized monitoring capability for central management. The main contribution of this study is the end-to-end integration of these three pillars, which is crucial for creating verified accountability within the franchise ecosystem.
Keywords: Franchise Management System; Multi-Tenant Architecture; Role-Based Access Control; Data Transparency; Design Science Research.
Abstrak
Sistem manajemen waralaba (FMS) pada UMKM dengan model multi-investor menghadapi masalah fundamental asimetri informasi dan kurangnya akuntabilitas akibat arsitektur single-owner yang tidak memadai, sehingga investor kesulitan memvalidasi data transaksi. Penelitian ini telah menerapkan metodologi Design Science Research (DSR) untuk merancang, mengimplementasikan, dan mengevaluasi sebuah artefak berupa model arsitektur FMS baru. Arsitektur ini ditopang oleh tiga pilar utama: arsitektur multi-tenant untuk isolasi data, model Role-Based Access Control (RBAC) granular untuk memisahkan wewenang, dan pola database snapshotting untuk integritas data historis. Hasil pengujian fungsional dan UAT secara konklusif memvalidasi bahwa artefak yang diusulkan berhasil menyediakan transparansi data real-time bagi investor, efisiensi operasional, dan kapabilitas pemantauan terpusat. Kontribusi utama penelitian ini adalah integrasi end-to-end dari ketiga pilar tersebut, yang krusial untuk menciptakan akuntabilitas yang terverifikasi dalam ekosistem waralaba.
Kata kunci: Franchise Management System; Arsitektur Multi-Tenant; Role-Based Access Control; Transparansi Data; Design Science Research.
References
F. Sandi, “UKM makanan di RI tembus 1,7 juta unit, serap 3,6 juta pekerja,” CNBC Indonesia, Jun. 6, 2024. [Online]. Available: https://www.cnbcindonesia.com/entrepreneur/ 20240606192846-25-544554/ukm-makanan-di-ri-tembus-17-juta-unit-serap-36-juta-pekerja.
A. Suhargo, Marcelino, S. Megawan, and Darwin, “Development of a mobile-based Point of Sale (POS) application to help MSMEs,” Jurnal Janitra Informatika dan Sistem Informasi, vol. 5, pp. 1-12, 2025.
Fitri and R. A. F. Halik, “Peran digital marketing dan inovasi produk terhadap kinerja bisnis yang berkelanjutan pada usaha mikro dan kecil agribisnis di Polewali Mandar,” Jurnal Ilmu Sosial dan Humaniora, vol. 12, no. 3, pp. 556–563, 2023, doi: 10.23887/jish.v12i3.67832.
I. N. Fatimah, T. S. Pamastutiningtyas, and E. S. Anafih, “Pengaruh sistem informasi akuntansi dalam pengambilan keputusan manajemen, efisiensi operasional perusahaan, dan pengendalian internal perusahaan,” Journal of Sustainability and Science Economic, vol. 2, no. 1, pp. 39–49, 2024, doi: 10.62337/jsse.v2i1.13.
R. A. Priambodo, “Dampak penerapan sistem informasi akuntansi pada efisiensi operasional usaha mikro kecil dan menengah,” Jurnal Manajemen, Akuntansi, dan Ekonomi, vol. 14, No. 2, pp. 32-41, 2025.
A. Frastya, S. H. Wijoyo, and D. Pramono, “Pengembangan sistem informasi aplikasi Point of Sales (POS) berbasis website menggunakan pendekatan metode waterfall (Studi Kasus: Yatai Tori),” Jurnal Pengembangan Teknologi Informasi dan Ilmu Komputer, vol. 9, no. 7, pp. 102-112, Jul. 2025.
B. M. Sidhunata et al., “Point of sales (POS) system design using Design Thinking Framework for motorcycle workshop,” Journal of Information Systems and Informatics, vol. 5, no. 3, pp. 874–886, Sep. 2023, doi: 10.51519/journalisi.v5i3.515.
W. Hashim and N. A. Hussein, “Securing cloud computing environments: An analysis of multi-tenancy vulnerabilities and countermeasures,” SHIFRA, pp. 8-16, Feb. 2024.
S. Pushpan, “Multi-tenant architecture: A comprehensive framework for building scalable SaaS applications,” International Journal of Scientific Research in Computer Science, Engineering and Information Technology, vol. 10, no. 6, pp. 860–867, Nov.-Dec. 2024, doi: 10.32628/CSEIT241061151.
R. Hendrastuti and R. F. Harahap, “Agency theory: Review of the theory and current research,” Jurnal Akuntansi Aktual, vol. 10, no. 1, pp. 85-94, Feb. 2023, doi: 10.17977/um004v10i12023p085.
Y. A. Marquis, “From theory to practice: Implementing effective Role-Based Access Control strategies to mitigate insider risks in diverse organizational contexts,” Journal of Engineering Research and Reports, vol. 26, no. 5, pp. 138–154, Apr. 2024, doi: 10.9734/JERR/2024/v26i51141.
T. Mehra, “The critical role of Role-Based Access Control (RBAC) in securing backup, recovery, and storage systems,” International Journal of Science and Research Archive, vol. 13, no. 1, pp. 1192–1194, 2024, doi: 10.30574/ijsra.2024.13.1.1733.
W. F. R. Assidiq, F. W. Putro, and A. M. Amri, “Evaluating software quality in a point of sales system in a fast-food restaurant using the McCall model,” Jurnal Teknik Informatika (JUTIF), vol. 6, no. 4, pp. 2317-2330, 2025.
M. Handayani and T. D. Natalia, “The influence of utilizing accounting information systems on financial transparency and accountability,” International Journal of Science and Research Archive, vol. 15, pp. 1140–1147, 2025.
J. Windsperger and X. Amado, “Strategic management of corporate social responsibility in international franchise networks,” Revista Estrategia Organizacional, vol. 14, no. 1, pp. 7–39, 2025, doi: 10.22490/issn.2539-2786.
How To Cite This :
Refbacks
- There are currently no refbacks.
