Publication: Design Road Traffic Injury Data Model and Visualization
Issued Date
2020-03-01
Resource Type
Other identifier(s)
2-s2.0-85085017292
Rights
Mahidol University
Rights Holder(s)
SCOPUS
Bibliographic Citation
2020 8th International Electrical Engineering Congress, iEECON 2020. (2020)
Suggested Citation
Sansanee Pudpong, Pratana Satitvipawee, Jutatip Sillabutra, Pichitpong Soontornpipit Design Road Traffic Injury Data Model and Visualization. 2020 8th International Electrical Engineering Congress, iEECON 2020. (2020). doi:10.1109/iEECON48109.2020.229534 Retrieved from: https://repository.li.mahidol.ac.th/handle/20.500.14594/56178
Research Projects
Organizational Units
Authors
Journal Issue
Thesis
Title
Design Road Traffic Injury Data Model and Visualization
Other Contributor(s)
Abstract
© 2020 IEEE. Due to serious situations of road traffic injuries in Thailand, the public health system has been affected and has to be reevaluated, as well as the injured people that need to be prevented both in planning and policy. Currently, there are many sources of information regarding road traffic injury from departments within the Ministry of Public Health in Thailand and there are many data standards used for these data. Although some standards and definitions are similar, the formats of the storage are different. Therefore, the data cannot be combined and exchanged for decision makers on prevention and policy. The objective of this paper was to develop and design a data model to standardize the three data sources under Misnitry of Public health including standard data structure on medicine, health, and referral, injury surveillance system, and information technology for emergency medical system of Ministry of Public Health. The data model was designed as a dimensional data model using the star schema of the data warehouse. The design using the dimensional data model allows the data to be analyzed in many dimensions. After that, the results of data analysis were presented as visualization for easier implementation in monitoring and policy-making decisions.