[1]张维国,孙效玉,周冲,等. 树形结构数据在数字矿山中的存储管理与应用[J].计算机技术与发展,2015,25(03):150-153.
　ZHANG Wei-guo,SUN Xiao-yu,ZHOU Chong,et al. Storage Management and Application of Tree Structure Data in Digital Mine[J].,2015,25(03):150-153.
点击复制

 树形结构数据在数字矿山中的存储管理与应用()
分享到：

《计算机技术与发展》[ISSN:1006-6977/CN:61-1281/TN]

卷:
25
期数:
2015年03期
页码:
150-153
栏目:
应用开发研究
出版日期:
2015-03-10

文章信息/Info

Title:
 Storage Management and Application of Tree Structure Data in Digital Mine
文章编号:
1673-629X（2015)03-0150-04
作者:
 张维国; 孙效玉; 周冲; 董波
 东北大学
Author(s):
 ZHANG Wei-guo; SUN Xiao-yu; ZHOU Chong; DONG Bo
关键词:
 ; 数字矿山; 关系数据库; 树形结构; 嵌套查询; 公用表表达式; 树形控件
Keywords:
 ; digital mine; relational database; tree structure; nested query; common table expression; Treeview control
分类号:
TP39
文献标志码:
A
摘要:
 在矿山信息化建设过程中需要建立高效便捷的数据管理和更新体系，其中露天矿组织管理机构是一种典型的树形图结构。针对树形结构数据在关系型数据库中的优化存储管理和交互操作较难实现的问题，文中设计了简化的单一关系数据库表结构，采用数据库高性能嵌套查询的公用表表达式语句，提出了递归数据绑定的树形结构数据管理模式，实现了树形结构数据的高效管理，并结合C#开发语言的树形控件及矿山组织管理机构的实际情况，在数字矿山建设的工作任务管理系统中得到了实际应用。
Abstract:
 In the process of mine informatization construction,it is necessary to establish efficient and convenient system of data manage-ment and updating,among which the open-pit mine organization management structure is a typical tree graph structure. In order to realize more difficult problems in relational database of optimized storage management and interactive operation of tree structure data,design a simplified single relational database table structure and adopt the common table expression statements of the high performance nested que-ry,put forward a data management mode of tree structure with recursive data binding,finally realize the efficient management of tree structure data,which is verified by the application of mining task management system combined with Treeview control of C # and the practical situation of mining organization and management agencies in digital mine.

相似文献/References:

[1]王彦彬 车德福 郭甲腾 张维国.三维地矿模型可视化控件研究[J].计算机技术与发展,2012,(06):61.
　WANG Yan-bin,CHE De-fu,GUO Jia-teng,et al.Research on Visual Control of 3D Geological Model[J].,2012,(03):61.
[2]张志宏,吴庆波,邵立松,等.基于飞腾平台TOE协议栈的设计与实现[J].计算机技术与发展,2014,24(07):1.
　ZHANG Zhi-hong,WU Qing-bo,SHAO Li-song,et al. Design and Implementation of TCP/IP Offload Engine Protocol Stack Based on FT Platform[J].,2014,24(03):1.
[3]梁文快,李毅. 改进的基因表达算法对航班优化排序问题研究[J].计算机技术与发展,2014,24(07):5.
　LIANG Wen-kuai,LI Yi. Research on Optimization of Flight Scheduling Problem Based on Improved Gene Expression Algorithm[J].,2014,24(03):5.
[4]黄静,王枫,谢志新,等. EAST文档管理系统的设计与实现[J].计算机技术与发展,2014,24(07):13.
　HUANG Jing,WANG Feng,XIE Zhi-xin,et al. Design and Implementation of EAST Document Management System[J].,2014,24(03):13.
[5]侯善江[],张代远[][][]. 基于样条权函数神经网络P2P流量识别方法[J].计算机技术与发展,2014,24(07):21.
　HOU Shan-jiang[],ZHANG Dai-yuan[][][]. P2P Traffic Identification Based on Spline Weight Function Neural Network[J].,2014,24(03):21.
[6]李璨,耿国华,李康,等. 一种基于三维模型的文物碎片线图生成方法[J].计算机技术与发展,2014,24(07):25.
　LI Can,GENG Guo-hua,LI Kang,et al. A Method of Obtaining Cultural Debris’ s Line Chart Based on Three-dimensional Model[J].,2014,24(03):25.
[7]翁鹤,皮德常. 混沌RBF神经网络异常检测算法[J].计算机技术与发展,2014,24(07):29.
　WENG He,PI De-chang. Chaotic RBF Neural Network Anomaly Detection Algorithm[J].,2014,24(03):29.
[8]刘茜[],荆晓远[],李文倩[],等. 基于流形学习的正交稀疏保留投影[J].计算机技术与发展,2014,24(07):34.
　LIU Qian[],JING Xiao-yuan[,LI Wen-qian[],et al. Orthogonal Sparsity Preserving Projections Based on Manifold Learning[J].,2014,24(03):34.
[9]尚福华,李想,巩淼. 基于模糊框架-产生式知识表示及推理研究[J].计算机技术与发展,2014,24(07):38.
　SHANG Fu-hua,LI Xiang,GONG Miao. Research on Knowledge Representation and Inference Based on Fuzzy Framework-production[J].,2014,24(03):38.
[10]叶偲,李良福,肖樟树. 一种去除运动目标重影的图像镶嵌方法研究[J].计算机技术与发展,2014,24(07):43.
　YE Si,LI Liang-fu,XIAO Zhang-shu. Research of an Image Mosaic Method for Removing Ghost of Moving Targets[J].,2014,24(03):43.

更新日期/Last Update: 2015-05-04