Design and Development of a Web-based One Data Portal Information System with Administrator and OPD Publisher Modules using the Laravel Framework: A Case Study of South Tangerang City

siska siska, Putri Yanti, Muhamad Riza Rahmatullah, Ibnu Mas’ud, Sri Widiastuti

Abstract


Presidential Regulation No. 39 of 2019 establishes the One Data Indonesia Policy, which requires government agencies to publish open data that are standardized and interconnected. However, the South Tangerang City Government does not yet have a centralized digital platform to facilitate Regional Government Organizations (Organisasi Perangkat Daerah or OPD) in publishing sectoral data in a structured manner for public access. This study aims to design and develop a web-based One Data Portal Information System using the Laravel framework. The proposed system consists of two main modules: the Administrator module and the OPD Publisher module. The system was developed using the Waterfall methodology, which comprises four phases: requirements analysis, system design, implementation, and testing. Each phase was carried out sequentially to ensure a systematic and well-organized development process. During the system design phase, Unified Modeling Language (UML) was used to represent the system architecture and workflows through Use Case Diagrams and Activity Diagrams, complemented by an Entity Relationship Diagram (ERD) for database modeling. The implementation phase utilized Laravel 12, PHP 8.2, MySQL, and Bootstrap 5. The system incorporates role-based access control (RBAC) and involves four main actors: Public Users, OPD Publishers, the System, and Administrators/Verifiers. Dataset records are managed through four statuses: Draft, Pending, Published, and Rejected. System functionality was evaluated using Black-Box Testing with the Equivalence Partitioning and Boundary Value Analysis techniques across 40 test scenarios. In addition, usability was assessed using the System Usability Scale (SUS) involving 20 respondents. The Black-Box Testing results showed that all 40 test scenarios passed, yielding a 100% functional success rate with no functional failures. The SUS evaluation produced an average score of 83.75, which falls within the Excellent usability category. These findings demonstrate that the developed system meets its functional requirements and provides a user-friendly platform that is suitable for use by local government personnel in managing and publishing sectoral data.

Keywords


black-box testing; Laravel; one data portal; system usability scale; waterfall

Full Text:

PDF

References


A. Hermanto, S. Solimun, A. A. R. Fernandes, W. Wahyono, dan Z. Zulkarnain, “The Importance of Open Government Data for the Private Sector and NGOs in Indonesia,” Digital Policy, Regulation and Governance, Vol. 20, No. 4, pp. 293–309, 2018.

Presiden Republik Indonesia, Peraturan Presiden Nomor 39 Tahun 2019 tentang Satu Data Indonesia. Jakarta: Sekretariat Negara, 2019.

A. P. P. Anwar dan D. H. F. Manongga, “Perancangan Sistem Informasi berbasis web sebagai Media Pencatatan Perjalanan pada Kasus Kantor Pemerintah Kota Salatiga,” IT-Explore: Jurnal Penerapan Teknologi Informasi dan Komunikasi, Vol. 3, No. 3, pp. 348–358, 2024.

F. Sinlae, E. Irwanda, Z. Maulana, dan V. E. Syahputra, “Penggunaan Framework Laravel dalam membangun Aplikasi Website berbasis PHP,” Jurnal Siber Multi Disiplin, Vol. 2, No. 2, pp. 45–53, 2024.

T. Mary dan N. Febriyani, “Peningkatan Keamanan Sistem Informasi berbasis Laravel 12 dengan Rate Limiting dan Role-based Access Control (RBAC),” Jurnal Teknologi dan Sistem Informasi Bisnis, Vol. 7, No. 3, pp. 473–481, 2025.

I. K. Wirawan, A. Srirahayu, dan S. Sopingi, “Rancang Bangun Sistem Informasi Keuangan Sekolah berbasis Website,” Jurnal Teknologi dan Sistem Informasi Bisnis, Vol. 6, No. 4, pp. 639–648, 2024.

A. F. Ridwan, F. Ilham, R. T. Pratomo, dan A. W. Wibowo, “Rancang Bangun Sistem Informasi Keuangan Pribadi berbasis Web menggunakan Metode Waterfall (Studi Kasus: Kwartir Ranting Tigaraksa),” BINER: Jurnal Ilmu Komputer, Teknik dan Multimedia, Vol. 4, No. 1, pp. 1–10, 2026.

M. A. C. Gyver, M. Marhaeni, dan H. Arrang, “Rancang Bangun Sistem Informasi Manajemen Pendidikan pada Rumah Qur’an berbasis Web dengan Implementasi Role-based Access Control,” Jurnal Rekayasa Informasi, Vol. 12, No. 2, pp. 1– 10, 2023.

M. Rosidin, M. H. Z. Hamidi, dan W. Y. Sulistyo, “Perancangan Sistem Informasi Manajemen Asosiasi dengan Metode Waterfall dan RBAC di Majelis Diktilitbang Muhammadiyah,” Jurnal Teknologi dan Sistem Informasi Bisnis, Vol. 7, No. 3, pp. 1–12, 2025.

A. I. Lubis, F. Setiawan, S. Supardianto, N. Ardi, dan U. Erdiansyah, “Rancang Bangun Sistem Informasi Organisasi berbasis website menerapkan Metode Waterfall,” Bulletin of Computer Science Research, Vol. 5, No. 3, pp. 182–192, 2025.

R. T. Ardiansah dan D. Hidayatullah, “Penerapan Metode Waterfall pada Aplikasi Reservasi Lapangan Futsal berbasis Web,” Journal of Information Technology, Software Engineering and Computer Science, Vol. 1, No. 1, pp. 6–13, 2022.

G. S. Mahendra dan I. K. A. Asmarajaya, “Evaluation using Black Box Testing and System Usability Scale in the Kidung Sekar Madya application,” Sinkron: Jurnal dan Penelitian Teknik Informatika, Vol. 7, No. 4, pp. 2292–2302, 2022.

J. Brooke, “SUS: A Quick and Dirty Usability Scale,” dalam Usability Evaluation in Industry, P. W. Jordan, B. Thomas, B. A. Weerdmeester, dan I. L. McClelland, Eds. London: Taylor & Francis, 1996, pp. 189–194.

A. Bangor, P. Kortum, dan J. Miller, “Determining What Individual SUS Scores Mean: Adding an Adjective Rating Scale,” Journal of Usability Studies, Vol. 4, No. 3, pp. 114–123, 2009.

I. Syahrohim dan J. Parhusip, “Pengukuran Usability Aplikasi Web menggunakan SUS (System Usability Scale) dan Pengujian Black Box pada Website ICONPLUS-Warehouse,”Jurnal Informatika dan Teknik Elektro Terapan, Vol. 14, No. 1, pp. 1–10, 2026.




DOI: https://doi.org/10.32520/stmsi.v15i11.6668

Article Metrics

Abstract view : 0 times
PDF - 0 times

Refbacks

  • There are currently no refbacks.


Creative Commons License
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.