Civil aircraft material management method and system
By storing material information in relational databases and storing parameter performance comparison graphical information in non-relational databases in the civil machine material management system, the problem of slowing down reading and writing speed caused by the increase in the number of civil machine products is solved, and development efficiency is improved.
Patent Information
- Application Number
- CN202411345610.5
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Priority Date
- 2024-08-09
- Filing Date
- 2024-09-26
- Publication Date
- 2025-01-03
AI Technical Summary
As the number of civilian products increases, the storage space demand for existing civilian material management systems increases, resulting in slowing down the reading and writing speed, seriously affecting the development cycle of developers.
The storage of civil machine material information in a relational database and the comparison of parameter performance graph information is stored in a non-relational database, and different requirements are processed separately through these two databases to improve processing efficiency.
It significantly improves the reading and writing speed of civil machine material management system and improves the development efficiency of developers.
Smart Images

Figure CN119250359A_ABST
Abstract
Description
Technical Field
[0001] The present invention relates to the field of civil aircraft management technology, and in particular to a civil aircraft material management method; (In addition, the present invention also relates to a civil aircraft material management system. Background Art
[0002] Civil aircraft material technology is a very important part of the aircraft design process and determines the performance of the aircraft to a large extent. With the continuous increase in the number of civil aircraft products, the storage space consumed by storing information related to civil aircraft product materials is increasing, resulting in the existing civil aircraft material management system reading and writing speeds becoming slower and slower, seriously affecting the development cycle of developers. Summary of the invention
[0003] In order to solve the problems existing in the prior art, at least one embodiment of the present invention provides a civil aircraft material management method, which greatly improves the reading and writing speed of the civil aircraft material management system and improves the development efficiency of developers. To this end, at least one embodiment of the present invention also provides a civil aircraft material management system.
[0004] In a first aspect, an embodiment of the present invention provides a civil aircraft material management method, including:
[0005] storing the civil aircraft material information in the first relational database, and storing the civil aircraft material parameter performance comparison graphic information in the non-relational database;
[0006] Select materials for civil aircraft products under development through civil aircraft material information in the first relational database;
[0007] Determine the available materials for civil aircraft products through the comparison of civil aircraft material parameter performance graphic information in the non-relational database;
[0008] The determined civil aircraft product availability material information is stored in the second relational database.
[0009] In some embodiments, the present invention provides a civil aircraft material management method, which stores the determined civil aircraft product availability material information in a second relational database, including:
[0010] The usage of the confirmed civil aircraft availability materials is counted and the statistical data is output in an Excel spreadsheet.
[0011] In some embodiments, the present invention provides a civil aircraft material management method, which stores civil aircraft material information in a first relational database, including:
[0012] The material supplier information is stored in the first relational database.
[0013] In some embodiments, the present invention provides a civil aircraft material management method, which determines the civil aircraft product availability materials through civil aircraft material parameter performance comparison graphic information in a non-relational database, including:
[0014] The availability materials of civil aircraft products are determined by performing performance tests on civil aircraft materials in the civil aircraft material parameter performance comparison graphic information, and the availability material information of civil aircraft products determined after the performance tests is stored in the second relational database.
[0015] In a second aspect, an embodiment of the present invention further provides a civil aircraft material management system, including:
[0016] A first storage module, used to store civil aircraft material information in a first relational database;
[0017] The second storage module is used to store the civil aircraft material parameter performance comparison graphic information in a non-relational database;
[0018] The material selection module is used to select materials for civil aircraft products under development through civil aircraft material information in the relational database;
[0019] A material determination module, used to determine the available materials of civil aircraft products through the civil aircraft material parameter performance comparison graphic information in the non-relational database;
[0020] The third storage module is used to store the determined civil aircraft product availability material information in the second relational database.
[0021] In some embodiments, the present invention provides a civil aircraft material management system, wherein the third storage module includes:
[0022] The statistical module is used to count the usage of the confirmed civil aircraft availability materials and output the statistical data through an Excel spreadsheet.
[0023] In some embodiments, the present invention provides a civil aircraft material management system, wherein the material determination module includes:
[0024] The testing module is used to determine the availability materials of civil aircraft products by performing performance tests on the civil aircraft materials in the civil aircraft material parameter performance comparison graphic information, and store the availability material information of civil aircraft products determined after the performance test in the second relational database.
[0025] In a third aspect, an embodiment of the present invention further provides a civil aircraft material management device, comprising at least one processor; a memory coupled to the at least one processor, the memory storing executable instructions, which when executed by the at least one processor implement the steps of any one of the methods of the first aspect above.
[0026] In a fourth aspect, an embodiment of the present invention further provides a chip for executing the steps of the method in the first aspect. Specifically, the chip includes: a processor for calling and running a computer program from a memory, so that a device equipped with the chip is used to execute the steps of the method in the first aspect.
[0027] In a fifth aspect, an embodiment of the present invention further provides a computer-readable storage medium, on which a computer program is stored, and when the computer program is executed by a processor, the steps of any one of the methods in the first aspect above are implemented.
[0028] It can be seen that a civil aircraft material management method and system in an embodiment of the present invention stores civil aircraft material information in a first relational database, stores civil aircraft material parameter performance comparison graphic information in a non-relational database, and then stores determined civil aircraft product availability material information in a second relational database. Different processing requirements use relational databases and non-relational databases respectively, thereby effectively improving the processing efficiency of different processing requirements, greatly improving the reading and writing speed of the civil aircraft material management system, and improving the development efficiency of developers. BRIEF DESCRIPTION OF THE DRAWINGS
[0029] In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the drawings required for use in the embodiments or the description of the prior art will be briefly introduced below. Obviously, the drawings described below are only some embodiments of the present invention. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying creative labor.
[0030] Figure 1 Shown is a flow chart of a civil aircraft material management method in an embodiment of the present invention;
[0031] Figure 2 Shown is a schematic diagram of the framework of a civil aircraft material management system in an embodiment of the present invention. Specific implementation plan
[0032] In order to make the purpose, technical solution and advantages of the embodiments of the present invention clearer, the technical solution in the embodiments of the present invention will be clearly and completely described below in conjunction with the drawings in the embodiments of the present invention. Obviously, the described embodiments are part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of the present invention.
[0033] It should be noted that, in this article, relational terms such as "first" and "second" are only used to distinguish one entity or operation from another entity or operation, and do not necessarily require or imply any such actual relationship or order between these entities or operations. In this article, the terms "include", "comprise" or any other variants thereof are intended to cover non-exclusive inclusion, so that a process, method, article or device including a series of elements includes not only those elements, but also other elements not explicitly listed, or also includes elements inherent to such process, method, article or device. In the absence of further restrictions, an element defined by the sentence "comprises a ..." does not exclude the existence of other identical elements in the process, method, article or device including the element.
[0034] The inventor of the present solution has found that in the prior art, with the continuous surge in the number of civil aircraft products, the storage space consumed by storing information related to civil aircraft product materials is getting larger and larger, resulting in the reading and writing speed of the existing civil aircraft material management system becoming slower and slower, seriously affecting the development cycle of developers.
[0035] [Example 1]
[0036] Embodiment 1 of the present invention provides the following solution:
[0037] like Figure 1 As shown, this embodiment provides a civil aircraft material management method, including:
[0038] Step 101, storing civil aircraft material information in a first relational database, and storing civil aircraft material parameter performance comparison graphic information in a non-relational database.
[0039] It should be noted that the first relational database can use the MySQL database, and civil aircraft material information can be added, modified, deleted, imported, and exported through the first relational database. The specific parameters of civil aircraft materials include material categories, material subcategories, material specifications, confidentiality levels, material names, material grades, suppliers, applicable models, melting temperatures, density, varieties, hardness, specifications, usage status, supply status, material identification, potential difference, number of calls, elongation, fracture toughness, specific strength, Young's modulus, shear modulus, yield strength, Poisson's ratio, and linear expansion coefficient.
[0040] The non-relational database can use the NoSQL database, and the civil aircraft material parameter performance comparison graphic information can be added, modified, and deleted through the non-relational database. The performance comparison of the parameters of various civil aircraft materials is displayed through the graph, so that R&D personnel can see the parameter performance comparison more intuitively and improve the R&D efficiency of R&D personnel.
[0041] In some embodiments, the material supplier information is stored in the first relational database, and the material supplier information can be added, modified, deleted, imported, and exported through the first relational database. The material supplier information includes supplier name, confidentiality level, contact person, contact information, region, enterprise qualification, confidentiality level, remarks, status, creator, creation time, modifier, modification time, and quantity of supplied materials.
[0042] Step 102, selecting materials for the civil aircraft product under development through the civil aircraft material information in the first relational database. It can be understood that civil aircraft materials that may be suitable for the civil aircraft product under development are selected from the first relational database.
[0043] Step 103, determine the available materials for civil aircraft products through the civil aircraft material parameter performance comparison graphic information in the non-relational database. It can be understood that by displaying the parameter performance comparison of each civil aircraft material through a graph, R&D personnel can see the parameter performance comparison more intuitively, thereby determining the available materials for civil aircraft products.
[0044] Step 104: Store the determined civil aircraft product availability material information into a second relational database.
[0045] In some embodiments, the usage of the materials of civil aircraft availability that have been determined is counted, and the statistical data is output through an Excel spreadsheet, thereby facilitating R&D personnel to check the data.
[0046] In some embodiments, the availability materials of civil aircraft products are determined by performing performance tests on civil aircraft materials in civil aircraft material parameter performance comparison graphic information, and the availability material information of civil aircraft products determined after the performance tests is stored in a second relational database, thereby more accurately ensuring the availability materials of the civil aircraft products.
[0047] [Example 2]
[0048] like Figure 2 As shown, this embodiment provides a civil aircraft material management system, including a first storage module, a second storage module, a material selection module, a material determination module, and a third storage module.
[0049] The first storage module is used to store civil aircraft material information in the first relational database. The second storage module is used to store civil aircraft material parameter performance comparison graphic information in the non-relational database. The material selection module is used to select materials for civil aircraft products under development through the civil aircraft material information in the first relational database. It can be understood that civil aircraft materials that may be suitable for the civil aircraft products under development are selected from the first relational database. The material determination module is used to determine the available materials for civil aircraft products through the civil aircraft material parameter performance comparison graphic information in the non-relational database. It can be understood that by displaying the parameter performance comparison of each civil aircraft material in a graph, R&D personnel can see the parameter performance comparison more intuitively, thereby determining the available materials for civil aircraft products. The third storage module is used to store the determined civil aircraft product availability material information in the second relational database.
[0050] It should be noted that the first relational database can use the MySQL database, and civil aircraft material information can be added, modified, deleted, imported, and exported through the first relational database. The specific parameters of civil aircraft materials include material categories, material subcategories, material specifications, confidentiality levels, material names, material grades, suppliers, applicable models, melting temperatures, density, varieties, hardness, specifications, usage status, supply status, material identification, potential difference, number of calls, elongation, fracture toughness, specific strength, Young's modulus, shear modulus, yield strength, Poisson's ratio, and linear expansion coefficient.
[0051] The non-relational database can use the NoSQL database, and the civil aircraft material parameter performance comparison graphic information can be added, modified, and deleted through the non-relational database. The performance comparison of the parameters of various civil aircraft materials is displayed through the graph, so that R&D personnel can see the parameter performance comparison more intuitively and improve the R&D efficiency of R&D personnel.
[0052] In some embodiments, the material supplier information is stored in the first relational database, and the material supplier information can be added, modified, deleted, imported, and exported through the first relational database. The material supplier information includes supplier name, confidentiality level, contact person, contact information, region, enterprise qualification, confidentiality level, remarks, status, creator, creation time, modifier, modification time, and quantity of supplied materials.
[0053] In some embodiments, the third storage module includes a statistical module, which is used to count the usage of the determined civil aircraft availability materials and output the statistical data through an Excel spreadsheet, thereby facilitating R&D personnel to check the data.
[0054] In some embodiments, the material determination module includes a testing module, which is used to determine the availability materials of civil aircraft products by performing performance tests on civil aircraft materials in civil aircraft material parameter performance comparison graphic information, and store the availability material information of civil aircraft products determined after the performance test in a second relational database, thereby more accurately ensuring the availability materials of the civil aircraft products.
[0055] [Example 3]
[0056] This embodiment provides a civil aircraft material management device, including:
[0057] At least one processor; a memory coupled to the at least one processor, the memory storing executable instructions, wherein the executable instructions, when executed by the at least one processor, implement the method steps of embodiment 1 of the present invention.
[0058] In a civil aircraft material management device provided by an embodiment of the present invention, a processor and a memory may be provided separately or integrated together.
[0059] For example, the memory may include a random access memory, a flash memory, a read-only memory, a programmable read-only memory, a non-volatile memory or a register, etc. The processor may be a central processing unit (CPU), etc. or a graphic processing unit (GPU). The memory may store executable instructions. The processor may execute the executable instructions stored in the memory to implement the various processes described herein.
[0060] It can be understood that the memory in this embodiment can be a volatile memory or a non-volatile memory, or can include both volatile and non-volatile memories. Among them, the non-volatile memory can be a ROM (Read-Only Memory), a PROM (Programmable ROM), an EPROM (Erasable PROM), an EEPROM (Electrically EPROM), or a flash memory. The volatile memory can be a RAM (Random Access Memory), which is used as an external cache. By way of example but not limitation, many forms of RAM are available, such as SRAM (Static RAM), DRAM (Dynamic RAM), SDRAM (Synchronous DRAM), DDR SDRAM (Double Data Rate SDRAM), ESDRAM (Enhanced SDRAM), SLDRAM (Synchlink DRAM), and DRRAM (Direct Rambus RAM). The memories described herein are intended to include, but are not limited to, these and any other suitable types of memories.
[0061] In some embodiments, the memory stores the following elements, upgrade packages, executable units or data structures, or a subset thereof, or an extended set thereof: an operating system and an application program.
[0062] The operating system includes various system programs, such as a framework layer, a core library layer, a driver layer, etc., which are used to implement various basic services and process hardware-based tasks. The application program includes various application programs, which are used to implement various application services. The program for implementing the method of the embodiment of the present invention can be included in the application program.
[0063] In the embodiment of the present invention, the processor calls a program or instruction stored in the memory, specifically, a program or instruction stored in an application program, and the processor is used to execute the method steps of the embodiment 1 of the present invention.
[0064] [Example 4]
[0065] This embodiment provides a chip for executing the method of the above-mentioned embodiment 1 of the present invention. Specifically, the chip includes: a processor for calling and running a computer program from a memory, so that a device equipped with the chip is used to execute the method of the embodiment 1 of the present invention.
[0066] [Example 5]
[0067] This embodiment provides a computer-readable storage medium, on which a computer program is stored. When the computer program is executed by a processor, the steps of the method of Embodiment 1 of the present invention are implemented.
[0068] For example, machine-readable storage media may include, but are not limited to, various known and unknown types of non-volatile memory.
[0069] In summary, embodiments 1-5 of the present invention provide a civil aircraft material management method and system, which stores civil aircraft material information in a first relational database, stores civil aircraft material parameter performance comparison graphic information in a non-relational database, and then stores the determined civil aircraft product availability material information in a second relational database. Different processing requirements use relational databases and non-relational databases respectively, which effectively improves the processing efficiency of different processing requirements, greatly improves the reading and writing speed of the civil aircraft material management system, and improves the development efficiency of developers.
[0070] It will be appreciated by those skilled in the art that the units and algorithm steps of each example described in conjunction with the embodiments disclosed herein can be implemented in electronic hardware, or a combination of software and electronic hardware. Whether these functions are implemented in hardware or software depends on the specific application and design constraints of the technical solution. Those skilled in the art may use different methods to implement the described functions for each specific application, but such implementation should not be considered to be beyond the scope of this application.
[0071] In the embodiments of the present application, the disclosed systems, devices and methods can be implemented in other ways. For example, the division of units is only a logical function division, and there can be other division methods in actual implementation. For example, multiple units or components can be combined or integrated into another system. In addition, the coupling between the various units can be direct coupling or indirect coupling. In addition, the various functional units in the embodiments of the present application can be integrated into a processing unit, or can be separate physical existences, etc.
[0072] It should be understood that in the various embodiments of the present application, the size of the serial number of each process does not mean the order of execution. The execution order of each process should be determined by its function and internal logic, and should not constitute any limitation on the implementation process of the embodiments of the present application.
[0073] If the functions are implemented in the form of software functional units and sold or used as independent materials, they can be stored in a machine-readable storage medium. Therefore, the technical solution of the present application can be embodied in the form of software materials, which can be stored in a machine-readable storage medium, which can include several instructions to enable an electronic device to perform all or part of the technical solution described in the embodiments of the present application. The above-mentioned storage medium may include various media that can store program codes, such as ROM, RAM, removable disk, hard disk, magnetic disk or optical disk.
[0074] The above contents are only specific implementation methods of the present application, and the protection scope of the present application is not limited thereto. Those skilled in the art may make changes or substitutions within the technical scope disclosed in the present application, and these changes or substitutions shall be within the protection scope of the present application.
Claims
1. A civil aircraft material management method, characterized in that: include: storing the civil aircraft material information in the first relational database, and storing the civil aircraft material parameter performance comparison graphic information in the non-relational database; Selecting materials for the civil aircraft products under development by using the civil aircraft material information in the first relational database; Determine the available materials for civil aircraft products through the civil aircraft material parameter performance comparison graphic information in the non-relational database; The determined civil aircraft product availability material information is stored in the second relational database.
2. The civil aircraft material management method according to claim 1, characterized in that: The storing the determined civil aircraft product availability material information into the second relational database includes: The usage of the confirmed civil aircraft availability materials is counted and the statistical data is output in an Excel spreadsheet.
3. The civil aircraft material management method according to claim 1, characterized in that: The storing of the civil aircraft material information in the first relational database includes: The material supplier information is stored in the first relational database.
4. The civil aircraft material management method according to claim 1, characterized in that: The determining of the civil aircraft product availability materials through the civil aircraft material parameter performance comparison graphic information in the non-relational database includes: The availability materials of civil aircraft products are determined by performing performance tests on the civil aircraft materials in the civil aircraft material parameter performance comparison graphic information, and the availability material information of civil aircraft products determined after the performance tests is stored in the second relational database.
5. A civil aircraft material management system, characterized in that: include: A first storage module, used to store civil aircraft material information in a first relational database; The second storage module is used to store the civil aircraft material parameter performance comparison graphic information in a non-relational database; A material selection module, used to select materials for the civil aircraft products under development according to the civil aircraft material information in the first relational database; A material determination module, used to determine the available materials of civil aircraft products through the civil aircraft material parameter performance comparison graphic information in the non-relational database; The third storage module is used to store the determined civil aircraft product availability material information in the second relational database.
6. The civil aircraft material management system according to claim 5, characterized in that: The third storage module includes: The statistical module is used to count the usage of the confirmed civil aircraft availability materials and output the statistical data through an Excel spreadsheet.
7. The civil aircraft material management system according to claim 5, characterized in that: The material determination module comprises: The testing module is used to determine the availability materials of civil aircraft products by performing performance tests on the civil aircraft materials in the civil aircraft material parameter performance comparison graphic information, and store the availability material information of civil aircraft products determined after the performance test in the second relational database.
8. A civil aircraft material management device, comprising at least one processor; a memory coupled to the at least one processor, the memory storing executable instructions, characterized in that: The executable instructions, when executed by the at least one processor, enable the steps of the method according to any one of claims 1 to 4 to be implemented.
9. A chip, characterized in that: It comprises a processor, which is used to call and run a computer program from a memory, so that a device equipped with the chip executes the steps of the method as claimed in any one of claims 1 to 4.
10. A computer-readable storage medium having a computer program stored thereon, characterized in that: When the computer program is executed by a processor, the steps of the method according to any one of claims 1 to 4 are implemented.
