面向出租车轨迹的数据库管理系统设计与应用
|
摘要
文中就南通出租车的轨迹数据管理问题,针对轨迹数据量大且不断累积的特点,基于Arc Engine和SQL设计了轨迹数据库管理系统,该系统实现了轨迹数据的空间和属性查询、车辆的空间分布分析以及空驶率的计算等功能,并以空驶率为例,详细阐述了该系统的设计与功能,从而说明该系统可使数据管理和分析工作变得更为便捷。
This paper focuses thetrajectory data management of nantong taxis. the trajectory database management system is designed on the basis of Arc Engineand SQL for the characteristics of large and cumulative trajectory data. The system realizes the functions of spatial and attribute query of trajectory data,spatial distribution analysis of vehicles,and calculation of empty-loaded rate. taking empty-loaded rate as an example,the design and function of the system are described in detail,which shows that the system can make data management and analysis more convenient.
This paper focuses thetrajectory data management of nantong taxis. the trajectory database management system is designed on the basis of Arc Engineand SQL for the characteristics of large and cumulative trajectory data. The system realizes the functions of spatial and attribute query of trajectory data,spatial distribution analysis of vehicles,and calculation of empty-loaded rate. taking empty-loaded rate as an example,the design and function of the system are described in detail,which shows that the system can make data management and analysis more convenient.
引文
[1]Xu J,Güting R H.A generic data model for moving objects[J].Geo Informatica,2013,17(1):125-172.
[2]Bothe W,Maat K.Deriving and Validating Trip Destinations and Modes for Multi-day GPS Based Travel Surveys:An Application In the Netherlands[C].In the Proceedings of the 87th Annual Meeting of the Transportation Research Board,2008:1-16.
[3]Fathi A,Krumm J.Detecting Road Intersection from GPS Trances[C].Proceedings of the 6th International Conference on Geographic Information Science,2010:56-69.
[4]李道勇,戴建军.基于FCD的深圳市出租汽车空驶率特点研究[A].科学技术部全国智能运输系统协调指导小组办公室.2007第三届中国智能交通年会论文集[C].科学技术部全国智能运输系统协调指导小组办公室:2007:5.
[5]Oort N V,Cats O.Improving Public Transport Decision Making,Planning and Operations by Using Big Data:Cases from Sweden and the Netherlands[C].IEEE International Conference on Intelligent Transportation Systems.IEEE,2015:19-24.
[2]Bothe W,Maat K.Deriving and Validating Trip Destinations and Modes for Multi-day GPS Based Travel Surveys:An Application In the Netherlands[C].In the Proceedings of the 87th Annual Meeting of the Transportation Research Board,2008:1-16.
[3]Fathi A,Krumm J.Detecting Road Intersection from GPS Trances[C].Proceedings of the 6th International Conference on Geographic Information Science,2010:56-69.
[4]李道勇,戴建军.基于FCD的深圳市出租汽车空驶率特点研究[A].科学技术部全国智能运输系统协调指导小组办公室.2007第三届中国智能交通年会论文集[C].科学技术部全国智能运输系统协调指导小组办公室:2007:5.
[5]Oort N V,Cats O.Improving Public Transport Decision Making,Planning and Operations by Using Big Data:Cases from Sweden and the Netherlands[C].IEEE International Conference on Intelligent Transportation Systems.IEEE,2015:19-24.