针对传统露天矿生产管理模式下人工计数的弊端,以及当前部分专题数据库未能充分利用空间数据的现状,从GIS空间分析的角度出发,提出以SQL Server 2008作为后台数据库的露天矿卡车调度系统数据库构建方案。在分析卡车调度系统需求的基础上...针对传统露天矿生产管理模式下人工计数的弊端,以及当前部分专题数据库未能充分利用空间数据的现状,从GIS空间分析的角度出发,提出以SQL Server 2008作为后台数据库的露天矿卡车调度系统数据库构建方案。在分析卡车调度系统需求的基础上,完成了数据库的概念设计、逻辑设计、物理设计及实现。该方案利用SQL Server2008新增的Geography数据类型存储并处理空间数据,将矿区的基础空间数据及卡车运行轨迹作为分析依据,具备车辆位置显示、轨迹回溯、卡车工作量自动统计等功能,确保了工作量统计的准确性,节约了人工成本,为进一步推动露天矿生产管理的现代化提供了有力的技术支撑。展开更多
We present a novel system productivity simulation and optimization modeling framework in which equipment availability is a variable in the expected productivity function of the system. The framework is used for alloca...We present a novel system productivity simulation and optimization modeling framework in which equipment availability is a variable in the expected productivity function of the system. The framework is used for allocating trucks by route according to their operating performances in a truck-shovel system of an open-pit mine, so as to maximize the overall productivity of the fleet. We implement the framework in an originally designed and specifically developed simulator-optimizer software tool. We make an application on a real open-pit mine case study taking into account the stochasticity of the equipment behavior and environment. The total system production values obtained with and without considering the equipment reliability, availability and maintainability (RAM) characteristics are compared. We show that by taking into account the truck and shovel RAM aspects, we can maximize the total production of the system and obtain specific information on the production availability and productivity of its components.展开更多
文摘针对传统露天矿生产管理模式下人工计数的弊端,以及当前部分专题数据库未能充分利用空间数据的现状,从GIS空间分析的角度出发,提出以SQL Server 2008作为后台数据库的露天矿卡车调度系统数据库构建方案。在分析卡车调度系统需求的基础上,完成了数据库的概念设计、逻辑设计、物理设计及实现。该方案利用SQL Server2008新增的Geography数据类型存储并处理空间数据,将矿区的基础空间数据及卡车运行轨迹作为分析依据,具备车辆位置显示、轨迹回溯、卡车工作量自动统计等功能,确保了工作量统计的准确性,节约了人工成本,为进一步推动露天矿生产管理的现代化提供了有力的技术支撑。
文摘We present a novel system productivity simulation and optimization modeling framework in which equipment availability is a variable in the expected productivity function of the system. The framework is used for allocating trucks by route according to their operating performances in a truck-shovel system of an open-pit mine, so as to maximize the overall productivity of the fleet. We implement the framework in an originally designed and specifically developed simulator-optimizer software tool. We make an application on a real open-pit mine case study taking into account the stochasticity of the equipment behavior and environment. The total system production values obtained with and without considering the equipment reliability, availability and maintainability (RAM) characteristics are compared. We show that by taking into account the truck and shovel RAM aspects, we can maximize the total production of the system and obtain specific information on the production availability and productivity of its components.
