CN-122020202-A - Engineering cost data storage processing method and device

CN122020202ACN 122020202 ACN122020202 ACN 122020202ACN-122020202-A

Abstract

The invention relates to the technical field of computer information processing, in particular to a method and a device for storing and processing engineering cost data, which comprises a data acquisition layer, a data processing and storing layer and an application service layer, wherein the data acquisition layer comprises a data acquisition module, the data processing and storing layer comprises a preprocessing module, a UDM unified data module, a multidimensional manufacturing cost database module and a real-time cost checking and deviation analyzing module, and the application service layer comprises a cost early warning service module and a user interaction and API module. According to the invention, standardized mapping of heterogeneous data is realized through the UDM unified data model, and the automatic engineering quantity extraction of the BIM analysis module and the automatic price hanging of the price matching sub-module are combined, so that the manual intervention links are reduced, the problems of price mismatch and data distortion in the traditional mode are thoroughly solved, and accurate data support is provided for cost accounting and decision making.

Inventors

An Manjiao
Dong Xinze
FENG XIXIANG
GAO XIANGJIE

Assignees

河北祥平建筑工程有限公司

Dates

Publication Date: 20260512
Application Date: 20260203

Claims (9)

1. The engineering cost data storage processing device is characterized by comprising a data acquisition layer, a data processing and storage layer and an application service layer, wherein the data acquisition layer comprises a data acquisition module, the data processing and storage layer comprises a preprocessing module, a UDM unified data module, a multidimensional cost database module and a real-time cost verification and deviation analysis module, and the application service layer comprises a cost early warning service module and a user interaction and API module; the data acquisition module is used for receiving BIM model files and market price data, carrying out preliminary verification on the integrity and format validity of the data, and transmitting effective original data to the preprocessing module after eliminating abnormal data; The preprocessing module is used for analyzing, cleaning and price matching the original data and providing basic data for subsequent standardized mapping; the UDM unified data module is used for mapping heterogeneous data into a unified format, establishing a data association relationship and outputting standardized data; The multidimensional manufacturing cost database module is used for storing standardized data, hanging price data and checking data according to a multidimensional association structure, synchronously executing block chain storage certificate and supporting efficient data inquiry, tracing and audit verification; The real-time cost verification and deviation analysis module is used for calculating the deviation rate of the current cost data and a comparison standard, and judging whether to trigger early warning after comparing the deviation rate with a preset threshold value; The cost early warning service module is used for receiving the early warning trigger signal, generating early warning information and pushing the early warning information to a user; And the user interaction and API module is used for receiving user operation instructions and feeding back execution results, generating a multidimensional analysis report and supporting export.
2. The engineering cost data storage processing device according to claim 1 is characterized in that a standardized data dictionary and an association rule base are built in the UDM unified data module, the data dictionary is used for defining unified field names, data types and unit standards of core cost factors such as engineering quantity, material price, manual unit price, mechanical station class fee, indirect fee and the like, data format consistency is guaranteed, and the association rule base is used for defining mapping relation and consumption quota between a component and resources, engineering quantity and price and providing rule support for data association matching.
3. The engineering cost data storage processing device according to claim 1 is characterized in that a BIM analysis submodule and a price matching submodule are arranged in the preprocessing module, the BIM analysis submodule is used for analyzing BIM model files in IFC and RVT formats, automatically extracting geometric property, non-geometric property and engineering quantity data of components, distributing temporary identification codes for each component and realizing automatic extraction of engineering quantity, and the price matching submodule is used for automatically matching standardized resource price with corresponding engineering quantity according to association rules provided by a UDM unified data module, calculating comprehensive unit price and price of each component or definition item according to a preset formula and realizing automatic association of quantity price.
4. The engineering cost data storage processing device according to claim 1 is characterized in that the multidimensional cost database module adopts a combined framework of a graph database and a time sequence database, wherein the graph database is used for storing multidimensional association relations of component-resource-time-contract-area to construct a data association network and supporting complex dimension inquiry, the time sequence database is used for storing engineering quantity accumulated values, cost accumulated values and price fluctuation data related to time sequences to meet time dimension analysis requirements, and the multidimensional cost database module is provided with a block chain evidence storage function and is used for forcedly encrypting and storing key data such as component IDs, core engineering quantities, comprehensive unit price, price and the like to ensure that the data cannot be tampered and improve audit reliability and traceability.
5. The engineering cost data storage processing device according to claim 1, wherein the real-time cost verification and deviation analysis module is used for presetting three groups of cost thresholds, wherein the three groups of cost thresholds are respectively a deviation threshold with a budget baseline, a deviation threshold with historical similar project data and a deviation threshold with market average data, the cost thresholds support user-defined adjustment, and the real-time cost verification and deviation analysis module is also used for real-time retrieval of current cost data and corresponding comparison reference data in a multi-dimensional cost database module, calculation of a deviation rate, comparison of the deviation rate with the preset threshold, and generation of an early warning trigger signal or verification record according to comparison results.
6. A construction cost data storage processing method, characterized in that it is realized based on the construction cost data storage processing device according to any one of claims 1-5, comprising the steps of: S101, data acquisition and preliminary verification, wherein a data acquisition module receives BIM model files and market price data, verifies data integrity and format validity, feeds abnormal data back to a user and requires correction, and transmits effective original data to a preprocessing module; s102, analyzing the BIM model and extracting the engineering quantity, analyzing the BIM model file by a BIM analysis submodule of the preprocessing module, extracting the geometric attribute, the non-geometric attribute and the engineering quantity data of the component, distributing temporary identification codes for the component, and transmitting related data to the preprocessing core unit; S103, data cleaning and standardized mapping, wherein a preprocessing core unit cleans data, a UDM unified data module calls a data dictionary and an association rule base, heterogeneous data is mapped into a unified format, unique component IDs and resource IDs are allocated, a data association relationship is established, and standardized data is transmitted to a multidimensional manufacturing cost database module and a price matching sub-module; S104, price matching and comprehensive unit price generation, wherein a price matching sub-module automatically matches standardized resource prices with corresponding engineering quantities according to association rules, calculates comprehensive unit price and price according to a preset formula, and transmits hanging price data to a multidimensional manufacturing cost database module; S105, storing and evidence storing in a multi-dimensional structured manner, wherein a multi-dimensional manufacturing cost database module stores standardized data and hanging price data according to a member-resource-time-contract-area multi-dimensional association structure, synchronously performs block chain evidence storing on key data such as member ID, core engineering quantity data, comprehensive unit price, closing price and the like, generates an evidence storing hash value and stores the evidence storing hash value in association with corresponding data in a database; S106, real-time cost verification and deviation analysis, wherein the real-time cost verification and deviation analysis module invokes current cost data and comparison reference data in the multidimensional cost database module, calculates a deviation rate, compares the deviation rate with a preset threshold value and judges whether to trigger early warning; S107, cost early warning pushing and recording, wherein if the deviation rate exceeds a threshold value, the cost early warning service module receives an early warning trigger signal, determines an early warning level, generates early warning information containing deviation details and influence analysis and processing suggestions, pushes the early warning information to a user through user interaction and an API module, and simultaneously stores the early warning record into a multidimensional manufacturing cost database module; S108, generating and exporting a multidimensional analysis report, wherein a user sends a report generation instruction through user interaction and an API module, and the module extracts corresponding data to a multidimensional manufacturing cost database module to generate a multidimensional visual analysis report, so that the user is supported to view or export the multidimensional visual analysis report to a third party system on line.
7. The method for storing and processing engineering cost data according to claim 6, wherein the data cleaning in the step S103 comprises the steps of removing extreme price data by adopting an outlier detection algorithm of a 3 sigma principle, deleting repeated input data through a hash table, and unifying non-standard units into preset standard units, wherein the standardized mapping is realized through a standardized data dictionary and an association rule base of a UDM unified data module, and is used for ensuring that data structures with different sources and different formats are unified, and association relations are clear, so that a basis is provided for subsequent storage and analysis.
8. The method for storing and processing engineering cost data according to claim 6, wherein the comprehensive unit price calculation formula in the step S104 is that comprehensive unit price= (material cost + labor cost + mechanical cost) × (1 + indirect fee rate) × (1 + profit rate) × (1 + tax rate), and wherein the material cost, labor cost and mechanical cost are calculated by a price matching sub-module based on the engineering quantity of the component, the corresponding resource price and the consumption quota provided by the UDM unified data module, and the price matching sub-module is used for automatically completing price quantity association calculation to reduce manual intervention.
9. The method for storing and processing engineering cost data according to claim 6, wherein the blockchain storage process in the step S105 is characterized in that after receiving standardized data and hanging price data, a multidimensional cost database module automatically carries out hash calculation on key information such as component ID, core engineering quantity data, comprehensive unit price, price and the like to generate a unique storage hash value, uploads the storage hash value to a blockchain network through a alliance chain interface to complete storage, and simultaneously establishes one-to-one association and stores the storage hash value and corresponding complete cost data in the database, so that the non-tamper modification and full-flow traceability of the key cost data are ensured, and audit verification requirements are met.

Description

Engineering cost data storage processing method and device Technical Field The invention relates to the technical field of computer information processing, in particular to a method and a device for storing and processing engineering cost data. Background The engineering cost data relates to the key links of engineering budget, cost accounting, bidding and the like, and multi-source data such as design files, engineering quantity lists, material price libraries and the like are required to be integrated. In the field of constructional engineering, cost management is a core link of project management and control, and directly influences the investment benefit and implementation efficiency of projects. When the traditional construction engineering cost management mode is used for data updating, the traditional construction engineering cost management mode mainly depends on manual input and post-calculation, the data updating is delayed from project implementation progress, and dynamic changes of project cost cannot be reflected in real time. When the cost deviation is found, irreversible hyperbranched loss is often caused, and the dynamic management targets of prevention and control in advance are difficult to realize, so that a method and a device for storing and processing engineering cost data are required to be designed. Disclosure of Invention In order to overcome the defects of the prior art, the invention aims to provide a method and a device for storing and processing engineering cost data. The technical scheme adopted by the invention is that the engineering cost data storage processing device comprises a data acquisition layer, a data processing and storage layer and an application service layer, wherein the data acquisition layer comprises a data acquisition module, the data processing and storage layer comprises a preprocessing module, a UDM unified data module, a multidimensional cost database module and a real-time cost verification and deviation analysis module, and the application service layer comprises a cost early warning service module and a user interaction and API module; the data acquisition module is used for receiving BIM model files and market price data, carrying out preliminary verification on the integrity and format validity of the data, and transmitting effective original data to the preprocessing module after eliminating abnormal data; The preprocessing module is used for analyzing, cleaning and price matching the original data and providing basic data for subsequent standardized mapping; the UDM unified data module is used for mapping heterogeneous data into a unified format, establishing a data association relationship and outputting standardized data; The multidimensional manufacturing cost database module is used for storing standardized data, hanging price data and checking data according to a multidimensional association structure, synchronously executing block chain storage certificate and supporting efficient data inquiry, tracing and audit verification; The real-time cost verification and deviation analysis module is used for calculating the deviation rate of the current cost data and a comparison standard, and judging whether to trigger early warning after comparing the deviation rate with a preset threshold value; The cost early warning service module is used for receiving the early warning trigger signal, generating early warning information and pushing the early warning information to a user; And the user interaction and API module is used for receiving user operation instructions and feeding back execution results, generating a multidimensional analysis report and supporting export. As a further description of the above technical solution: The UDM unified data module is internally provided with a standardized data dictionary and an association rule base, wherein the data dictionary is used for defining unified field names, data types and unit standards of core cost factors such as engineering quantity, material price, manual unit price, mechanical station class fee, indirect fee and the like, so as to ensure data format consistency, and the association rule base is used for defining the mapping relation and consumption quota between a component and a resource and between the engineering quantity and the price and providing rule support for data association matching. As a further description of the above technical solution: The preprocessing module is internally provided with a BIM analysis submodule and a price matching submodule, the BIM analysis submodule is used for analyzing BIM model files in IFC and RVT formats, automatically extracting geometric attributes, non-geometric attributes and engineering quantity data of components, distributing temporary identification codes for each component and realizing automatic extraction of engineering quantity, and the price matching submodule is used for automatically matching standardized resource prices with correspond