滚动轴承资源库系统设计与开发

Design and Development of Rolling Bearing Resource Database System

基于关系模型和关系数据库技术,设计并构建可共享、可扩展的的滚动轴承资源库系统。在需求分析的基础上,对滚动轴承资源库进行概念设计、逻辑设计及物理设计,利用My SQL数据库管理系统分别开发滚动轴承资源库的基本信息数据库、标准数据库和非标数据库。研究基于JDBC的数据库访问技术,开发滚动轴承资源库的查询和调用模块。以圆柱滚子轴承的外形尺寸参数设计计算作为应用背景,实现在matlab开发环境中对滚动轴承资源库的调用,缩短了机械产品设计的周期。

Based on the relational model and relational database technology, a shared and extensible rolling bearing resource database system is designed and constructed. Based on requirement analysis, the concept design, logic design and physical design of rolling bearing resource database are carried out. The basic information database, standard database and non-standard database of rolling bearing resource database are developed by My SQL database management system. The database access technology based on JDBC is studied, and the query and call module of rolling bearing resource database is developed. Taking the design and calculation of cylindrical roller bearing’s shape and dimension parameters as the application background, the rolling bearing resource database is transferred in the MatLab development environment, which shortens the design cycle of mechanical products.