The powder metallurgy database is a data system for effective management of powder metallurgy information. With the development of information technology, its construction scale and quality will directly affect the convenient inquiry of powder metallurgy information, the selection of gear materials, the research and development and engineering application of micro-drive systems, and have engineering significance and market value. However, the groundwork in this field still lags behind other materials fields and needs to be developed systematically.

Consider the small modulus powder metallurgy gear’s elastic modulus, Poisson’s ratio, fatigue life, metallographic structure and processing parameters as research objectives, the functional requirements of the database, system functions and data relationships are analyzed. The function module, database model, user authority and system architecture are designed in detail. Based on the Flask framework and MySQL, the database system on the basic properties of powder metallurgy materials is designed and developed, which realizes the systematic and standardization of mechanical property data of powder metallurgy. Users are provided with upload, query and retrieval services of chemical composition, heat treatment and molding properties, fracture mechanics, material suppliers and other information.

In this paper, the necessity and urgency of building a powder metallurgy database to increase the efficiency of transmission system development and its application are demonstrated. The deficiencies of the existing powder metallurgy database are analyzed, and suggestions are provided for the selection, design, data coverage, and construction of big data applications for smart materials. The technical challenges of small modulus powder metallurgy gear selection and plan formulation are then ameliorated.

Github repository: PMdatabase2 (github.com)