基于OLAP的道路交通事故影响因素分析  

A Study on the Influencing Factors of Road Traffic Accidents Based on OLAP

作　　者：惠宝锋[1] 冯桂莲[1] 王咏宁[1] HUI Baofeng;FENG Guilian;WANG Yongning(School of Physics and Electronic Information Engineering,Qinghai University for Nationalities,Xining 810007,China)

机构地区：[1]青海民族大学物理与电子信息工程学院,青海西宁810007

出　　处：《软件工程》2018年第7期21-23,20,共4页Software Engineering

基　　金：青海民族大学2017-2018年度本科教学研究项目项目编号:(2017-BKJXYB-08)

摘　　要：本文通过数据挖掘相关基础进行数据库搭建,选取2002—2016年数据进行OLAP分析,通过数据切片及数据向下钻取,将二维数据转换成三维数据进行深度剖析,结果显示全国道路交通事故影响因素主要集中在机动车超速行驶及逆向行驶中,其中驾驶人行为尤为突出。在Eviews软件中对数据进行预测分析发现道路交通事故存在非线性关系,并且预测了未来三年的道路交通事故数量及伤亡数量,数据显示出道路交通事故呈逐年下降趋势。The paper constructs the database by means of related data mining,and selects the data from 2002 to 2016 for OLAP analysis.Through data slicing and data drilling down,the two-dimensional data are converted into three-dimensional data for further analysis.The results show that the main infuencing factors of domestic road traffc accidents are mainly speeding and reverse driving of motor vehicles,especially the behaviors of drivers.The data analysis in Eviews shows that there is a non-linear relationship between the predictions and road traffc accidents.The data of accidents and casualties in the next 3 years is predicted which shows a declining trend in road traffc accidents.

关 键 词：数据挖掘 联机分析处理 交通事故 预测分析 

分 类 号：TP319[自动化与计算机技术—计算机软件与理论]