| 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 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. |
