A smart information-based material warehouse data management method and system

By constructing a database information database and analyzing the use control weights and risk factors of materials, combining the merchant-material relationship evaluation and historical retrieval behavior of merchants and materials, risk behavior rules are formulated, which solves the problem that the existing system cannot accurately judge merchants' dangerous operations, and achieves effective control of materials and the reduction of warehousing management costs.

CN118863756BActive Publication Date: 2025-03-28JIANGSU RUIXIANG TECH GRP CO LTD
View PDF 2 Cites 0 Cited by

Patent Information

Application Number
CN202411109075.3
Authority / Receiving Office
CN · China
Patent Type
Patents(China)
Current Assignee / Owner
Filing Date
2024-08-13
Publication Date
2025-03-28
Estimated Expiration
2044-08-13

AI Technical Summary

Technical Problem

The existing smart information material warehouse data management system cannot accurately determine whether there are dangerous operations in the warehouse for merchants, especially under the restrictions on the call of special business license materials and dangerous goods materials, it is difficult to balance the relationship between merchants' convenient call and material control.

Method used

By building a database management information database, analyzing the use control weight and risk factors of materials, and dividing materials into controlled materials and non-controlled materials. Based on the merchant’s business relationship evaluation and historical retrieval behaviors, formulate the risk behavior rules for merchants to retrieve materials, and monitor and judge the compliance of merchants’ behavior.

Benefits of technology

It realizes effective control of materials called by merchants, reduces the risk of call and operation of dangerous materials, reduces the cost of warehousing management, and improves the efficient flow of materials in the warehouse.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN118863756B_ABST
    Figure CN118863756B_ABST
Patent Text Reader

Abstract

The present invention relates to the field of data processing technology, and in particular to a method and system for managing data in a smart information-based material warehouse. The method first constructs a warehouse management information database, analyzes the use control weights of each material and the risk factors of the brief description phrases of each material, divides each material in the warehouse into controlled materials and non-controlled materials, and further obtains the merchant-material association evaluation between the merchant and the material, and then formulates the risk behavior rules for the merchant to retrieve materials based on the merchant-material association evaluation and the number of materials that the merchant can retrieve, and finally monitors the merchant's behavior of retrieving materials to determine the merchant's compliance with the risk behavior rules when retrieving materials. The present invention can solve the problem that the merchant's control ability is insufficient when calling materials, the merchant's high risk of calling controlled materials, and further leads to high storage management costs.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The present invention relates to the field of data processing technology, and in particular to a smart information-based material warehouse data management method and system. Background Art

[0002] The traditional warehousing industry is based on charging storage fees as its business model, which runs counter to the purpose of logistics. Modern logistics is committed to integrating processes and coordinating upstream and downstream. The less static inventory, the better. Its business model is also based on the assessment of total logistics costs. With the rapid development of computers, e-commerce and the Internet of Things, it is particularly important to keep all materials used, produced or sold in the manufacturing process, from raw materials to finished products, to ensure that they flow efficiently in the warehouse and are ready for use when needed. Therefore, smart information material warehouse data management is also increasingly used.

[0003] The smart information-based material warehouse data management system is an efficient and intelligent warehouse management system that can cope with the complex and efficient development of existing logistics. Although the application of the Internet of Things and RFID technologies in the smart information-based material warehouse data management has improved the automation level of warehouse control to a certain extent, they cannot accurately determine whether the merchant's behavior in the warehouse involves dangerous operations when the merchant calls for materials in a complex material environment. For example, the existing smart information-based material warehouse data management system cannot determine the merchant's restrictions on the call for materials with special business licenses and dangerous goods. For another example, the existing smart information-based material warehouse data management system cannot balance the relationship between the convenience of merchants calling for warehouse materials and the control of dangerous material calls. Summary of the invention

[0004] In order to solve the problem that the smart information material warehouse data management system in the prior art has insufficient control over the merchants' material calls, resulting in high risks in the merchants' call operations for controlled materials, and further resulting in high warehouse management costs, the purpose of the present invention is to provide a smart information material warehouse data management method and system, and the technical solutions adopted are as follows:

[0005] In a first aspect, a smart information-based material warehouse data management method is provided, the method comprising:

[0006] Step S1: Building a warehouse management information database based on the information of each merchant in the warehouse management history, the information of each material in the warehouse, and the retrieval status of each merchant for each material in the warehouse;

[0007] Step S2: Analyze the usage control weight of each material and the risk factor of each material's brief description phrase according to the material information in the warehouse management information database, and divide the materials in the warehouse into controlled materials and non-controlled materials;

[0008] Step S3: Obtain the merchant-material association evaluation based on the subordinate relationship between the material types and the merchant types in the warehouse management information database and the proportion of the number of times any merchant simultaneously retrieves any two materials to the total number of times any one of the two materials is retrieved;

[0009] Step S4: Obtain the quantity of materials that the merchant can retrieve based on the merchant-material association evaluation, the ratio of the quantity retrieved by the merchant in any previous retrieval of a material to the time interval between the current retrieval of the material and the last retrieval of the material in the warehouse management information database, and the time interval between the current retrieval of the material and the last retrieval of the material;

[0010] Step S5: formulating risk behavior rules for merchants to retrieve materials based on the merchant-material association evaluation and the quantity of materials that merchants can retrieve;

[0011] Step S6: Monitor the merchant's behavior of retrieving materials, and determine whether the merchant complies with the risk behavior rules when retrieving materials.

[0012] Furthermore, in step S1, the merchant information includes: merchant type, scale, credit rating, merchant location; the material information includes: material name, material category, material purpose, inventory, material location; the material retrieval status includes: material name, merchant using the material, retrieval time, retrieval quantity, and name of the person using the material.

[0013] Furthermore, in step S2, the use control weight of each material and the risk factor of the brief description phrase of each material are analyzed specifically as follows:

[0014] Obtain the usage control weight of each material based on the cosine similarity between the word vector corresponding to the material usage and the word vector corresponding to the daily description of each material;

[0015] The risk factor of each material's brief description phrase is obtained based on the cosine similarity between the word vector corresponding to the brief description phrase of each material and the word vector corresponding to the phrase describing common hazards of the material.

[0016] Furthermore, in step S2, the materials in the warehouse are divided into controlled materials and non-controlled materials as follows:

[0017] Obtain the control risk assessment of each material based on the use control weight of each material and the risk factor of each material's brief description phrase;

[0018] A first threshold value for the control hazard evaluation of each material is preset. If the control hazard evaluation of a material is above the first threshold value, the corresponding material is considered to be hazardous and is classified as a controlled material. If the control hazard evaluation of a material is less than the first threshold value, the material is classified as an uncontrolled material.

[0019] Furthermore, in step S3, the subordinate relationship between the material type and the merchant type in the warehouse management information database is specifically as follows:

[0020] According to the same usage of any material in the business material set permitted by the merchant type of a merchant, and the cosine similarity of the semantics of the material and the corresponding material in the business material set in the introduction, the similarity between the material and the corresponding material in the business material set is obtained;

[0021] According to the similarity between the material and the corresponding material in the business material set, and the cosine similarity between the word vector corresponding to the merchant type of the merchant and the word vector corresponding to the material type of the material, the subordinate relationship of the material type of the material with respect to the merchant type of the merchant is obtained.

[0022] Furthermore, the step S3 also includes: presetting a second threshold of the business-goods association evaluation between the merchant and the material, when the business-goods association evaluation corresponding to the merchant and the material is above the second threshold, the merchant is recorded as matching the material; when the business-goods association evaluation corresponding to the merchant and the material is less than the second threshold, the merchant is recorded as not matching the material.

[0023] Furthermore, in step S4, when the merchant is matched with the material, the greater the ratio of the quantity retrieved by the merchant in the warehouse management information database in the past to the time interval between the current retrieval of the material and the last retrieval of the material, and the longer the time interval between the current retrieval of the material and the last retrieval of the material, the greater the quantity of the material that the merchant can retrieve.

[0024] Furthermore, in step S5, the risk behavior rules for the merchant to retrieve materials are specifically:

[0025] If the merchant matches the material, and the merchant has a record of retrieving the material in the inventory management information database, the merchant has the right to retrieve the material, and the quantity that can be retrieved is close to its past retrieval record;

[0026] If the merchant and the material do not match, and the material is a non-controlled material, the merchant has access to the material, but the quantity that can be retrieved is small;

[0027] If the merchant matches the material department and the material is a controlled material, the merchant has no access to the material and the quantity that can be accessed is 0.

[0028] Furthermore, the step S6 further includes:

[0029] If the merchant retrieves non-controlled materials and the retrieved quantity exceeds the preset third threshold of the quantity of materials that the merchant can retrieve, the merchant must provide a reason and submit an application;

[0030] If the merchant has the authority to retrieve controlled materials, the merchant must present the corresponding business license when retrieving the controlled materials and register the materials when they are shipped out;

[0031] If the merchant does not have the authority to retrieve controlled materials, but still retrieves them, notify the inspection personnel at the material warehouse to handle the matter.

[0032] In another aspect, the present invention provides a smart information-based material warehouse data management system, the system comprising:

[0033] The warehouse management information database acquisition module is used to build a warehouse management information database based on the information of each merchant in the warehouse management history, the information of each material in the warehouse, and the retrieval status of each merchant on each material in the warehouse;

[0034] The material classification module is used to analyze the use control weight of each material and the risk factor of each material's brief description phrase according to the material information in the warehouse management information database, and divide the materials in the warehouse into controlled materials and non-controlled materials;

[0035] A module for acquiring a business-product association evaluation is used to acquire a business-product association evaluation between a merchant and a material based on the subordinate relationship between the material type and the merchant type in the warehouse management information database and the proportion of the number of times any merchant simultaneously retrieves any two materials to the total number of times any one of the two materials is retrieved;

[0036] The module for obtaining the number of materials that can be retrieved is used to obtain the number of materials that can be retrieved by the merchant based on the merchant-material association evaluation, the ratio of the number of materials retrieved by the merchant in the past and the time interval between the current retrieval of the material and the last retrieval of the material in the warehouse management information database, and the time interval between the current retrieval of the material and the last retrieval of the material.

[0037] The risk behavior rule acquisition module is used to formulate risk behavior rules for merchants to retrieve materials based on the merchant-material association evaluation and the number of materials that merchants can retrieve;

[0038] The monitoring and compliance judgment module is used to monitor the merchant's material retrieval behavior and judge whether the merchant complies with the risk behavior rules when retrieving materials.

[0039] The present invention has the following beneficial effects:

[0040] 1. The materials in the warehouse can be effectively classified, and the materials in the warehouse can be divided into controlled materials and non-controlled materials. In view of the situation that the material classification in the prior art is only considered to be judged, the present invention obtains the use control weight of each material according to the information of each material in the warehouse management information database, according to the cosine similarity between the word vector corresponding to the material use of each material and the word vector corresponding to the daily description of each material; obtains the risk factor of the brief description phrase of each material according to the cosine similarity between the word vector corresponding to the brief description phrase of each material and the word vector corresponding to the common dangerous description phrase of the material; obtains the control risk evaluation of each material according to the use control weight of each material and the risk factor of the brief description phrase of each material; presets the first threshold value of the control risk evaluation of each material, if the control risk evaluation of the material is above the first threshold value, the corresponding material is considered to be dangerous, and the material is classified as a controlled material; if the control risk evaluation of the material is less than the first threshold value, the material is classified as a non-controlled material.

[0041] Second, it can strengthen the control over merchants' access to special business license materials, dangerous goods materials, etc., reduce the operational risks of accessing these materials, and further reduce the storage management costs of material access. The present invention proposes to obtain the merchant-material association evaluation based on the subordinate relationship of material types relative to merchant types in the warehouse management information database, and the proportion of the number of times any merchant simultaneously accesses any two materials in the total number of times any one of the two materials is accessed; obtain the number of materials that the merchant can access based on the merchant-material association evaluation, the ratio of the number of materials accessed by the merchant in the past in the warehouse management information database to the time interval between the time when the material is accessed this time and the time interval between the access of the material this time and the access of the material last time; formulate risk behavior rules for merchants to access materials based on the merchant-material association evaluation and the number of materials that merchants can access; further, monitor the merchant's access behavior to determine the merchant's compliance with the risk behavior rules when accessing materials. BRIEF DESCRIPTION OF THE DRAWINGS

[0042] In order to more clearly illustrate the technical solutions and advantages in the embodiments of the present invention or the prior art, the drawings required for use in the embodiments or the prior art descriptions are 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 work.

[0043] Figure 1 A flow chart of a smart information-based material warehouse data management method provided by one embodiment of the present invention.

[0044] Figure 2 A block diagram of an intelligent information-based material warehouse data management system provided by one embodiment of the present invention. DETAILED DESCRIPTION

[0045] In order to further explain the technical means and effects adopted by the present invention to achieve the predetermined invention purpose, the following is a detailed description of the specific implementation method, structure, characteristics and effects of a smart information material warehouse data management method and system proposed according to the present invention, in combination with the accompanying drawings and preferred embodiments. In the following description, different "one embodiment" or "another embodiment" does not necessarily refer to the same embodiment. Unless otherwise defined, all technical and scientific terms used in this document have the same meaning as commonly understood by technicians in the technical field of the present invention.

[0046] The scenario targeted by the present invention is: a system platform for controlling all behaviors of all terminals in the smart information material warehouse data management system and the institutional merchants using these terminals, and establishing the authority of merchants to retrieve materials and corresponding quantities.

[0047] The specific scheme of a smart information material warehouse data management method and system provided by the present invention is described in detail below with reference to the accompanying drawings.

[0048] First, see Figure 1 , which shows a flow chart of a smart information material warehouse data management method provided by an embodiment of the present invention, the method comprising the following steps:

[0049] Step S1: construct a warehouse management information database based on the information of each merchant in the warehouse management history, the information of each material in the warehouse, and the retrieval status of each material in the warehouse by each merchant.

[0050] In order to analyze the relationship between merchants and materials and further construct risk behavior rules for merchant behavior, first, it is necessary to collect the retrieval status of many materials in the warehouse over the past period of time, the actual location of each merchant and each material, and collect relevant information of each merchant and each material. Preferably, this information can be collected within the past six months.

[0051] It should be further explained that in step S1, the information of each merchant includes: merchant type, scale, credit rating, merchant location, etc.; the information of each material includes: material name, material category, material purpose, inventory, material location, material attributes, storage precautions, etc., among which the merchant type can be the business scope registered by the merchant on the relevant license; the retrieval status of each material includes: material name, merchant using it, retrieval time, retrieval quantity, name of the person using it, etc.

[0052] This information is then integrated to build a warehouse management information database.

[0053] Step S2: According to the information of each material in the warehouse management information database, the use control weight of each material and the risk factor of each material's brief description phrase are analyzed, and the materials in the warehouse are divided into controlled materials and non-controlled materials.

[0054] The material information in the warehouse management information database specifically includes: attribute information, usage and daily description information of each material identification, and the attribute information includes toxicity, flammability, explosiveness and corrosiveness.

[0055] Furthermore, in step S2, the use control weight of each material and the risk factor of the brief description phrase of each material are analyzed specifically as follows: the use control weight of each material is obtained according to the cosine similarity between the word vector corresponding to the material use of each material and the word vector corresponding to its daily description.

[0056] First, the more the description of an item's use is biased towards daily life, the more similar its semantics are to some daily descriptions; the more the use of a material is biased towards daily supplies, that is, the more frequently it is used in daily life, the less control it needs, and the danger it can cause is relatively limited. Therefore, the calculation formula for the use control weight of each material constructed in this embodiment is as follows:

[0057]

[0058] In the formula, w represents the material; The word vector corresponding to the material usage of material w; Represents the word vector corresponding to daily description; Indicates the calculation of the cosine similarity of two vectors, which is used to describe the use of materials t w The semantic similarity with the daily description r; max r () represents the maximum value function of the independent variable r, which is used to accurately calculate the daily use of materials. This is because daily descriptions are not a single phrase, and using a single phrase to calculate the daily use of materials may have errors; exp[] is an exponential function with the natural constant e as the base. The exponential function is set to avoid its corresponding result being 0; T w It represents the usage control weight of material w; among them, daily description is some synonyms and antonyms of "daily, daily nature" (queried through the "Synonym Dictionary").

[0059] In the above formula for calculating the usage control weight of each material, Represents the absolute value of the difference between the maximum value function of the cosine similarity between the word vector corresponding to the material use of material w and the word vector corresponding to its daily description with respect to the independent variable r and 1, The dissimilarity factor between the word vector corresponding to the material usage of material w and the word vector corresponding to its daily description is affected. That is, it represents the weight value of material w excluding the influence of the dissimilarity factor between the word vector corresponding to the material use of material w and the word vector corresponding to its daily description, that is, T w Indicates the usage control weight of material w.

[0060] Since determining the hazardousness of materials is a complex process involving multiple aspects, the corresponding characteristics of various materials will be taken into consideration when they are stored and put into storage. For example, flammable materials will be kept away from fire and heat sources, and corrosive materials will be specially packaged. In addition, there will be corresponding labels for reminders, such as toxicity, flammability, explosiveness, corrosiveness, etc. These special packaging information and label reminder information will be registered in the introduction column or remarks column when the materials are put into storage.

[0061] Furthermore, in step S2, the risk factor of the brief description phrase of each material is analyzed specifically by obtaining the risk factor of the brief description phrase of each material according to the cosine similarity between the word vector corresponding to the brief description phrase of each material and the word vector corresponding to the phrase of common risk description of the material.

[0062] When materials are put into storage, there are some attribute information of the material identification and some descriptions of its related storage requirements in the introduction column or the remarks column. Through these descriptions, the specific situation of the items can be intuitively judged. The more similar the descriptive phrases in these descriptions are to the relevant phrases describing dangerous goods, that is, the more dangerous this phrase is, the greater its risk factor. Among them, the description phrase can be obtained by segmenting the material introduction and the remarks, and removing stop words. In addition, since there are many types of dangerous goods, it is difficult to determine what kind of dangerous goods the description phrase describes, so all similarities are calculated and the maximum value is taken. Therefore, the risk factor calculation formula of the brief description phrase of the material constructed in this embodiment is as follows:

[0063]

[0064] In the formula, The word vector corresponding to the brief description phrase j of material w; The word vectors corresponding to phrases representing common hazardous descriptions of materials. Hazardous goods descriptions refer to the definitions and classifications of hazardous goods in the national standard plan "Classification and Name Numbering of Dangerous Goods", such as explosives, toxic gases, etc. Indicates the calculation of the cosine similarity of two vectors, which is used for the semantic similarity between the brief description phrase j of material w and the hazard description h; max h () represents the maximum value function about the independent variable h; c represents the adjustment constant (c=3 can be preset), which adjusts the value range of the maximum value of the cosine similarity; softsign[] represents the normalization of the positive proportion.

[0065] In the above material description phrase risk factor calculation formula, The cosine similarity between the word vector corresponding to the phrase j that briefly describes material w and the word vector corresponding to the phrase that describes the common hazards of the material; It represents the maximum value of the semantic similarity between the brief description phrase j of the material w and the hazard description h about the independent variable h; since the cosine similarity value range is [-1,1], c (c=3 can be preset) is used for adjustment to limit the range of the subsequent positive proportional normalization results, and finally the positive proportional normalization is performed through softsign[]. The result C w,j is the risk factor of the material w in the form of a brief description of the phrase j.

[0066] Furthermore, in step S2, the materials in the warehouse are divided into controlled materials and non-controlled materials. Specifically, the control risk evaluation of each material is obtained according to the use control weight of each material and the risk factor of the brief description phrase of each material.

[0067] Since the use of materials tends to be daily, their danger is more controllable, that is, the danger caused is relatively limited; in addition, in the description of the item in the item introduction, the more dangerous phrases appear, and the more dangerous the semantics expressed by the phrases, the more dangerous the item is. Based on this, the calculation formula for the material control risk assessment constructed in this embodiment is as follows:

[0068]

[0069] Where, T w Indicates the usage control weight of material w; N j represents the number of dangerous phrases in the description phrase j; C w,j Represents the risk factor of phrase j in the brief description of material w, used to describe the risk of phrase j; tanh() is used for positive proportional normalization; G w Indicates the usage control weight of material w.

[0070] In the above material control risk assessment calculation formula, the use control weight T of material w is w , the risk factor C of phrase j in the brief description of material w w,j They are respectively positively correlated with the control risk assessment of material w, so the product of the two can be defined as the use control weight of material w.

[0071] Furthermore, in step S2, the materials in the warehouse are divided into controlled materials and uncontrolled materials. Specifically, a first threshold value of the control risk assessment of each material is preset. If the control risk assessment of the material is above the first threshold value, the corresponding material is considered to be dangerous, and the material is classified as a controlled material; if the control risk assessment of the material is less than the first threshold value, the material is classified as an uncontrolled material.

[0072] Specifically, all materials are traversed, and their control risk assessment is calculated. The first threshold of the control risk assessment of each material is preset to 0.65. If the control risk assessment of a material is ≥0.65, the corresponding material is considered to be dangerous and is classified as a controlled material. If the control risk assessment of a material is <0.65, the material is classified as an uncontrolled material or an ordinary material.

[0073] Step S3: Obtain the merchant-material association evaluation based on the subordinate relationship between the material types and the merchant types in the warehouse management information database and the proportion of the number of times any merchant simultaneously retrieves any two materials in the total number of times any one of the two materials is retrieved.

[0074] Among them, in step S3, the subordinate relationship of material types in the warehouse management information database to merchant types is specifically as follows: according to the same use of a material in the business material set permitted by the merchant type of a merchant, and the cosine similarity of the semantics between the material and the corresponding material in the business material set in the introduction, the similarity between the material and the corresponding material in the business material set is obtained; according to the similarity between the material and the corresponding material in the business material set, and the cosine similarity between the word vector corresponding to the merchant type of the merchant and the word vector corresponding to the material type of the material, the subordinate relationship of the material type of the material to the merchant type of the merchant is obtained.

[0075] Specifically, among all the merchants, merchants with the same merchant type have roughly similar business scopes, which leads to a large portion of the materials retrieved from the material warehouse overlapping with each other. These overlapping materials are the materials under the jurisdiction of this merchant type, which are recorded as the business material set; if the material type of the target material is highly similar to the types of materials in the business material set corresponding to the merchant type of the target merchant, then it is considered that the target material type belongs to the target merchant type.

[0076] In this embodiment, the similarity calculation formula for a material in a set of business materials permitted by a merchant type of a merchant is constructed as follows:

[0077]

[0078] In the formula, s<q,v> Indicates the similarity between material q and material v in the operating material set; yt<q,ν> Indicates the same use of material q and material ν, the same is recorded as 1, and the different is recorded as 0; Indicates the cosine similarity of the semantics of material q and material ν in the introduction, that is, the mean cosine similarity of each phrase in the introduction of the two materials.<q,v> It means the same situation of usage. Indicates semantic similarity. Indicates to increase the proportion of semantic similarity. For example, when the purpose is the same, yt<q,v> The value is 1, which indicates semantic similarity. When it is 0.85, in fact, the purpose is the same, the semantics are similar, and the overall situation is very similar. Then the overall similarity is (1+(1+0.85) / 2) / 2=0.9625.

[0079] In the above-mentioned similarity calculation formula for any material in the set of business materials permitted by the merchant type of a material, the factors that determine the similarity of two materials are generally the semantic similarity of the two materials in the introduction and the same use of the two materials. The same use of material q and material v, yt<q,v> Its value is 1, if the usage is different, its value is 0; among them, due to the cosine similarity of the semantics of material q and material v in the introduction Its value ranges from 0 to 1. It is also important to compare the similarity of the uses of the two materials. It is possible to modify and increase the proportion of the semantic similarity between material q and material v in the introduction in the overall similarity between material q and material v in the operating material set. This means that the similarity between the two materials is obtained by comprehensively considering the semantic similarity of the two materials in the introduction and the same usage of the two materials.

[0080] Furthermore, the subordinate relationship C between the material type of material q and the merchant type of merchant h constructed in this embodiment h,q The calculation formula is as follows:

[0081]

[0082] In the formula, The word vector corresponding to the merchant type of merchant h; The word vector corresponding to the material type of material q; N h,v Indicates the set of business materials allowed by the merchant type of merchant h; Indicates calculating the cosine similarity of two word vectors; s<q,v> Indicates the similarity between material q and material v in the operating material set; It means to find the average value of the function value of different materials v in the operating material set; C h,q Indicates the subordinate relationship between the material type of material q and the merchant type of merchant h.

[0083] In the above material type of material q, the subordinate relationship C to the merchant type of merchant h h,q In the calculation formula, Represents the cosine similarity between the word vector corresponding to the merchant type of merchant h and the word vector corresponding to the material type of material q, and its subordinate relationship C with the material type of material q relative to the merchant type of merchant h h,q Positive correlation; It represents the average value of the similarity between material q and material v in the operating material set when the variable is different materials v in the operating material set, and its subordinate relationship C with the material type of material q relative to the merchant type of merchant h h,q Positive correlation; the product of the two is the subordinate relationship of the material type of material q to the merchant type of merchant h.

[0084] Furthermore, the greater the proportion of the number of times two materials are retrieved at the same time in the number of times the two materials are retrieved, the more it indicates that the two materials have the same purpose (or category) in the eyes of the merchant, that is, the greater the correlation between the two materials; the greater the correlation between the current material and the material retrieved by the merchant in the past, the greater the correlation between the merchant and the material; in addition, when analyzing the correlation between two materials, the stronger the subordinate relationship between the material type retrieved by the merchant in the past and the merchant type, the more credible the corresponding calculated correlation. Therefore, the merchant-item correlation evaluation S of merchant h and material w constructed in this embodiment is h,w The calculation formula is as follows:

[0085]

[0086] Where N w+q Indicates the total number of times any merchant retrieved materials w and q at the same time in the past period of time; N w / q Indicates the total number of times material w or material q is retrieved; C h,q Indicates the subordinate relationship between the material type of material q and the merchant type of merchant h; μ q (,) represents the weighted mean function, that is, the weighted mean of the function values ​​of many different materials q is calculated, C h,q represents the weight, where material q is any material that merchant h has retrieved in the past; tanh[] is used for positive proportion normalization; S h,w Indicates the merchant-item association evaluation between merchant h and material w.

[0087] In the above merchant h and material w, the commodity association evaluation S h,w In the calculation formula, the ratio of the total number of times any merchant retrieved materials w and q at the same time to the total number of times they retrieved material w or material q in the past period of time is: Indicates the association between the merchant and the material; Indicates the subordinate relationship C of the material type of material q relative to the merchant type of merchant h h,q The association between the weighted merchant and the material, after the result is normalized in positive proportion, represents the merchant-material association evaluation between merchant h and material w.

[0088] Furthermore, step S3 also includes: presetting a second threshold of the business-goods association evaluation between the merchant and the material, when the business-goods association evaluation corresponding to the merchant and the material is above the second threshold, the merchant is recorded as matching the material; when the business-goods association evaluation corresponding to the merchant and the material is less than the second threshold, the merchant is recorded as not matching the material.

[0089] Specifically, all merchants and materials are traversed to obtain the corresponding merchant-material association evaluations of many merchants and materials. The preset second threshold of the merchant-material association evaluation can be 0.7. If the merchant-material association evaluation corresponding to the merchant and the material is ≥0.7, the material is considered to be the associated material of the corresponding merchant, and all these corresponding relationships are marked as materials matched by the merchant; otherwise, if the merchant-material association evaluation is <0.7, it is considered that the two do not match, and it is marked as a non-matching material of the merchant.

[0090] Then, the behavior rules of the merchants are formulated in combination with the association relationship between the merchants and the materials and the risk situation of the materials. Based on this, the present embodiment further includes the following steps.

[0091] Step S4: Obtain the quantity of materials that the merchant can retrieve based on the merchant-material association evaluation, the ratio of the quantity retrieved by the merchant in any past retrieval of a material to the time interval between the current retrieval of the material and the last retrieval of the material in the warehouse management information database, and the time interval between the current retrieval of the material and the last retrieval of the material.

[0092] Specifically, in step S4, when the merchant is matched with the material, the greater the ratio of the quantity retrieved by the merchant in the past to the time interval between the last time the material was retrieved in the warehouse management information database, and the longer the time interval between the current retrieval of the material and the last retrieval of the material, the greater the quantity of the material that the merchant can retrieve.

[0093] In addition, if the business scope of the merchant does not match the type of material, and the material is not too dangerous, the merchant also has the right to retrieve the material, but the quantity it can retrieve will be limited, and only a very small amount can be retrieved; if the business scope of the merchant does not match the type of material, but the material is highly dangerous (the material is a controlled material), the merchant has no right to retrieve the corresponding material, that is, the quantity it can retrieve is 0.

[0094] In this embodiment, the calculation formula for the quantity of material a that merchant α can retrieve is:

[0095]

[0096] Where M α,a Indicates the quantity of material a that merchant α can retrieve; Y SIndicates the second threshold of the merchant-material association evaluation; Y G Indicates the first threshold of the control risk assessment of each material; G a Indicates the control risk assessment of material a; S α,a represents the business-product association evaluation between merchant α and material a; Δt a Indicates the time interval between the current retrieval of material a and the last retrieval of material a; N a,k Indicates the quantity of material a retrieved the kth time in the past; t a,k N represents the time between the kth time material a was retrieved and the k-1th time material a was retrieved; k,α Indicates the total number of times merchant α retrieves material a; N a,c Indicates the number of times a merchant who can retrieve (has the authority to retrieve) material a retrieved the material in the past c times; min c () indicates the minimum value corresponding to different c; 5% is the limit standard, which is the preset value.

[0097] In the above calculation formula for the quantity of material a that merchant α can retrieve, when the merchant α and material a have a commodity-related evaluation S α,a ≥0.7, that is, when merchant α matches material a, It represents the ratio of the quantity of material a retrieved in the kth time in the past to the time between the kth time of retrieving material a and the k-1th time of retrieving material a in the past. This value is positively correlated with the quantity of material a that merchant α can retrieve. In addition, the time interval Δt between the current retrieval of material a and the last retrieval of material a is a It is positively correlated with the quantity of material a that merchant α can retrieve, and the time interval Δt a The larger the M α,a The larger the value, the higher the merchant α is. α,a <0.7, that is, merchant α does not match material a, and the control risk assessment of material a is G a <0.65, that is, when material a is a non-controlled material, 5% of the minimum quantity of the material that has been retrieved by the merchant with the authority to retrieve material a for the cth time can be used as the result M α,a The corresponding value is the quantity of material a that merchant α can retrieve. This can avoid the existing rigid and inconvenient management method - if the material attributes do not match the merchant's business scope, the merchant is directly not allowed to take the material. However, in reality, there are cases where merchants help their neighbors or merchants with whom they have a good relationship to take other types of materials. When the merchant α and the material a's business association evaluation S α,a <0.7, that is, merchant α does not match material a, and the control risk assessment of material a is G a ≥0.65, that is, when material a is a controlled material, merchant α can retrieve the quantity M of material a α,a =0.

[0098] Step S5: Based on the merchant-material association evaluation and the quantity of materials that the merchant can retrieve, formulate risk behavior rules for the merchant to retrieve materials.

[0099] Specifically, the risk behavior rules for merchants to retrieve materials are as follows: if the merchant matches the material, and the merchant has a record of retrieving the material in the warehouse management information database, then the merchant has the right to retrieve the material, and the quantity that can be retrieved is close to its past retrieval record. The specific retrieval quantity can refer to the calculation formula for the quantity of material a that merchant α can retrieve If the merchant and the material do not match, and the material is a non-controlled material, the merchant has the right to retrieve the material, but the quantity that can be retrieved is small. For the specific quantity to be retrieved, please refer to the calculation formula M for the quantity of material a that merchant α can retrieve. α,a =min c (N a,c )×5%; If the merchant and the material do not match, and the material is a controlled material, the merchant has no access to the material and the available quantity is 0.

[0100] It should be further explained that if a merchant matches a material, but the merchant has no record of retrieving the material in the inventory management information database, it means that the merchant is a new merchant and the quantity that can be retrieved can refer to the average quantity of materials retrieved by all other merchants with the same business license.

[0101] Step S6: Monitor the merchant's behavior of retrieving materials, and determine whether the merchant complies with the risk behavior rules when retrieving materials.

[0102] If a merchant retrieves non-controlled materials and the retrieved quantity is greater than the preset third threshold of the quantity of materials that the merchant can retrieve, the merchant must give a reason and submit an application; if the merchant has the authority to retrieve controlled materials, when retrieving controlled materials, the merchant must present the corresponding business license and register the materials when they are shipped out; if the merchant does not have the authority to retrieve controlled materials, but still retrieves controlled materials, the merchant must notify the inspection personnel of the material warehouse to handle it.

[0103] Specifically, the types and quantities of materials retrieved by merchants each time are monitored. When merchants retrieve materials within their authority and the materials are non-controlled materials, merchants are allowed to make certain estimated adjustments in quantity, and the retrieved quantity range is increased by about 5% on the quantity of the above rules, that is, the third threshold can be set to 1.05. However, if the merchant illegally retrieves excessive materials, that is, the merchant retrieves more than 1.05 times the number of materials that the merchant can retrieve, the merchant is required to submit an application and describe the reasons. In addition, if the retrieved materials are controlled materials, the merchant must present the corresponding business license and other relevant documents, and register the materials when they are shipped out. However, if the merchant does not have the authority to retrieve controlled materials, it is also necessary to retrieve highly dangerous controlled materials, notify the patrol personnel of the material warehouse to handle them, and take alarm measures in time when necessary (the patrol personnel cannot handle them).

[0104] In the second aspect, this embodiment provides a smart information material warehouse data management system, see Figure 2 , which shows a block diagram of a smart information material warehouse data management system provided by an embodiment of the present invention, the system includes:

[0105] The warehouse management information database acquisition module 101 is used to build a warehouse management information database based on the information of each merchant in the warehouse management history, the information of each material in the warehouse, and the retrieval status of each merchant on each material in the warehouse;

[0106] The material classification module 102 is used to analyze the use control weight of each material and the risk factor of each material's brief description phrase according to the material information in the warehouse management information database, and classify the materials in the warehouse into controlled materials and non-controlled materials;

[0107] The business-product association evaluation acquisition module 103 is used to acquire the business-product association evaluation between the merchant and the material according to the subordinate relationship between the material type and the merchant type in the warehouse management information database and the proportion of the number of times any merchant simultaneously retrieves any two materials in the total number of times any one of the two materials is retrieved;

[0108] The module 104 for obtaining the number of materials available for retrieving is used to obtain the number of materials available for retrieving by the merchant based on the merchant-material association evaluation, the ratio of the number of materials retrieved by the merchant in the past and the time interval between the current retrieval of the material and the last retrieval of the material in the warehouse management information database, and the time interval between the current retrieval of the material and the last retrieval of the material.

[0109] The risk behavior rule acquisition module 105 is used to formulate risk behavior rules for merchants to retrieve materials based on the merchant-material association evaluation and the quantity of materials that merchants can retrieve;

[0110] The monitoring and compliance judgment module 106 is used to monitor the merchant's behavior of retrieving materials and judge whether the merchant complies with the risk behavior rules when retrieving materials.

[0111] The present embodiment provides a smart information material warehouse data management method and system, according to the information of each material in the warehouse management information database, according to the cosine similarity between the word vector corresponding to the material use of each material and the word vector corresponding to the daily description of each material, the use control weight of each material is obtained; according to the cosine similarity between the word vector corresponding to the brief description phrase of each material and the word vector corresponding to the phrase of the common danger description of the material, the risk factor of the brief description phrase of each material is obtained; according to the use control weight of each material and the risk factor of the brief description phrase of each material, the control risk evaluation of each material is obtained; the first threshold value of the control risk evaluation of each material is preset, if the control risk evaluation of the material is above the first threshold value, the corresponding material is considered to be dangerous, and the material is classified as a controlled material; if the control risk evaluation of the material is less than the first threshold value, the material is classified as a non-controlled material. The materials in the warehouse can be effectively classified, and the materials in the warehouse can be divided into controlled materials and non-controlled materials.

[0112] In addition, this embodiment proposes to obtain the merchant-material association evaluation based on the subordinate relationship of material types relative to merchant types in the warehouse management information database, the proportion of the number of times any merchant simultaneously retrieves any two materials in the total number of times any one of the two materials is retrieved; obtain the number of materials that the merchant can retrieve based on the merchant-material association evaluation, the ratio of the number of materials retrieved by the merchant in the past in the warehouse management information database to the time interval between the last time the material was retrieved, and the time interval between the current retrieval of the material and the last retrieval of the material; formulate the risk behavior rules for merchants to retrieve materials based on the merchant-material association evaluation and the number of materials that merchants can retrieve; further, monitor the merchant's behavior in retrieving materials and judge the merchant's compliance with the risk behavior rules when retrieving materials. It can strengthen the ability to control merchants' material retrieval, reduce the operational risks of controlled materials, and further reduce the storage management costs of material retrieval.

[0113] It should be noted that the sequence of the above embodiments of the present invention is only for description and does not represent the advantages and disadvantages of the embodiments. The processes depicted in the accompanying drawings do not necessarily require the specific order or continuous order shown to achieve the desired results. In some embodiments, multitasking and parallel processing are also possible or may be advantageous.

[0114] The embodiments described above are only used to illustrate the technical solutions of the present application, rather than to limit them. Although the present application has been described in detail with reference to the aforementioned embodiments, a person skilled in the art should understand that the technical solutions described in the aforementioned embodiments may still be modified, or some of the technical features may be replaced by equivalents. Such modifications or replacements do not deviate the essence of the corresponding technical solutions from the scope of the technical solutions of the embodiments of the present application, and should all be included in the protection scope of the present application.

Claims

1. A smart information-based material warehouse data management method, characterized in that: The method comprises: Step S1: Building a warehouse management information database based on the information of each merchant in the warehouse management history, the information of each material in the warehouse, and the retrieval status of each merchant for each material in the warehouse; Step S2: Analyze the usage control weight of each material and the risk factor of each material's brief description phrase according to the material information in the warehouse management information database, and divide the materials in the warehouse into controlled materials and non-controlled materials; Step S3: Obtain the merchant-material association evaluation based on the subordinate relationship between the material types and the merchant types in the warehouse management information database and the proportion of the number of times any merchant simultaneously retrieves any two materials to the total number of times any one of the two materials is retrieved; The calculation formula for the commodity association evaluation is as follows: ; in, Indicates merchant With materials Evaluation of the association of goods; Indicates that any merchant has retrieved materials at the same time in the past period of time and The total number of times; Indicates that the material has been retrieved Or retrieved materials The total number of times; Indicates material The types of materials relative to merchants Merchant type affiliation; represents the weighted mean function; Used for positive proportion normalization; The subordinate relationship of the material type to the merchant type in the warehouse management information database is specifically as follows: according to the same usage of any material in the business material set permitted by the merchant type of a merchant, and the cosine similarity of the semantics of the material and the corresponding material in the business material set in the introduction, the similarity of the material and the corresponding material in the business material set is obtained; according to the similarity of the material and the corresponding material in the business material set, and the cosine similarity between the word vector corresponding to the merchant type of the merchant and the word vector corresponding to the material type of the material, the subordinate relationship of the material type of the material to the merchant type of the merchant is obtained; Step S4: Obtain the quantity of materials that the merchant can retrieve based on the merchant-material association evaluation, the ratio of the quantity retrieved by the merchant in any previous retrieval of a material to the time interval between the current retrieval of the material and the last retrieval of the material in the warehouse management information database, and the time interval between the current retrieval of the material and the last retrieval of the material; Step S5: Formulate risk behavior rules for merchants to retrieve materials based on the merchant-material association evaluation and the quantity of materials that merchants can retrieve; Step S6: Monitor the merchant's behavior of retrieving materials, and determine whether the merchant complies with the risk behavior rules when retrieving materials.

2. According to claim 1, a smart information material warehouse data management method is characterized in that: In step S1, the merchant information includes: merchant type, scale, credit rating, merchant location; the material information includes: material name, material category, material purpose, inventory, material location; the material retrieval status includes: material name, merchant using, retrieval time, retrieval quantity, and name of the person using the material.

3. The intelligent information-based material warehouse data management method according to claim 1 is characterized in that: In step S2, the use control weight of each material and the risk factor of the brief description phrase of each material are analyzed as follows: Obtain the usage control weight of each material based on the cosine similarity between the word vector corresponding to the material usage of each material and the word vector corresponding to its daily description; The risk factor of each material's brief description phrase is obtained based on the cosine similarity between the word vector corresponding to the brief description phrase of each material and the word vector corresponding to the phrase describing common hazards of the material.

4. The intelligent information-based material warehouse data management method according to claim 3 is characterized in that: In step S2, the materials in the warehouse are divided into controlled materials and non-controlled materials as follows: Obtain the control risk assessment of each material based on the use control weight of each material and the risk factor of each material's brief description phrase; A first threshold value for the control hazard evaluation of each material is preset. If the control hazard evaluation of a material is above the first threshold value, the corresponding material is considered to be hazardous and is classified as a controlled material. If the control hazard evaluation of a material is less than the first threshold value, the material is classified as an uncontrolled material.

5. The intelligent information-based material warehouse data management method according to claim 1 is characterized in that: The step S3 also includes: presetting a second threshold value of the business-goods association evaluation between the merchant and the material, when the business-goods association evaluation corresponding to the merchant and the material is above the second threshold value, recording that the merchant matches the material; when the business-goods association evaluation corresponding to the merchant and the material is less than the second threshold value, recording that the merchant does not match the material.

6. The intelligent information-based material warehouse data management method according to claim 5 is characterized in that: In step S4, when the merchant is matched with the material, the greater the ratio of the quantity retrieved by the merchant in the past to the time interval between the last time the material was retrieved in the warehouse management information database, and the longer the time interval between the current retrieval of the material and the last retrieval of the material, the greater the quantity of the material that the merchant can retrieve.

7. The intelligent information-based material warehouse data management method according to claim 1 is characterized in that: In step S5, the risk behavior rules for the merchant to retrieve materials are specifically: If the merchant matches the material, and the merchant has a record of retrieving the material in the inventory management information database, the merchant has the right to retrieve the material. The calculation formula for the quantity of the material that can be retrieved is: ;in, Indicates merchant Available materials the number of Indicates that the material is retrieved this time Same as last time material was retrieved the time interval between Indicates the past Retrieve materials The number of times the data is retrieved; Indicates merchant Retrieve materials The total number of times; Indicates the past Retrieve materials Time distance past Retrieve materials Length of time between If the merchant does not match the material, and the material is a non-controlled material, the merchant has the right to retrieve the material. The calculation formula for the quantity of the material that can be retrieved is: ;in, Indicates that different The corresponding minimum value; Indicates that materials can be retrieved Merchants in the past The number of materials retrieved at a time; This is the default value for the restriction standard; If the merchant and the material do not match, and the material is a controlled material, the merchant has no access to the material and the quantity that can be retrieved is 0.

8. The intelligent information-based material warehouse data management method according to claim 1 is characterized in that: The step S6 further comprises: If the merchant retrieves non-controlled materials and the retrieved quantity exceeds the preset third threshold of the quantity of materials that the merchant can retrieve, the merchant must provide a reason and submit an application; If the merchant has the authority to retrieve controlled materials, the merchant must present the corresponding business license when retrieving the controlled materials and register the materials when they are shipped out; If the merchant does not have the authority to retrieve controlled materials, but still retrieves them, notify the inspection personnel at the material warehouse to handle the matter.

9. A smart information-based material warehouse data management system, characterized in that: The system is used to implement a smart information material warehouse data management method as described in any one of claims 1-8, and the system includes: The warehouse management information database acquisition module is used to build a warehouse management information database based on the information of each merchant in the warehouse management history, the information of each material in the warehouse, and the retrieval status of each merchant on each material in the warehouse; The material classification module is used to analyze the use control weight of each material and the risk factor of each material's brief description phrase according to the material information in the warehouse management information database, and divide the materials in the warehouse into controlled materials and non-controlled materials; A module for acquiring a business-product association evaluation is used to acquire a business-product association evaluation between a merchant and a material based on the subordinate relationship between the material type and the merchant type in the warehouse management information database and the proportion of the number of times any merchant simultaneously retrieves any two materials to the total number of times any one of the two materials is retrieved; The module for obtaining the number of materials that can be retrieved is used to obtain the number of materials that can be retrieved by the merchant based on the merchant-material association evaluation, the ratio of the number of materials retrieved by the merchant in the past and the time interval between the current retrieval of the material and the last retrieval of the material in the warehouse management information database, and the time interval between the current retrieval of the material and the last retrieval of the material. The risk behavior rule acquisition module is used to formulate risk behavior rules for merchants to retrieve materials based on the merchant-material association evaluation and the number of materials that merchants can retrieve; The monitoring and compliance judgment module is used to monitor the merchant's material retrieval behavior and judge whether the merchant complies with the risk behavior rules when retrieving materials.

Citation Information

Patent Citations

  • Customer risk identification method and device

    CN110738498A

  • Product warehouse management system for smart factory

    CN116228095A