# In-ETL Architecture with Isolation Forest-Based Data Triage for Improving Open Government Data Quality > Asdar M. URL kanonis: https://discover.unhas.ac.id/publications/pub_scopus_105055424702 Jurnal / Konferensi: 2026 IEEE International Conference on Artificial Intelligence and Mechatronics Systems Aims 2026 Tahun terbit: 2026 DOI: https://doi.org/10.1109/AIMS71270.2026.11712596 Citations: 0 ## Authors - Asdar M. ## Abstract Implementing Open Government Data (OGD) in Indonesia faces data quality challenges due to inconsistencies and anomalies across Regional Apparatus Organizations. This study proposes a proactive approach by integrating multi-stage rule-based validation and Isolation Forest anomaly detection within an In-Extract, Transform, Load (In-ETL) pipeline. Incoming records are dynamically classified into Clean, Suspicious, and Rejected categories prior to warehouse storage. Evaluation utilizing a hybrid dataset incorporating 2,344 authentic commodity records from the Makassar City portal scaled to 100,000, demonstrated effective data triage, categorizing 88.11% as Clean. A baseline algorithmic comparison further justified the selection of Isolation Forest, which maintained near-instantaneous processing (0.14 seconds) compared to the severe latency bottlenecks of distance-based models like LOF and One-Class SVM. Compared to reactive Post-ETL methods, the In-ETL architecture reduced dirty data exposure by 79.11% and maintained 97.63% warehouse purity. These findings confirm that integrating preventative anomaly detection during the ETL transit phase significantly improves early-stage data quality and minimizes downstream errors. Future research should focus on expanding this architecture to accommodate complex unstructured data types and national-level portal integrations. ## Keywords - Data quality - Computer science - Architecture - Government (linguistics) - Quality (philosophy) - Isolation (microbiology) - Open data - Triage - Computer security - Open government - Business - Key (lock) - Systems architecture - Server - Process management --- Sumber: Discover Unhas — RIMS Universitas Hasanuddin. Saat mengutip, gunakan DOI bila tersedia atau URL kanonis di atas.