PENERAPAN SISTEM BASIS DATA DALAM PENGELOLAAN ANGGARAN PEMELIHARAAN JALAN DI KOTA SEMARANG
PENERAPAN SISTEM BASIS DATA DALAM PENGELOLAAN ANGGARAN PEMELIHARAAN JALAN DI KOTA SEMARANG
DOI:
https://doi.org/10.32497/bangunrekaprima.v11i2.7382Keywords:
Database system, PKRMS, road maintenance, budgetingAbstract
Improperly managed road conditions have led to increased maintenance costs and a decline in transportation service quality in Semarang City. Inefficiencies in road maintenance budget managementee often occur due to limited data availability and the lack of an integrated system. This study aims to implement a database system for managing road maintenance budgets using the Provincial Kabupaten Road Management System (PKRMS) developed with Microsoft Access. The research methodology involves the collection of primary data through field surveys and road condition inventories, as well as secondary data obtained from relevant government agencies. The collected data were processed within the PKRMS framework to generate cost estimates for maintenance activities categorized as routine maintenance, periodic maintenance, rehabilitation, and road widening. The analysis results show that road segments with severe damage require the highest budget allocation, particularly for rehabilitation work, whereas roads in good condition only require routine maintenance with relatively lower costs. The implementation of this database system has proven effective in improving efficiency, accuracy, and transparency in the planning and decision-making process for road maintenance budget allocation in Semarang City.
References
Ahmed, S., et al. (2019). Economic Evaluation of Road Maintenance Strategies. Transportation Research Part A: Policy and Practice, 124, 120–132.
Brown, H. & Lee, S. (2021). Digital Transformation in Public Infrastructure: A Study of Database Applications in Road Management. Digital Infrastructure Journal, 5(1), 33–50.
Carter, S., Roberts, M., & Nguyen, L. (2020). Data-Driven Approaches to Optimize Resource Allocation in Road Maintenance: A Comparative Study. International Journal of Sustainable Transportation, 14(2), 178–191.
Chen, W., & Wang, L. (2021). Optimizing Resource Allocation in Road Infrastructure Maintenance Using Data-Driven Methods. Journal of Transportation Research, 75(1), 55–68.
Garcia, M., & Hernandez, P. (2018). Integration of Budgeting Techniques in Road Maintenance: A Case Study Approach. International Journal of Construction Management, 18(2), 152–165.
Garcia, L. & Martinez, J. (2022). Integration of Data Management Systems in Municipal Budgeting for Infrastructure Projects. International Journal of Public Administration in the Digital Era, 15(2), 215–232.
Ivanov, A. (2020). Smart Maintenance Strategies for Urban Infrastructure: Integrating Database Systems in Decision Making. Journal of Civil Engineering and Management, 26(4), 289–302.
Kumar, R. & Gupta, P. (2018). Database Integration for Infrastructure Management: A Case Study of Urban Road Systems. Journal of Infrastructure Engineering, 24(5), 04018035.
Lee, J., & Park, C. (2020). Implementation of Database Management Systems in Infrastructure Asset Management. Journal of Infrastructure Systems, 26(3), 04020027.
Li, X., et al. (2018). Innovative Approaches in Infrastructure Maintenance Planning. Transportation Research Record, 2672(7), 45–58.
Nguyen, P. & Tran, Q. (2020). Optimizing Public Budgeting through Data Integration: A Case Study of Infrastructure Maintenance. Public Sector Innovation Journal, 5(3), 159–174.
Patel, R. & Choi, M. (2021). Implementing Database Systems in Urban Maintenance: Challenges and Opportunities. Journal of Urban Planning, 27(4), 345–361.
Perdana, V. G. S. (2019). Pemanfaatan Microsoft Access dalam Pengarsipan Dokumen pada PT Kerta Rajasa Raya. Institut Bisnis dan Informatika Stikom Surabaya.
Pusat Data dan Informasi Kemenristek/BRIN. (2021). Kajian Kebijakan dan Sistem Pengelolaan Data Penelitian. Kementerian Riset dan Teknologi/Badan Riset dan Inovasi Nasional.
Sato, T. & Suzuki, K. (2021). Application of Microsoft Access in Managing City Infrastructure: A Comparative Analysis. Journal of Information Technology and Urban Development, 11(1), 45–60.
Smith, J. & Anderson, T. (2019). Leveraging Information Technology for Optimizing Road Maintenance Budgets: Challenges and Opportunities. Transportation Research Part D: Transport and Environment, 67, 123–135.
Wang, L. & Zhang, Y. (2019). The Role of Relational Databases in Enhancing Public Infrastructure Management: Insights from Urban Road Networks. Journal of Urban Technology, 26(3), 45–61.
Yoon, S. (2017). Analysis of Pavement Deterioration Under Heavy Traffic: An International Perspective. International Journal of Pavement Engineering, 18(4), 329–341.
Downloads
Published
Issue
Section
License
This work is licensed under a Creative Commons Attribution 4.0 International License.
The copyright of the received article shall be assigned to the journal as the publisher of the journal. The intended copyright includes the right to publish the article in various forms (including reprints). The journal maintains the publishing rights to the published articles.
This work is licensed under a Creative Commons Attribution 4.0 International License.
