Optimalisasi Database dan Pembuatan Guidebook Layanan Sistem Informasi Desa Pupuan
Main Article Content
Abstract
Article Summary
The rapid development of information technology has impacted the way people think and perceive various activities. This swift progress, along with its wide-ranging potential applications, opens up opportunities for quick access to and dissemination of information. In village governance, information technology is used to quickly disseminate information and provide village services. The village of Pupuan has implemented the OpenSID village information system. However, it is not yet fully utilized by the village staff because the data on the website has not been fully entered. Additionally, there are no guidelines for submitting requests on the village website. Based on this situation, the researcher conducted activities such as optimizing the village website database, creating articles on the village website, and creating user manuals and instructional videos for the website's services. These activities are expected to provide the benefits of a village information system to the government of Pupuan Village and the local community. As a result, the OpenSID website of Pupuan Village was successfully managed and developed through these activities, and the village staff gained a better understanding of the website's services through the provided training and user manuals.
Keywords
Article Keywords
Downloads
Article Details

This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.
Authors who publish with this journal agree to the following terms:
- Authors retain copyright and grant the journal right of first publication with the work simultaneously licensed under a Creative Commons Attribution License (CC-BY 4.0) that allows others to share the work with an acknowledgement of the work's authorship and initial publication in this journal.
- Authors are able to enter into separate, additional contractual arrangements for the non-exclusive distribution of the journal's published version of the work (e.g., post it to an institutional repository or publish it in a book), with an acknowledgement of its initial publication in this journal.
- Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) prior to and during the submission process, as it can lead to productive exchanges, as well as earlier and greater citation of published work.
Laksamana, M., Gusman, A., Arif, M., Fadli, M., Anam, M., & Utami, E. (2021). Analisa dan optimalisasi rancangan basis data aplikasi pencatat keuangan digital. Dinamik, 26(1), 23-30. https://doi.org/10.35315/dinamik.v26i1.8276
Maita, I., Mulyani Egust, B. W., Salisah, F. N., & Rahmawita, M. (2022). Perancangan enterprise architecture untuk mendukung transformasi digital usaha kecil dan menengah (UMKM) menggunakan TOGAF ADM. Jurnal Ilmiah Rekayasa Dan Manajemen Sistem Informasi, 8(1), 48–54. https://doi.org/10.24014/RMSI.V8I1.16590
Marliana, R., Sejati, W., Nisa, W., Pujayanti, U., Sopian, R., & Noergana, W. (2022). Rancang bangun website desa citengah untuk pengembangan promosi potensi desa. JPPM (Jurnal Pengabdian Dan Pemberdayaan Masyarakat, 6(1), 193. https://doi.org/10.30595/jppm.v6i1.7667
Muhandhis, I. (2022). Website development and performance improvement of village apparatus in beton village. Prosiding Konferensi Nasional Pengabdian Kepada Masyarakat Dan Corporate Social Responsibility (Pkm-Csr), 5, 1-10. https://doi.org/10.37695/pkmcsr.v5i0.1752
Nasrulloh, M. F., Wahono, P., Amanah, F. N., Mufarrohah, C., & Satiti, W. S. (2022). Optimalisasi penggunaan aplikasi Open SID pada sistem administrasi pemerintah desa Gabusbanaran. Jumat Informatika: Jurnal Pengabdian Masyarakat, 2(3), 142–146. https://doi.org/10.32764/abdimas_if.v2i3.2166
Pamungkas, R. (2018). Optimalisasi query dalam basis data MySQL menggunakan index. Research Computer Information System & Technology Management, 1(1), 27. https://doi.org/10.25273/research.v1i1.2453
Puji Rianto, S., Bayu Wahyono, N., Kurnia, W. M. A., & Wendratama, E. (2017). Sistem informasi desa dan akses informasi. PR2Media.
Ramsi, D. (2023). Perbandingan performa waktu eksekusi kueri antara database Oracle dan SQL Server. Sitasi, 3(1), 254-259. https://doi.org/10.33005/sitasi.v3i1.369
Rasyid, H. A. N., & Rahmawati, D. E. (2023). Pengelolaan website desa untuk optimalisasi data potensi desa dalam sistem informasi desa (SID). JCOMENT (Journal of Community Empowerment), 4(1), 14–21. https://doi.org/10.55314/jcoment.v4i1.497
Samidi, & Hariyanto, H. (2023). Performance tuning Oracle 11g database melalui inisial parameter, struktur database, dan SQL tuning. Studi pada ERP Sisforbun Dana Pensiun Perkebunan (Dapenbun). Techno Com, 22(2), 400-408. https://doi.org/10.33633/tc.v22i2.7831
Tamrin, M. H., Umiyati, S., Lubis, L., & Raharja, W. T. (2022). Optimalisasi pemanfaatan sistem informasi desa dalam pendataan dan pemantauan penduduk pada masa pandemi COVID-19. JPM (Jurnal Pemberdayaan Masyarakat), 07(1), 761–770.
Tomy Dwi Cahyono, Erwin Mardinata, Ryan Suarantalla, Jannatun Aliyah, & Wilia Ismiyarti. (2024). Optimasi pelayanan publik melalui sosialisasi dan pelatihan penggunaan OpenSID di masyarakat Desa Tatede. https://journal.universitaspahlawan.ac.id/index.php/cdj/article/view/24004/16928
Zulmaizar, M., Khairat, U., & Tamin, R. (2021). Digital profil desa menggunakan website untuk meningkatkan potensi desa Pappandangan. Sipissangngi Jurnal Pengabdian Kepada Masyarakat, 1(1), 14. https://doi.org/10.35329/sipissangngi.v1i1.1815.