Semantic Object Model-Based Database Design for Archive Management: A Case Study at the South Sumatra Provincial Archives Service
Abstract
Purpose of the study: This research aims to design an integrated archive database system using the Semantic Object Model (SOM) approach to address the challenges of slow archive retrieval, high risk of loss, and non-compliance with Archive Retention Schedules at the South Sumatra Provincial Archives Service
Methodology: This qualitative research employed observation, interviews, and document analysis at the South Sumatra Provincial Archives Service. The database design followed three phases of SOM: conceptual (identifying semantic objects from archive forms and reports), logical (transforming objects into table relations), and physical (implementing in MySQL DBMS).
Main Findings: The research identified 19 semantic objects transformed into integrated database tables covering all archive types (active, inactive, vital, and static records). The design includes retention period attributes supporting Archive Retention Schedule compliance, with successful MySQL implementation.
Novelty/Originality of this study: This study introduces a comprehensive SOM-based archive database model integrating dynamic, vital, and static records with lending, media transfer, and retention control procedures in a unified design. Unlike previous semantic web applications focused on general data integration, this research addresses the specific regulatory requirements of government archive management based on actual user needs.
References
N. Hayatin, B. Mavindo, and E. B. Cahyono, “The development of mobile application based customer service system in Malang waste bank,” Kinet. Game Technol. Inf. Syst. Comput. Network, Comput. Electron. Control, vol. 2, no. 4, pp. 291–298, 2017, doi: 10.22219/kinetik.v2i4.266.
R. Thomas and D. Jackson, “A database in access for assessing vaccine serious adverse events,” Vaccine Dev. Ther., vol. 2298, p. 9, 2015, doi: 10.2147/vdt.s82427.
R. Fang et al., “The Chinese clinical sleep database: An innovative database system includes large-scale clinical data of chinese population,” Nat. Sci. Sleep, vol. 16, pp. 305–313, 2024, doi: 10.2147/NSS.S450578.
A. Krugliak, D. Draschkow, M. L. H. Võ, and A. Clarke, “Semantic object processing is modulated by prior scene context,” Lang. Cogn. Neurosci., vol. 39, no. 8, pp. 962–971, 2024, doi: 10.1080/23273798.2023.2279083.
D. P. Kartikasari, A. Tobing, A. Bhawiyuga, A. Kusyanti, and N. H. Purwaningtyas, “A store-forward method for biosignal acquisition in smart health care system using wearable iot device,” Kinet. Game Technol. Inf. Syst. Comput. Network, Comput. Electron. Control, vol. 4, no. 2021, pp. 51–58, 2021, doi: 10.22219/kinetik.v6i1.1154.
I. G. F. Wirganata, K. Agustini, and G. S. Santyadiputra, “Effectiveness of schoology-based e-module national journal of informatics engineering education media | 133,” vol. 7, no. 2, pp. 132–140, 2018.
N. Blavet et al., “Uncleprot (universal nuclear protein database of barley): The first nuclear protein database that distinguishes proteins from different phases of the cell cycle,” Nucleus, vol. 8, no. 1, pp. 70–80, 2017, doi: 10.1080/19491034.2016.1255391.
N. Hayatin, B. Mavindo, and E. B. Cahyono, “The development of mobile application based customer service system in Malang waste bank,” Kinet. Game Technol. Inf. Syst. Comput. Network, Comput. Electron. Control, vol. 2, no. 4, pp. 291–298, 2017, doi: 10.22219/kinetik.v2i4.266.
R. Thomas and D. Jackson, “A database in access for assessing vaccine serious adverse events,” Vaccine Dev. Ther., vol. 2298, p. 9, 2015, doi: 10.2147/vdt.s82427.
R. Fang et al., “The Chinese clinical sleep database: An innovative database system includes large-scale clinical data of chinese population,” Nat. Sci. Sleep, vol. 16, pp. 305–313, 2024, doi: 10.2147/NSS.S450578.
A. Krugliak, D. Draschkow, M. L. H. Võ, and A. Clarke, “Semantic object processing is modulated by prior scene context,” Lang. Cogn. Neurosci., vol. 39, no. 8, pp. 962–971, 2024, doi: 10.1080/23273798.2023.2279083.
D. P. Kartikasari, A. Tobing, A. Bhawiyuga, A. Kusyanti, and N. H. Purwaningtyas, “A store-forward method for biosignal acquisition in smart health care system using wearable iot device,” Kinet. Game Technol. Inf. Syst. Comput. Network, Comput. Electron. Control, vol. 4, no. 2021, pp. 51–58, 2021, doi: 10.22219/kinetik.v6i1.1154.
I. G. F. Wirganata, K. Agustini, and G. S. Santyadiputra, “Effectiveness of schoology-based e-module national journal of informatics engineering education media | 133,” vol. 7, no. 2, pp. 132–140, 2018.
N. Blavet et al., “Uncleprot (universal nuclear protein database of barley): The first nuclear protein database that distinguishes proteins from different phases of the cell cycle,” Nucleus, vol. 8, no. 1, pp. 70–80, 2017, doi: 10.1080/19491034.2016.1255391.
M. Maskur, “Designing a student information center chatbot using aiml as a web-based virtual assistant,” Kinetik, vol. 1, no. 3, p. 123, 2016, doi: 10.22219/kinetik.v1i3.47.
I. G. B. Budi Dharma and I Gusti Bagus Baskara Nugraha, “The implementation of enterprise resource planning during the product design process through the process of design thinking,” J. Nas. Pendidik. Tek. Inform., vol. 13, no. 3, pp. 460–470, 2024, doi: 10.23887/janapati.v13i3.80691.
A. P. Hanifah, Y. Fitrisia, and D. Hajar, “Web-based clinical service information system (case study: Annisa Medika Clinic) 2),” J. RESTI (Rekayasa Sist. dan Teknol. Informasi), vol. 2, no. 3, pp. 668–673, 2018, doi: 10.29207/resti.v2i3.513.
Y. Liu, S. Chen, H. Zhang, N. N. Xiong, and W. Liang, “Doe: A dynamic object elimination scheme based on geometric and semantic constraints,” Conn. Sci., vol. 35, no. 1, 2023, doi: 10.1080/09540091.2023.2293460.
H. Terada, H. Nagai, A. Tanaka, K. Tsuduki, and M. Kadowaki, “Atmospheric-dispersion database system that can immediately provide calculation results for various source term and meteorological conditions,” J. Nucl. Sci. Technol., vol. 57, no. 6, pp. 745–754, 2020, doi: 10.1080/00223131.2019.1709994.
Z. Cao et al., “A large scale training sample database system for intelligent interpretation of remote sensing imagery,” Geo-Spatial Inf. Sci., vol. 27, no. 5, pp. 1489–1508, 2024, doi: 10.1080/10095020.2023.2244005.
I. W. B. Permana, I. M. A. Wirawan, and I. G. P. Sindu, “learning in object-oriented programming subject for class xi rpl at state vocational high school 2 Tabanan,” J. Nas. Pendidik. Tek. Inform., vol. 6, no. 2, pp. 140–154, 2017, [Online]. Available: https://www.researchgate.net/publication/334246666_Pengembangan_E-Modul_Berbasis_Project_Based_Learning_Pada_Mata_Pelajaran_Pemrograman_Berorientasi_Objek_Kelas_XI_RPL_di_SMK_Negeri_2_Tabanan
L. N. Aryani, G. R. Dantes, and K. Y. Ernanda Aryanto, “Zachman framework approach for remuneration system data integration architecture design,” J. Nas. Pendidik. Tek. Inform., vol. 11, no. 1, p. 23, 2022, doi: 10.23887/janapati.v11i1.40181.
J. K. Lee et al., “Genex va: VBC open source microarray database and analysis software,” Biotechniques, vol. 36, no. 4, pp. 634–642, 2004, doi: 10.2144/04364st04.
S. Basuki, A. Rizky, and G. W. Wicaksono, “Case based reasioning (CBR) for medical question answering system,” Kinet. Game Technol. Inf. Syst. Comput. Network, Comput. Electron. Control, vol. 3, no. 2, pp. 113–118, 2018, doi: 10.22219/kinetik.v3i2.263.
R. Muslim and B. Adi Pratomo, “Development of authentication and authorization mechanisms in configuration management for container-based web hosting user cases,” Kinetik, vol. 1, no. 2, pp. 63–68, 2016, [Online]. Available: http://www.zone-h.org
Y. Nurhadryani, W. Ramadhan, and A. Asfarian, “Development and optimization of nosql database in food insecurity early warning system based on local community participation,” Kinet. Game Technol. Inf. Syst. Comput. Network, Comput. Electron. Control, vol. 4, pp. 161–168, 2020, doi: 10.22219/kinetik.v5i2.1048.
X. Yang, X. Fan, M. Peng, Q. Guan, and L. Tang, “Semantic segmentation for remote sensing images based on an AD-HRNet model,” Int. J. Digit. Earth, vol. 15, no. 1, pp. 2376–2399, 2022, doi: 10.1080/17538947.2022.2159080.
M. Calmon, “Forensic data management and database systems in forensic investigations for cases of missing and unidentified persons in Brazil,” Forensic Sci. Res., vol. 7, no. 4, pp. 599–608, 2022, doi: 10.1080/20961790.2022.2076994.
F. Edwardi, I. Gunawan, D. Sarli, S. Informasi, S. Jaya Nusa, and S. Alifah Padang, “Accredited by sinta rank 2 epdsap: Android-based baby blues screening application with sensitivity and specificity tests,” Masa Berlaku Mulai, vol. 1, no. 3, pp. 1135–1141, 2017.
H. Arrosida, A. Setiarini, B. Winarno, and A. Sudaryanto, “A monitoring system of ankle rehabilitation for paralyzed patients using android aplication,” Kinet. Game Technol. Inf. Syst. Comput. Network, Comput. Electron. Control, vol. 4, no. 3, pp. 277–286, 2019, doi: 10.22219/kinetik.v4i3.674.
A. C. Raharja, I. S. Sitanggang, and A. Buono, “Purchase recommendation and product inventory management using content based filtering with sequential pattern mining approach,” Kinet. Game Technol. Inf. Syst. Comput. Network, Comput. Electron. Control, vol. 3, no. 4, pp. 287–294, 2018, doi: 10.22219/kinetik.v3i4.663.
J. G. Kuiper, M. Bakker, F. J. A. Penning-Van Beest, and R. M. C. Herings, “Existing data sources for clinical epidemiology: The pharmo database network,” clin. Epidemiol., vol. 12, pp. 412–422, 2020, doi: 10.2147/CLEP.S247575.
P. Ingeholm, I. Gögenur, and L. H. Iversen, “Danish colorectal cancer group database,” Clin. Epidemiol., vol. 8, pp. 465–468, 2016, doi: 10.2147/CLEP.S99481.
K. Karsono, B. Irawan, and J. Dewanto, “Development of multimedia-based project management learning in higher education,” J. Nas. Pendidik. Tek. Inform., vol. 5, no. 3, p. 115, 2016, doi: 10.23887/janapati.v5i3.9918.
K. T. Dermawan, I. M. Putrama, and I. G. M. Darmawiguna, “Application of e-cr in the development of data center prototypes (case study: Information and communication technology technical service unit, Ganesha university of education).,” J. Nas. Pendidik. Tek. Inform., vol. 7, no. 1, p. 25, 2018, doi: 10.23887/janapati.v7i1.12160.
I. N. E. Mertayasa, “Interactive e-module oriented to vak content for data communication subject,” J. Nas. Pendidik. Tek. Inform., vol. 8, no. 3, pp. 208–217, 2019.
M. Wildan, A. Goeritno, and J. Irawan, “Plc-based embedded device on miniature conveyor for rejection system simulator operation,” J. RESTI, vol. 5, no. 2, pp. 301–311, 2021, doi: 10.29207/resti.v5i2.2994.
Copyright (c) 2026 Utama Khalid Lubis, Joni Karman
This work is licensed under a Creative Commons Attribution 4.0 International License.
Authors who publish with this journal agree to the following terms:
- Authors retain copyright and acknowledge that the SYNAPSI: Journal of Information Systems and Informatics Education is the first publisher licensed under a Creative Commons Attribution 4.0 International License.
- 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 acknowledgment 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 and earlier and greater citation of published work.
.png)
.png)
