采煤机科学数据共享服务系统.pdf

万方数据万方数据万方数据硕士学术学位、硕士非工程类专业学位学位论文答辩信息表论文题目采煤机科学数据共享服务系统课题来源* 省科技厅项目论文答辩日期 2020 年 6 月 11 日答辩秘书谢嘉成学位论文答辩委员会成员姓名职称博导/硕导工作单位答辩委员会主席李秀红教授博导太原理工大学答辩委员 1 庞新宇副教授硕导太原理工大学答辩委员 2 崔红伟副教授硕导太原理工大学 *课题来源可填国家重点研发计划项目、国家自然科学基金项目、国家社科基金项目、教育部人文社科项目、国家其他部委项目、省科技厅项目、省教育厅项目、企事业单位委托项目、其他。万方数据万方数据摘要 I 摘要目前，煤炭能源仍然是我国的主体能源，面对煤炭长期可持续开发与利用等问题，明确高效的煤炭开采技术与先进的配套装备是解决该问题的主要方法。采煤机作为现代化机械开采的重要设备之一，在设计过程中产生大量数据，由于这些数据分散于采煤机各信息化平台，造成了技术流失和知识共享困难等问题。因此，实现数据驱动的创新设计是采煤机现代设计的主要内容，有助于促进企业集数据资源整合、数据应用、技术创新、产业结构为一体的协同化发展。面向数据驱动的采煤机创新设计发展趋势，针对采煤机数据分散、共享程度低等现状，围绕科学数据共享服务系统的需求，运用 ASP.NET 技术、 Ajax 异步技术、Web Service 技术及先进的数据库技术，以 Visual Studio、 SQL server 2008 为系统开发工具，构建一个集专题数据、应用服务、数据汇交为一体的基于数据共享的采煤机服务系统。共享服务系统包括专题服务子系统、应用服务子系统、汇交服务子系统和其他辅助子系统，有效地将分散于采煤机各数字化平台数据资源整合和汇聚，为设计人员提供具有指导意义的数据资源，促进采煤机数据资源的应用与共享。本研究提出采煤机科学数据专题数据服务子系统解决方案，通过对采煤机数据深度挖掘、分析处理，构建具有专项特点的专题数据库，包括设计资源库、零件库、CAD 模型库及 CAE 分析库等专题库，满足用户对数据资源的浏览、检索、下载等功能。通过对概念设计、参数化建模和 CAE 分析技术的研究，构建在线概念设计、CAD 参数化建模、CAE 分析等功能模块，完成采煤机应用服务子系统的集成，通过实例分析初步验证应用服务子系统，满足用户在线对采煤机的选型设计、关键零部件的 CAD 参数化建模和 CAE 参数化分析，为采煤机数字化设计提供技术支持。通过对采煤机科学数据特征分析，设计采煤机设计数据汇交体系和功能框架，提出“以专家审核为主、数据管理员为辅”的汇交审核方案，构建比较完整的采煤机设计数据汇交服务子系统，满足用户对数据产品的元数据和数据实体的汇交需求，不断丰富采煤机数据中心数据资源，初步实现采煤机制造企业数据的高效汇交。根据用户实际使用需求，确定系统测试方案，完成系统功能测试、性能测试、安全性测试、兼容性等测试，通过对各个子系统运行实例验证系统的万方数据太原理工大学硕士学位论文 II 可靠性和安全性。该系统将数字化设计贯穿于采煤机设计流程中，收集整合大量具有设计意义的数据资源，设计并开发供用户共享数据的汇交平台，为用户提供集数据资源、数字化设计、数据汇交等服务为一体的数据应用共享服务模式，促进数据资源的共享应用，实现数据资源的科学管理，减少数据资源的浪费，对煤机装备的资源集成化、设计数字化、运行网络化、管理信息化和服务智能化具有重要的作用。关键词关键词采煤机；创新设计；专题数据库；数据汇交；共享系统万方数据 ABSTRACT III ABSTRACT At present, coal energy is still the main energy source in China. It is clear that efficient coal mining technology and advanced supporting equipment are the main s to solve the problems of long-term sustainable development and utilization of coal. Shearer, as one of the important equipment for modern machinery mining, generates a large amount of data in the process of design. Because these data are scattered in various ination plats of shearer, there are some problems such as technology loss and difficulty in knowledge sharing. Therefore, the realization of data-driven innovative design is the main content of the modern design of shearer, which helps to promote the collaborative development of enterprises integrating data resource integration, data application, technological innovation and industrial structure. Data-driven design is an inevitable development trend for shearer innovation design. In view of shearer data, there are some current situations such as dispersion and low sharing of shearer data. Using Visual Studio and SQL server 2008 as system development tools, a data sharing service system for shearer is researched, which integrates thematic data, application service and data collection, around the demand of scientific data sharing service system. The development of the research is based on some technologies such as the ASP.NET technology, Ajax asynchronous technology, Web Service technology and advanced database technology. The sharing service system includes the special service subsystem, application service subsystem, collection service subsystem and other auxiliary subsystems, effectively integrating and gathering data resources scattered in each digital plat of shearer, which provides data resources with guiding significance for designers and promotes the application and sharing of shearer data resources. This paper puts forward the solution plan of special data service subsystem of shearer scientific data. Through deep mining, analysis and other processing of shearer data, special databases with special characteristics are established, including design resource database, parts database, CAD model database and CAE analysis database, to meet the functions of browsing, retrieving and downloading data resources for users. 万方数据太原理工大学硕士学位论文 IV Through the research on conceptual design, parametric modeling and CAE analysis technology, some functional modules are constructed such as online conceptual design, CAD parametric modeling, CAE analysis and other functional modules, completing the integration of the shearer application service subsystem. The application service subsystem is preliminarily verified by case analysises which meeting some online needs for users such as selection design of shearer, CAD parametric modeling and CAE parametric analysing for key parts, providing technical support for digital design of shearer. Based on the analysis of scientific data characteristics of shearer, the data collection system and functional framework of shearer design data are designed. Putting forward the collection audit scheme with “expert audit as the main and data administrator as the auxiliary“, a relatively integral collection service subsystem is built for shearer design data. It meets the collection needs of users for metadata and data entities of data products, and constantly enriches the data resource of the shearer data center, initially realizing the efficient data collection and delivery of the shearer manufacturing enterprises. According to the actual needs of users, the system test plan is determined. Some system tests are completed such as the system function test, perance test, safety test, compatibility test and other tests. And the reliability and safety of the system are verified by running examples of each subsystem. The system runs digital design throughout the design process of shearer, which collects and integrates a large number of data resources with design significance. A data collection and delivery plat is designed and developed for users to share data, providing for users the service mode of data application and sharing integrating data resources, digital design, data collection and delivery services. The system promotes the sharing and application of data resources, realizing the scientific management of data resources and reducing the waste of data resources, which plays an important role in the resource integration, design digitization, operation networking, management inatization and service intelligence of coal machinery equipment. Key Words Shearer; Innovative Design; Thematic Database; Data Collection; Sharing System 万方数据目录 V 目录摘要 ......................................................................................................................................... I ABSTRACT ............................................................................................................................. III 目录 ....................................................................................................................................... V 第一章绪论 ............................................................................................................................ 1 1.1 研究目的与意义 ........................................................................................................... 1 1.2 国内外研究动态 ........................................................................................................... 2 1.2.1 科学数据共享 ........................................................................................................ 2 1.2.2 数据共享技术研究 ................................................................................................ 4 1.2.3 采煤机数据库共享与知识库系统 ........................................................................ 5 1.2.4 存在的问题 ............................................................................................................ 6 1.3 主要研究内容 ............................................................................................................... 6 1.4 技术路线 ....................................................................................................................... 7 第二章采煤机科学数据共享服务系统总体架构设计 ........................................................ 9 2.1 引言 ............................................................................................................................... 9 2.2 采煤机科学数据资源 ................................................................................................... 9 2.3 系统需求分析 ............................................................................................................. 10 2.3.1 功能需求分析 ...................................................................................................... 10 2.3.2 非功能性需求分析 .............................................................................................. 12 2.4 系统体系架构与功能设计 ......................................................................................... 12 2.4.1 设计原则 .............................................................................................................. 12 2.4.2 体系架构 .............................................................................................................. 13 2.4.3 功能设计 .............................................................................................................. 14 2.5 系统实现关键技术 ..................................................................................................... 16 2.5.1 ASP.NET .............................................................................................................. 16 2.5.2 Ajax 技术 ............................................................................................................. 17 2.5.3 Web Service 技术 ................................................................................................. 18 2.6 系统开发环境 ............................................................................................................. 19 2.6.1 系统架构 .............................................................................................................. 19 万方数据太原理工大学硕士学位论文 VI 2.6.2 系统硬件开发环境 .............................................................................................. 21 2.6.3 系统软件开发环境 .............................................................................................. 21 2.7 系统可行性分析 ......................................................................................................... 22 2.8 小结 ............................................................................................................................. 23 第三章采煤机科学数据共享服务系统模块集成 .............................................................. 25 3.1 引言 ............................................................................................................................. 25 3.2 专题数据服务子系统 ................................................................................................. 25 3.2.1 采煤机专题数据资源 .......................................................................................... 25 3.2.2 功能结构设计 ...................................................................................................... 26 3.2.3 数据库设计 .......................................................................................................... 27 3.3 应用服务子系统 ......................................................................................................... 30 3.3.1 概念设计功能 ...................................................................................................... 30 3.3.2 CAD 参数化建模功能 ........................................................................................ 33 3.3.3 CAE 参数化分析功能 ......................................................................................... 34 3.4 下载中心子系统 ......................................................................................................... 35 3.4.1 功能设计 .............................................................................................................. 35 3.4.2 功能实现 .............................................................................................................. 36 3.5 用户管理子系统 ......................................................................................................... 40 3.5.1 用户权限分析 ...................................................................................................... 40 3.5.2 用户管理功能实现 .............................................................................................. 41 3.6 系统帮助子系统 ......................................................................................................... 44 3.6.1 联系我们 .............................................................................................................. 44 3.6.2 问题反馈 .............................................................................................................. 45 3.7 小结 ............................................................................................................................. 46 第四章采煤机设计数据汇交服务子系统 .......................................................................... 47 4.1 引言 ............................................................................................................................. 47 4.2 汇交子系统需求分析 ................................................................................................. 47 4.2.1 采煤机设计数据特征 .......................................................................................... 47 4.2.2 采煤机设计数据汇交面临的问题 ...................................................................... 48 4.3 汇交体系 ..................................................................................................................... 48 4.3.1 汇交体系结构 ...................................................................................................... 48 万方数据目录 VII 4.3.2 汇交技术流程 ...................................................................................................... 49 4.3.3 汇交工作流程 ...................................................................................................... 50 4.4 功能设计 ..................................................................................................................... 51 4.4.1 汇交注册 .............................................................................................................. 51 4.4.2 数据汇交 .............................................................................................................. 51 4.4.3 汇交审核 .............................................................................................................. 51 4.4.4 数据管理 .............................................................................................................. 52 4.5 功能实现技术研究 ..................................................................................................... 52 4.5.1 元数据汇交 .......................................................................................................... 52 4.5.2 数据传输 .............................................................................................................. 52 4.5.3 专家审核 .............................................................................................................. 53 4.6 数据库设计 ....................................................................