Designing the Foundation of a Multi-Tenant and Surrogate Key-Based Nusa Praja Village Government System on the Nusa Eka Platform

Sri Rahayu; Aulia Hamdi; Lina Nur Afifah; Aulia Suryaning Tyas; Rizki Cahya Putri; Mayza Nurul Khasanatun Nisa; Intan Nur Sifa; Purnia Setiawati

doi:10.59934/jaiea.v5i3.2371

Authors

Sri Rahayu Universitas Amikom Purwokerto
Aulia Hamdi
Lina Nur Afifah
Aulia Suryaning Tyas
Rizki Cahya Putri
Mayza Nurul Khasanatun Nisa
Intan Nur Sifa
Purnia Setiawati

DOI:

https://doi.org/10.59934/jaiea.v5i3.2371

Keywords:

E-Government, Multi-Tenant, Surrogate Key, System Design

Abstract

Village government administration in Indonesia is still largely manual, resulting in service inefficiencies and the potential loss of sensitive population data. The purpose of this research is to create the architectural foundation of a village government information system called NUSA PRAJA, which is part of the NUSAEKA multi-tenant Software as a Service (SaaS) platform. This research applies the Multi-Tenant Isolation concept to ensure data security and separation between villages, as well as the Surrogate Key concept to protect residents' National Identification Number (NIK) data from leaks. The research method used is Waterfall with the stages of requirements analysis, system architecture design, and database design. The results of the research are a multi-tenant system architecture design based on a shared database with tenant_id filters, an Entity Relationship Diagram (ERD) design with 14 main tables, and a flowchart design for three user roles. This project is expected to be a strong foundation for building a secure, scalable, and easy-to-use digital village system for village governments throughout Indonesia.

Downloads

Download data is not yet available.

References

D. Widiyanto, “Sistem Pelayanan Surat Dan Pengelolaan Data Kependudukan Studi Kasus Desa Jelok Kecamatan Kaligesing Kabupaten Purworejo,” Jurnal Ekonomi dan Teknik Informatika, vol. 13, no. 1, pp. 25–31, Apr. 2025, doi: 10.37601/jneti.v13i1.326.

J. M. Sagita Putri, P. Korespondensi, A. Thyo Priandika, and Y. Rahmanto, “Sistem Informasi Administrasi Surat Menyurat Pada Kantor Balai Desa Jatimulyo,” CHAIN : Journal of Computer Technology, vol. 1, no. 1, 2023.

J. Dwi Mulyanto, “Implementasi Sistem Informasi Pelayanan Administrasi Kependudukan Berbasis Web,” 2022.

A. L. Romadhon and M. Maryam, “RANCANG BANGUN SISTEM INFORMASI LAYANAN ADMINISTRASI DESA BERBASIS WEB DI DESA DUKUH,” JIPI (Jurnal Ilmiah Penelitian dan Pembelajaran Informatika), vol. 8, no. 2, pp. 514–524, May 2023, doi: 10.29100/jipi.v8i2.3553.

G. Li, W. Fang, and K. Mao, “Mathematical Modeling and Algorithm Application Research on Data Security Isolation and Sharing Mechanism in Cloud Multi-tenant Environment Based on Blockchain and Federated Learning”.

T. Agustina, “Implementasi Metode Data Encryption Standard (Des) Untuk Enkripsi Dan Dekripsi Data Kependudukan Desa Wonoharjo,” Jurnal Dinamika Informatika, vol. 14, no. 1, 2025.

N. Asuni, “Reversible Numeric Composite Key (RNCK),” Jun. 2023, [Online]. Available: http://arxiv.org/abs/2306.04353

D. Sunardi, R. Guntur Alam, J. Raya Kampung Bali, and K. Bengkulu, “PERANCANGAN APLIKASI PENGOLAHAN DATA WARGA DESA TANJUNG DALAM BERBASIS WEB,” 2025.

A. Nanda, M. Jamil, A. Khoirunnita, and R. Alex, “Digitalisasi Pelayanan Administrasi Desa Menggunakan Website E-surat Pada Desa Handil Terusan,” Ilmu Komputer Untuk Masyarakat, vol. 5, no. 2, pp. 60–69, 2024.

E. Mardinata et al., “PARTA: Jurnal Pengabdian Kepada Masyarakat Transformasi Digital Desa Melalui Sistem Informasi Desa (SID): Meningkatkan Kualitas Pelayanan Publik dan Kesejahteraan Masyarakat History Artikel,” vol. 4, p. 2023, [Online]. Available: http://journal.undiknas.ac.id/index.php/parta.

A. A and A. Meizary, “Pengembangan Website Desa dalam Peningkatan Informasi dan Data Penduduk Di Era Digital Desa Trimulyo,” Jurnal Pengabdian Masyarakat Tapis Berseri (JPMTB), vol. 2, no. 2, pp. 91–96, Nov. 2023, doi: 10.36448/jpmtb.v2i2.66.

M. RATULIU and N. Hidayasari, “PERANCANGAN SISTEM INFORMASI WEBSITE DESA UNTUK PELAYANAN SURAT-MENYURAT DENGAN PENDEKATAN SECURE SOFTWARE DEVELOPMENT LIFE CYCLE (SSDLC),” Rabit : Jurnal Teknologi dan Sistem Informasi Univrab, vol. 11, no. 1, pp. 2040–2054, Mar. 2026, doi: 10.36341/rabit.v11i1.7589.

A. M. Al-Ansi, A. Garad, M. Jaboob, and A. Al-Ansi, “Elevating e-government: Unleashing the power of AI and IoT for enhanced public services,” Heliyon, vol. 10, no. 23, p. e40591, Dec. 2024, doi: 10.1016/j.heliyon.2024.e40591.

“IEEE Transactions on Intelligent Transportation Systems publication information,” IEEE Transactions on Intelligent Transportation Systems, vol. 21, no. 12, pp. C2–C2, Dec. 2020, doi: 10.1109/TITS.2020.3037564.