CN110969379B - Screening method of substitute materials and related device - Google Patents

Screening method of substitute materials and related device Download PDF

Info

Publication number
CN110969379B
CN110969379B CN201811139155.8A CN201811139155A CN110969379B CN 110969379 B CN110969379 B CN 110969379B CN 201811139155 A CN201811139155 A CN 201811139155A CN 110969379 B CN110969379 B CN 110969379B
Authority
CN
China
Prior art keywords
data
dimension
original
substitute
alternative
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.)
Active
Application number
CN201811139155.8A
Other languages
Chinese (zh)
Other versions
CN110969379A (en
Inventor
陈文莉
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Beijing Gridsum Technology Co Ltd
Original Assignee
Beijing Gridsum Technology Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Beijing Gridsum Technology Co Ltd filed Critical Beijing Gridsum Technology Co Ltd
Priority to CN201811139155.8A priority Critical patent/CN110969379B/en
Publication of CN110969379A publication Critical patent/CN110969379A/en
Application granted granted Critical
Publication of CN110969379B publication Critical patent/CN110969379B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

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 screening method and a related device for alternative materials, which are used for determining material data of original materials; determining a corresponding material substitution rule of 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 an original material and an alternative substitute material in each dimension; according to the material substitution rules, matching the material data of the original material and the material data of each alternative substitute material respectively; and taking the alternative substitute material meeting the requirement of the material substitution rule as the substitute material of the original material. The invention screens the substitute materials with comprehensive reference dimensions, can obtain all substitute materials meeting the requirements of enterprises, is convenient for enterprises to select according to different conditions, and simultaneously avoids the loss of single reference quantity for screening the substitute materials to the enterprises.

Description

Screening method of substitute materials and related device
Technical Field
The invention relates to the field of data processing, in particular to a screening method of alternative materials and a related device.
Background
Material substitution means that one material can be replaced with another material under specific conditions. Material substitution is often employed in the procurement and production of enterprises to distribute risks, promote external competition, and reduce costs.
The existing screening method of the substitute material only considers the attribute of the substitute material, such as the material quality, model, color, weight and the like of the material. Although the alternative materials screened in the mode can finish the alternative work in the aspect of material application, because factors other than the properties of the materials are not considered, problems are likely to be encountered in purchasing and production processes, such as the price of the screened optimal alternative materials is more expensive than that of the original materials, the cost of purchasing the materials is increased, or the screened optimal alternative materials are not subjected to quality authentication, the quality of products of enterprises is influenced after the screened optimal alternative materials are put into production, and therefore, the screening method of the alternative materials in the prior art has single reference quantity and is easy to cause unnecessary loss to enterprise operation.
Disclosure of Invention
The invention provides a screening method and a related device for alternative materials, which can solve the problem of loss to enterprises caused by single reference quantity for screening the alternative materials in the prior art.
In order to achieve the above purpose, the present invention provides the following technical solutions:
in a first aspect, a method of screening a surrogate material includes:
determining material data of an original material;
Determining a corresponding material substitution rule of 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 an original material and an alternative substitute material in each dimension;
according to the material substitution rules, matching the material data of the original material and the material data of each alternative substitute material respectively;
And taking the alternative substitute material meeting the requirement of the material substitution rule as the substitute material of the original material.
Optionally, the process for establishing the material substitution rule includes:
Selecting dimensions for evaluating alternative substitute materials from various dimensions for evaluating materials based on preset evaluation rules to form a material substitute dimension group;
And setting a replaceable threshold range corresponding to the evaluation index in each dimension in the material substitution dimension group based on the evaluation index in each dimension in the material substitution dimension group, and obtaining a material substitution rule corresponding to the material.
Optionally, the matching, according to the material substitution rule, the material data of the original material and the material data of each alternative substitute material respectively includes:
Accumulating weight values set by dimensions meeting screening conditions 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 the first dimension and the material data of any alternative substitute material in the first dimension meets the range of the alternative threshold value of the first dimension; the first dimension is each dimension in the material substitution rule, and the matching degree is determined based on an evaluation index under the corresponding dimension;
judging whether the accumulated result of the weight values exceeds a preset threshold value or not;
And if the accumulated result of the weight values exceeds the preset threshold value, taking the alternative substitute material corresponding to the accumulated result of the weight values as the substitute material of the original material.
Optionally, the determining the material data of the original 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;
And finishing 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-market product usage data;
And carrying out dimension division on the subject data to obtain material data of the original material.
In a second aspect, a screening apparatus for substitute materials, comprising:
the first determining unit is used for determining material data of the original material;
A second determining unit, configured to determine a material substitution rule corresponding to the original material, where the material substitution 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 an original material and an alternative substitute material in 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 rules;
And the replacing unit is used for taking the alternative replacing material meeting the requirement of the material replacing rule as the replacing material of the original material.
Optionally, the screening device further includes:
The selecting unit is used for selecting dimensions for evaluating alternative substitute materials from various dimensions for evaluating the materials based on preset evaluation rules to form a material substitution dimension group;
The setting unit is used for setting the substitutable threshold range corresponding to the evaluation index in each dimension in the material substitution dimension group based on the evaluation index in each dimension in the material substitution dimension group, and obtaining the material substitution rule corresponding to the material.
Optionally, the matching unit includes:
The calculating unit is used for accumulating weight values set by the dimension 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 the first dimension and the material data of any alternative substitute material in the first dimension meets the range of the alternative threshold value of the first dimension; the first dimension is each dimension in the material substitution rule, and the matching degree is determined based on an evaluation index under the corresponding dimension;
the judging unit is used for judging whether the accumulated result of the weight values exceeds a preset threshold value;
And if the judging unit judges that the accumulated result of the weight values exceeds a preset threshold value, the replacing unit is used for taking the alternative substitute material corresponding to the accumulated result of the weight values as the substitute material of the original material.
Optionally, the first determining unit includes:
The acquisition unit is used for acquiring attribute information and network information of the original materials, wherein the network information comprises: at least one or any combination of three information of market reference price, authentication information and defect information;
The arrangement unit is configured to arrange the attribute information and the network information to obtain theme data, where the theme data includes: 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;
The dividing unit is used for carrying out dimension division on the main body data to obtain material data of the original material.
A storage medium storing a program which, when executed, is adapted to carry out the screening method according to the first aspect.
A processor for running a program, wherein the program is run for executing: the screening method of the first aspect.
According to the technical scheme, the invention discloses a screening method of alternative materials and a related device, and the material data of original materials are determined; determining a corresponding material substitution rule of 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 an original material and an alternative substitute material in each dimension; according to the material substitution rules, matching the material data of the original material and the material data of each alternative substitute material respectively; and taking the alternative substitute material meeting the requirement of the material substitution rule as the substitute material of the original material. According to the invention, the substitute material screening is performed in the aspect of at least one dimension or any combination of the market reference price dimension, the authentication information dimension and the defect information dimension, so that all substitute materials meeting the enterprise requirements can be obtained, the enterprise can select according to different conditions, and meanwhile, the loss caused by single reference quantity of the screened substitute materials to the enterprise 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 that are required to be used in the embodiments or the description of the prior art will be briefly described below, and it is obvious that the drawings in the following description are only embodiments of the present invention, and that other drawings can be obtained according to the provided drawings without inventive effort for a person skilled in the art.
FIG. 1 is a flow chart of a method for screening alternative materials according to an embodiment of the present invention;
Fig. 2 is a schematic diagram of a screening apparatus for alternative materials according to an embodiment of the present invention.
Detailed Description
The following description of the embodiments of the present invention will be made clearly and completely with reference to the accompanying drawings, in which it is apparent that the embodiments described are only some embodiments of the present invention, but not all embodiments. All other embodiments, which can be made by those skilled in the art based on the embodiments of the invention without making any inventive effort, are intended to be within the scope of the invention.
The invention provides a screening method and a related device for alternative materials, which can solve the problem of loss to enterprises caused by single reference quantity for screening the alternative materials in the prior art.
As shown in fig. 1, the embodiment of the invention discloses a screening method of alternative materials, which comprises the following steps:
s101, determining material data of original materials.
Optionally, the process of determining the material data of the original material includes:
Collecting attribute information and network information of an original material, wherein the network information comprises: at least one of market reference price, authentication information and defect information or any combination thereof.
And finishing 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-market product usage data.
And carrying out dimension division on the main body data to obtain material data of the original material.
In the practical application scenario, the informatization construction foundation of the enterprise must reach an advanced level, the informatization platform of the enterprise must have a big data analysis condition, the attribute information is collected from an information system of the enterprise, and the material main data information, the supplier main data information, the purchase transaction data, the ex-warehouse data and the 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 admission data, the purchase transaction data, the ex-warehouse data and the quality problem data are collected by adopting an Extract-Transform-Load (ETL).
The network information is collected from the Internet, such as a Chinese quality authentication center official network, a smart network, a public news media, a public number of a public WeChat, a microblog, a forum, a blog, a bar, a video website, an overseas social network and other data from a media information release platform, the Internet data is collected by adopting a web crawler technology, and 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:
The attribute information and the network information are subjected to conversion, mapping, filtering and other modes for cleaning;
and structuring the cleaned attribute information and the network information to obtain the subject data.
S102, determining a corresponding material substitution rule of the original material.
In step S102, the material substitution 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 an original material and an alternative substitute material in each dimension.
Optionally, the process for establishing the material substitution rule includes:
And selecting dimensions for evaluating the alternative substitute materials from various dimensions for evaluating the materials based on a preset evaluation rule to form a material substitute dimension group.
And setting a replaceable threshold range corresponding to the evaluation index in each dimension in the material substitution dimension group based on the evaluation index in each dimension in the material substitution dimension group, and obtaining a material substitution rule corresponding to the material.
It should be noted that, the process of establishing the correspondence between the category of the material and all the dimensions corresponding to the category of the material includes:
Establishing a material model according to preset dimensions, wherein the preset dimensions comprise: material category, name, unit of measure, material, specification model, grade, shape, weight, color, state (solid, liquid or gas), edge state, mechanical state, component content, package specification, modeling pattern, material use, brand, manufacturer, special description, market reference price, authentication information, defect information.
And inputting theme data into the material model. Specifically, acquiring material use data from material warehouse-out data; acquiring dimension data except for material application, 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 main data, acquiring authenticated information from supplier information data, and combining the information to be authenticated and the authenticated information into authentication information; and obtaining 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 quality and after-sale problems of the material.
And 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, according to the material substitution rule, the material data of the original material and the material data of each alternative substitute material respectively includes:
Accumulating weight values set by dimensions meeting screening conditions 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 the first dimension and the material data of any alternative substitute material in the first dimension meets the range of the alternative threshold value of the first dimension; the first dimension is each dimension in the material substitution rule, and the matching degree is determined based on an evaluation index in the corresponding dimension.
And setting a corresponding weight value for each dimension of the material substitution rules, wherein the weight value is used for reflecting the reference degree of the dimension in the process of screening the substituted materials. If the reference degree of a certain dimension in the material substitution rule is higher in the process of screening the substituted materials, a higher weight value is set. And the weighted value addition of all dimensions of the material substitution rule is 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 further noted that, the weight value of the dimension is set according to the material category, so as to automatically calculate the matching degree (percentage) of the alternative material, and provide one of the consideration conditions for the matching degree of the alternative material and the original material for the user.
And judging whether the accumulated result of the weight values exceeds a preset threshold value.
And if the accumulated result of the weight values exceeds the preset threshold value, taking the alternative substitute material corresponding to the accumulated result of the weight values as the substitute material of the original material.
For ease of understanding, specific examples are listed here as follows:
The material substitution rule of the original material comprises five dimensions, wherein the weight of each dimension is respectively 5% of the first dimension, 10% of the second dimension, 15% of the third dimension, 20% of the fourth dimension and 50% of the fifth dimension, when the first dimension data of the substitute material is matched with the first dimension data of the original material, the weight value of the first dimension is 5%, when the first dimension data of the substitute material is not matched with the first dimension data of the original material, the weight value of the first dimension is 0, and so on, the weight value of the second dimension data of the substitute material is not matched with the second dimension data of the original material, the weight value of the second dimension is 0, the weight value of the third dimension data of the substitute material is matched with the third dimension data of the original material, the weight value of the third dimension is 15%, the weight value of the fourth dimension data of the substitute material is matched with the fourth dimension data of the original material, the weight value of the fourth dimension is 20%, when the fifth dimension data of the substitute material is matched with the fifth dimension data of the original material, the weight value of the fifth dimension data of the substitute material is 50%, and all the weight values of the first dimension data of the fifth dimension data of the substitute material are 0, the weight value of the fourth dimension data is 20%, the weight value of the fourth dimension data is 20+the fourth dimension data is obtained, and the weight value of the fourth dimension data is 20+20+the fourth dimension data is the fourth, and the fourth dimension data is equal to the fourth dimension data, and the weight value of the fourth dimension data is 20+value is and the fourth value.
If the preset threshold value is 85%, namely, the substitute material with the weight value more than 85% can be used as the substitute material of the original material. The calculation shows that 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 of the original material, otherwise, if the weight value calculation result in the example is less than 85%, the substitute material in the example cannot be used as the substitute material of the original material. S104, taking the alternative substitute material meeting the requirement of the material substitution rule as the substitute material of the original material.
Optionally, after step S104, the method further includes:
and finishing all the substitute materials which can be used as the original materials, and pushing the substitute materials to a user.
Specifically, the substitute materials may be sorted and stored in a database, and the substitute material data in the data may be displayed on a visualization platform by means of open database interconnection (Open Database Connectivity, ODBC).
The embodiment discloses a screening method of alternative materials, which comprises the steps of determining material data of original materials; determining a corresponding material substitution rule of 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 an original material and an alternative substitute material in each dimension; according to the material substitution rules, matching the material data of the original material and the material data of each alternative substitute material respectively; and taking the alternative substitute material meeting the requirement of the material substitution rule as the substitute material of the original material. The invention screens the substitute materials with comprehensive reference dimensions, can obtain all substitute materials meeting the requirements of enterprises, is convenient for enterprises to select according to different conditions, and simultaneously avoids the loss of single reference quantity for screening the substitute materials to the enterprises.
Based on the above-mentioned screening method for the substitute material disclosed in the embodiment of the present invention, fig. 2 specifically discloses a screening device for the substitute material applying the screening method for the substitute material.
As shown in fig. 2, another embodiment of the present invention discloses a screening apparatus for alternative materials, which includes:
A first determining unit 201 for determining material data of an original material.
A second determining unit 202, configured to determine a material substitution rule corresponding to the original material, where the material substitution 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 an original material and an alternative substitute material in each dimension.
And the matching unit 203 is configured to match the material data of the original material and the material data of each alternative substitute material according to the material substitution rule.
And the replacing unit 204 is used for taking the alternative replacing material meeting the requirement of the replacing rule of the material as the replacing material of the original material.
Optionally, the screening device further includes:
The selecting unit is used for selecting dimensions for evaluating alternative substitute materials from various dimensions for evaluating the materials based on preset evaluation rules to form a material substitution dimension group;
The setting unit is used for setting the substitutable threshold range corresponding to the evaluation index in each dimension in the material substitution dimension group based on the evaluation index in each dimension in the material substitution dimension group, and obtaining 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 the dimension 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 the first dimension and the material data of any alternative substitute material in the first dimension meets the range of the alternative threshold value of the first dimension; the first dimension is each dimension in the material substitution rule, and the matching degree is determined based on an evaluation index in the corresponding dimension.
And the judging unit is used for judging whether the accumulated result of the weight values exceeds a preset threshold value.
And if the judging unit judges that the accumulated result of the weight values exceeds a preset threshold value, the replacing unit is used for taking the alternative substitute material corresponding to the accumulated result of the weight values as the substitute material of the original material.
Optionally, the first determining unit 201 includes:
The acquisition unit is used for acquiring attribute information and network information of the original materials, wherein the network information comprises: at least one of market reference price, authentication information and defect information or any combination thereof.
The arrangement unit is configured to arrange the attribute information and the network information to obtain theme data, where the theme data includes: 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-market product usage data.
The dividing unit is used for carrying out dimension division on the main body data to obtain material data of the original material.
The 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 device for the substitute materials disclosed in the above embodiment of the present invention may refer to the corresponding content in the screening method for the substitute materials disclosed in the above embodiment of the present invention, and will not be described herein.
In the screening device for substitute materials disclosed in this embodiment, a first determining unit determines material data of an original material; a second determining unit determines a corresponding material substitution rule of 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 an original material and an alternative substitute material in each dimension; the matching unit respectively matches the material data of the original material with the material data of each alternative substitute material according to the material substitution rules; the substitution unit uses the alternative substitution material meeting the requirement of the material substitution rule as the substitution material of the original material. The invention screens the substitute materials with comprehensive reference dimensions, can obtain all substitute materials meeting the requirements of enterprises, is convenient for enterprises to select according to different conditions, and simultaneously avoids the loss of single reference quantity for screening the substitute materials to the enterprises.
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 substituting unit and the like are all stored in the memory as program units, and the processor executes the program units stored in the memory to realize corresponding functions.
The processor includes a kernel, and the kernel fetches the corresponding program unit from the memory. The kernel can be provided with one or more than one, and the screening of the substitute materials is realized by adjusting kernel parameters.
The memory may include volatile memory, random Access Memory (RAM), and/or nonvolatile memory, such as Read Only Memory (ROM) or flash memory (flash RAM), among other forms in computer readable media, the memory including 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 instructions realize the screening method of the substitute materials when being executed by a processor.
The embodiment of the invention provides a processor which is used for running a program, wherein the program runs to execute the screening method of the substitute materials.
The embodiment of the invention provides equipment, wherein 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, wherein the processor executes the program to realize the following steps:
Material data of the original material is determined.
Determining a corresponding material substitution rule of 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 an original material and an alternative substitute material in 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 taking the alternative substitute material meeting the requirement of the material substitution rule as the substitute material of the original material.
Optionally, the process for establishing the material substitution rule includes:
And selecting dimensions for evaluating the alternative substitute materials from various dimensions for evaluating the materials based on a preset evaluation rule to form a material substitute dimension group.
And setting a replaceable threshold range corresponding to the evaluation index in each dimension in the material substitution dimension group based on the evaluation index in each dimension in the material substitution dimension group, and obtaining a material substitution rule corresponding to the material.
Optionally, the matching, according to the material substitution rule, the material data of the original material and the material data of each alternative substitute material respectively includes:
Accumulating weight values set by dimensions meeting screening conditions 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 the first dimension and the material data of any alternative substitute material in the first dimension meets the range of the alternative threshold value of the first dimension; the first dimension is each dimension in the material substitution rule, and the matching degree is determined based on an evaluation index in the corresponding dimension.
And judging whether the accumulated result of the weight values exceeds a preset threshold value.
And if the accumulated result of the weight values exceeds the preset threshold value, taking the alternative substitute material corresponding to the accumulated result of the weight values as the substitute material of the original material.
Optionally, the determining the material data of the original material includes:
Collecting attribute information and network information of an original material, wherein the network information comprises: at least one of market reference price, authentication information and defect information or any combination thereof.
And finishing the attribute information and the network information to obtain theme data, wherein the theme data comprises: purchase order data, purchase contract data, vendor 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 after-market product usage data.
And carrying out dimension division on the subject data to obtain material data of the original material.
The invention also provides a computer program product adapted to perform, when executed on a screening device for replacement material, a program initialized with the method steps of:
Material data of the original material is determined.
Determining a corresponding material substitution rule of 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 an original material and an alternative substitute material in 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 taking the alternative substitute material meeting the requirement of the material substitution rule as the substitute material of the original material.
Optionally, the process for establishing the material substitution rule includes:
And selecting dimensions for evaluating the alternative substitute materials from various dimensions for evaluating the materials based on a preset evaluation rule to form a material substitute dimension group.
And setting a replaceable threshold range corresponding to the evaluation index in each dimension in the material substitution dimension group based on the evaluation index in each dimension in the material substitution dimension group, and obtaining a material substitution rule corresponding to the material.
Optionally, the matching, according to the material substitution rule, the material data of the original material and the material data of each alternative substitute material respectively includes:
Accumulating weight values set by dimensions meeting screening conditions 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 the first dimension and the material data of any alternative substitute material in the first dimension meets the range of the alternative threshold value of the first dimension; the first dimension is each dimension in the material substitution rule, and the matching degree is determined based on an evaluation index in the corresponding dimension.
And judging whether the accumulated result of the weight values exceeds a preset threshold value.
And if the accumulated result of the weight values exceeds the preset threshold value, taking the alternative substitute material corresponding to the accumulated result of the weight values as the substitute material of the original material.
Optionally, the determining the material data of the original material includes:
Collecting attribute information and network information of an original material, wherein the network information comprises: at least one of market reference price, authentication information and defect information or any combination thereof.
And finishing the attribute information and the network information to obtain theme data, wherein the theme data comprises: purchase order data, purchase contract data, vendor 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 after-market product usage data.
And carrying out dimension division on the subject data to obtain material data of the original material.
It will be apparent to those skilled in the art that 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 flowchart illustrations and/or block diagrams, and combinations of flows and/or blocks in the flowchart illustrations 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 one typical configuration, a computing device includes one or more processors (CPUs), input/output interfaces, network interfaces, and memory.
The memory may include volatile memory in a computer-readable medium, random Access Memory (RAM) and/or nonvolatile memory, etc., such as Read Only Memory (ROM) or flash RAM. 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 storage media for a computer 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, which can be used to store information that can be accessed by a computing device. Computer-readable media, as defined herein, does not include transitory computer-readable media (transmission media), such as modulated data signals and carrier waves.
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 one … …" does not exclude the presence of other like elements in a process, method, article, or apparatus that comprises an element.
It will be appreciated by those skilled in the art that 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 foregoing is merely exemplary of the present application and is not intended to limit the present application. Various modifications and variations of the present application will be apparent to those skilled in the art. Any modification, equivalent replacement, improvement, etc. which come within the spirit and principles of the application are to be included in the scope of the claims of the present application.

Claims (6)

1. A method of screening a surrogate material comprising:
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;
Cleaning the attribute information and the network information, wherein the cleaning mode comprises conversion, mapping and filtering modes;
Structuring the cleaned 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-market product use data;
performing dimension division on the subject data to obtain material data of an original material;
Determining a corresponding material substitution rule of 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 an original material and an alternative substitute material in each dimension;
according to the material substitution rules, matching the material data of the original material and the material data of each alternative substitute material respectively;
taking the alternative substitute materials meeting the requirement of the material substitution rule as substitute materials of the original materials;
the process for establishing the material substitution rule comprises the following steps:
Selecting dimensions for evaluating alternative substitute materials from various dimensions for evaluating materials based on preset evaluation rules to form a material substitute dimension group;
And setting a replaceable threshold range corresponding to the evaluation index in each dimension in the material substitution dimension group based on the evaluation index in each dimension in the material substitution dimension group, and obtaining a material substitution rule corresponding to the material, wherein the process of establishing the corresponding relation between the category of the material and all the corresponding dimensions of the material is to establish a material model according to a preset dimension, and the subject data is input into the material model.
2. The screening method according to claim 1, wherein the matching the material data of the original material and the material data of each alternative substitute material according to the material substitution rule, respectively, includes:
Accumulating weight values set by dimensions meeting screening conditions 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 the first dimension and the material data of any alternative substitute material in the first dimension meets the range of the alternative threshold value of the first dimension; the first dimension is each dimension in the material substitution rule, and the matching degree is determined based on an evaluation index under the corresponding dimension;
judging whether the accumulated result of the weight values exceeds a preset threshold value or not;
And if the accumulated result of the weight values exceeds the preset threshold value, taking the alternative substitute material corresponding to the accumulated result of the weight values as the substitute material of the original material.
3. A screening apparatus for substitute materials, comprising:
the first determining unit is used for determining material data of the original material;
A second determining unit, configured to determine a material substitution rule corresponding to the original material, where the material substitution 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 an original material and an alternative substitute material in 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 rules;
The replacing unit is used for taking the alternative replacing material meeting the requirement of the material replacing rule as the replacing material of the original material;
The first determination unit includes:
The acquisition unit is used for acquiring attribute information and network information of the original materials, wherein the network information comprises: at least one or any combination of three information of market reference price, authentication information and defect information;
the sorting unit is used for cleaning the attribute information and the network information, and the cleaning modes comprise conversion, mapping and filtering modes; structuring the cleaned 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-market product use data;
The dividing unit is used for dimensionally dividing the theme data to obtain material data of the original material;
The selecting unit is used for selecting dimensions for evaluating alternative substitute materials from various dimensions for evaluating the materials based on preset evaluation rules to form a material substitution dimension group;
The setting unit is used for setting a replaceable threshold range corresponding to the evaluation index in each dimension in the material substitution dimension group based on the evaluation index in each dimension in the material substitution dimension group, and obtaining a material substitution rule corresponding to the material, wherein the process of establishing the corresponding relation between the category of the material and all the corresponding dimensions is that a material model is established according to preset dimensions, and the subject data is input into the material model.
4. A screening apparatus according to claim 3, wherein the matching unit comprises:
The calculating unit is used for accumulating weight values set by the dimension 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 the first dimension and the material data of any alternative substitute material in the first dimension meets the range of the alternative threshold value of the first dimension; the first dimension is each dimension in the material substitution rule, and the matching degree is determined based on an evaluation index under the corresponding dimension;
the judging unit is used for judging whether the accumulated result of the weight values exceeds a preset threshold value;
and if the judging unit judges that the accumulated result of the weight values exceeds a preset threshold value, the replacing unit is used for taking the alternative replacing material corresponding to the accumulated result of the weight values as the replacing material of the original material.
5. A storage medium storing a program which, when executed, is adapted to carry out the screening method of any one of claims 1-2.
6. A processor configured to execute a program, wherein the program is configured to, when executed, perform: a screening method according to any one of claims 1-2.
CN201811139155.8A 2018-09-28 2018-09-28 Screening method of substitute materials and related device Active CN110969379B (en)

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 CN110969379A (en) 2020-04-07
CN110969379B true 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)

Families Citing this family (2)

* Cited by examiner, † Cited by third party
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 (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
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
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

Family Cites Families (2)

* Cited by examiner, † Cited by third party
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
US20140304104A1 (en) * 2013-04-08 2014-10-09 Amazon Technologies, Inc. Identifying part interchanges at electronic marketplaces

Patent Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
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
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

Also Published As

Publication number Publication date
CN110969379A (en) 2020-04-07

Similar Documents

Publication Publication Date Title
CN107563757B (en) Data risk identification method and device
CN101334787B (en) Objects evaluation information enquiry system and method
CN104951465B (en) Application recommendation method and device
CN105184618A (en) Commodity individual recommendation method for new users and system
Sanjuan et al. Measuring and improving eco‐efficiency using data envelopment analysis: A case study of Mahón‐Menorca cheese
CN104731816A (en) Method and device for processing abnormal business data
CN106485566A (en) A kind of information recommendation method and device
CN110969379B (en) Screening method of substitute materials and related device
CN104111938A (en) Information recommendation method and device
CN106127521A (en) A kind of information processing method and data handling system
CN107481058A (en) A kind of Products Show method and Products Show device
CN111242430A (en) Power equipment supplier evaluation method and device
CN110782139A (en) Daily yield daily clearing accounting method, device, equipment and storage medium based on block chain
CN111626767A (en) Resource data distribution method, device and equipment
CN109344173B (en) Data management method and device and data structure
CN117196646A (en) Supplier qualification auditing method, equipment and medium
CN111242425A (en) Power data processing method and device
CN116542747A (en) Product recommendation method and device, storage medium and electronic equipment
Nabin et al. On the relationship between technology transfer and economic growth in Asian economies
CN110969400A (en) Supply chain upstream and downstream data association method and device
CN112182429A (en) New customer product and service recommendation method and system based on position information
CN112650864A (en) Data processing method and device, electronic equipment and storage medium
JP2017200079A (en) Computing for outputting distrust index of user by acquiring telephone number of user declared from portable terminal through internet
CN112580915A (en) Project milestone determination method and device, storage medium and electronic equipment
CN113888322B (en) Credit evaluation method, system, storage medium and electronic equipment

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