露天矿道路网数据库的设计与实现  

Design and implementation of road network database in open-pit mine

作　　者：李震 孙效玉[1] 田凤亮 LI Zhen;SUN Xiaoyu;TIAN Fengliang(School of Resource&Civil Engineering,Northeastern University,Shenyang 110819,China)

机构地区：[1]东北大学资源与土木工程学院,辽宁沈阳110819

出　　处：《煤炭科学技术》2020年第S01期129-133,共5页Coal Science and Technology

基　　金：国家自然科学基金资助项目(51674063);国家重点研发计划资助项目(2016YFC0801608).

摘　　要：为了解决当前露天矿道路网数据的管理中可视化水平不高、使用维护不便的弊端,依托于计算机领域的关系型数据库和面向对象技术等相关理论和方法,在分析道路网功能需求和数据需求的基础上,实现了道路网数据库概念结构、逻辑结构和物理结构的设计,建立了二进制格式存储向数据库存储的数据转换模型,并利用某露天矿真实道路数据对道路网数据库进行查询和保存测试。结果表明:道路网数据库的设计和实现提高了数据的可视性,简化了数据访问,通过数据库的主、外键确保了数据的一致和准确;读取全部道路网数据用时79.14 ms,保存用时50.99 ms,均不会对露天矿的生产活动造成影响。In order to solve the drawbacks of low level of visualization and inconvenient maintenance in the management of road network data in open pit mine,relying on relational database and object-oriented technology in the field of computer and other related theories and methods,base on the basis of analyzing,the functional requirements and data requirements of road network,the design of conceptual structure logical structure and physical structure of road network database is realized,the data conversion model from binary format storage to database storage is established.and the road network database is queried and saved by using the real road data of an open pit mine.The results show that the design and implementation of the road network database improves the visibility of the data,simplifies the data access,ensures the consistency and accuracy of the data through the main and foreign keys of the database;reads all the road network data using 79.14 ms,saves 50.99 ms,and does not interfere with the production activities of the open pit mine.

关 键 词：露天矿 数据库 数据转换模型 性能测试 

分 类 号：TD57[矿业工程—矿山机电] TP311.13[自动化与计算机技术—计算机软件与理论]