Editor/Reviewer loginFrequency : 12 issues per year
Subject : Computer Applications and Technology
ISSN : 2319–8656 (Online)
IJCATR Volume 14 Issue 2
Data Validation and Matching Algorithm for Road Safety Database Integrity in the Philippines
Maywadee Soytong, Arse John P. Salison, Patrick Rollan, Adrian Roy L. Valdez, Susan Pancho-Festin, Harvey Ian Arbas
10.7753/IJCATR1402.1008
keywords : Data Validation, Data Matching, Data Integration, Database, Road Safety, Data Storage
Fragmented road safety data across Philippine agencies hinders practical analysis and intervention. This paper explores a data matching algorithm for the Philippine Integrated Traffic Incident Database (PITAD), designed to consolidate data from various sources. The algorithm prioritizes matching incident time/date, and GPS coordinates with secondary criteria such as vehicle types and demographics. By pre-processing data, computing matching scores based on time, location, and additional factors, and clustering matched entries, the algorithm tackles data fragmentation and improves data quality within PITAD. This paves the way for comprehensive analysis of road safety trends, enabling data-driven decisions for targeted interventions and, ultimately, enhanced road safety in the Philippines.
@artical{m1422025ijcatr14021008,
Title = "Data Validation and Matching Algorithm for Road Safety Database Integrity in the Philippines ",
Journal ="International Journal of Computer Applications Technology and Research(IJCATR)",
Volume = "14",
Issue ="2",
Pages ="113 - 120",
Year = "2025",
Authors ="Maywadee Soytong, Arse John P. Salison, Patrick Rollan, Adrian Roy L. Valdez, Susan Pancho-Festin, Harvey Ian Arbas"}
The paper focuses on a data-matching algorithm for integrating fragmented road data.
The algorithm prioritizes time, location (latitude and longitude), and main source database.
The algorithm uses a weighted scoring system to assess record similarity.
Validation results show improved accuracy when incorporating additional variables.