Construction method and system of three-phase asynchronous motor database

Abstract

The invention provides a three-phase asynchronous motor database construction method and system, and the method comprises the steps: obtaining the source data of a three-phase asynchronous motor, and the source data comprises the common parameters, geometric dimensions and performance parameters of the motor; analyzing a data dependency relationship among the common parameters, the geometric dimensions and the performance parameters to determine a determination condition of each data set; creating a plurality of correlative data tables based on the data dependency relationship, wherein the data tables comprise a geometric dimension table group for storing geometric dimensions of the motor and a performance parameter table for storing performance parameters of the motor; and constructing an entity-relationship model of the database based on the association relationship among the plurality of data tables, and generating an SQL statement for data query. According to the technical scheme provided by the invention, structured and standardized storage of the motor data is realized, data redundancy is remarkably reduced, data reusability and query efficiency are improved, and industrial digital application is effectively supported.

Description

Technical Field

[0001] This application relates to the field of database construction technology, and in particular to a method and system for constructing a database of three-phase asynchronous motors. Background Technology

[0002] In industrial sectors such as coal mining, chemical engineering, and manufacturing, three-phase asynchronous motors serve as core power equipment. Their models and specifications are complex, with diverse parameters (covering voltage levels, power, number of poles, installation dimensions, efficiency, and other geometric and performance parameters). Furthermore, they need to adapt to different scenarios in equipment selection, engineering design (such as drives for underground coal mining equipment and supporting conveying systems in coal preparation plants), and operation and maintenance. With the advancement of industrial digital transformation, technologies such as 3D design, intelligent selection, and predictive maintenance place higher demands on the structured storage of motor data. Currently, motor data management and application face the following pain points: Fragmented data management and poor reusability: Existing motor data is mostly stored in unstructured formats (such as manufacturer PDF samples, Excel spreadsheets, and design drawing annotations) scattered across local enterprise terminals or document systems, lacking a unified storage medium and classification standards. This requires significant time to retrieve and verify data, severely hindering design efficiency and data reuse value. When it's necessary to quickly generate new motor models based on parameter changes (e.g., adjusting from 380V / 55kW to 660V / 75kW) or to perform selection compliance verification, manual recalculation and matching of parameters are required. This cannot support digital scenarios such as parametric modeling in 3D design, leading to a disconnect between motor data and industrial digital processes.

[0003] Database construction lacks standardized methods and is not universally applicable. Although some enterprises have attempted to build electric motor data storage systems, they often suffer from problems such as storing only single types of data, failing to form a unified and universal electric motor data service capability, having overly simple table relationships, and high levels of data redundancy. These issues make it difficult to meet the standardized and structured application requirements of electric motor data for industrial digital transformation.

[0004] Therefore, there is an urgent need for a standardized database construction scheme for three-phase asynchronous motors to achieve efficient data management and support for digital applications. Summary of the Invention

[0005] This application provides a method and system for constructing a three-phase asynchronous motor database, in order to at least solve the technical problems of fragmented, redundant, and lack of standardized structure in motor data management in the prior art.

[0006] The first aspect of this application proposes a method for constructing a three-phase asynchronous motor database, the method comprising: Obtain source data for a three-phase asynchronous motor, including common parameters, geometric dimensions, and performance parameters of the motor; The data dependencies among the shared parameters, geometric dimensions, and performance parameters are analyzed to determine the conditions for determining each data set; Based on the data dependencies, multiple interrelated data tables are created, including a geometric dimension table group for storing the geometric dimensions of the motor and a performance parameter table for storing the performance parameters of the motor. Based on the relationships between the multiple data tables, an entity-relationship model of the database is constructed, and SQL statements for data querying are generated.

[0007] Preferably, the common parameters include: frame number, frame type, core length code, number of poles, voltage, and power; The geometric dimensions include installation dimensions and external dimensions; The performance parameters include rated speed, efficiency, power factor, stall torque / rated torque ratio, and maximum torque / rated torque ratio.

[0008] Furthermore, the analysis of the data dependencies among the shared parameters, geometric dimensions, and performance parameters to determine the conditions for each data set includes: Electric motors are classified into two categories: conventional electric motors and special electric motors. For a conventional electric motor, its geometric dimensions are determined by a set of {frame size, voltage} or {frame size, voltage, number of poles}; For special motors, their geometric dimensions are determined by a set of {frame size, voltage, motor series, manufacturer} or {frame size, voltage, motor series, manufacturer, frame type, number of poles}. The performance parameters are determined by a set of {power, voltage, motor series, manufacturer, number of poles}.

[0009] Furthermore, the process of creating a geometry table set for storing the geometry of a typical electric motor includes: A standard motor mounting dimension table is used to store geometric dimension data determined by {frame size, voltage}; A standard motor side-view bolt positioning dimension table, associated with the standard motor installation dimension table, is used to store geometric dimension data determined by {frame number, voltage, frame type}; A standard motor output shaft dimension table, associated with the standard motor mounting dimension table, is used to store geometric dimension data determined by {frame size, voltage, number of poles}; The standard motor end view external dimensions table is associated with the standard motor side view bolt positioning dimensions table, and is also associated with the motor series table and the motor manufacturer table; The standard motor side view dimensions table is associated with the standard motor end view dimensions table.

[0010] Furthermore, the process of creating the geometry table set for storing specific motor geometries includes: Special motor end view dimension table, used to store geometric dimension data determined by {frame size, voltage, motor series, manufacturer}; A special motor side view mounting dimension table, associated with the special motor end view dimension table, is used to store geometric dimension data determined by {frame number, voltage, motor series, manufacturer, frame type}. A special motor length and shaft dimension table, associated with the special motor side view mounting dimension table, is used to store geometric dimension data determined by {frame number, voltage, motor series, manufacturer, frame type, number of poles}.

[0011] Furthermore, the performance parameter table is linked to the motor series table and the motor manufacturer table via foreign keys, and its primary key or uniqueness constraint is constructed based on the set of {power, voltage, motor series, manufacturer, number of poles}.

[0012] Preferably, the three-phase asynchronous motor includes one or more of the following series: YB, YE, YBBP, YBF, YBX, YBK, Y, YX, YKK, and YXKK.

[0013] A second aspect of this application provides a system for constructing a database of three-phase asynchronous motors, comprising: The acquisition module is used to acquire source data of a three-phase asynchronous motor, the source data including common parameters, geometric dimensions and performance parameters of the motor; The determination module is used to analyze the data dependencies between the common parameters, geometric dimensions, and performance parameters to determine the determination conditions for each data set; A creation module is used to create multiple interrelated data tables based on the data dependencies. The data tables include a geometric dimension table group for storing the geometric dimensions of the motor and a performance parameter table for storing the performance parameters of the motor. The building module is used to construct the entity-relationship model of the database based on the relationships between the multiple data tables, and generate SQL statements for data querying.

[0014] A third aspect of this application provides an electronic device, including: a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein when the processor executes the program, it implements the method described in the first aspect embodiment.

[0015] A fourth aspect of this application provides a computer-readable storage medium having a computer program stored thereon that, when executed by a processor, implements the method described in the first aspect.

[0016] The technical solutions provided by the embodiments of this application bring at least the following beneficial effects: This application proposes a method and system for constructing a three-phase asynchronous motor database. The method includes: acquiring source data of the three-phase asynchronous motor, the source data including common parameters, geometric dimensions, and performance parameters of the motor; analyzing the data dependencies between the common parameters, geometric dimensions, and performance parameters to determine the conditions for determining each data set; creating multiple interrelated data tables based on the data dependencies, the data tables including a geometric dimension table group for storing the motor's geometric dimensions and a performance parameter table for storing the motor's performance parameters; constructing an entity-relationship model of the database based on the relationships between the multiple data tables, and generating SQL statements for data querying. The technical solution proposed in this application achieves structured and standardized storage of motor data, significantly reduces data redundancy, improves data reusability and query efficiency, and effectively supports industrial digital applications.

[0017] Additional aspects and advantages of this application will be set forth in part in the description which follows, and in part will be obvious from the description, or may be learned by practice of this application. Attached Figure Description

[0018] The above and / or additional aspects and advantages of this application will become apparent and readily understood from the following description of the embodiments taken in conjunction with the accompanying drawings, wherein: Figure 1 This is a flowchart illustrating a method for constructing a three-phase asynchronous motor database according to an embodiment of this application; Figure 2 A diagram showing the geometric dimensions of an asynchronous motor according to an embodiment of this application; Figure 3 This is a geometric dimension table of a special asynchronous motor provided according to an embodiment of this application; Figure 4 This is a diagram showing the relationship between performance parameters of an asynchronous motor according to an embodiment of this application. Figure 5 This is a structural diagram of a three-phase asynchronous motor database construction system provided according to an embodiment of this application. Detailed Implementation

[0019] The embodiments of this application are described in detail below. Examples of these embodiments are shown in the accompanying drawings, wherein the same or similar reference numerals denote the same or similar elements or elements having the same or similar functions throughout. The embodiments described below with reference to the accompanying drawings are exemplary and intended to explain this application, and should not be construed as limiting this application.

[0020] This application proposes a method and system for constructing a three-phase asynchronous motor database. The method includes: acquiring source data of the three-phase asynchronous motor, the source data including common parameters, geometric dimensions, and performance parameters of the motor; analyzing the data dependencies among the common parameters, geometric dimensions, and performance parameters to determine the determination conditions of each data set; creating multiple interrelated data tables based on the data dependencies, the data tables including a geometric dimension table group for storing the motor's geometric dimensions and a performance parameter table for storing the motor's performance parameters; and constructing an entity-relationship model of the database based on the relationships between the multiple data tables, and generating SQL statements for data querying. The technical solution proposed in this application achieves structured and standardized storage of motor data, significantly reduces data redundancy, improves data reusability and query efficiency, and effectively supports industrial digital applications.

[0021] The following description, with reference to the accompanying drawings, illustrates a method and system for constructing a three-phase asynchronous motor database according to an embodiment of this application.

[0022] Example 1 Figure 1 This is a flowchart illustrating a method for constructing a three-phase asynchronous motor database according to an embodiment of this application, as shown below. Figure 1 As shown, the method includes: Step 1: Obtain the source data of the three-phase asynchronous motor, which includes the motor's common parameters, geometric dimensions, and performance parameters; In this embodiment of the disclosure, the common parameters include: frame number, frame type, core length code, number of poles, voltage, and power; The geometric dimensions include installation dimensions and external dimensions; The performance parameters include rated speed, efficiency, power factor, stall torque / rated torque ratio, and maximum torque / rated torque ratio.

[0023] It should be noted that different asynchronous motor product series use the same parameters to express basic characteristics. These parameters are called common motor parameters, including frame size, frame type, core code, number of poles, voltage, and output. Among them, frame size, frame type, core code, and number of poles become specification codes.

[0024] Based on their external outline, electric motors can be divided into cylindrical motors (such as YB3, YX3, YBBP, YE3, etc.) and box-type motors (YKK, YAKK, YRKK, etc.). Generally, box-type motors have a frame size of 355 or higher and are high-voltage motors.

[0025] However, the external dimensions vary between different manufacturers and product series. Most manufacturers provide the installation dimensions and external dimensions shown in Table 1 in their product catalogs.

[0026]

[0027] Common performance parameters of asynchronous motors are shown in Table 2.

[0028] Electric motors produced by different manufacturers all refer to national and industry standards to some extent, and have also formed their own enterprise standards. Among them, the installation dimensions of motors with frame sizes of 56-355 are relatively standard and follow certain patterns with common parameters; the installation dimensions of motors with frame sizes of 355-560 vary greatly among different manufacturers and have weaker patterns; the patterns are even weaker for motors with frame sizes of 630 and above.

[0029] (1) General Law 1) Based on the types and relationships between the geometric dimensions of motors, motors can be divided into ordinary motors and special motors. Ordinary motors refer to cylindrical motors with frame sizes between 63 and 560, and whose geometric dimensions follow certain patterns. Special motors are motors that do not conform to the geometric dimension patterns of ordinary motors.

[0030] 2) The frame size is the center height of the motor, which is serialized and directly affects other dimensions of the motor, especially dimensions perpendicular to the axial direction, such as the distance between the axes of the base bolt through holes (end view, A) and the distance between the outer edges of the base bolts (end view, AB). 3) The number of poles of the motor mainly affects the relevant dimensions of the motor output shaft (D, E, F, G) and the length of the motor (L). 4) The three frame types of short, medium and long mainly affect the length of the motor feet (the distance between the axes of the through holes of the foot bolts, the distance between the outer edges of the feet, etc.) and the length of the motor (L); 5) The external dimensions of motors from different series and manufacturers vary considerably; 6) The external dimensions of motors vary depending on the mounting type; this database design prioritizes the IMB3 mounting method, specifically the horizontal mounting method with feet.

[0031] 7) The external dimensions AB and AD are related to the motor series and manufacturer.

[0032] (2) The geometric dimensions of cylindrical motors with frame sizes 56-355 and 355-560 1) The distance between the axes of the base bolt through holes (end view, A), the distance from the drive end shaft shoulder to the nearest base bolt through hole axis (C), and the bolt hole diameter (K) are only related to the frame size and voltage rating; 2) The dimensions of the motor output shaft (D, E, F, G) are only related to the frame size and the number of poles; 3) The distance (B) between the axes of the through holes of the foundation bolts is only related to the frame size and frame type; 4) The external dimensions are related to the motor series and manufacturer. If it is a high-voltage motor, it is also related to the voltage level. 5) The length of the motor is related to the frame size, frame type, motor series, manufacturer, and number of poles; 6) Motors with frame sizes 56-355 are mostly low-voltage motors, but frame sizes 315 and 355 are also used for high-voltage motors. When it is a low-voltage motor, the frame size is used in conjunction with the frame type (S, M, L); when it is a high-voltage motor, the frame size is used alone. Therefore, it can be identified according to voltage level category or frame type. However, regardless of the method used, duplicate data will be generated when establishing the database. Since there are many types of motors with frame sizes 56-355, while there are fewer types of motors with frame sizes 355-560, the high / low voltage classification method is adopted.

[0033] (3) Geometric Dimensions of Special Motors Special motors include box-type motors, YBF, YBBP (630-900), YE4 (355-450), etc. The geometric dimensions of these motors are relatively universal and can be used as asynchronous motors in the coal mining industry.

[0034] 1) The end view dimensions of the motor (including A, AB, AD) (end view, A) are related to the frame size, voltage rating, motor series, and manufacturer; 2) B is related to frame size, voltage rating, motor series, manufacturer, and frame type; 3) The dimensions of C, D, E, F, G, K, L, HD, etc. are related to the frame size, voltage rating, motor series, manufacturer, frame type, and number of poles; 4) The external dimensions of some electric motors are also related to the bearing type (rolling or sliding). This design prioritizes rolling bearings.

[0035] 2. Motor performance parameters The performance parameters of an electric motor are affected by application conditions and technical characteristics, reflecting the manufacturer's processing and manufacturing capabilities. Performance parameters vary between different series and manufacturers. These parameters are related to output power, voltage, motor series, manufacturer, and number of poles.

[0036] Step 2: Analyze the data dependencies among the shared parameters, geometric dimensions, and performance parameters to determine the conditions for defining each data set; In this embodiment of the disclosure, step 2 specifically includes: Electric motors are classified into two categories: conventional electric motors and special electric motors. For a conventional electric motor, its geometric dimensions are determined by a set of {frame size, voltage} or {frame size, voltage, number of poles}; For special motors, their geometric dimensions are determined by a set of {frame size, voltage, motor series, manufacturer} or {frame size, voltage, motor series, manufacturer, frame type, number of poles}. The performance parameters are determined by a set of {power, voltage, motor series, manufacturer, number of poles}.

[0037] It should be noted that the electric motor's geometric dimensions are as follows: (1) Dependence of the geometric dimensions of conventional asynchronous motors Based on the general principles of the geometric dimensions of conventional asynchronous motors, the following dependencies exist between their geometric dimensions: {FrameSize,Voltage}→{A,C,K}; {FrameSize,Voltage,FrameType}→{A,C,K,B}; {FrameSize,Voltage,Poles}→{A,C,K,D,E,F,G}; {FrameSize,Voltage,FrameType,MotorSeries,MotorManufacturer}→{A,C,K,B,AD,HD}; {FrameSize,Voltage,FrameType,MotorSeries,MotorManufacturer,Poles}→{A,C,K,B,AD,HD,L}; (2) Dependence of the geometric dimensions of special asynchronous motors {FrameSize,Voltage,MotorSeries,MotorManufacturer}→{A,AB,AD}; {FrameSize,Voltage,MotorSeries,MotorManufacturer,FrameType}→{A,AB,AD,B}; {FrameSize,Voltage,FrameType,MotorSeries,MotorManufacturer,Poles}→{A,AB,AD,B,C,D,E,F,G,K,L,HD}; Electric motor performance parameters: The performance parameters have the following dependencies: {Output,Voltage,MotorSeries,MotorManufacturer,Poles}→{f,n,I,η,cosφ,Ist,Tst,Tm,Tmin,Jm,dB,w} Performance parameters and geometric dimensions can be correlated and looked up through the following dependencies: {Output,Voltage,Poles,MotorSeries,MotorManufacturer}→{FrameSize,FrameType}.

[0038] Step 3: Create multiple interrelated data tables based on the data dependencies. The data tables include a geometric dimension table group for storing the geometric dimensions of the motor and a performance parameter table for storing the performance parameters of the motor. In this embodiment of the disclosure, the process of creating a geometry table group for storing conventional electric motor geometry includes: A standard motor mounting dimension table is used to store geometric dimension data determined by {frame size, voltage}; A standard motor side-view bolt positioning dimension table, associated with the standard motor installation dimension table, is used to store geometric dimension data determined by {frame number, voltage, frame type}; A standard motor output shaft dimension table, associated with the standard motor mounting dimension table, is used to store geometric dimension data determined by {frame size, voltage, number of poles}; The standard motor end view external dimensions table is associated with the standard motor side view bolt positioning dimensions table, and is also associated with the motor series table and the motor manufacturer table; The standard motor side view dimensions table is associated with the standard motor end view dimensions table.

[0039] In this embodiment of the disclosure, the process of creating the geometry table group for storing specific motor geometries includes: Special motor end view dimension table, used to store geometric dimension data determined by {frame size, voltage, motor series, manufacturer}; A special motor side view mounting dimension table, associated with the special motor end view dimension table, is used to store geometric dimension data determined by {frame number, voltage, motor series, manufacturer, frame type}. A special motor length and shaft dimension table, associated with the special motor side view mounting dimension table, is used to store geometric dimension data determined by {frame number, voltage, motor series, manufacturer, frame type, number of poles}.

[0040] In this embodiment of the disclosure, the performance parameter table is linked to the motor series table and the motor manufacturer table via foreign keys, and its primary key or uniqueness constraint is constructed based on the set of {power, voltage, motor series, manufacturer, number of poles}.

[0041] It should be noted that the electric motor's geometric dimensions are as follows: The installation dimensions of conventional cylindrical asynchronous motors are relatively fixed and can be determined by the frame size, frame type, and number of poles. Since different data sets require different basic dimensions, the installation dimensions are divided into three tables: Conventional Cylindrical Asynchronous Motor Installation Dimensions Table, Conventional Cylindrical Asynchronous Motor Side View Bolt Spacing Table, and Conventional Cylindrical Asynchronous Motor Output Shaft Dimensions Table. The external dimensions of conventional cylindrical asynchronous motors are stored in Conventional Cylindrical Asynchronous Motor End View Dimensions Table and Conventional Cylindrical Asynchronous Motor Side View Dimensions Table. See Tables 3, 4, 5, 6, 7, 8, and 9 for details.

[0042]

[0043] The geometric dimensions of special asynchronous motors are less predictable. Based on collected data, the geometric dimension tables are divided into tables for end views, side views, and output shaft and length dimensions. Geometric data for which the rules governing conventional cylindrical and box-type asynchronous motors cannot be applied are treated as those for special asynchronous motors. See Tables 10, 11, and 12 for details.

[0044]

[0045]

[0046] Electric motor performance parameters The established performance parameters of the asynchronous motor are shown in Table 13.

[0047]

[0048] Step 4: Based on the relationships between the multiple data tables, construct the entity-relationship model of the database and generate SQL statements for data querying.

[0049] It should be noted that this involves creating an ER diagram of data tables and SQL query statements.

[0050] 1. Electric motor geometry (1) Geometric dimensions of conventional asynchronous motors The primary keys of tables NormalMotorInstln, NormalMotorAnchorSV, NormalMotorShaftDim, NormalMotorShapeEV, ​​MotorManufacturer, and NormalMotorShapeSV are all set to GUID, and the primary key of table MotorSeries is set to Series.

[0051] The primary keys of table NormalMotorInstln are foreign keys to both table NormalMotorAnchorSV and table NormalMotorShaftDim. The primary keys of table NormalMotorAnchorSV, table MotorSeries, and table MotorManufacturer are foreign keys to table NormalMotorShapeEV, ​​and the primary key of table NormalMotorShapeEV is a foreign key to table NormalMotorShapeSV. The relationships between the tables are shown in [link to table details]. Figure 2 Using this table structure can reduce data redundancy by about 50%.

[0052] (2) Geometric dimensions of special asynchronous motors The primary keys of tables SpecMotorDimEV, SpecMotorDimSV, SpecMotorLengthAndShaft, and MotorManufacturer are all set to GUID, and the primary key of table MotorSeries is set to Series.

[0053] The primary keys of tables MotorSeries and MotorManufacturer are foreign keys to tables SpecMotorDimEV, SpecMotorDimEV is a foreign key to SpecMotorDimSV, and SpecMotorDimSV is a foreign key to SpecMotorLengthAndShaft. See [link to table relationships] for details. Figure 3 Using this table structure can reduce data redundancy by about 50%.

[0054] 2. Motor performance parameters A performance parameter data table is created based on the dependencies. The relationships between these data tables are shown below. Figure 4 .

[0055] The primary keys for tables AsynMotorPerformance and MotorManufacturer are both set to GUID, and the primary key for table MotorSeries is set to Series.

[0056] The primary key of table MotorSeries and the primary key of table MotorManufacturer are foreign keys of table AsynMotorPerformance.

[0057] In this embodiment of the disclosure, the three-phase asynchronous motor includes one or more three-phase asynchronous motors selected from the YB, YE, YBBP, YBF, YBX, YBK, Y, YX, YKK, and YXKK series.

[0058] In summary, the method for constructing a three-phase asynchronous motor database proposed in this embodiment realizes the structured and standardized storage of motor data, significantly reduces data redundancy, improves data reusability and query efficiency, and effectively supports industrial digital applications.

[0059] Example 2 Figure 5 This is a structural diagram of a three-phase asynchronous motor database construction system according to an embodiment of this application, as shown below. Figure 5 As shown, the system includes: The acquisition module 100 is used to acquire source data of a three-phase asynchronous motor, the source data including common parameters, geometric dimensions and performance parameters of the motor; It should be noted that the common parameters include: frame number, frame type, core length code, number of poles, voltage, and power; The geometric dimensions include installation dimensions and external dimensions; The performance parameters include rated speed, efficiency, power factor, stall torque / rated torque ratio, and maximum torque / rated torque ratio.

[0060] The determination module 200 is used to analyze the data dependencies between the common parameters, geometric dimensions, and performance parameters to determine the determination conditions for each data set; A creation module 300 is used to create multiple interrelated data tables based on the data dependencies. The data tables include a geometric dimension table group for storing the geometric dimensions of the motor and a performance parameter table for storing the performance parameters of the motor. The construction module 400 is used to construct the entity-relationship model of the database based on the relationship between the multiple data tables, and generate SQL statements for data querying.

[0061] In this embodiment of the disclosure, the determining module 200 is further configured to: Electric motors are classified into two categories: conventional electric motors and special electric motors. For a conventional electric motor, its geometric dimensions are determined by a set of {frame size, voltage} or {frame size, voltage, number of poles}; For special motors, their geometric dimensions are determined by a set of {frame size, voltage, motor series, manufacturer} or {frame size, voltage, motor series, manufacturer, frame type, number of poles}. The performance parameters are determined by a set of {power, voltage, motor series, manufacturer, number of poles}.

[0062] In this embodiment of the disclosure, the creation module 300 is further configured to: A standard motor mounting dimension table is used to store geometric dimension data determined by {frame size, voltage}; A standard motor side-view bolt positioning dimension table, associated with the standard motor installation dimension table, is used to store geometric dimension data determined by {frame number, voltage, frame type}; A standard motor output shaft dimension table, associated with the standard motor mounting dimension table, is used to store geometric dimension data determined by {frame size, voltage, number of poles}; The standard motor end view external dimensions table is associated with the standard motor side view bolt positioning dimensions table, and is also associated with the motor series table and the motor manufacturer table; The standard motor side view dimensions table is associated with the standard motor end view dimensions table.

[0063] In this embodiment of the disclosure, the creation module 300 is further configured to: Special motor end view dimension table, used to store geometric dimension data determined by {frame size, voltage, motor series, manufacturer}; A special motor side view mounting dimension table, associated with the special motor end view dimension table, is used to store geometric dimension data determined by {frame number, voltage, motor series, manufacturer, frame type}. A special motor length and shaft dimension table, associated with the special motor side view mounting dimension table, is used to store geometric dimension data determined by {frame number, voltage, motor series, manufacturer, frame type, number of poles}.

[0064] In this embodiment of the disclosure, the creation module 300 is further configured to: The performance parameter table is constructed by linking the motor series table and the motor manufacturer table through foreign keys, and its primary key or uniqueness constraint is based on the set of {power, voltage, motor series, manufacturer, number of poles}.

[0065] It should be noted that the three-phase asynchronous motor includes one or more of the following series: YB, YE, YBBP, YBF, YBX, YBK, Y, YX, YKK, and YXKK.

[0066] In summary, the three-phase asynchronous motor database construction system proposed in this embodiment realizes the structured and standardized storage of motor data, significantly reduces data redundancy, improves data reusability and query efficiency, and effectively supports industrial digital applications.

[0067] Example 3 To implement the above embodiments, this disclosure also proposes an electronic device, including: a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein when the processor executes the program, it implements the method described in Embodiment 1.

[0068] Example 4 To implement the above embodiments, this disclosure also proposes a computer-readable storage medium having a computer program stored thereon, which, when executed by a processor, implements the method described in Embodiment 1.

[0069] In the description of this specification, the references to terms such as "one embodiment," "some embodiments," "example," "specific example," or "some examples," etc., refer to specific features, structures, materials, or characteristics described in connection with that embodiment or example, which are included in at least one embodiment or example of this application. In this specification, the illustrative expressions of the above terms do not necessarily refer to the same embodiment or example. Furthermore, the specific features, structures, materials, or characteristics described may be combined in any suitable manner in one or more embodiments or examples. Moreover, without contradiction, those skilled in the art can combine and integrate the different embodiments or examples described in this specification, as well as the features of different embodiments or examples.

[0070] Any process or method described in the flowchart or otherwise herein can be understood as representing a module, segment, or portion of code comprising one or more executable instructions for implementing custom logic functions or processes, and the scope of the preferred embodiments of this application includes additional implementations in which functions may be performed not in the order shown or discussed, including substantially simultaneously or in reverse order depending on the functions involved, as should be understood by those skilled in the art to which embodiments of this application pertain.

[0071] Although embodiments of this application have been shown and described above, it is understood that the above embodiments are exemplary and should not be construed as limiting this application. Those skilled in the art can make changes, modifications, substitutions and variations to the above embodiments within the scope of this application.

Claims

1. A method for constructing a database of three-phase asynchronous motors, characterized in that, The method includes: Obtain source data for a three-phase asynchronous motor, including common parameters, geometric dimensions, and performance parameters of the motor; The data dependencies among the shared parameters, geometric dimensions, and performance parameters are analyzed to determine the conditions for determining each data set; Based on the data dependencies, multiple interrelated data tables are created, including a geometric dimension table group for storing the geometric dimensions of the motor and a performance parameter table for storing the performance parameters of the motor. Based on the relationships between the multiple data tables, an entity-relationship model of the database is constructed, and SQL statements for data querying are generated.

2. The method as described in claim 1, characterized in that, The common parameters include: frame number, frame type, core length code, number of poles, voltage, and power. The geometric dimensions include installation dimensions and external dimensions; The performance parameters include rated speed, efficiency, power factor, stall torque / rated torque ratio, and maximum torque / rated torque ratio.

3. The method as described in claim 2, characterized in that, The analysis of the data dependencies among the shared parameters, geometric dimensions, and performance parameters to determine the conditions for each data set includes: Electric motors are classified into two categories: conventional electric motors and special electric motors. For a conventional electric motor, its geometric dimensions are determined by a set of {frame size, voltage} or {frame size, voltage, number of poles}; For special motors, their geometric dimensions are determined by a set of {frame size, voltage, motor series, manufacturer} or {frame size, voltage, motor series, manufacturer, frame type, number of poles}. The performance parameters are determined by a set of {power, voltage, motor series, manufacturer, number of poles}.

4. The method as described in claim 3, characterized in that, The process of creating a geometry table group for storing the geometry of a common electric motor includes: A standard motor mounting dimension table is used to store geometric dimension data determined by {frame size, voltage}; A standard motor side-view bolt positioning dimension table, associated with the standard motor installation dimension table, is used to store geometric dimension data determined by {frame number, voltage, frame type}; A standard motor output shaft dimension table, associated with the standard motor mounting dimension table, is used to store geometric dimension data determined by {frame size, voltage, number of poles}; The standard motor end view external dimensions table is associated with the standard motor side view bolt positioning dimensions table, and is also associated with the motor series table and the motor manufacturer table; The standard motor side view dimensions table is associated with the standard motor end view dimensions table.

5. The method as described in claim 4, characterized in that, The process of creating the geometry table group for storing specific motor geometries includes: Special motor end view dimension table, used to store geometric dimension data determined by {frame size, voltage, motor series, manufacturer}; A special motor side view mounting dimension table, associated with the special motor end view dimension table, is used to store geometric dimension data determined by {frame number, voltage, motor series, manufacturer, frame type}. A special motor length and shaft dimension table, associated with the special motor side view mounting dimension table, is used to store geometric dimension data determined by {frame number, voltage, motor series, manufacturer, frame type, number of poles}.

6. The method as described in claim 5, characterized in that, The performance parameter table is linked to the motor series table and the motor manufacturer table via foreign keys, and its primary key or uniqueness constraint is constructed based on the set {power, voltage, motor series, manufacturer, number of poles}.

7. The method as described in claim 1, characterized in that, The three-phase asynchronous motors include one or more of the following series: YB, YE, YBBP, YBF, YBX, YBK, Y, YX, YKK, and YXKK.

8. A system for constructing a database of three-phase asynchronous motors, characterized in that, The system includes: The acquisition module is used to acquire source data of a three-phase asynchronous motor, the source data including common parameters, geometric dimensions and performance parameters of the motor; The determination module is used to analyze the data dependencies between the common parameters, geometric dimensions, and performance parameters to determine the determination conditions for each data set; A creation module is used to create multiple interrelated data tables based on the data dependencies. The data tables include a geometric dimension table group for storing the geometric dimensions of the motor and a performance parameter table for storing the performance parameters of the motor. The building module is used to construct the entity-relationship model of the database based on the relationships between the multiple data tables, and generate SQL statements for data querying.

9. An electronic device, characterized in that, include: A memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor, when executing the program, implements the method as described in any one of claims 1-7.

10. A computer-readable storage medium having a computer program stored thereon, characterized in that, When the program is executed by the processor, it implements the method as described in any one of claims 1-7.

Images