Material feature describing and storing method during material management

Abstract

The invention belongs to the field of material management, and in particular relates to a material feature describing and storing method during material management. The method comprises the following steps of: (1) describing and grouping the main features of materials that users concern; (2) establishing a one-dimensional address pointer; (3) pairing and combining the main features of materials with the address pointer, and establishing a description specification; (4) describing each newly-added material data according to the description specification established in step (3), namely carrying out feature combination; (5) storing the data described in step (4) in a database; (6) decomposing features of the data in the database by an address pointer isolating method and generating a query table; and (7) carrying out multi-feature combination searching operation on the query table generated in step (6). By adopting the method, the required materials can be retrieved rapidly.

Description

technical field [0001] The invention relates to the field of material management, in particular to a method for material feature description and storage in material management. Background technique [0002] There are at least tens of thousands of product materials in a mature enterprise. Some materials have design drawings, and some do not have design drawings. It is very difficult to quickly find the required materials among so many materials. Usually, the practice of enterprises It is to establish a material library, and to retrieve these materials, it is necessary to describe them in advance, and the current feature description methods of PDM or ERP software on the market are all through keyword matching, because the material code and its feature description are based on the master data table. is stored in the database in the form of , the main data table is the data source table, and the feature description is in the main data table, which occupies only one cell in the d...

AI Technical Summary

Problems solved by technology

[0002] A mature enterprise has at least tens of thousands of product materials, some of which have design drawings, and some do not have design drawings. It is very difficult to quickly find the required materials among so many materials. It is to establish a material library, and to retrieve these materials, they must be described in advance. However, the feature description methods of PDM or ERP software currently on the market are all through keyword matching, because the material code and its feature description are based on the master data table. The form is stored in the database, the main data table is the data source table, and the feature description is in the main data table, which only occupies one cell in the database, because if the feature description occupies more cells in the database, Then other relational tables and queries in the database need to be very slow when calling the data described by these features, and the calling efficiency is very low, so most of them cannot realize multi-feature matching retrieval, and can only perform single-feature matching, so that only through keyword matching (that is, single There will be many kinds of materials retrieved by feature retrieval), and then it is necessary to continuously perform keyword matching retrieval until the required materials are retrieved, which is very inconvenient and the retrieval speed is slow, and sometimes there may be omissions, As a result, the required materials cannot be found. If the materials are not found, it is equivalent to not finding the drawings. The engineer needs to redraw, which increases the workload of the engineer and even delays production; The characteristic description of the material is equivalent to occupying only one cell, so the total capacity (that is, the number of bytes) contained in this cell is fixed, so the total capacity will be divided into multiple parts and distributed to multiple Different features, so the capacity assigned to each feature is fixed. When the required material’s feature does not reach this capacity, you need to make up this capacity by adding 0, that is, for example, the axis of the material I need to retrieve The length is 51 mm, and I allocated 4 bytes to the feature of shaft length when I started the allocation, then we need to enter 0051 when searching, and when the feature of the required material exceeds this capacity, we cannot search for this feature , it is not very convenient to retrieve

Images