Browse > Article
http://dx.doi.org/10.9708/jksci.2017.22.09.099

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)
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
big data; vehicle accident; database system; government policy; weather condition;
Citations & Related Records
Times Cited By KSCI : 3  (Citation Analysis)
연도 인용수 순위
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 KMA (Korea Meteorological Administration) http://www.kma.go.kr/index.jsp
9 KOSIS (Korean Statistical Information Service) http://kosis.kr/statHtml/statHtml.do?orgId=132&tblId=TX_13201_A000&conn_path=I2
10 Korea Insurance Development Institute http://www.kidi.or.kr/stats/car_contract.asp
11 Yoon Seung Min, Oct., 2015 http://biz.khan.co.kr/khan_art_view.html?artid=201510121507001&code=920100
12 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.
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 Yongjun Lee, Minjae Lee, "A Study of Characteristics Analysis of Vehicle Accidents in Chungcheong Region", Journal of Korean Society of Civil Engineering, 2014.
17 Insik Hwang, Sangseon Ko, "A Study of Implementation of the Factor Descrimination Model for Vehicle Accidents", Gyeongnam Development Institute, 2004.
18 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.
19 National Police Agency http://www.police.go.kr/files/infodata/200187/2015/201 5_02_1.PDF
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.   DOI
21 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.   DOI
22 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.   DOI