CN117010925B - Automatic pricing method, system, equipment and storage medium for engineering materials - Google Patents

Automatic pricing method, system, equipment and storage medium for engineering materials Download PDF

Info

Publication number
CN117010925B
CN117010925B CN202310749355.XA CN202310749355A CN117010925B CN 117010925 B CN117010925 B CN 117010925B CN 202310749355 A CN202310749355 A CN 202310749355A CN 117010925 B CN117010925 B CN 117010925B
Authority
CN
China
Prior art keywords
data
engineering
specification characteristic
characteristic information
matching
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
CN202310749355.XA
Other languages
Chinese (zh)
Other versions
CN117010925A (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.)
Guangdong Zhongzhou Guoxin Construction Management Consulting Co ltd
Original Assignee
Guangdong Zhongzhou Guoxin Construction Management Consulting 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 Guangdong Zhongzhou Guoxin Construction Management Consulting Co ltd filed Critical Guangdong Zhongzhou Guoxin Construction Management Consulting Co ltd
Priority to CN202310749355.XA priority Critical patent/CN117010925B/en
Publication of CN117010925A publication Critical patent/CN117010925A/en
Application granted granted Critical
Publication of CN117010925B publication Critical patent/CN117010925B/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
    • G06Q30/00—Commerce
    • G06Q30/02—Marketing; Price estimation or determination; Fundraising
    • G06Q30/0201—Market modelling; Market analysis; Collecting market data
    • G06Q30/0206—Price or cost determination based on market factors
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F18/00—Pattern recognition
    • G06F18/20—Analysing
    • G06F18/22—Matching criteria, e.g. proximity measures
    • 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
    • G06Q30/00—Commerce
    • G06Q30/02—Marketing; Price estimation or determination; Fundraising
    • G06Q30/0283—Price estimation or determination
    • 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
    • G06Q50/00—Systems or methods specially adapted for specific business sectors, e.g. utilities or tourism
    • G06Q50/08—Construction

Abstract

The invention relates to the technical field of data analysis in the construction industry, in particular to an automatic proportioning method, system, equipment and storage medium for engineering materials, wherein the automatic proportioning method for engineering materials comprises the steps of obtaining material data to be proportioning of engineering material data, identifying the material data to be proportioning, and obtaining material source data of the material to be proportioning and standard type data for identifying the attribute of the material source data; identifying material source data with the same attribute based on the standard data, and forming a material data column by using the material source data with one attribute and storing the material data column; extracting material specification characteristic information according to a material data column, wherein the material specification characteristic information comprises a key specification characteristic information number and a common specification characteristic information number; and inputting the material data column into a preset engineering material price database for matching based on the material specification characteristic information to obtain the engineering material price information. The method has the effects of rapidly completing the price matching of the engineering materials and reducing the influence of the price matching of the engineering materials on the progress of the engineering projects.

Description

Automatic pricing method, system, equipment and storage medium for engineering materials
Technical Field
The invention relates to the technical field of data analysis in the construction industry, in particular to an automatic pricing method, system, equipment and storage medium for engineering materials.
Background
In construction projects at home and abroad, the construction material cost accounts for a large proportion of the construction cost, so the material cost is the main cost for constructing the project cost. The price allocation cost control of the engineering material price is one of the key points and difficulties in the work of the cost control department.
Currently, the approach to obtain material prices is to query information prices issued by government authorities, market queries, and to obtain empirical data through communication and communication with experienced engineers. However, since engineering materials are of various types and price information corresponding to each type of materials is scattered, the price matching process of engineering materials is extremely complicated for manufacturing personnel, and further the cost of the price matching cost of engineering materials in the construction industry is further increased, the cost calculation time of engineering projects is further increased, and the progress of the engineering projects is influenced, so that a certain improvement space exists.
Disclosure of Invention
In order to realize rapid completion of engineering material allocation, the influence of the engineering material allocation on the progress of engineering projects is effectively reduced, and the application provides an automatic engineering material allocation method, system, equipment and storage medium.
The first object of the present invention is achieved by the following technical solutions:
an automatic pricing method for engineering materials, comprising the following steps:
acquiring material data to be weighted of engineering material data, identifying the material data to be weighted, and acquiring material source data of the material to be weighted and standard type data for marking the material source data attribute;
identifying material source data with the same attribute based on the standard data, and forming and storing the material source data with the same attribute into a material data column;
extracting material specification characteristic information according to the material data column, wherein the material specification characteristic information comprises key specification characteristic information number and common specification characteristic information number;
and inputting the material data column into a preset engineering material price database for matching based on the material specification characteristic information to obtain the engineering material price information.
By adopting the technical scheme, before the engineering materials are subjected to price matching, all engineering materials in the construction engineering are arranged into engineering material data, the engineering materials to be subjected to price matching are arranged into the material data to be subjected to price matching in the engineering material data, the material source data of the material to be subjected to price matching and the standard type data for identifying the attribute of the material source data are obtained through identification of the material data to be subjected to price matching, each material source data corresponds to one standard type data, the material source data with the same attribute are subjected to data arrangement by utilizing the standard type data to obtain a material data column, and the material data column is stored in an engineering material price matching system, so that the subsequent material data to be subjected to price matching is convenient to read, the reading efficiency of the material to be subjected to price matching is improved, the material specification characteristic information of the material to be subjected to price matching is obtained, the material data column is matched with an engineering material price database according to the material specification characteristic information of the material to be subjected to price matching, the construction material price matching is obtained, the construction price matching function of the engineering material is realized, and further, the construction price matching of the engineering material can be subjected to price matching is completed rapidly, and the effect of the engineering material price matching on the engineering material is effectively reduced.
The present application may be further configured in a preferred example to: after identifying the material source data with the same attribute based on the standard data, forming and storing the material source data with the one attribute into a material data column, the automatic pricing method for the engineering material further comprises the following steps:
copying the standard class data from the material data column to form a standard class data copy;
and establishing a data structure based on the B+ tree based on the standard class data copy.
By adopting the technical scheme, the standard type data is copied from the material data column and stored in the memory system to form the standard type data copy, so that the efficiency of data retrieval of the material data is improved, after the loading of the standard type data copy is finished, a data structure based on a B+ tree is established based on the standard type data copy, and the method has the characteristics of small storage depth and high searching efficiency, and meanwhile, the I/O times of a hard disk or a memory during the inquiry can be reduced, so that the function of efficiently searching engineering material data by using the standard type data is realized.
The present application may be further configured in a preferred example to: inputting the material data column into a preset engineering material price database for matching based on the material specification characteristic information to obtain engineering material price information, wherein the method specifically comprises the following steps of:
calculating the specification characteristic matching rate of the engineering material according to the material specification characteristic information;
and constructing a mapping relation between the material data column and price data in a preset engineering material price database based on the engineering material specification characteristic matching rate, and obtaining the engineering material price information.
By adopting the technical scheme, the specification characteristic matching rate of the engineering materials is calculated by analyzing and counting the specification characteristic information of the materials, the prices of the engineering materials are quickly matched in a preset engineering material price database by utilizing the specification characteristic matching rate of the engineering materials, and the mapping relation between the engineering materials and the price data is established, so that the cost personnel in the engineering are facilitated, each engineering material and the corresponding price of the engineering materials can be clearly known, and the price matching of the engineering materials can be quickly completed.
The present application may be further configured in a preferred example to: the calculating the engineering material specification characteristic matching rate according to the material specification characteristic information specifically comprises the following steps:
calculating the matching number of common specification features and the matching number of key specification features in the material specification feature information;
and calculating the specification characteristic matching rate of the engineering material according to the following formula based on the common specification characteristic matching number, the key specification characteristic matching number and the material specification characteristic information:
wherein P is engineering material specification characteristic matching rate, M is common specification characteristic matching number, N is key specification characteristic matching number, M is common specification characteristic information number, N is key specification characteristic information number, and k is preset material specification characteristic weight value.
By adopting the technical scheme, the key specification feature matching number and the common specification feature matching number of the engineering material are obtained by analyzing the material specification feature information, the material identification of the engineering material to be subjected to price matching can be more accurate by utilizing the key specification feature matching number and the common specification feature matching number, the phenomenon that the engineering material is not matched with price data can be effectively prevented, the specification feature matching rate of the engineering material is calculated according to the key specification feature matching number, the common specification feature matching number and the material specification feature information of the engineering material, and the matching accuracy of the engineering material and the price data can be improved by utilizing the specification feature matching rate of the engineering material in the price matching of the engineering material.
The present application may be further configured in a preferred example to: after the material data columns are input into a preset engineering material price database for matching based on the material specification characteristic information to obtain engineering material price information, the automatic engineering material price matching method further comprises the following steps:
acquiring engineering material change data, wherein the engineering material change data comprises material update data and material addition data, and performing data change processing on a material data column based on the material update data;
and acquiring material adding source data and standard class adding data for identifying the attribute of the material adding source data based on the material adding data, and adding the material adding source data to a corresponding material data column according to the standard class adding data.
By adopting the technical scheme, along with the progress of construction engineering, the situation that engineering materials can be correspondingly increased or changed is achieved, engineering material change data are obtained in real time, when engineering materials are changed in the construction engineering, the engineering material change data are material update data, material data columns are updated according to the material update data, when new engineering materials are added in the construction engineering, the engineering material change data are material increase data, the material increase data are identified, standard type increase data for obtaining material increase source data and standard type increase data for identifying the attribute of the material increase source data are obtained, the material increase source data are added into the corresponding material data columns by the standard type increase data to be stored, and the function of the new engineering material data is achieved.
The present application may be further configured in a preferred example to: the data change processing for the material data column based on the material update data specifically includes:
acquiring material update source data and standard type update data for identifying the attribute of the material update source data based on the material update data; and identifying a corresponding material data column according to the standard type updating data, and inputting the material updating source data into the material data column to replace the corresponding material source data.
By adopting the technical scheme, when the acquired engineering material change data is material update data, the material update data is identified, the material update source data and standard update data for identifying the attribute of the material update source data are obtained, the material data column to be updated is identified by utilizing the standard update data, the material update source data is input into the material data column to be updated, the corresponding material source data in the material data column is replaced, and the updating function of the engineering material data is completed.
The second object of the present invention is achieved by the following technical solutions:
an automatic engineering material proportioning device, the automatic engineering material proportioning device comprising:
the engineering material analysis module is used for acquiring material data to be priced of engineering material data, identifying the material data to be priced, and acquiring material source data of the material to be priced and standard type data for marking the material source data attribute;
the material data column construction module is used for identifying material source data with the same attribute based on the standard data, and forming and storing the material data column by using the material source data with the same attribute;
the material specification characteristic acquisition module is used for extracting material specification characteristic information according to the material data array, wherein the material specification characteristic information comprises a key specification characteristic information number and a common specification characteristic information number;
and the engineering material price matching module is used for inputting the material data column into a preset engineering material price database for matching based on the material specification characteristic information to obtain engineering material price matching information.
By adopting the technical scheme, before the engineering materials are subjected to price matching, all engineering materials in the construction engineering are arranged into engineering material data, the engineering materials to be subjected to price matching are arranged into the material data to be subjected to price matching in the engineering material data, the material source data of the material to be subjected to price matching and the standard type data for identifying the attribute of the material source data are obtained through identification of the material data to be subjected to price matching, each material source data corresponds to one standard type data, the material source data with the same attribute are subjected to data arrangement by utilizing the standard type data to obtain a material data column, and the material data column is stored in an engineering material price matching system, so that the subsequent material data to be subjected to price matching is convenient to read, the reading efficiency of the material to be subjected to price matching is improved, the material specification characteristic information of the material to be subjected to price matching is obtained, the material data column is matched with an engineering material price database according to the material specification characteristic information of the material to be subjected to price matching, the construction material price matching is obtained, the construction price matching function of the engineering material is realized, and further, the construction price matching of the engineering material can be subjected to price matching is completed rapidly, and the effect of the engineering material price matching on the engineering material is effectively reduced.
The third object of the present application is achieved by the following technical solutions:
a computer device comprising a memory, a processor and a computer program stored in the memory and executable on the processor, the processor implementing the steps of a method for automatic pricing of engineering materials as described above when the computer program is executed.
The fourth object of the present application is achieved by the following technical solutions:
a computer readable storage medium storing a computer program which when executed by a processor performs the steps of a method for automatic pricing of engineering materials as described above.
In summary, the present application includes at least one of the following beneficial technical effects:
1. the method comprises the steps of identifying material source data of a material to be matched and standard type data for identifying material source data attributes, wherein each material source data corresponds to one standard type data, using the standard type data to conduct data arrangement on the material source data with the same attribute to obtain a material data column, storing the material data column in an engineering material matching system, facilitating subsequent reading of the material data to be matched, improving reading efficiency of the material to be matched, analyzing the material data column to obtain material specification characteristic information of the material to be matched, matching the material data column with an engineering material price database according to the material specification characteristic information of the material to be matched to obtain engineering material matching information, achieving automatic matching of engineering materials, and further achieving rapid completion of engineering material matching in construction engineering, and effectively reducing influences of engineering material matching on engineering project progress; 2. the method has the advantages that a standard class data is copied from a material data column and stored in a memory system to form a standard class data copy, so that the efficiency of data retrieval of the material data is improved, after the standard class data copy is loaded, a data structure based on a B+ tree is built based on the standard class data copy, the method has the characteristics of small storage depth and high searching efficiency, and meanwhile, the I/O times of a hard disk or a memory during inquiry can be reduced, so that the function of efficiently searching engineering material data by using the standard class data is realized;
3. the key specification feature matching number and the common specification feature matching number of the engineering material are obtained by analyzing the material specification feature information, the material identification of the engineering material to be subjected to price matching can be more accurate by utilizing the key specification feature matching number and the common specification feature matching number, the phenomenon that the engineering material is not matched with price data can be effectively prevented, the specification feature matching rate of the engineering material is calculated according to the key specification feature matching number, the common specification feature matching number and the material specification feature information of the engineering material, and the matching accuracy of the engineering material and the price data can be improved by utilizing the specification feature matching rate of the engineering material in the price matching of the engineering material;
4. with the progress of construction engineering, the situation that the engineering material can be correspondingly increased or changed is achieved through acquiring engineering material change data in real time, when engineering material is changed in the construction engineering, the engineering material change data are material update data, material data columns are updated according to the material update data, when new engineering material is added in the construction engineering, the engineering material change data are material increase data, the material increase data are identified, standard type increase data for obtaining material increase source data and marking material increase source data attributes are obtained, the standard type increase data are utilized to add the material increase source data into the corresponding material data columns for storage, and the function of the new engineering material data is achieved.
Drawings
FIG. 1 is a flow chart of an automatic pricing method for engineering materials according to one embodiment of the present application;
FIG. 2 is another flow chart of an automatic pricing method for engineering materials according to one embodiment of the present application;
FIG. 3 is a flowchart illustrating an implementation of step S40 in an automatic pricing method for engineering materials according to an embodiment of the present application;
FIG. 4 is a flowchart showing an implementation of step S41 in an automatic pricing method for engineering materials according to an embodiment of the present application;
FIG. 5 is another flow chart of an automatic pricing method for engineering materials according to one embodiment of the present application;
FIG. 6 is a flowchart illustrating an implementation of step S50 in an automatic pricing method for engineering materials according to an embodiment of the present application;
FIG. 7 is a schematic block diagram of an automatic pricing system for engineering materials according to one embodiment of the present application;
FIG. 8 is a schematic diagram of a computer device in an embodiment of the present application.
Detailed Description
The present application is described in further detail below with reference to the accompanying drawings.
In one embodiment, as shown in fig. 1, the application discloses an automatic pricing method for engineering materials, which specifically includes the following steps:
s10: and acquiring material source data of the material to be weighted and standard type data for identifying the material source data attribute.
In this embodiment, the material data to be priced refers to engineering material data to be priced for matching, the material source data refers to data obtained by decomposing the material data to be priced, and the standard type data refers to data for describing the material source data, which is mainly used for describing attribute information of the material source data so as to be used for identifying storage location information of the material source data.
Specifically, in each construction project, a large number of different engineering materials are involved, and the variety is various, the engineering material data to be subjected to price matching is decomposed, so that material source data of the engineering materials and standard type data for identifying the attribute of the material source data are obtained, and each material source data corresponds to one standard type data.
For example, one piece of engineering material data to be price-matched is "a manufacturer of material name a is B, an average price of material a is C, a highest price is D, and a lowest price is E", and the material data to be price-matched can be decomposed into a plurality of material source data such as "material name", "manufacturer", "highest price", "lowest price", "average price", and the like, and corresponding standard class data such as "a (material name)", "B (manufacturer)", "C (average price)", "D (highest price)", and "E (lowest price") are generated from each material source data.
S20: and identifying material source data with the same attribute based on the standard data, and forming and storing the material source data with the same attribute into a material data column.
Specifically, a material data column is formed based on each material source data and the corresponding label data, for example, a certain material data column is: and (3) storing all material source data with the type of 'material name' in a material data column, wherein the material data column comprises the material name of each engineering material in all material data to be priced, and similarly, storing all material source data with the type of 'manufacturer' in a column B.
S30: and extracting material specification characteristic information according to the material data column, wherein the material specification characteristic information comprises a key specification characteristic information number and a common specification characteristic information number.
Specifically, through analyzing the data in the material data array, the material specification characteristic information corresponding to each engineering material can be extracted, wherein the material specification characteristic information comprises a key specification characteristic information number and a common specification characteristic information number, the key specification characteristic information number is the key characteristic and the characteristic number which can represent the engineering material, the common specification characteristic information number is the common characteristic and the number of the engineering material except the key characteristic, for example, the identified engineering material is an engineering cable, the characteristics of the nominal section, the core number, the rated voltage, the model, the cable section radius and the like of the engineering cable belong to the key specification characteristic information number, and the manufacturer, the insulating material, the sheath material and the like of the engineering electric cable are the common specification characteristic information number, so that more accurate price matching can be conveniently carried out by combining the key specification characteristic information and the common specification characteristic information of the engineering material when the engineering material is subjected to price matching.
S40: and inputting the material data column into a preset engineering material price database for matching based on the material specification characteristic information to obtain the engineering material price information.
Specifically, according to the material specification characteristic information of the material to be matched, the material data array is matched with the engineering material price database to obtain engineering material matching information, so that the automatic matching function of the engineering material is realized, further, in construction engineering, the rapid matching of the engineering material can be realized, and the influence of the matching of the engineering material on the progress of engineering projects is effectively reduced.
In this embodiment, before the construction materials are allocated, all the construction materials in the construction project are arranged into engineering material data, the engineering materials to be allocated in the engineering material data are arranged into material data to be allocated, the material source data of the material to be allocated and the standard type data for identifying the attribute of the material source data are obtained by identifying the material data to be allocated, each material source data corresponds to one standard type data, the material source data with the same attribute are arranged by utilizing the standard type data to obtain material data columns, and the material data columns are stored in the engineering material allocation system, so that the subsequent material data to be allocated can be conveniently read, the reading efficiency of the material to be allocated is improved, the material specification characteristic information of the material to be allocated is obtained by analyzing the material data columns, the material data columns are matched with the engineering material price database according to the material specification characteristic information of the material to be allocated, the material allocation information of the engineering material to be allocated is obtained, and further in the construction project construction, the construction and construction material allocation functions can be completed rapidly, and the influence of the engineering material allocation on the project progress is effectively reduced.
In one embodiment, as shown in fig. 2, after step S20, that is, after identifying material source data of a same attribute based on the label data, the material source data of a same attribute is formed into a material data column and stored, the automatic pricing method for engineering materials further includes:
s201: the tag data is copied from the column of material data to form a copy of the tag data.
Specifically, a copy of the standard class data is copied from each material data column, the copied standard class data is summarized to form a standard class data copy, the standard class data copy is stored in a hard disk, and a copy of the read-only standard class data copy is copied and stored in a memory, so that the efficiency of subsequent retrieval of the material data to be matched is improved.
S202: and establishing a data structure based on the B+ tree based on the standard class data copy.
Specifically, a data structure based on a B+ tree is established according to standard data copies formed by summarizing standard data of a plurality of material data columns, the data structure of the B+ tree has the characteristics of small storage depth and high searching efficiency, and meanwhile, the I/O times of a hard disk or a memory when inquiring the material data to be matched can be reduced, so that the function of efficiently searching the engineering material data to be matched by using the standard data is realized.
In one embodiment, as shown in fig. 3, in step S40, that is, based on the material specification characteristic information, the material data sequence is input into a preset engineering material price database for matching, so as to obtain engineering material price matching information, which specifically includes:
s41: and calculating the engineering material specification characteristic matching rate according to the material specification characteristic information.
S42: and constructing a mapping relation between the material data column and price data in a preset engineering material price database based on the engineering material specification characteristic matching rate, and obtaining the engineering material price information.
Specifically, the specification characteristic matching rate of the engineering material is calculated by analyzing and counting the specification characteristic information of the material, the price of the engineering material is quickly matched in a preset engineering material price database by utilizing the specification characteristic matching rate of the engineering material, and the mapping relation between the engineering material and the price data is established, so that the cost personnel in the engineering can clearly know the price of each engineering material and the corresponding engineering material, and the price of the engineering material can be quickly completed.
In one embodiment, as shown in fig. 4, in step S41, the calculating the engineering material specification feature matching rate according to the material specification feature information specifically includes:
s411: and calculating the matching number of the common specification features and the matching number of the key specification features in the material specification feature information.
Specifically, by analyzing the material specification characteristic information, the key specification characteristic matching number and the common specification characteristic matching number of the engineering material are obtained, and the material identification of the engineering material to be subjected to price matching can be more accurate by utilizing the key specification characteristic matching number and the common specification characteristic matching number, so that the phenomenon that the engineering material is not matched with price data can be effectively prevented.
S412: and calculating the specification characteristic matching rate of the engineering material according to the following formula based on the common specification characteristic matching number, the key specification characteristic matching number and the material specification characteristic information:
wherein P is engineering material specification characteristic matching rate, M is common specification characteristic matching number, N is key specification characteristic matching number, M is common specification characteristic information number, N is key specification characteristic information number, and k is preset material specification characteristic weight value.
Specifically, the specification characteristic matching rate of the engineering material is calculated according to the key specification characteristic matching number, the common specification characteristic matching number and the material specification characteristic information of the engineering material, so that in the process of proportioning the engineering material, the matching accuracy of the engineering material and the price data can be improved by utilizing the specification characteristic matching rate of the engineering material.
In one embodiment, as shown in fig. 5, after step S40, the automatic pricing method for engineering materials further includes:
s50: and acquiring engineering material change data, wherein the engineering material change data comprises material update data and material addition data, and performing data change processing on a material data column based on the material update data.
In this embodiment, the engineering material change data refers to data after the engineering material data to be allocated changes, the material update data refers to data after the engineering material characteristics to be allocated changes, and the material addition data refers to newly added engineering material data.
Specifically, as the construction engineering proceeds, the engineering materials are correspondingly increased or changed, and when the engineering materials are changed in the construction engineering, the engineering material change data are material update data, and the material data columns are updated according to the material update data.
S60: and acquiring material adding source data and standard class adding data for identifying the attribute of the material adding source data based on the material adding data, and adding the material adding source data to a corresponding material data column according to the standard class adding data.
Specifically, when a new process material is added in the construction engineering, the engineering material change data are material addition data, the material addition data are identified, standard type addition data of material addition source data and mark material addition source data attributes are obtained, and the standard type addition data are used for adding the material addition source data into a corresponding material data column for storage, so that a new engineering material data function is realized.
In one embodiment, as shown in fig. 6, in step S50, the data modification process is performed on the material data sequence based on the material update data, which specifically includes:
s51: and acquiring material update source data and standard type update data for identifying the attribute of the material update source data based on the material update data.
S52: and identifying a corresponding material data column according to the standard type updating data, and inputting the material updating source data into the material data column to replace the corresponding material source data.
Specifically, when the obtained engineering material change data is material update data, the material update data is identified, so as to obtain material update source data and standard update data for identifying the attribute of the material update source data, a material data column to be updated is identified by using the standard update data, the material update source data is input into the material data column to be updated, and the corresponding material source data in the material data column is replaced, so that the updating function of the engineering material data is completed.
It should be understood that the sequence number of each step in the foregoing embodiment does not mean that the execution sequence of each process should be determined by the function and the internal logic of each process, and should not limit the implementation process of the embodiment of the present application in any way.
In an embodiment, an automatic engineering material pricing device is provided, and the automatic engineering material pricing device corresponds to the automatic engineering material pricing method in the embodiment one by one. As shown in fig. 7, the automatic engineering material pricing device comprises an engineering material analysis module, a material data column construction module, a material specification characteristic acquisition module and an engineering material pricing module. The functional modules are described in detail as follows:
the engineering material analysis module is used for acquiring material data to be priced of engineering material data, identifying the material data to be priced, and acquiring material source data of the material to be priced and standard type data for marking the material source data attribute;
the material data column construction module is used for identifying material source data with the same attribute based on the standard data, and forming and storing the material data column by using the material source data with the same attribute;
the material specification characteristic acquisition module is used for extracting material specification characteristic information according to the material data array, wherein the material specification characteristic information comprises a key specification characteristic information number and a common specification characteristic information number;
and the engineering material price matching module is used for inputting the material data column into a preset engineering material price database for matching based on the material specification characteristic information to obtain engineering material price matching information.
Preferably, after identifying the material source data of the same attribute based on the label data, the forming and storing the material source data of the same attribute into a material data column further includes:
and the standard class data copy module is used for copying standard class data from the material data column to form a standard class data copy.
And the data tree construction module is used for establishing a data structure based on the B+ tree based on the standard class data copy.
Preferably, the engineering material pricing module includes:
and the engineering material specification characteristic matching rate submodule is used for calculating engineering material specification characteristic matching rate according to the material specification characteristic information and constructing a mapping relation between the material data column and price data in a preset engineering material price database based on the engineering material specification characteristic matching rate.
Preferably, the engineering material specification characteristic matching rate submodule includes:
the matching rate calculation sub-module is used for calculating the matching number of the common specification features and the matching number of the key specification features in the material specification feature information;
and calculating the specification characteristic matching rate of the engineering material according to the following formula based on the common specification characteristic matching number, the key specification characteristic matching number and the material specification characteristic information:
wherein P is engineering material specification characteristic matching rate, M is common specification characteristic matching number, N is key specification characteristic matching number, M is common specification characteristic information number, N is key specification characteristic information number, and k is preset material specification characteristic weight value.
Preferably, after inputting the material data column into a preset engineering material price database for matching based on the material specification characteristic information, the method further includes:
and the engineering material data changing module is used for acquiring engineering material changing data, wherein the engineering material changing data comprises material updating data and material adding data, and data changing processing is carried out on a material data column based on the material updating data.
And the engineering material data new adding module is used for acquiring material adding source data and standard type adding data for identifying the attribute of the material adding source data based on the material adding data, and adding the material adding source data to the corresponding material data column according to the standard type adding data.
Preferably, the engineering material data changing module includes:
the engineering material data updating sub-module is used for acquiring material updating source data and standard type updating data for identifying the attribute of the material updating source data based on the material updating data; and identifying a corresponding material data column according to the standard type updating data, and inputting the material updating source data into the material data column to replace the corresponding material source data.
The specific limitation of the automatic proportioning device for engineering materials can be referred to as the limitation of the automatic proportioning method for engineering materials, and the description is omitted herein. All or part of each module in the automatic proportioning device for engineering materials can be realized by software, hardware and a combination thereof. The above modules may be embedded in hardware or may be independent of a processor in the computer device, or may be stored in software in a memory in the computer device, so that the processor may call and execute operations corresponding to the above modules.
In one embodiment, a computer device is provided, which may be a server, and the internal structure of which may be as shown in fig. 8. The computer device includes a processor, a memory, a network interface, and a database connected by a system bus. Wherein the processor of the computer device is configured to provide computing and control capabilities. The memory of the computer device includes a non-volatile storage medium and an internal memory. The non-volatile storage medium stores an operating system, computer programs, and a database. The internal memory provides an environment for the operation of the operating system and computer programs in the non-volatile storage media. The database of the computer equipment is used for storing the data of the materials to be priced, the data column of the materials, the characteristic information of the specifications of the materials and the preset engineering material price database. The network interface of the computer device is used for communicating with an external terminal through a network connection. The computer program when executed by the processor is configured to implement a method for automatic pricing of engineering materials.
In one embodiment, a computer device is provided comprising a memory, a processor, and a computer program stored on the memory and executable on the processor, the processor implementing the steps of when executing the computer program:
acquiring material data to be weighted of engineering material data, identifying the material data to be weighted, and acquiring material source data of the material to be weighted and standard type data for marking the material source data attribute;
identifying material source data with the same attribute based on the standard data, and forming and storing the material source data with the same attribute into a material data column;
extracting material specification characteristic information according to the material data column, wherein the material specification characteristic information comprises key specification characteristic information number and common specification characteristic information number;
and inputting the material data column into a preset engineering material price database for matching based on the material specification characteristic information to obtain the engineering material price information.
In one embodiment, a computer readable storage medium is provided having a computer program stored thereon, which when executed by a processor, performs the steps of:
acquiring material data to be weighted of engineering material data, identifying the material data to be weighted, and acquiring material source data of the material to be weighted and standard type data for marking the material source data attribute;
identifying material source data with the same attribute based on the standard data, and forming and storing the material source data with the same attribute into a material data column;
extracting material specification characteristic information according to the material data column, wherein the material specification characteristic information comprises key specification characteristic information number and common specification characteristic information number;
and inputting the material data column into a preset engineering material price database for matching based on the material specification characteristic information to obtain the engineering material price information.
Those skilled in the art will appreciate that implementing all or part of the above described methods may be accomplished by way of a computer program stored on a non-transitory computer readable storage medium, which when executed, may comprise the steps of the embodiments of the methods described above. Any reference to memory, storage, database, or other medium used in the various embodiments provided herein may include non-volatile and/or volatile memory. The nonvolatile memory can include Read Only Memory (ROM), programmable ROM (PROM), electrically Programmable ROM (EPROM), electrically Erasable Programmable ROM (EEPROM), or flash memory. Volatile memory can include Random Access Memory (RAM) or external cache memory. By way of illustration and not limitation, RAM is available in a variety of forms such as Static RAM (SRAM), dynamic RAM (DRAM), synchronous DRAM (SDRAM), double Data Rate SDRAM (DDRSDRAM), enhanced SDRAM (ESDRAM), synchronous Link DRAM (SLDRAM), memory bus direct RAM (RDRAM), direct memory bus dynamic RAM (DRDRAM), and memory bus dynamic RAM (RDRAM), among others.
It will be apparent to those skilled in the art that, for convenience and brevity of description, only the above-described division of the functional units and modules is illustrated, and in practical application, the above-described functional distribution may be performed by different functional units and modules according to needs, i.e. the internal structure of the apparatus is divided into different functional units or modules to perform all or part of the above-described functions.
The above embodiments are only for illustrating the technical solution of the present application, and are not limiting; although the present application has been described in detail with reference to the foregoing embodiments, it should be understood by those of ordinary skill in the art that: the technical scheme described in the foregoing embodiments can be modified or some technical features thereof can be replaced by equivalents; such modifications and substitutions do not depart from the spirit and scope of the technical solutions of the embodiments of the present application, and are intended to be included in the scope of the present application.

Claims (8)

1. The automatic proportioning method for the engineering materials is characterized by comprising the following steps of:
acquiring material data to be weighted of engineering material data, identifying the material data to be weighted, and acquiring material source data of the material to be weighted and standard type data for marking the material source data attribute;
identifying material source data with the same attribute based on the standard data, and forming and storing the material source data with the same attribute into a material data column;
extracting material specification characteristic information according to the material data column, wherein the material specification characteristic information comprises key specification characteristic information number and common specification characteristic information number;
inputting the material data column into a preset engineering material price database for matching based on the material specification characteristic information to obtain engineering material price information, wherein the method specifically comprises the following steps of:
calculating the specification characteristic matching rate of the engineering material according to the material specification characteristic information;
calculating the matching number of common specification features and the matching number of key specification features in the material specification feature information;
and calculating the specification characteristic matching rate of the engineering material according to the following formula based on the common specification characteristic matching number, the key specification characteristic matching number and the material specification characteristic information:
P＝[k(M+N)(mN+nM)/MN(m+n)]×100
wherein P is the engineering material specification characteristic matching rate, M is the common specification characteristic matching number, N is the key specification characteristic matching number, M is the common specification characteristic information number, N is the key specification characteristic information number, and k is the preset material specification characteristic weight value;
and constructing a mapping relation between the material data column and price data in a preset engineering material price database based on the engineering material specification characteristic matching rate, and obtaining the engineering material price information.
2. The automatic pricing method of engineering materials according to claim 1, wherein after identifying material source data of a same attribute based on the standard data, forming and storing the material source data of the same attribute into a material data column, the automatic pricing method of engineering materials further comprises:
copying the standard class data from the material data column to form a standard class data copy;
and establishing a data structure based on the B+ tree based on the standard class data copy.
3. The automatic pricing method for engineering materials according to claim 1, wherein after the material data string is input into a preset engineering material price database for matching based on the material specification characteristic information, the automatic pricing method for engineering materials further comprises:
acquiring engineering material change data, wherein the engineering material change data comprises material update data and material addition data, and performing data change processing on a material data column based on the material update data;
and acquiring material adding source data and standard class adding data for identifying the attribute of the material adding source data based on the material adding data, and adding the material adding source data to a corresponding material data column according to the standard class adding data.
4. The automatic pricing method for engineering materials according to claim 3, wherein the data modification processing is performed on the material data sequence based on the material update data, specifically comprising:
acquiring material update source data and standard type update data for identifying the attribute of the material update source data based on the material update data;
and identifying a corresponding material data column according to the standard type updating data, and inputting the material updating source data into the material data column to replace the corresponding material source data.
5. An automatic engineering material proportioning device, which is characterized in that the automatic engineering material proportioning device comprises:
the engineering material analysis module is used for acquiring material data to be priced of engineering material data, identifying the material data to be priced, and acquiring material source data of the material to be priced and standard type data for marking the material source data attribute;
the material data column construction module is used for identifying material source data with the same attribute based on the standard data, and forming and storing the material source data with the same attribute into a material data column;
the material specification characteristic acquisition module is used for extracting material specification characteristic information according to the material data array, wherein the material specification characteristic information comprises a key specification characteristic information number and a common specification characteristic information number;
the engineering material price matching module is used for inputting the material data column into a preset engineering material price database for matching based on the material specification characteristic information to obtain engineering material price matching information, and specifically comprises the following steps: calculating engineering material specification characteristic matching rate according to the material specification characteristic information, and constructing a mapping relation between the material data column and price data in a preset engineering material price database based on the engineering material specification characteristic matching rate to obtain engineering material price information; the calculating the engineering material specification characteristic matching rate according to the material specification characteristic information specifically comprises the following steps: calculating the matching number of common specification features and the matching number of key specification features in the material specification feature information; and calculating the specification characteristic matching rate of the engineering material according to the following formula based on the common specification characteristic matching number, the key specification characteristic matching number and the material specification characteristic information:
P＝[k(M+N)(mN+nM)/MN(m+n)]×100
wherein P is engineering material specification characteristic matching rate, M is common specification characteristic matching number, N is key specification characteristic matching number, M is common specification characteristic information number, N is key specification characteristic information number, and k is preset material specification characteristic weight value.
6. The automatic engineering material pricing device of claim 5, wherein the engineering material pricing module comprises:
and the engineering material specification characteristic matching rate submodule is used for calculating engineering material specification characteristic matching rate according to the material specification characteristic information and constructing a mapping relation between the material data column and price data in a preset engineering material price database based on the engineering material specification characteristic matching rate.
7. A computer device comprising a memory, a processor and a computer program stored in the memory and executable on the processor, characterized in that the processor implements the steps of a method for automatic pricing of engineering materials according to any of claims 1 to 4 when the computer program is executed.
8. A computer readable storage medium storing a computer program, characterized in that the computer program when executed by a processor implements the steps of an automatic pricing method for engineering materials according to any of claims 1 to 4.
CN202310749355.XA 2023-06-21 2023-06-21 Automatic pricing method, system, equipment and storage medium for engineering materials Active CN117010925B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202310749355.XA CN117010925B (en) 2023-06-21 2023-06-21 Automatic pricing method, system, equipment and storage medium for engineering materials

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202310749355.XA CN117010925B (en) 2023-06-21 2023-06-21 Automatic pricing method, system, equipment and storage medium for engineering materials

Publications (2)

Publication Number Publication Date
CN117010925A CN117010925A (en) 2023-11-07
CN117010925B true CN117010925B (en) 2024-03-22

Family

ID=88560900

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202310749355.XA Active CN117010925B (en) 2023-06-21 2023-06-21 Automatic pricing method, system, equipment and storage medium for engineering materials

Country Status (1)

Country Link
CN (1) CN117010925B (en)

Citations (9)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
KR20130082872A (en) * 2011-12-21 2013-07-22 (주) 명진소프트컨설팅 Construction work management system for which a matrix technique was shown to the price of construction materials
CN103761249A (en) * 2013-12-24 2014-04-30 北京恒华伟业科技股份有限公司 Data importing method and system based on data matching
CN109658156A (en) * 2018-12-25 2019-04-19 华联世纪工程咨询股份有限公司 A kind of material price measuring method, device, terminal device and storage medium
CN109685576A (en) * 2018-12-25 2019-04-26 华联世纪工程咨询股份有限公司 A kind of automatic coordination valence method, apparatus of engineering material, terminal device and storage medium
CN109857890A (en) * 2018-12-25 2019-06-07 华联世纪工程咨询股份有限公司 The recommended method and device of engineering material picture
KR20190142526A (en) * 2018-06-18 2019-12-27 유승상 Product recommendation system and product recommendation method for prospective customers in offline stores
CN113886653A (en) * 2021-10-18 2022-01-04 广州翔实工程咨询有限公司 Automatic matching method and system for engineering cost work order database
JP2022117701A (en) * 2021-02-01 2022-08-12 沖電気工業株式会社 Matching system, matching method, and program
CN115495507A (en) * 2022-11-17 2022-12-20 江苏鸿程大数据技术与应用研究院有限公司 Engineering material information price matching method, system and storage medium

Patent Citations (9)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
KR20130082872A (en) * 2011-12-21 2013-07-22 (주) 명진소프트컨설팅 Construction work management system for which a matrix technique was shown to the price of construction materials
CN103761249A (en) * 2013-12-24 2014-04-30 北京恒华伟业科技股份有限公司 Data importing method and system based on data matching
KR20190142526A (en) * 2018-06-18 2019-12-27 유승상 Product recommendation system and product recommendation method for prospective customers in offline stores
CN109658156A (en) * 2018-12-25 2019-04-19 华联世纪工程咨询股份有限公司 A kind of material price measuring method, device, terminal device and storage medium
CN109685576A (en) * 2018-12-25 2019-04-26 华联世纪工程咨询股份有限公司 A kind of automatic coordination valence method, apparatus of engineering material, terminal device and storage medium
CN109857890A (en) * 2018-12-25 2019-06-07 华联世纪工程咨询股份有限公司 The recommended method and device of engineering material picture
JP2022117701A (en) * 2021-02-01 2022-08-12 沖電気工業株式会社 Matching system, matching method, and program
CN113886653A (en) * 2021-10-18 2022-01-04 广州翔实工程咨询有限公司 Automatic matching method and system for engineering cost work order database
CN115495507A (en) * 2022-11-17 2022-12-20 江苏鸿程大数据技术与应用研究院有限公司 Engineering material information price matching method, system and storage medium

Also Published As

Publication number Publication date
CN117010925A (en) 2023-11-07

Similar Documents

Publication Publication Date Title
CN112199366A (en) Data table processing method, device and equipment
CN108388640B (en) Data conversion method and device and data processing system
CN111090788B (en) json file comparison method and device, storage medium and computer equipment
CN112286934A (en) Database table importing method, device, equipment and medium
CN109597979A (en) Inventory table generation method, device, computer equipment and storage medium
CN109325042A (en) Handle template acquisition methods, form processing method, device, equipment and medium
CN117010925B (en) Automatic pricing method, system, equipment and storage medium for engineering materials
CN111382250A (en) Question text matching method and device, computer equipment and storage medium
CN115757411A (en) Stock market information data management method, system, equipment and storage medium
CN111984659A (en) Data updating method and device, computer equipment and storage medium
CN111695330A (en) Method and device for generating table, electronic equipment and computer-readable storage medium
CN116208465A (en) Intelligent monitoring and early warning method and system for electric power information communication condition
CN113791594B (en) Configuration establishing method, system, equipment and medium of distributed control system
CN110688400A (en) Data processing method, data processing device, computer equipment and storage medium
CN116956838A (en) Project determining method and device for engineering quantity list
CN112115159A (en) SQL statement generation method and device, electronic equipment and storage medium
CN113377712B (en) Buried data query method, buried data query device, buried data query equipment and computer readable storage medium
CN117312833B (en) Data identification method and system applied to digital asset environment
CN117423299B (en) Performance detection method, device and equipment for liquid crystal display screen and storage medium
CN117076467B (en) Smart city identification method, system, equipment and medium based on MA system
CN116431660A (en) Data processing method, device, system, electronic equipment and storage medium
CN115033483A (en) Test case enhancement method and device, computer equipment and storage medium
CN117033242A (en) Test data generation method, device, computer equipment and storage medium
CN116132283A (en) Distributed data acquisition method, system, equipment and storage medium
CN115408397A (en) Data table merging method, system, equipment and storage medium

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