没有合适的资源?快使用搜索试试~ 我知道了~
资源推荐
资源详情
资源评论
大连理工大学硕士学位论文
- I -
摘 要
随着信息技术的高速发展,传统的基于设计人员经验的机械产品设计方法已经无法
适应不断变化的设计需求,在机械产品市场的竞争中即将面临淘汰。数字化设计技术对
机械工业的飞速发展提供了新的技术手段,针对滚动轴承的设计,一些实用的资源数据
库存储了来源于不同厂家的轴承参数数据,或针对特定的任务开发资源数据库系统,但
是对于程序开发人员来说,难以实现数据共享,无法针对不断变更的设计任务对资源库
数据进行扩展,丰富的数据资源未得到有效利用。因此本文设计并开发了一套可共享、
可扩展的滚动轴承资源库及滚动轴承资源库系统,并以滚动轴承的通用化设计方法为应
用背景,实现基于资源库的滚动轴承设计。主要工作内容及研究成果如下:
(1)对滚动轴承资源库进行整体方案设计。针对设计任务进行信息要求、处理要
求和安全性与完整性要求三个方面的需求分析,对滚动轴承资源库顺序进行概念结构设
计获得资源库的概念模型,基于数据库关系模型理论进行逻辑结构设计并优化获得资源
库的关系模型,进行物理结构设计获得资源库的物理模型,综合得到了滚动轴承资源库
的整体方案模型,为滚动轴承资源库的创建及系统开发提供了理论根据。
(2)创建了滚动轴承资源库。利用 MySQL 及 Navicat 等开发工具和 SQL 结构化查
询语言,提出资源库的规范化实施方法,结合资源库物理模型的字段结构,设计基本信
息数据表和参数数据表的记录结构,并提出了基于自然语言处理的关联信息表自动生成
方法,最后将全部数据资源导入到资源库,形成可扩展的资源库数据层。
(3)开发了滚动轴承资源库系统。利用 tkinter、pymysql 等工具库,在 Python 环
境中开发了滚动轴承资源库的用户管理模块、数据管理模块、资源库查询及调用模块等
面向用户的图形界面,并利用资源库访问接口实现各个模块与资源库之间的数据交互,
最终调试完成了滚动轴承资源库系统的开发。
(4)实现基于资源库的滚动轴承设计。讨论并创建了针对多种数据表复杂查询与
调用方式的嵌入式 SQL 语句模板,研究基于资源库的滚动轴承的设计方法及流程,在
Matlab 语言环境中开发了滚动轴承设计程序及资源库数据交互模块程序,最后以圆柱滚
子轴承的设计为案例,实现了基于资源库的滚动轴承设计,验证了滚动轴承资源库系统
的可行性。
关键词:资源库;关系模型;系统开发;数据交互;滚动轴承
滚动轴承资源库系统设计、开发及应用
- II -
Design, Development and Application of Rolling Bearing Resource
Database System
Abstract
With the rapid development of information technology, traditional mechanical product
design methods based on designer experience have been unable to adapt to changing design
needs, and will soon be eliminated in the competition of mechanical product market. Digital
design technology provides new technical means for the rapid development of the machinery
industry. For the design of rolling bearings, some practical resource databases store bearing
parameter data from different manufacturers, or develop resource database systems for specific
tasks, but for programs For developers, it is difficult to achieve data sharing, unable to expand
the resource database data for changing design tasks, and the rich data resources have not been
effectively used. Therefore, this paper designs and develops a set of sharable and extensible
rolling bearing resource database and rolling bearing resource database system, and uses the
universal design method of rolling bearing as the application background to realize the rolling
bearing design based on the resource database. The main work content and research results are
as follows:
(1) Design the overall plan of the rolling bearing resource database. According to the
requirements of the design task, information requirements, processing requirements and safety
and integrity requirements are analyzed in three aspects. The conceptual structure design of the
rolling bearing resource database is obtained to obtain the conceptual model of the resource
database. The logical structure design and optimization are based on the database relationship
model theory. Obtain the relationship model of the resource database, design the physical
structure to obtain the physical model of the resource database, and comprehensively obtain the
overall scheme model of the rolling bearing resource database, which provides a theoretical
basis for the creation and system development of the rolling bearing resource database.
(2) Created rolling bearing resource database. Using development tools such as MySQL
and Navicat and SQL structured query language, a standardized implementation method of the
resource database is proposed, combined with the field structure of the physical model of the
resource database, the record structure of the basic information data table and the parameter
data table is designed, and a natural language-based The method of automatically generating
the related information table for processing, and finally importing all data resources to the
resource database to form an extensible resource database data layer.
(3) Developed rolling bearing resource database system. Using tool libraries such as
大连理工大学硕士学位论文
- III -
tkinter and pymysql, a user-oriented graphical interface such as user management module, data
management module, resource database query and call module of the rolling bearing resource
database was developed in the Python environment, and each module and resource was
implemented using the resource database access interface The data interaction between the
libraries, the final debugging completed the development of the rolling bearing resource
database system.
(4) Realize the design of rolling bearing based on resource database. Discuss and create
embedded SQL statement templates for complex query and calling methods of multiple data
tables, study the design method and process of rolling bearing based on resource database,
develop rolling bearing design program and resource database data interaction module program
in Matlab language environment Finally, taking the design of cylindrical roller bearings as an
example, the rolling bearing design based on the resource database was realized, and the
feasibility of the rolling bearing resource database system was verified.
Keywords: Resource Database; Relationship Model; System Development; Data
Interaction; Rolling bearing
滚动轴承资源库系统设计、开发及应用
- IV -
目 录
摘 要 ............................................................................................................................. I
Abstract ............................................................................................................................. II
1 绪论 .............................................................................................................................. 1
1.1 研究背景及意义 ............................................................................................... 1
1.2 国内外研究综述 ............................................................................................... 2
1.2.1 数据库技术研究现状 ............................................................................ 2
1.2.2 滚动轴承资源库研究现状 .................................................................... 3
1.3 本文研究工作 ................................................................................................... 5
2 滚动轴承资源库方案设计 .......................................................................................... 7
2.1 滚动轴承资源库需求分析 ............................................................................... 8
2.1.1 信息要求 ................................................................................................ 9
2.1.2 功能要求 ................................................................................................ 9
2.1.3 安全性与完整性要求 .......................................................................... 10
2.2 资源库总体架构设计 ..................................................................................... 11
2.3 资源库概念结构设计 ..................................................................................... 12
2.4 资源库逻辑结构设计 ..................................................................................... 13
2.4.1 资源库关系模型转换 .......................................................................... 13
2.4.2 关系规范化之第一范式 ...................................................................... 15
2.4.3 关系规范化之第二范式 ...................................................................... 15
2.4.4 关系规范化之第三范式 ...................................................................... 16
2.5 资源库物理结构设计 ..................................................................................... 17
2.5.1 数据表结构设计 .................................................................................. 17
2.5.2 数据表关系设计 .................................................................................. 22
2.6 本章小结 ......................................................................................................... 23
3 滚动轴承资源库创建 ................................................................................................ 24
3.1 资源库创建工具 ............................................................................................. 24
3.1.1 数据库管理系统 .................................................................................. 24
3.1.2 数据库管理工具 .................................................................................. 24
3.2 资源库实施规范 ............................................................................................. 24
3.2.1 结构化查询语言 .................................................................................. 24
大连理工大学硕士学位论文
- V -
3.2.2 资源库命名规范 .................................................................................. 25
3.2.3 资源库字段类型规范 .......................................................................... 25
3.3 资源库数据表设计 ......................................................................................... 26
3.3.1 基本信息表设计 .................................................................................. 26
3.3.2 参数数据表设计 .................................................................................. 33
3.4 资源库数据导入 ............................................................................................. 33
3.5 本章小结 ......................................................................................................... 35
4 滚动轴承资源库系统开发 ........................................................................................ 36
4.1 资源库系统开发工具 ..................................................................................... 36
4.2 资源库系统开发 ............................................................................................. 37
4.2.1 用户管理模块开发 .............................................................................. 39
4.2.2 高级管理模块开发 .............................................................................. 41
4.2.3 资源库访问技术 .................................................................................. 42
4.3 资源库系统查询模块开发 ............................................................................. 43
4.3.1 基本信息查询 ...................................................................................... 44
4.3.2 参数数据查询 ...................................................................................... 44
4.4 资源库系统调用模块开发 ............................................................................. 46
4.4.1 资源库调用过程说明 .......................................................................... 46
4.4.2 资源库调用程序 .................................................................................. 47
4.5 本章小结 ......................................................................................................... 48
5 基于资源库的滚动轴承设计 .................................................................................... 49
5.1 基于资源库的滚动轴承数据查询与调用 ..................................................... 49
5.1.1 嵌入式 SQL 语言 ................................................................................ 49
5.1.2 资源库参数表的单值查询与调用 ...................................................... 49
5.1.3 资源库参数表的范围值查询与调用 .................................................. 50
5.1.4 资源库参数表的标准值查询与调用 .................................................. 51
5.2 基于资源库的滚动轴承设计程序开发 ......................................................... 52
5.2.1 基于资源库的滚动轴承尺寸设计模块 .............................................. 53
5.2.2 基于资源库的滚动轴承校核计算模块 .............................................. 56
5.2.3 资源库数据交互模块 .......................................................................... 58
5.3 基于资源库的滚动轴承设计案例 ................................................................. 59
5.4 本章小结 ......................................................................................................... 61
剩余85页未读,继续阅读
资源评论
2201_75761617
- 粉丝: 20
- 资源: 7339
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功