Abstract
Database design is a fundamental component in the development of Regional Information Systems (RIS), as it determines data quality, inter-agency integration, system performance, and the sustainability of public services. This study aims to analyze the impact of database design on the success of RIS implementation by examining aspects of data quality, system integration, operational efficiency, information security, decision-making support, and system scalability. The research employs a literature review and conceptual analysis of various database design models and their implementation within local government environments. The results indicate that effective database design characterized by standardized data structures, clear inter-table relationships, strong data validation, and multi-layered security mechanisms significantly enhances the effectiveness and accuracy of regional data management. Conversely, suboptimal database design leads to data duplication, low interoperability among local government units, slower public service processes, and an increased risk of data breaches. Therefore, the success of Regional Information Systems is strongly influenced by the quality of database design as the primary foundation for data processing and information provision in local governments.
References
Alavi, M., & Leidner, D. E. (2001). Review: Knowledge management and knowledge management systems: Conceptual foundations and research issues. MIS Quarterly, 25(1), 107–136. https://doi.org/10.2307/3250961
Chen, P. P. S. (1976). The entity-relationship model: Toward a unified view of data. ACM Transactions on Database Systems, 1(1), 9–36. https://doi.org/10.1145/320434.320440
Connolly, T., & Begg, C. (2015). Database systems: A practical approach to design, implementation, and management (6th ed.). Pearson Education.
Dawis, A. M., Rahmayanti, D., Rachman, T., Impron, A., & Kelen, Y. P. K. (2025). Pendekatan modern dalam analisis dan desain teknologi informasi. Get Press Indonesia
DeLone, W. H., & McLean, E. R. (2003). The DeLone and McLean model of information systems success: A ten-year update. Journal of Management Information Systems, 19(4), 9–30. https://doi.org/10.1080/07421222.2003.11045748
Diani, R. O., & Manar, D. G. (2024). Analisis pelayanan online Sirancak Dinas Kependudukan dan Pencatatan Sipil Kota Padang (studi tentang keandalan, ketanggapan, dan jaminan layanan). Journal of Politic and Government Studies, 13(3), 33–46.
Ellyusman, S. (2017). Analisis kualitas sistem informasi akademik menggunakan metode importance performance analysis (ipa)(studi kasus pada website portal akademik universitas xyz BANDUNG). Jurnal Kajian Informasi & Perpustakaan, 5(1), 51-64. https://doi.org/10.24198/jkip.v5i1.11908
Elmasri, R., & Navathe, S. B. (2016). Fundamentals of database systems (7th ed.). Pearson.
Ghozali, I. (2018). Aplikasi analisis multivariate dengan program IBM SPSS 23. Badan Penerbit Universitas Diponegoro.
Hendrawan, I. R., Antara, P., Indraswari, A. D., Widihasani, A. F., & Utami, E. (2023). Analisis aspek kualitas skema basis data pada sistem informasi tour dan travel. JIKO (Jurnal Informatika dan Komputer), 7(1), 37-45. https://dx.doi.org/10.26798/jiko.v7i1.655
Kementerian Dalam Negeri Republik Indonesia. (2021). Pedoman sistem informasi pemerintahan daerah (SIPD). Kemendagri.
Khosla, I. (2021). Book review: Social research methods: Qualitative and quantitative approaches. Frontiers in Psychology, 12. https://doi.org/10.3389/fpsyg.2021.696828
Matondang, N., & Warsuta, B. (2025). Perancangan model arsitektur untuk mendukung persyaratan big data dan cloud computing pada PTNB. Informatik: Jurnal Ilmu Komputer, 21(2), 102–114. https://doi.org/10.52958/iftk.v21i2.11925
Nugroho, R. (2020). E-government di Indonesia: Konsep, strategi, dan implementasi. Elex Media Komputindo.
Siregar, D. D. P. (2011). Faktor-faktor yang mempengaruhi kinerja kepala kelurahan dalam melaksanakan tugas pemerintahan di Kota Medan Provinsi Sumatera Utara (Thesis Magister, Universitas Sumatera Utara).
Siswati, R., & Riharjo, I. B. (2015). Sistem informasi manajemen aset dan penyajian aset tetap dalam laporan keuangan. Jurnal Ilmu dan Riset Akuntansi (JIRA), 4(6), 1-18.
Sugiyono. (2016). Metode penelitian kuantitatif, kualitatif, dan R&D. Alfabeta.
Wardiana, W. (2002). Perkembangan teknologi informasi dan dampaknya terhadap dunia pendidikan dan pemerintahan. Jurnal Teknologi Informasi dan Komunikasi, 1(1), 1–10.
Wardiana, W. (2002). Perkembangan teknologi informasi di Indonesia. In Seminar dan Pameran Teknologi Informasi
Zein, H. H. M., & Septiani, S. (2024). Digitalisasi pemerintahan daerah: Katalis untuk integrasi dan optimasi good governance. Sada Kurnia Pustaka.
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
Copyright (c) 2025 Viktor Dirman Jaya Buulolo, Syakirah Azzahra, Dealova Venolika Br Sembiring, Nur Citra Hasanah, Irawan Irawan