露天矿卡车调度系统数据库设计与实现

Design and Realization of Database for Open-pit Truck Dispatching System

针对传统露天矿生产管理模式下人工计数的弊端,以及当前部分专题数据库未能充分利用空间数据的现状,从GIS空间分析的角度出发,提出以SQL Server 2008作为后台数据库的露天矿卡车调度系统数据库构建方案。在分析卡车调度系统需求的基础上,完成了数据库的概念设计、逻辑设计、物理设计及实现。该方案利用SQL Server2008新增的Geography数据类型存储并处理空间数据,将矿区的基础空间数据及卡车运行轨迹作为分析依据,具备车辆位置显示、轨迹回溯、卡车工作量自动统计等功能,确保了工作量统计的准确性,节约了人工成本,为进一步推动露天矿生产管理的现代化提供了有力的技术支撑。

There are shortcomings of manual count in traditional open-pit management, and partial special database fail to make full use of spatial data. Given this situation, from the view of spatial analysis in GIS, a database construction plan is pro- posed, which is established for open-pit truck dispatching system and uses SQL Server 2008 as backend database. Based on re- quirements analysis of the truck dispatching system, conceptual design, logic design, physical design and database building are done. A newly added spatial data type of SQL Server 2008 named Geography is introduced, and it is used for spatial data stor- age and management. With the fundamental spatial data of open-pit and running track of vehicles as the basis for spatial analy- sis, a series of common functions are realized, such as display vehicle location, track back and automatic statistics of vehicles workload,etc. This plan ensures the accuracy of automatic statistics and saves the manpower. Moreover, it provides a strong technical support for further promoting the open-pit managerial modernization.