CN110969379A - Alternative material screening method and related device - Google Patents
Alternative material screening method and related device Download PDFInfo
- Publication number
- CN110969379A CN110969379A CN201811139155.8A CN201811139155A CN110969379A CN 110969379 A CN110969379 A CN 110969379A CN 201811139155 A CN201811139155 A CN 201811139155A CN 110969379 A CN110969379 A CN 110969379A
- Authority
- CN
- China
- Prior art keywords
- data
- dimension
- substitute
- alternative
- original
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
- 239000000463 material Substances 0.000 title claims abstract description 517
- 238000012216 screening Methods 0.000 title claims abstract description 60
- 238000000034 method Methods 0.000 title claims abstract description 54
- 238000006467 substitution reaction Methods 0.000 claims abstract description 81
- 230000007547 defect Effects 0.000 claims abstract description 25
- 238000011156 evaluation Methods 0.000 claims description 32
- 238000003860 storage Methods 0.000 claims description 15
- 238000009825 accumulation Methods 0.000 claims description 14
- 230000008569 process Effects 0.000 claims description 14
- 239000002994 raw material Substances 0.000 claims description 7
- 238000004590 computer program Methods 0.000 description 10
- 238000010586 diagram Methods 0.000 description 8
- 230000006870 function Effects 0.000 description 5
- 238000012545 processing Methods 0.000 description 5
- 238000004519 manufacturing process Methods 0.000 description 4
- 238000005516 engineering process Methods 0.000 description 3
- 230000003287 optical effect Effects 0.000 description 3
- 238000004364 calculation method Methods 0.000 description 2
- 238000013075 data extraction Methods 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 230000005540 biological transmission Effects 0.000 description 1
- 230000008859 change Effects 0.000 description 1
- 238000006243 chemical reaction Methods 0.000 description 1
- 238000004140 cleaning Methods 0.000 description 1
- 239000003086 colorant Substances 0.000 description 1
- 238000010276 construction Methods 0.000 description 1
- 238000007405 data analysis Methods 0.000 description 1
- 238000001914 filtration Methods 0.000 description 1
- 239000007789 gas Substances 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 239000007788 liquid Substances 0.000 description 1
- 238000013507 mapping Methods 0.000 description 1
- -1 models Substances 0.000 description 1
- 238000004806 packaging method and process Methods 0.000 description 1
- 239000007787 solid Substances 0.000 description 1
- 230000003068 static effect Effects 0.000 description 1
- 238000012800 visualization Methods 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/08—Logistics, e.g. warehousing, loading or distribution; Inventory or stock management
- G06Q10/087—Inventory or stock management, e.g. order filling, procurement or balancing against orders
- G06Q10/0875—Itemisation or classification of parts, supplies or services, e.g. bill of materials
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
- G06Q10/063—Operations research, analysis or management
- G06Q10/0639—Performance analysis of employees; Performance analysis of enterprise or organisation operations
- G06Q10/06393—Score-carding, benchmarking or key performance indicator [KPI] analysis
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
- G06Q10/063—Operations research, analysis or management
- G06Q10/0639—Performance analysis of employees; Performance analysis of enterprise or organisation operations
- G06Q10/06395—Quality analysis or management
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02P—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
- Y02P90/00—Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
- Y02P90/30—Computing systems specially adapted for manufacturing
Landscapes
- Business, Economics & Management (AREA)
- Human Resources & Organizations (AREA)
- Engineering & Computer Science (AREA)
- Economics (AREA)
- Strategic Management (AREA)
- Development Economics (AREA)
- Entrepreneurship & Innovation (AREA)
- Educational Administration (AREA)
- Quality & Reliability (AREA)
- Operations Research (AREA)
- Marketing (AREA)
- Tourism & Hospitality (AREA)
- Physics & Mathematics (AREA)
- General Business, Economics & Management (AREA)
- General Physics & Mathematics (AREA)
- Theoretical Computer Science (AREA)
- Game Theory and Decision Science (AREA)
- Finance (AREA)
- Accounting & Taxation (AREA)
- General Factory Administration (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses a method for screening alternative materials and a related device, which are used for determining material data of original materials; determining a corresponding material substitution rule for the original material, wherein the material substitution rule comprises: at least one or any combination of three dimensions of a market reference price dimension, an authentication information dimension group and a defect information dimension, and a matching rule between the original material and the alternative substitute material under each dimension; respectively matching the material data of the original material with the material data of each alternative substitute material according to the material substitution rules; and using the alternative substitute materials meeting the material substitution rule requirements as substitute materials of the original materials. According to the method, the substitute materials are screened according to comprehensive reference dimensions, all the substitute materials meeting the requirements of enterprises can be obtained, the enterprises can conveniently select the substitute materials according to different conditions, and meanwhile, the loss of the enterprises caused by single reference quantity of the screened substitute materials is avoided.
Description
Technical Field
The invention relates to the field of data processing, in particular to a method for screening substitute materials and a related device.
Background
Material substitution means that a certain material can be substituted by another material under specific conditions. Generally, a material replacement mode is adopted in purchasing and production of enterprises to disperse risks, promote external competition and reduce cost.
The existing screening method of the substitute materials only considers the attributes of the substitute materials, such as the materials, models, colors, weights and the like. Although the substitute materials screened by the method can complete the substitution work in the aspect of material application, due to the fact that factors except the material attributes are not considered, problems are likely to occur in the purchasing and production processes, for example, the price of the screened optimal substitute materials is more expensive than that of the original materials, the cost of purchasing the materials is increased, or the screened optimal substitute materials are not subjected to quality certification and influence is caused on the product quality of an enterprise after being put into production.
Disclosure of Invention
The invention provides a method and a related device for screening alternative materials, which can solve the problem of loss of enterprises caused by single reference amount of screened alternative materials in the prior art.
In order to achieve the purpose, the invention provides the following technical scheme:
in a first aspect, a method for screening substitute materials comprises:
determining material data of an original material;
determining a corresponding material substitution rule for the original material, wherein the material substitution rule comprises: at least one or any combination of three dimensions of a market reference price dimension, an authentication information dimension and a defect information dimension, and a matching rule between the original material and the alternative substitute material under each dimension;
respectively matching the material data of the original material with the material data of each alternative substitute material according to the material substitution rules;
and using the alternative substitute materials meeting the material substitution rule requirements as substitute materials of the original materials.
Optionally, the process of establishing the material replacement rule includes:
selecting dimensions for evaluating alternative substitute materials from various dimensions for evaluating materials based on a preset evaluation rule to form a material substitution dimension group;
and setting an alternative threshold range corresponding to the evaluation index under each dimensionality in the material alternative dimensionality group based on the evaluation index under each dimensionality in the material alternative dimensionality group to obtain a material alternative rule corresponding to the material.
Optionally, the matching the material data of the original material and the material data of each alternative substitute material according to the material substitution rule includes:
accumulating weight values set by dimensions meeting the screening condition in all dimensions of the material substitution rule; wherein the screening conditions are: the matching degree of the material data of the original material in a first dimension and the material data of any alternative substitute material in the first dimension meets the alternative threshold range of the first dimension; the first dimension is each dimension in the material substitution rule, and the matching degree is determined based on evaluation indexes under the corresponding dimension;
judging whether the accumulation result of the weighted values exceeds a preset threshold value or not;
and if the accumulated result of the weighted values exceeds a preset threshold value, the alternative substitute material corresponding to the accumulated result of the weighted values is used as the substitute material of the original material.
Optionally, the determining material data of the raw material includes:
collecting attribute information and network information of an original material, wherein the network information comprises: at least one or any combination of three information of market reference price, authentication information and defect information;
sorting the attribute information and the network information to obtain theme data, wherein the theme data comprises: purchase order data, purchase contract data, supplier information data, material main data, material ex-warehouse data, quality problem data, product authentication data, material market price data, social quality public opinion data and after-sale use data of products;
and carrying out dimensionality division on the theme data to obtain material data of the original material.
In a second aspect, a substitute material screening apparatus, comprising:
the first determining unit is used for determining material data of the original material;
a second determining unit, configured to determine a corresponding material replacement rule for the original material, where the material replacement rule includes: at least one or any combination of three dimensions of a market reference price dimension, an authentication information dimension group and a defect information dimension, and a matching rule between the original material and the alternative substitute material under each dimension;
the matching unit is used for respectively matching the material data of the original material with the material data of each alternative substitute material according to the material substitution rule;
and the replacing unit is used for taking the alternative replacing materials meeting the material replacing rule requirements as the replacing materials of the original materials.
Optionally, the screening apparatus further includes:
the selection unit is used for selecting dimensions for evaluating alternative substitute materials from various dimensions for evaluating the materials based on a preset evaluation rule to form a material substitute dimension group;
and the setting unit is used for setting the substitutable threshold range corresponding to the evaluation index under each dimensionality in the material substitution dimensionality group based on the evaluation index under each dimensionality in the material substitution dimensionality group to obtain the material substitution rule corresponding to the material.
Optionally, the matching unit includes:
the calculating unit is used for accumulating weight values set by dimensions meeting the screening condition in all dimensions of the material substitution rule; wherein the screening conditions are: the matching degree of the material data of the original material in a first dimension and the material data of any alternative substitute material in the first dimension meets the alternative threshold range of the first dimension; the first dimension is each dimension in the material substitution rule, and the matching degree is determined based on evaluation indexes under the corresponding dimension;
the judging unit is used for judging whether the accumulation result of the weighted values exceeds a preset threshold value or not;
if the judgment unit judges that the accumulation result of the weighted value exceeds a preset threshold value, the replacement unit is used for taking the alternative substitute material corresponding to the accumulation result of the weighted value as the substitute material of the original material.
Optionally, the first determining unit includes:
the collecting unit is used for collecting attribute information and network information of an original material, wherein the network information comprises: at least one or any combination of three information of market reference price, authentication information and defect information;
a sorting unit, configured to sort the attribute information and the network information to obtain theme data, where the theme data includes: purchasing order data, purchasing contract data, supplier information data, material main data, material ex-warehouse data, quality problem data, product authentication data, material market price data, social quality public opinion data and after-sale use data of products;
and the dividing unit is used for carrying out dimensional division on the main body data to obtain material data of the original material.
A storage medium storing a program for implementing the screening method according to the first aspect when executed.
A processor for executing a program, wherein the program is executed for performing: a screening method according to the first aspect.
According to the technical scheme, the invention discloses a method and a related device for screening alternative materials, which are used for determining material data of original materials; determining a corresponding material substitution rule for the original material, wherein the material substitution rule comprises: at least one or any combination of three dimensions of a market reference price dimension, an authentication information dimension group and a defect information dimension, and a matching rule between the original material and the alternative substitute material under each dimension; respectively matching the material data of the original material with the material data of each alternative substitute material according to the material substitution rules; and using the alternative substitute materials meeting the material substitution rule requirements as substitute materials of the original materials. According to the method, at least one of the market reference price dimension, the certification information dimension and the defect information dimension or the dimension in any combination is used for screening the substitute materials, so that all the substitute materials meeting the enterprise requirements can be obtained, the enterprise can conveniently select the substitute materials according to different conditions, and meanwhile, the loss of the enterprise caused by the single reference amount of the screened substitute materials is avoided.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, it is obvious that the drawings in the following description are only embodiments of the present invention, and for those skilled in the art, other drawings can be obtained according to the provided drawings without creative efforts.
FIG. 1 is a flow chart of a method for screening substitute materials according to an embodiment of the present invention;
fig. 2 is a schematic view of a substitute material screening device disclosed in the embodiment of the present invention.
Detailed Description
The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
The invention provides a method and a related device for screening alternative materials, which can solve the problem of loss of enterprises caused by single reference amount of screened alternative materials in the prior art.
As shown in fig. 1, the embodiment of the invention discloses a method for screening substitute materials, which comprises the following steps:
s101, determining material data of the original material.
Optionally, the process of determining the material data of the raw material includes:
collecting attribute information and network information of an original material, wherein the network information comprises: at least one or any combination of market reference price, authentication information and defect information.
Sorting the attribute information and the network information to obtain theme data, wherein the theme data comprises: the system comprises purchase order data, purchase contract data, supplier information data, material main data, material ex-warehouse data, quality problem data, product authentication data, material market price data, social quality public opinion data and after-sale use data of products.
And carrying out dimensionality division on the main data to obtain material data of the original material.
It should be noted that in an actual application scenario, an information-based construction foundation of an enterprise must reach an advanced level, an information-based platform of the enterprise must have a big data analysis condition, the attribute information is collected from an information system of the enterprise, and material main data information, supplier main data information, purchase transaction data, ex-warehouse data and quality problem data in the subject data are also derived from the information system of the enterprise, wherein the material main data information, the supplier main data information, supplier admission data, purchase transaction data, ex-warehouse data and quality problem data are collected by data extraction (Extract-Transform-Load, ETL).
The network information is collected from the internet, such as data from a media information publishing platform of a China quality authentication center official network, a smart network, an easy-to-serve guest, a mainstream news media, a famous WeChat public number, a famous microblog, a famous forum, a famous blog, a post bar, a video website, an overseas social network and the like, the data of the internet is collected by adopting a web crawler technology, and then the crawled data is extracted to a database of an enterprise big data platform through ETL data extraction.
Optionally, the sorting the attribute information and the network information to obtain theme data includes:
cleaning the attribute information and the network information in the modes of conversion, mapping, filtering and the like;
and structuring the cleaned attribute information and the network information to obtain theme data.
And S102, determining a corresponding material substitution rule of the original material.
In step S102, the material replacement rule includes: at least one or any combination of three dimensions of a market reference price dimension, an authentication information dimension group and a defect information dimension, and a matching rule between the original material and the alternative substitute material under each dimension.
Optionally, the process of establishing the material replacement rule includes:
and selecting the dimension for evaluating the alternative substitute materials from various dimensions for evaluating the materials based on a preset evaluation rule to form a material substitution dimension group.
And setting an alternative threshold range corresponding to the evaluation index under each dimensionality in the material alternative dimensionality group based on the evaluation index under each dimensionality in the material alternative dimensionality group to obtain a material alternative rule corresponding to the material.
It should be noted that the process of establishing the correspondence between the categories of the materials and all the corresponding dimensions thereof includes:
establishing a material model according to a preset dimension, wherein the preset dimension comprises: material type, name, measuring unit, material, specification type, grade, shape, weight, color, state (solid, liquid or gas), edge state, mechanical state, component content, packaging specification, modeling pattern, material application, brand, manufacturer, special description, market reference price, authentication information and defect information.
And inputting the theme data into the material model. Specifically, material use data is obtained from material warehouse-out data; acquiring dimension data except for material use, market reference price, authentication information and defect information from the material main data; obtaining market reference price from material market price data; acquiring information to be authenticated from product authentication data and material master data, acquiring authenticated information from supplier information data, and combining the information to be authenticated and the authenticated information into authentication information; and acquiring defect information from the quality problem data, the social quality public opinion data and the after-sale use data of the product, wherein the defect information comprises the problems of the material in the aspects of quality and after-sale.
S103, respectively matching the material data of the original material with the material data of each alternative substitute material according to the material substitution rules.
Optionally, the matching the material data of the original material and the material data of each alternative substitute material according to the material substitution rule includes:
accumulating weight values set by dimensions meeting the screening condition in all dimensions of the material substitution rule; wherein the screening conditions are: the matching degree of the material data of the original material in a first dimension and the material data of any alternative substitute material in the first dimension meets the alternative threshold range of the first dimension; the first dimension is each dimension in the material substitution rule, and the matching degree is determined based on evaluation indexes under the corresponding dimension.
Each dimension of the material substitution rule is provided with a corresponding weight value, and the weight value is used for reflecting the reference degree of the dimension in the screening process of the substituted materials. If the reference degree of a certain dimensionality in the material substitution rule is higher in the process of screening the substitute materials, a higher weight value is set. And the weighted values of all dimensions of the material substitution rule are added to be equal to one.
Optionally, a weight value is set for each dimension of the material substitution rule, and the weight value may be set according to the material category. It should be noted that, the weighted value of the dimension is set according to the material category, so as to automatically calculate the matching degree (percentage) of the substitute material, and provide one of the consideration conditions of the matching degree of the substitute material and the original material for the user.
And judging whether the accumulation result of the weighted values exceeds a preset threshold value or not.
And if the accumulated result of the weighted values exceeds a preset threshold value, the alternative substitute material corresponding to the accumulated result of the weighted values is used as the substitute material of the original material.
For convenience of understanding, specific examples are listed herein as follows:
the material substitution rule of the original material comprises five dimensions, wherein the weight of each dimension is respectively 5% of a first dimension, 10% of a second dimension, 15% of a third dimension, 20% of a fourth dimension and 50% of a fifth dimension, when the first dimension data of the substituted material is matched with the first dimension data of the original material, the weight of the first dimension is 5%, when the first dimension data of the substituted material is not matched with the first dimension data of the original material, the weight of the first dimension is 0, and so on, when the second dimension data of the substituted material is not matched with the second dimension data of the original material, the weight of the second dimension is 0, the third dimension data of the substituted material is matched with the third dimension data of the original material, the weight of the third dimension is 15%, and the fourth dimension data of the substituted material is matched with the fourth dimension data of the original material, obtaining a weight value of 20% of a fourth dimension, obtaining a weight value of 50% of the fifth dimension when the fifth dimension data of the substitute material is matched with the fifth dimension data of the original material, and accumulating the weight values of all dimensions, wherein 5+0+15+20+50 is 90%, that is, the weight value set by the dimension meeting the screening condition in all dimensions of the accumulated material substitution rule is 90%.
If the preset threshold value is 85%, the substitute material with the weight value of more than 85% can be used as the substitute material of the original material. As can be seen from the above calculation, if the weight value of the substitute material in the example is 90%, and exceeds the preset threshold, the substitute material in the example can be used as the substitute material for the original material, and conversely, if the weight value calculation result in the above example is less than 85%, the substitute material in the example cannot be used as the substitute material for the original material. And S104, using the alternative substitute materials meeting the material substitution rule requirements as substitute materials of the original materials.
Optionally, after step S104, the method further includes:
and arranging all materials which can be used as the substitute materials of the original materials, and pushing the materials to a user.
Specifically, the substitute materials may be sorted and stored in a Database, and substitute material data in the data may be displayed on a visualization platform in an Open Database Connectivity (ODBC) manner.
The embodiment discloses a method for screening substitute materials, which comprises the steps of determining material data of original materials; determining a corresponding material substitution rule for the original material, wherein the material substitution rule comprises: at least one or any combination of three dimensions of a market reference price dimension, an authentication information dimension group and a defect information dimension, and a matching rule between the original material and the alternative substitute material under each dimension; respectively matching the material data of the original material with the material data of each alternative substitute material according to the material substitution rules; and using the alternative substitute materials meeting the material substitution rule requirements as substitute materials of the original materials. According to the method, the substitute materials are screened according to comprehensive reference dimensions, all the substitute materials meeting the requirements of enterprises can be obtained, the enterprises can conveniently select the substitute materials according to different conditions, and meanwhile, the loss of the enterprises caused by single reference quantity of the screened substitute materials is avoided.
Based on the method for screening substitute materials disclosed in the above embodiment of the present invention, fig. 2 specifically discloses a device for screening substitute materials using the method for screening substitute materials.
As shown in fig. 2, another embodiment of the present invention discloses a substitute material screening apparatus, which includes:
a first determining unit 201, configured to determine material data of an original material.
A second determining unit 202, configured to determine a corresponding material replacement rule for the original material, where the material replacement rule includes: at least one or any combination of three dimensions of a market reference price dimension, an authentication information dimension group and a defect information dimension, and a matching rule between the original material and the alternative substitute material under each dimension.
And the matching unit 203 is configured to match the material data of the original material with the material data of each alternative substitute material according to the material substitution rule.
A substitute unit 204, configured to use a candidate substitute material that meets the material substitution rule requirement as a substitute material for the original material.
Optionally, the screening apparatus further includes:
the selection unit is used for selecting dimensions for evaluating alternative substitute materials from various dimensions for evaluating the materials based on a preset evaluation rule to form a material substitute dimension group;
and the setting unit is used for setting the substitutable threshold range corresponding to the evaluation index under each dimensionality in the material substitution dimensionality group based on the evaluation index under each dimensionality in the material substitution dimensionality group to obtain the material substitution rule corresponding to the material.
Optionally, the matching unit 203 includes:
the calculating unit is used for accumulating weight values set by dimensions meeting the screening condition in all dimensions of the material substitution rule; wherein the screening conditions are: the matching degree of the material data of the original material in a first dimension and the material data of any alternative substitute material in the first dimension meets the alternative threshold range of the first dimension; the first dimension is each dimension in the material substitution rule, and the matching degree is determined based on evaluation indexes under the corresponding dimension.
And the judging unit is used for judging whether the accumulation result of the weighted values exceeds a preset threshold value or not.
If the judgment unit judges that the accumulation result of the weighted value exceeds a preset threshold value, the replacement unit is used for taking the alternative substitute material corresponding to the accumulation result of the weighted value as the substitute material of the original material.
Optionally, the first determining unit 201 includes:
the collecting unit is used for collecting attribute information and network information of an original material, wherein the network information comprises: at least one or any combination of market reference price, authentication information and defect information.
A sorting unit, configured to sort the attribute information and the network information to obtain theme data, where the theme data includes: the system comprises purchase order data, purchase contract data, supplier information data, material main data, material ex-warehouse data, quality problem data, product authentication data, material market price data, social quality public opinion data and after-sale use data of products.
And the dividing unit is used for carrying out dimensional division on the main body data to obtain material data of the original material.
For specific working processes of the first determining unit 201, the second determining unit 202, the matching unit 203 and the replacing unit 204 in the screening apparatus for alternative materials disclosed in the above embodiment of the present invention, reference may be made to corresponding contents in the screening method for alternative materials disclosed in the above embodiment of the present invention, and details are not repeated here.
In the screening apparatus for alternative materials disclosed in this embodiment, the first determining unit determines material data of an original material; the second determination unit determines a corresponding material replacement rule of the original material, wherein the material replacement rule comprises: at least one or any combination of three dimensions of a market reference price dimension, an authentication information dimension group and a defect information dimension, and a matching rule between the original material and the alternative substitute material under each dimension; the matching unit is used for respectively matching the material data of the original material with the material data of each alternative substitute material according to the material substitution rule; and the substitute unit takes the alternative substitute materials meeting the material substitution rule requirements as substitute materials of the original materials. According to the method, the substitute materials are screened according to comprehensive reference dimensions, all the substitute materials meeting the requirements of enterprises can be obtained, the enterprises can conveniently select the substitute materials according to different conditions, and meanwhile, the loss of the enterprises caused by single reference quantity of the screened substitute materials is avoided.
The screening device for the substitute materials comprises a processor and a memory, wherein the first determining unit, the second determining unit, the matching unit, the substitute unit and the like are stored in the memory as program units, and the processor executes the program units stored in the memory to realize corresponding functions.
The processor comprises a kernel, and the kernel calls the corresponding program unit from the memory. One or more than one kernel can be set, and the screening of the substitute materials is realized by adjusting kernel parameters.
The memory may include volatile memory in a computer readable medium, Random Access Memory (RAM) and/or nonvolatile memory such as Read Only Memory (ROM) or flash memory (flash RAM), and the memory includes at least one memory chip.
The embodiment of the invention provides a storage medium, wherein a program is stored in the storage medium, and the instruction is executed by a processor to realize the screening method of the substitute material.
The embodiment of the invention provides a processor, which is used for running a program, wherein the program executes the screening method of the substitute materials when running.
The embodiment of the invention provides equipment, and the equipment can be a server, a PC, a PAD, a mobile phone and the like. The device comprises a processor, a memory and a program stored on the memory and capable of running on the processor, and the processor realizes the following steps when executing the program:
determining material data of the raw material.
Determining a corresponding material substitution rule for the original material, wherein the material substitution rule comprises: at least one or any combination of three dimensions of a market reference price dimension, an authentication information dimension and a defect information dimension, and a matching rule between the original material and the alternative substitute material under each dimension.
And respectively matching the material data of the original material with the material data of each alternative substitute material according to the material substitution rules.
And using the alternative substitute materials meeting the material substitution rule requirements as substitute materials of the original materials.
Optionally, the process of establishing the material replacement rule includes:
and selecting the dimension for evaluating the alternative substitute materials from various dimensions for evaluating the materials based on a preset evaluation rule to form a material substitution dimension group.
And setting an alternative threshold range corresponding to the evaluation index under each dimensionality in the material alternative dimensionality group based on the evaluation index under each dimensionality in the material alternative dimensionality group to obtain a material alternative rule corresponding to the material.
Optionally, the matching the material data of the original material and the material data of each alternative substitute material according to the material substitution rule includes:
accumulating weight values set by dimensions meeting the screening condition in all dimensions of the material substitution rule; wherein the screening conditions are: the matching degree of the material data of the original material in a first dimension and the material data of any alternative substitute material in the first dimension meets the alternative threshold range of the first dimension; the first dimension is each dimension in the material substitution rule, and the matching degree is determined based on evaluation indexes under the corresponding dimension.
And judging whether the accumulation result of the weighted values exceeds a preset threshold value or not.
And if the accumulated result of the weighted values exceeds a preset threshold value, the alternative substitute material corresponding to the accumulated result of the weighted values is used as the substitute material of the original material.
Optionally, the determining material data of the raw material includes:
collecting attribute information and network information of an original material, wherein the network information comprises: at least one or any combination of market reference price, authentication information and defect information.
Sorting the attribute information and the network information to obtain theme data, wherein the theme data comprises: purchase order data, purchase contract data, supplier information data, material master data, material ex-warehouse data, quality problem data, product authentication data, material market price data, social quality public opinion data, and product after-sale use data.
And carrying out dimensionality division on the theme data to obtain material data of the original material.
The invention also provides a computer program product adapted to perform a procedure for initializing the following method steps when executed on a device for screening substitute materials:
determining material data of the raw material.
Determining a corresponding material substitution rule for the original material, wherein the material substitution rule comprises: at least one or any combination of three dimensions of a market reference price dimension, an authentication information dimension and a defect information dimension, and a matching rule between the original material and the alternative substitute material under each dimension.
And respectively matching the material data of the original material with the material data of each alternative substitute material according to the material substitution rules.
And using the alternative substitute materials meeting the material substitution rule requirements as substitute materials of the original materials.
Optionally, the process of establishing the material replacement rule includes:
and selecting the dimension for evaluating the alternative substitute materials from various dimensions for evaluating the materials based on a preset evaluation rule to form a material substitution dimension group.
And setting an alternative threshold range corresponding to the evaluation index under each dimensionality in the material alternative dimensionality group based on the evaluation index under each dimensionality in the material alternative dimensionality group to obtain a material alternative rule corresponding to the material.
Optionally, the matching the material data of the original material and the material data of each alternative substitute material according to the material substitution rule includes:
accumulating weight values set by dimensions meeting the screening condition in all dimensions of the material substitution rule; wherein the screening conditions are: the matching degree of the material data of the original material in a first dimension and the material data of any alternative substitute material in the first dimension meets the alternative threshold range of the first dimension; the first dimension is each dimension in the material substitution rule, and the matching degree is determined based on evaluation indexes under the corresponding dimension.
And judging whether the accumulation result of the weighted values exceeds a preset threshold value or not.
And if the accumulated result of the weighted values exceeds a preset threshold value, the alternative substitute material corresponding to the accumulated result of the weighted values is used as the substitute material of the original material.
Optionally, the determining material data of the raw material includes:
collecting attribute information and network information of an original material, wherein the network information comprises: at least one or any combination of market reference price, authentication information and defect information.
Sorting the attribute information and the network information to obtain theme data, wherein the theme data comprises: purchase order data, purchase contract data, supplier information data, material master data, material ex-warehouse data, quality problem data, product authentication data, material market price data, social quality public opinion data, and product after-sale use data.
And carrying out dimensionality division on the theme data to obtain material data of the original material.
As will be appreciated by one skilled in the art, embodiments of the present application may be provided as a method, apparatus, or computer program product. Accordingly, the present application may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the present application may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and the like) having computer-usable program code embodied therein.
The present application is described with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems), and computer program products according to embodiments of the application. It will be understood that each flow and/or block of the flow diagrams and/or block diagrams, and combinations of flows and/or blocks in the flow diagrams and/or block diagrams, can be implemented by computer program instructions. These computer program instructions may be provided to a processor of a general purpose computer, special purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create means for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be stored in a computer-readable memory that can direct a computer or other programmable data processing apparatus to function in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including instruction means which implement the function specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be loaded onto a computer or other programmable data processing apparatus to cause a series of operational steps to be performed on the computer or other programmable apparatus to produce a computer implemented process such that the instructions which execute on the computer or other programmable apparatus provide steps for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
In a typical configuration, a computing device includes one or more processors (CPUs), input/output interfaces, network interfaces, and memory.
The memory may include forms of volatile memory in a computer readable medium, Random Access Memory (RAM) and/or non-volatile memory, such as Read Only Memory (ROM) or flash memory (flash RAM). The memory is an example of a computer-readable medium.
Computer-readable media, including both non-transitory and non-transitory, removable and non-removable media, may implement information storage by any method or technology. The information may be computer readable instructions, data structures, modules of a program, or other data. Examples of computer storage media include, but are not limited to, phase change memory (PRAM), Static Random Access Memory (SRAM), Dynamic Random Access Memory (DRAM), other types of Random Access Memory (RAM), Read Only Memory (ROM), Electrically Erasable Programmable Read Only Memory (EEPROM), flash memory or other memory technology, compact disc read only memory (CD-ROM), Digital Versatile Discs (DVD) or other optical storage, magnetic cassettes, magnetic tape magnetic disk storage or other magnetic storage devices, or any other non-transmission medium that can be used to store information that can be accessed by a computing device. As defined herein, a computer readable medium does not include a transitory computer readable medium such as a modulated data signal and a carrier wave.
It should also be noted that the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising an … …" does not exclude the presence of other identical elements in the process, method, article, or apparatus that comprises the element.
As will be appreciated by one skilled in the art, embodiments of the present application may be provided as a method, system, or computer program product. Accordingly, the present application may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the present application may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and the like) having computer-usable program code embodied therein.
The above are merely examples of the present application and are not intended to limit the present application. Various modifications and changes may occur to those skilled in the art. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present application should be included in the scope of the claims of the present application.
Claims (10)
1. A method of screening substitute materials, comprising:
determining material data of an original material;
determining a corresponding material substitution rule for the original material, wherein the material substitution rule comprises: at least one or any combination of three dimensions of a market reference price dimension, an authentication information dimension and a defect information dimension, and a matching rule between the original material and the alternative substitute material under each dimension;
respectively matching the material data of the original material with the material data of each alternative substitute material according to the material substitution rules;
and using the alternative substitute materials meeting the material substitution rule requirements as substitute materials of the original materials.
2. The screening method according to claim 1, wherein the establishing process of the material substitution rule comprises:
selecting dimensions for evaluating alternative substitute materials from various dimensions for evaluating materials based on a preset evaluation rule to form a material substitution dimension group;
and setting an alternative threshold range corresponding to the evaluation index under each dimensionality in the material alternative dimensionality group based on the evaluation index under each dimensionality in the material alternative dimensionality group to obtain a material alternative rule corresponding to the material.
3. The screening method of claim 2, wherein the matching the material data of the original material and the material data of each alternative substitute material separately according to the material substitution rules comprises:
accumulating weight values set by dimensions meeting the screening condition in all dimensions of the material substitution rule; wherein the screening conditions are: the matching degree of the material data of the original material in a first dimension and the material data of any alternative substitute material in the first dimension meets the alternative threshold range of the first dimension; the first dimension is each dimension in the material substitution rule, and the matching degree is determined based on evaluation indexes under the corresponding dimension;
judging whether the accumulation result of the weighted values exceeds a preset threshold value or not;
and if the accumulated result of the weighted values exceeds a preset threshold value, the alternative substitute material corresponding to the accumulated result of the weighted values is used as the substitute material of the original material.
4. The screening method of claim 1, wherein determining the material data of the raw material comprises:
collecting attribute information and network information of an original material, wherein the network information comprises: at least one or any combination of three information of market reference price, authentication information and defect information;
sorting the attribute information and the network information to obtain theme data, wherein the theme data comprises: purchase order data, purchase contract data, supplier information data, material main data, material ex-warehouse data, quality problem data, product authentication data, material market price data, social quality public opinion data and after-sale use data of products;
and carrying out dimensionality division on the theme data to obtain material data of the original material.
5. A substitute material screening device, comprising:
the first determining unit is used for determining material data of the original material;
a second determining unit, configured to determine a corresponding material replacement rule for the original material, where the material replacement rule includes: at least one or any combination of three dimensions of a market reference price dimension, an authentication information dimension group and a defect information dimension, and a matching rule between the original material and the alternative substitute material under each dimension;
the matching unit is used for respectively matching the material data of the original material with the material data of each alternative substitute material according to the material substitution rule;
and the replacing unit is used for taking the alternative replacing materials meeting the material replacing rule requirements as the replacing materials of the original materials.
6. The screening apparatus of claim 5, further comprising:
the selection unit is used for selecting dimensions for evaluating alternative substitute materials from various dimensions for evaluating the materials based on a preset evaluation rule to form a material substitute dimension group;
and the setting unit is used for setting the substitutable threshold range corresponding to the evaluation index under each dimensionality in the material substitution dimensionality group based on the evaluation index under each dimensionality in the material substitution dimensionality group to obtain the material substitution rule corresponding to the material.
7. The screening apparatus according to claim 6, wherein the matching unit includes:
the calculating unit is used for accumulating weight values set by dimensions meeting the screening condition in all dimensions of the material substitution rule; wherein the screening conditions are: the matching degree of the material data of the original material in a first dimension and the material data of any alternative substitute material in the first dimension meets the alternative threshold range of the first dimension; the first dimension is each dimension in the material substitution rule, and the matching degree is determined based on evaluation indexes under the corresponding dimension;
the judging unit is used for judging whether the accumulation result of the weighted values exceeds a preset threshold value or not;
if the judgment unit judges that the accumulation result of the weighted value exceeds a preset threshold value, the replacement unit is used for taking the alternative substitute material corresponding to the accumulation result of the weighted value as the substitute material of the original material.
8. The screening apparatus according to claim 5, wherein the first determination unit includes:
the collecting unit is used for collecting attribute information and network information of an original material, wherein the network information comprises: at least one or any combination of three information of market reference price, authentication information and defect information;
a sorting unit, configured to sort the attribute information and the network information to obtain theme data, where the theme data includes: purchasing order data, purchasing contract data, supplier information data, material main data, material ex-warehouse data, quality problem data, product authentication data, material market price data, social quality public opinion data and after-sale use data of products;
and the dividing unit is used for carrying out dimensional division on the main body data to obtain material data of the original material.
9. A storage medium storing a program which, when executed, implements the screening method of any one of claims 1 to 5.
10. A processor configured to execute a program, wherein the program is configured to perform: the screening method according to any one of claims 1 to 5.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811139155.8A CN110969379B (en) | 2018-09-28 | 2018-09-28 | Screening method of substitute materials and related device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811139155.8A CN110969379B (en) | 2018-09-28 | 2018-09-28 | Screening method of substitute materials and related device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN110969379A true CN110969379A (en) | 2020-04-07 |
| CN110969379B CN110969379B (en) | 2024-04-30 |
Family
ID=70026833
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811139155.8A Active CN110969379B (en) | 2018-09-28 | 2018-09-28 | Screening method of substitute materials and related device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110969379B (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112633802A (en) * | 2020-12-23 | 2021-04-09 | 云汉芯城（上海）互联网科技股份有限公司 | Material matching method and system, electronic equipment and computer storage medium |
| CN117078170A (en) * | 2023-10-17 | 2023-11-17 | 北京谷器数据科技有限公司 | Method for automatically supplementing substitute materials in reporting process |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20030033179A1 (en) * | 2001-08-09 | 2003-02-13 | Katz Steven Bruce | Method for generating customized alerts related to the procurement, sourcing, strategic sourcing and/or sale of one or more items by an enterprise |
| US7343212B1 (en) * | 2003-12-17 | 2008-03-11 | Glovia International, Inc. | Item substitution in the manufacture of products |
| CN102034162A (en) * | 2010-12-22 | 2011-04-27 | 广州视源电子科技有限公司 | Material requirement planning (MRP) operation method and device |
| CN103268538A (en) * | 2013-03-26 | 2013-08-28 | 大连海洋大学 | Production plan change-oriented multi-objective constraint material substitution method |
| US20140304104A1 (en) * | 2013-04-08 | 2014-10-09 | Amazon Technologies, Inc. | Identifying part interchanges at electronic marketplaces |
| CN104766179A (en) * | 2015-04-23 | 2015-07-08 | 广州视源电子科技股份有限公司 | Maintenance method and system for substitute materials |
| CN108520270A (en) * | 2018-03-12 | 2018-09-11 | 明觉科技（北京）有限公司 | Part match method, system and terminal |
-
2018
- 2018-09-28 CN CN201811139155.8A patent/CN110969379B/en active Active
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20030033179A1 (en) * | 2001-08-09 | 2003-02-13 | Katz Steven Bruce | Method for generating customized alerts related to the procurement, sourcing, strategic sourcing and/or sale of one or more items by an enterprise |
| US7343212B1 (en) * | 2003-12-17 | 2008-03-11 | Glovia International, Inc. | Item substitution in the manufacture of products |
| CN102034162A (en) * | 2010-12-22 | 2011-04-27 | 广州视源电子科技有限公司 | Material requirement planning (MRP) operation method and device |
| CN103268538A (en) * | 2013-03-26 | 2013-08-28 | 大连海洋大学 | Production plan change-oriented multi-objective constraint material substitution method |
| US20140304104A1 (en) * | 2013-04-08 | 2014-10-09 | Amazon Technologies, Inc. | Identifying part interchanges at electronic marketplaces |
| CN104766179A (en) * | 2015-04-23 | 2015-07-08 | 广州视源电子科技股份有限公司 | Maintenance method and system for substitute materials |
| CN108520270A (en) * | 2018-03-12 | 2018-09-11 | 明觉科技（北京）有限公司 | Part match method, system and terminal |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112633802A (en) * | 2020-12-23 | 2021-04-09 | 云汉芯城（上海）互联网科技股份有限公司 | Material matching method and system, electronic equipment and computer storage medium |
| CN117078170A (en) * | 2023-10-17 | 2023-11-17 | 北京谷器数据科技有限公司 | Method for automatically supplementing substitute materials in reporting process |
Also Published As
| Publication number | Publication date |
|---|---|
| CN110969379B (en) | 2024-04-30 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103514178A (en) | Searching and sorting method and device based on click rate | |
| CN102254028A (en) | Personalized commodity recommending method and system which integrate attributes and structural similarity | |
| CN111445134A (en) | Commodity sales prediction method, commodity sales prediction apparatus, computer device, and storage medium | |
| CN103678518A (en) | Method and device for adjusting recommendation lists | |
| CN105096152A (en) | Commodity popularity-based operation execution method and device | |
| CN108629436B (en) | Method and electronic equipment for estimating warehouse goods picking capacity | |
| CN110969467B (en) | Product sales prediction method and related device | |
| CN112308462A (en) | Power consumer classification method and device | |
| CN108830443A (en) | A kind of contract review method and device | |
| CN106610818A (en) | Attribute determining method and apparatus | |
| CN110969379B (en) | Screening method of substitute materials and related device | |
| CN105303447A (en) | Method and device for carrying out credit rating through network information | |
| CN111932044A (en) | Steel product price prediction system and method based on machine learning | |
| CN106372964A (en) | Behavior loyalty identification and management method, system and terminal | |
| CN111242425A (en) | Power data processing method and device | |
| Jakaitiene et al. | Forecasting the world economy in the short term | |
| CN114004691A (en) | Line scoring method, device, equipment and storage medium based on fusion algorithm | |
| CN117196646A (en) | Supplier qualification auditing method, equipment and medium | |
| CN105677677A (en) | Information classification and device | |
| CN116595390A (en) | Commodity information processing method and electronic equipment | |
| CN116542747A (en) | Product recommendation method and device, storage medium and electronic equipment | |
| CN113298575A (en) | Method, system, equipment and storage medium for trademark value batch evaluation | |
| Jayant et al. | Decision support framework for smart implementation of green supply chain management practices | |
| CN114548631A (en) | Dynamic evaluation method and device | |
| CN112232945A (en) | Method and device for determining personal customer credit |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |