Journal of the Korea Society of Computer and Information (한국컴퓨터정보학회논문지)

Korean Society of Computer Information (한국컴퓨터정보학회)
권호 표지
DOI QR코드

DOI QR Code

Utilizing Integrated Public Big Data in the Database System for Analyzing Vehicle Accidents

  • Lee, Gun-woo (Dept. of Management Information Systems, Hankuk University of Foreign Studies) ;
  • Kim, Tae-ho (Dept. of Management Information Systems, Hankuk University of Foreign Studies) ;
  • Do, Songi (Dept. of Management Information Systems, Hankuk University of Foreign Studies) ;
  • Jun, Hyun-jin (Dept. of Management Information Systems, Hankuk University of Foreign Studies) ;
  • Moon, Yoo-Jin (Dept. of Management Information Systems, Hankuk University of Foreign Studies)
  • Received : 2017.02.02
  • Accepted : 2017.04.10
  • Published : 2017.09.30
Download PDF
⟨ Previous Next ⟩

Abstract

In this paper, we propose to design and implement the database management system for analyzing vehicle accidents through utilizing integration of the public big data. And the paper aims to provide valuable information for recognizing seriousness of the vehicle accidents and various circumstances at the accident time, and to utilize the produced information for the insurance company policies as well as government policies. For analysis of the vehicle accidents the system utilizes the integrated big data of National Indicator System, the Meteorological Office, National Statistical Office, Korea Insurance Development Institute, Road Traffic Authority, Ministry of Land, Infrastructure and Transport as well as the National Police Agency, which differentiates this system from the previous systems. The system consists of data at the accident time including weather conditions, vehicle models, age, sex, insurance amount etc., by which the database system users are able to obtain the integral information about vehicle accidents. The result shows that the vehicle accidents occur more frequently in the clear weather conditions, in the vehicle to vehicle conditions and in crosswalk & crossway. Also, it shows that the accidents in the cloudy weather leads more seriously to injury and death than in the clear weather. As well, the vehicle accident information produced by the system can be utilized to effectively prevent drivers from dangerous accidents.

Keywords

References

  1. Avi Silberschatz, Henry F. Korth, S. Sudarshan, "Database System Concepts", McGraw-Hill, 2010.
  2. David Kroenke and David Auer, "Database Concepts", Pearson, 2015.
  3. Prabhanjan N. Tattar, Suresh Ramaiah, B. G. Manjunath, "A Course in Statistics with R", Willey, 2016.
  4. National Index Systemhttp://www.index.go.kr/potal/main/EachDtlPageDetail.do?idx_cd=1257
  5. National Index Systemhttp://www.index.go.kr/potal/main/EachDtlPageDetail.do?idx_cd=1617
  6. TAAS (Traffic Accident Analysis System) http://taas.koroad.or.kr/sta/acs/gus/selectAgeTfcacd.do?menuId=WEB_KMP_OVT_TAG_AGT
  7. MOLIT (Ministry of Land, Infrastructure, and Transport) http://www.molit.go.kr/USR/NEWS/m_71/dtl.jsp?lcmspage=20&id=95070027
  8. National Police Agency http://www.police.go.kr/files/infodata/200187/2015/201 5_02_1.PDF
  9. KMA (Korea Meteorological Administration) http://www.kma.go.kr/index.jsp
  10. KOSIS (Korean Statistical Information Service) http://kosis.kr/statHtml/statHtml.do?orgId=132&tblId=TX_13201_A000&conn_path=I2
  11. Korea Insurance Development Institute http://www.kidi.or.kr/stats/car_contract.asp
  12. Yoon Seung Min, Oct., 2015 http://biz.khan.co.kr/khan_art_view.html?artid=201510121507001&code=920100
  13. Hoengseongnews, "In October the car accident happens more than the other times because of vehicles heading for holiday destinations", Oct. 12, 2012 http://www.hsgnews.net/default/index_view_page.php?part_idx=4530&idx=16972
  14. Korea Transport Institute https://www.koti.re.kr/user/bbs/BD_selectBbsList.do?q_bbsCode=1017&q_clCode=1&q_lang=kor
  15. Jinhwa Yoo, "Cause Analysis and Safety Measures for Passenger Vehicle Accidents in Summer", Journal of the Korea Transportation Industrial Research Institute, 2014.
  16. Ministry of Land, Transport and Maritime Affairs, "Cause Analysis and Safety Measures for Senior Vehicle Accidents", Report of the Ministry of Land, Transport and Maritime Affairs, 2011.
  17. Yongjun Lee, Minjae Lee, "A Study of Characteristics Analysis of Vehicle Accidents in Chungcheong Region", Journal of Korean Society of Civil Engineering, 2014.
  18. Insik Hwang, Sangseon Ko, "A Study of Implementation of the Factor Descrimination Model for Vehicle Accidents", Gyeongnam Development Institute, 2004.
  19. Bongki Kim, Cheolwoo Jeong, Wonkyu Lee, "A Study of Implementation of Factor Descrimination and Classification Model for the Vehicle Accident Type", Journal of Police Science, 2011.
  20. Yong-Hwan Kim, Ja-Hee Kim, Jihoon Park and Seung-Jun Lee, "Analysis of Success Factors for Mobile Commerce using Text Mining and PLS Regression," Journal of the Korea Society of Computer and Information, v.21, no.11, 127-134, 2016. https://doi.org/10.9708/JKSCI.2016.21.11.127
  21. Posang Lee, "Stock Market Reaction of Disclosure of Technological Information and R&D Intensity," Journal of the Korea Society of Computer and Information, v.21, no.11, 151-158, 2016. https://doi.org/10.9708/jksci.2016.21.11.151
  22. Hyon Hee Kim, Hey Young Rhee, "Trend Analysis of Data Mining Research Using Topic Network Analysis," Journal of the Korea Society of Computer and Information, v.21, no.5, 141-148, 2016. https://doi.org/10.9708/JKSCI.2016.21.5.141