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.%在矿山信息化建设过程中需要建立高效便捷的数据管理和更新体系,其中露天矿组织管理机构是一种典型的树形图结构。针对树形结构数据在关系型数据库中的优化存储管理和交互操作较难实现的问题,文中设计了简化的单一关系数据库表结构,采用数据库高性能嵌套查询的公用表表达式语句,提出了递归数据绑定的树形结构数据管理模式,实现了树形结构数据的高效管理,并结合C#开发语言的树形控件及矿山组织管理机构的实际情况,在数字矿山建设的工作任务管理系统中得到了实际应用。
展开▼