Civil air defense project settlement system and method based on big data

Abstract

The invention discloses a civil air defense project settlement system and method based on big data. The system comprises a data acquisition module, a data storage module, a data processing module, a project amount calculation module, a price analysis module, a settlement rule management module, a settlement generation module, a settlement auditing module, a data analysis and decision support module and a user management module. According to the invention, efficient collection, storage, processing and analysis of civil air defense project settlement data are realized through a big data technology, and the settlement efficiency and accuracy are improved. The system is rich in modules and covers links of data acquisition, settlement auditing, data analysis and the like, automation and intelligence of the settlement process are realized through reasonable module design and method steps, and powerful support is provided for project management and decision making. And meanwhile, through data encryption and authority management, the security and confidentiality of the data are ensured.

Description

Technical Field

[0001] The present invention relates to the technical field of civil air defense project settlement, and specifically to a civil air defense project settlement system and method based on big data. Background Art

[0002] In the full life cycle management of a project, the settlement process is the core node of the closed-loop project funds, involving multi-dimensional data processing such as bill of quantities calculation, material price difference adjustment, and contract terms and conditions performance review. According to industry research, under the traditional manual settlement model, the settlement cycle of a single medium-sized civil air defense project is as long as 6-8 weeks on average, and the dispute rate due to human calculation errors is as high as 15%-20%. The data island problem causes more than 30% delay in information transmission between the various participants (construction units, construction companies, and audit departments). As the penetration rate of big data technology in the construction field continues to rise year by year, how to build an intelligent settlement system through cutting-edge technologies such as data mining and machine learning to achieve real-time analysis of engineering data, early warning of abnormal fluctuations, and cross-departmental collaborative audits has become an important breakthrough in promoting the digital transformation of civil air defense construction. Summary of the Invention

[0003] The purpose of the present invention is to provide a civil air defense project settlement system and method based on big data to solve the problems raised in the above background technology.

[0004] To achieve the above-mentioned object, the present invention provides the following technical solution: a civil air defense project settlement system based on big data, comprising a data acquisition module, a data storage module, a data processing module, a project quantity calculation module, a price analysis module, a settlement rule management module, a settlement generation module, a settlement review module, a data analysis and decision support module, and a user management module;

[0005] The data collection module is used to collect data related to the settlement of civil air defense projects, including basic project information, project quantity data, material price data, labor cost data, equipment rental data, design change data, visa data and acceptance data;

[0006] The data storage module classifies and stores the collected data to establish data;

[0007] The data processing module processes and analyzes the stored data, including data cleaning, data integration, data conversion and data mining;

[0008] The engineering quantity calculation module calculates the engineering quantity using big data technology according to engineering design drawings and relevant specifications;

[0009] The price analysis module performs real-time analysis and monitoring of material prices, labor costs, and equipment rental prices;

[0010] The settlement rule management module is used to formulate and manage the rules and standards for civil air defense project settlement, including pricing methods, fee standards and settlement methods;

[0011] The settlement generation module automatically generates a settlement report based on the data provided by the data processing module, the engineering quantity calculated by the engineering quantity calculation module, the price information provided by the price analysis module, and the rules formulated by the settlement rule management module;

[0012] The settlement audit module audits the generated settlement reports, including rationality audit, accuracy audit and compliance audit;

[0013] The data analysis and decision support module analyzes and mines historical settlement data to provide support for project management and decision-making;

[0014] The user management module is used to manage user information of the system, including user registration, login and authority management.

[0015] Preferably, the data acquisition module obtains data by connecting with the engineering management system, material supplier system, human resource management system, equipment leasing system or other external systems, as well as manually entering data; in order to ensure the accuracy and completeness of the data, the collected data is preliminarily verified and cleaned to remove duplicate and erroneous data; the accuracy of data collection is evaluated by the following formula:

[0016]

[0017] Among them, A represents the accuracy of data collection, N c Indicates the amount of correctly collected data, N t Indicates the total amount of data that should be collected.

[0018] Preferably, the data storage module adopts distributed database technology to achieve efficient storage and management of data; the database includes a project information database, a project quantity database, a material price database, a labor cost database, an equipment rental database, a design change database, a visa database, and an acceptance database; the data is encrypted to ensure data security;

[0019] Data cleaning in the data processing module further removes noise data and abnormal data, data integration integrates data from different sources, data conversion converts data into a format suitable for analysis, and data mining uses big data analysis technology to explore potential patterns and valuable information in the data.

[0020] Preferably, the big data analysis technology is used to realize intelligent analysis of civil air defense project settlement, and the specific steps are as follows:

[0021] Data Collection: Through IoT sensors, BIM models, financial systems, construction management platforms, or other multi-source channels, real-time data collection is carried out on the entire life cycle of civil air defense projects, including structured and unstructured data on project design parameters, construction progress, material procurement records, staff hours, equipment usage data, and change approval forms.

[0022] Data cleaning and preprocessing: Use ETL (Extract, Transform, Load) tools to process raw data, identify and correct missing values, duplicate values, and outliers (such as cost data that significantly deviates from the normal range), unify data formats and coding standards, and improve data quality;

[0023] Data storage and management: Store processed data in a distributed file system (such as HDFS) or a columnar database (such as HBase) to build a civil air defense project settlement data warehouse; use a data layered architecture (ODS original layer, DWD detail layer, DWS summary layer) to achieve efficient data management and query;

[0024] Data analysis and modeling:

[0025] Association analysis: Use the Apriori algorithm or FP-Growth algorithm to explore potential associations between data, such as analyzing the relationship between material price fluctuations and market supply and demand, and the relationship between construction process changes and cost increases;

[0026] Cluster analysis: Using algorithms such as K-Means and hierarchical clustering, similar civil air defense projects are classified, settlement indicators of similar projects are compared, and abnormal cost items are identified;

[0027] Predictive analysis: Based on time series algorithms (such as ARIMA, LSTM) or regression models (linear regression, random forest), combined with historical settlement data and real-time project data, predict the final cost of the project and the risk of construction period;

[0028] Data visualization and decision support: The analysis results are presented intuitively in the form of charts (such as cost composition pie charts, progress Gantt charts, trend line charts) and dashboards to provide data support for settlement auditors, helping them to quickly locate settlement disputes and formulate reasonable settlement plans.

[0029] Preferably, a quantity calculation model is established in the quantity calculation module, combining historical engineering data with the characteristics of the current project to improve the accuracy and efficiency of quantity calculation; for complex civil air defense engineering structures, three-dimensional modeling technology is used to realize visual calculation of engineering quantities; the quantity calculation is based on the following formula to build a basic model:

[0030]

[0031] Among them, V represents the total project volume; n is the number of components calculated by length, width and height, L i 、W i 、H i are the length, width, and height of the i-th component respectively; m is the number of components calculated by area, S j is the area of ​​the jth component;

[0032] In practical applications, combining BIM model parameters and construction drawing data, obtaining component geometric dimensions in real time through API interfaces, and developing algorithms using Python or Java programming languages ​​to achieve automated calculations;

[0033] The price analysis module obtains the latest price information by connecting with the market price database, analyzes price fluctuation trends, and provides a reasonable price basis for settlement; establishes a price early warning mechanism, and issues early warning signals in a timely manner when price fluctuations exceed a certain range.

[0034] Preferably, the settlement rule management module supports user-defined settlement rules to meet the settlement requirements of different projects; and performs version management on the settlement rules to ensure the consistency and traceability of the settlement rules;

[0035] The settlement report in the settlement generation module includes the total project settlement price, the settlement price of each sub-project, the settlement price of material costs, the settlement price of labor costs, and the settlement price of equipment rental costs; and supports the export and printing of settlement reports.

[0036] Preferably, the auditors in the settlement audit module can conduct online audits through the system, put forward audit opinions and suggestions, and record the audit process to ensure the traceability of the audit;

[0037] The analysis content in the data analysis and decision support module includes the composition of project costs, the impact of price fluctuations on project costs, and settlement cycle analysis; through data visualization technology, the analysis results are displayed in the form of charts and reports, which allows users to intuitively understand the project settlement status.

[0038] Preferably, the user management module allocates different operating permissions according to the user's role and responsibilities to ensure the security and confidentiality of the system; and records the user's operation log to facilitate auditing and supervision of user behavior.

[0039] A settlement method for a civil air defense project settlement system based on big data, comprising the following steps:

[0040] Step 1: Data collection: Collect data related to civil air defense project settlement from external systems and manual input through the data collection module, and perform preliminary verification and cleaning on the collected data to ensure the accuracy and completeness of the data;

[0041] Step 2, data storage: the cleaned data is classified and stored in the database of the data storage module, and distributed database technology is used to achieve efficient storage and management of data, and the data is encrypted;

[0042] Step 3: Data processing: Use the data processing module to clean, integrate, convert, and mine the stored data, uncovering potential patterns and valuable information in the data to provide support for subsequent settlement work;

[0043] Step 4: Calculate the quantity of work: Based on the engineering design drawings and relevant specifications, use the quantity calculation model established by the quantity calculation module, combine historical engineering data and the characteristics of the current project, calculate the quantity of work, and improve the accuracy and efficiency of the calculation;

[0044] Step 5. Price Analysis: The price analysis module connects to the market price database to obtain the latest information on material prices, labor costs, and equipment rental prices, analyzes price fluctuation trends, provides a reasonable price basis for settlement, and establishes a price early warning mechanism;

[0045] Step 6. Settlement rule development: The settlement rule management module is used to develop and manage the rules and standards for civil air defense project settlement. This module supports user-defined settlement rules to meet the settlement requirements of different projects and implements version management for settlement rules.

[0046] Step 7, Settlement Generation: The settlement generation module automatically generates a settlement report based on the data provided by the data processing module, the engineering quantity calculated by the engineering quantity calculation module, the price information provided by the price analysis module, and the rules established by the settlement rule management module. It also supports exporting and printing the report.

[0047] Step 8. Settlement Audit: The settlement audit module audits the rationality, accuracy, and compliance of the generated settlement reports. Auditors conduct online audits and provide comments and suggestions, and record the audit process to ensure traceability.

[0048] Step 9: Data Analysis and Decision Support: Use the data analysis and decision support module to analyze and mine historical settlement data, and display the analysis results through data visualization technology to provide support for project management and decision-making;

[0049] Step 10. User management: Manage system user information, assign user permissions, and record user operation logs through the user management module to ensure system security and confidentiality.

[0050] Compared with the prior art, the present invention has the following beneficial effects:

[0051] This invention leverages big data technology to efficiently collect, store, process, and analyze civil air defense project settlement data, improving settlement efficiency and accuracy. The system features a rich set of modules, covering every stage from data collection to settlement review and analysis. Through rational module design and methodological procedures, it automates and intelligentizes the settlement process, providing strong support for project management and decision-making. Furthermore, data encryption and rights management ensure data security and confidentiality. BRIEF DESCRIPTION OF THE DRAWINGS

[0052] Figure 1 It is a system principle diagram of the present invention;

[0053] Figure 2 It is a flow chart of the method of the present invention. DETAILED DESCRIPTION

[0054] The following will be combined with the embodiments of the present invention to clearly and completely describe the technical solutions in the embodiments of the present invention. Obviously, the embodiments described are only part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without making creative efforts are within the scope of protection of the present invention.

[0055] See also Figure 1-2 The present invention provides a civil air defense project settlement system based on big data, including a data acquisition module, a data storage module, a data processing module, a project quantity calculation module, a price analysis module, a settlement rule management module, a settlement generation module, a settlement review module, a data analysis and decision support module and a user management module;

[0056] The data collection module is used to collect data related to civil air defense project settlement, including basic project information, project quantity data, material price data, labor cost data, equipment rental data, design change data, visa data and acceptance data;

[0057] The data storage module classifies and stores the collected data and establishes data;

[0058] The data processing module processes and analyzes the stored data, including data cleaning, data integration, data conversion and data mining;

[0059] The engineering quantity calculation module calculates the engineering quantity based on engineering design drawings and relevant specifications using big data technology;

[0060] The price analysis module conducts real-time analysis and monitoring of material prices, labor costs, and equipment rental prices;

[0061] The settlement rule management module is used to formulate and manage the rules and standards for civil air defense project settlement, including pricing methods, fee standards and settlement methods;

[0062] The settlement generation module automatically generates settlement reports based on the data provided by the data processing module, the engineering quantities calculated by the engineering quantity calculation module, the price information provided by the price analysis module, and the rules formulated by the settlement rule management module;

[0063] The settlement audit module audits the generated settlement reports, including rationality audit, accuracy audit and compliance audit;

[0064] The data analysis and decision support module analyzes and mines historical settlement data to provide support for project management and decision-making;

[0065] The user management module is used to manage the system's user information, including user registration, login, and permission management.

[0066] The data collection module obtains data by connecting with the engineering management system, material supplier system, human resource management system, equipment rental system or other external systems, as well as manually entering data. To ensure the accuracy and completeness of the data, the collected data is preliminarily verified and cleaned to remove duplicate and erroneous data. The accuracy of data collection is evaluated using the following formula:

[0067]

[0068] Among them, A represents the accuracy of data collection, N c Indicates the amount of correctly collected data, N t Indicates the total amount of data that should be collected.

[0069] The data storage module uses distributed database technology to achieve efficient data storage and management; the database includes project information database, engineering quantity database, material price database, labor cost database, equipment rental database, design change database, visa database, and acceptance database; data is encrypted to ensure data security;

[0070] Data cleaning in the data processing module further removes noise data and abnormal data, data integration integrates data from different sources, data conversion converts data into a format suitable for analysis, and data mining uses big data analysis technology to explore potential patterns and valuable information in the data.

[0071] Big data analysis technology is used to realize intelligent analysis of civil air defense project settlement. The specific steps are as follows:

[0072] Data Collection: Through IoT sensors, BIM models, financial systems, construction management platforms, or other multi-source channels, real-time data collection is carried out on the entire life cycle of civil air defense projects, including structured and unstructured data on project design parameters, construction progress, material procurement records, staff hours, equipment usage data, and change approval forms.

[0073] Data cleaning and preprocessing: Use ETL (Extract, Transform, Load) tools to process raw data, identify and correct missing values, duplicate values, and outliers (such as cost data that significantly deviates from the normal range), unify data formats and coding standards, and improve data quality;

[0074] Data storage and management: Store processed data in a distributed file system (such as HDFS) or a columnar database (such as HBase) to build a civil air defense project settlement data warehouse; use a data layered architecture (ODS original layer, DWD detail layer, DWS summary layer) to achieve efficient data management and query;

[0075] Data analysis and modeling:

[0076] Association analysis: Use the Apriori algorithm or FP-Growth algorithm to explore potential associations between data, such as analyzing the relationship between material price fluctuations and market supply and demand, and the relationship between construction process changes and cost increases;

[0077] Cluster analysis: Using algorithms such as K-Means and hierarchical clustering, similar civil air defense projects are classified, settlement indicators of similar projects are compared, and abnormal cost items are identified;

[0078] Predictive analysis: Based on time series algorithms (such as ARIMA, LSTM) or regression models (linear regression, random forest), combined with historical settlement data and real-time project data, predict the final cost of the project and the risk of construction period;

[0079] Data visualization and decision support: The analysis results are presented intuitively in the form of charts (such as cost composition pie charts, progress Gantt charts, trend line charts) and dashboards to provide data support for settlement auditors, helping them to quickly locate settlement disputes and formulate reasonable settlement plans.

[0080] The quantity calculation module establishes a quantity calculation model, combining historical project data with the characteristics of the current project to improve the accuracy and efficiency of quantity calculation. For complex civil air defense engineering structures, 3D modeling technology is used to achieve visual calculation of engineering quantities. The basic model for quantity calculation is constructed based on the following formula:

[0081]

[0082] Among them, V represents the total project volume; n is the number of components calculated by length, width and height, L i 、W i 、H i are the length, width, and height of the i-th component respectively; m is the number of components calculated by area, S j is the area of ​​the jth component;

[0083] In practical applications, combining BIM model parameters and construction drawing data, obtaining component geometric dimensions in real time through API interfaces, and developing algorithms using Python or Java programming languages ​​to achieve automated calculations;

[0084] The price analysis module connects with the market price database to obtain the latest price information, analyze price fluctuation trends, and provide a reasonable price basis for settlement; establishes a price early warning mechanism to issue early warning signals in a timely manner when price fluctuations exceed a certain range.

[0085] The settlement rule management module supports user-defined settlement rules to meet the settlement requirements of different projects; it also manages the settlement rules to ensure their consistency and traceability;

[0086] The settlement report in the settlement generation module includes the total project settlement price, settlement price of each sub-project, settlement price of material costs, settlement price of labor costs, and settlement price of equipment rental costs; it supports the export and printing of settlement reports.

[0087] In the settlement audit module, auditors can conduct online audits through the system and provide audit opinions and suggestions; the audit process is recorded to ensure the traceability of the audit;

[0088] The analysis content in the data analysis and decision support module includes the composition of project costs, the impact of price fluctuations on project costs, and settlement cycle analysis; through data visualization technology, the analysis results are displayed in the form of charts and reports, allowing users to intuitively understand the project settlement status.

[0089] The user management module assigns different operating permissions according to the user's role and responsibilities to ensure the security and confidentiality of the system; it records the user's operation log to facilitate auditing and supervision of user behavior.

[0090] A settlement method for a civil air defense project settlement system based on big data, comprising the following steps:

[0091] Step 1: Data collection: Collect data related to civil air defense project settlement from external systems and manual input through the data collection module, and perform preliminary verification and cleaning on the collected data to ensure the accuracy and completeness of the data;

[0092] Step 2, data storage: the cleaned data is classified and stored in the database of the data storage module, and distributed database technology is used to achieve efficient storage and management of data, and the data is encrypted;

[0093] Step 3: Data processing: Use the data processing module to clean, integrate, convert, and mine the stored data, uncovering potential patterns and valuable information in the data to provide support for subsequent settlement work;

[0094] Step 4: Calculate the quantity of work: Based on the engineering design drawings and relevant specifications, use the quantity calculation model established by the quantity calculation module, combine historical engineering data and the characteristics of the current project, calculate the quantity of work, and improve the accuracy and efficiency of the calculation;

[0095] Step 5. Price Analysis: The price analysis module connects to the market price database to obtain the latest information on material prices, labor costs, and equipment rental prices, analyzes price fluctuation trends, provides a reasonable price basis for settlement, and establishes a price early warning mechanism;

[0096] Step 6. Settlement rule development: The settlement rule management module is used to develop and manage the rules and standards for civil air defense project settlement. This module supports user-defined settlement rules to meet the settlement requirements of different projects and implements version management for settlement rules.

[0097] Step 7, Settlement Generation: The settlement generation module automatically generates a settlement report based on the data provided by the data processing module, the engineering quantity calculated by the engineering quantity calculation module, the price information provided by the price analysis module, and the rules established by the settlement rule management module. It also supports exporting and printing the report.

[0098] Step 8. Settlement Audit: The settlement audit module audits the rationality, accuracy, and compliance of the generated settlement reports. Auditors conduct online audits and provide comments and suggestions, and record the audit process to ensure traceability.

[0099] Step 9: Data Analysis and Decision Support: Use the data analysis and decision support module to analyze and mine historical settlement data, and display the analysis results through data visualization technology to provide support for project management and decision-making;

[0100] Step 10. User management: Manage system user information, assign user permissions, and record user operation logs through the user management module to ensure system security and confidentiality.

[0101] Example

[0102] Data collection example:

[0103] In a certain air defense engineering project, the data collection module connects with the engineering management system to obtain basic project information, design drawings, construction progress, and other data. It also connects with the material supplier system to obtain data such as material purchase prices, specifications, and quantities. It also manually enters data such as visa and acceptance data. The collected data is initially verified, such as to ensure that material prices are within a reasonable range and that construction quantity data is consistent with the design drawings, to remove duplicate and erroneous data.

[0104] Data processing example:

[0105] Data mining is performed on collected historical material price data, using time series analysis to establish a material price forecasting model. This model is used to predict future material prices, providing a reference for current project settlements. For example, if the price of a certain type of steel is predicted to increase by 10% over the next three months, this price increase can be factored into settlements.

[0106] Settlement generation and review implementation example:

[0107] The Settlement Generation Module automatically generates settlement reports based on the material price forecasts provided by the Data Processing Module, the project quantities calculated by the Project Quantity Calculation Module, and the pricing methods and fee standards established by the Settlement Rules Management Module. The Settlement Audit Module reviews the settlement reports, checking whether all expense calculations are correct and comply with relevant regulations and contract requirements. Auditors provide online review comments. If any errors are found in the project quantity calculations for a particular sub-project, the report is returned to the Project Quantity Calculation Module for correction. The settlement report is then regenerated and reviewed again until it passes approval.

[0108] Although the present invention has been described in detail with reference to the aforementioned embodiments, it is still possible for those skilled in the art to modify the technical solutions described in the aforementioned embodiments, or to make equivalent substitutions for some of the technical features therein. Any modifications, equivalent substitutions, improvements, etc. made within the spirit and principles of the present invention should be included in the scope of protection of the present invention.

Claims

1. A civil air defense project settlement system based on big data, characterized by: It includes data acquisition module, data storage module, data processing module, engineering quantity calculation module, price analysis module, settlement rule management module, settlement generation module, settlement review module, data analysis and decision support module and user management module; The data collection module is used to collect data related to the settlement of civil air defense projects, including basic project information, project quantity data, material price data, labor cost data, equipment rental data, design change data, visa data and acceptance data; The data storage module classifies and stores the collected data to establish data; The data processing module processes and analyzes the stored data, including data cleaning, data integration, data conversion and data mining; The engineering quantity calculation module calculates the engineering quantity using big data technology according to engineering design drawings and relevant specifications; The price analysis module performs real-time analysis and monitoring of material prices, labor costs, and equipment rental prices; The settlement rule management module is used to formulate and manage the rules and standards for civil air defense project settlement, including pricing methods, fee standards and settlement methods; The settlement generation module automatically generates a settlement report based on the data provided by the data processing module, the engineering quantity calculated by the engineering quantity calculation module, the price information provided by the price analysis module, and the rules formulated by the settlement rule management module; The settlement audit module audits the generated settlement reports, including rationality audit, accuracy audit and compliance audit; The data analysis and decision support module analyzes and mines historical settlement data to provide support for project management and decision-making; The user management module is used to manage user information of the system, including user registration, login and authority management.

2. The big data-based civil air defense project settlement system according to claim 1, characterized in that: The data acquisition module acquires data by connecting with the engineering management system, material supplier system, human resource management system, equipment rental system or other external systems, as well as manually entering data; in order to ensure the accuracy and completeness of the data, the collected data is preliminarily verified and cleaned to remove duplicate and erroneous data; The accuracy of data collection is evaluated using the following formula: Among them, A represents the accuracy of data collection, N c Indicates the amount of correctly collected data, N t Indicates the total amount of data that should be collected.

3. The civil air defense project settlement system based on big data according to claim 1 is characterized by: The data storage module adopts distributed database technology to achieve efficient data storage and management; the database includes project information database, project quantity database, material price database, labor cost database, equipment rental database, design change database, visa database, and acceptance database; the data is encrypted to ensure data security; Data cleaning in the data processing module further removes noise data and abnormal data, data integration integrates data from different sources, data conversion converts data into a format suitable for analysis, and data mining uses big data analysis technology to explore potential patterns and valuable information in the data.

4. The big data-based civil air defense project settlement system according to claim 3 is characterized by: The big data analysis technology is used to realize intelligent analysis of civil air defense project settlement, and its specific steps are as follows: Data Collection: Through IoT sensors, BIM models, financial systems, construction management platforms, or other multi-source channels, real-time data collection is carried out on the entire life cycle of civil air defense projects, including structured and unstructured data on project design parameters, construction progress, material procurement records, staff hours, equipment usage data, and change approval forms. Data cleaning and preprocessing: Use ETL tools to process raw data, identify and correct missing values, duplicate values, and outliers, unify data formats and coding standards, and improve data quality; Data storage and management: Store processed data in a distributed file system or column-based database to build a civil air defense project settlement data warehouse; use a data layered architecture to achieve efficient data management and query; Data analysis and modeling: Association analysis: Use the Apriori algorithm or FP-Growth algorithm to explore potential associations between data, such as analyzing the relationship between material price fluctuations and market supply and demand, and the relationship between construction process changes and cost increases; Cluster analysis: Using algorithms such as K-Means and hierarchical clustering, similar civil air defense projects are classified, settlement indicators of similar projects are compared, and abnormal cost items are identified; Predictive analysis: Based on time series algorithms or regression models, combined with historical settlement data and real-time project data, predict the final cost and duration risk of the project; Data visualization and decision support: The analysis results are presented intuitively in the form of charts and dashboards to provide data support for settlement auditors, helping them to quickly locate settlement disputes and formulate reasonable settlement plans.

5. The civil air defense project settlement system based on big data according to claim 1 is characterized by: The engineering quantity calculation module establishes an engineering quantity calculation model, combining historical engineering data with the characteristics of the current project to improve the accuracy and efficiency of engineering quantity calculation. For complex civil air defense engineering structures, 3D modeling technology is used to achieve visual calculation of engineering quantities. The basic model for engineering quantity calculation is constructed based on the following formula: Among them, V represents the total project volume; n is the number of components calculated by length, width and height, L i 、W i 、H i are the length, width, and height of the i-th component respectively; m is the number of components calculated by area, S j is the area of ​​the jth component; In practical applications, combining BIM model parameters and construction drawing data, obtaining component geometric dimensions in real time through API interfaces, and developing algorithms using Python or Java programming languages ​​to achieve automated calculations; The price analysis module obtains the latest price information by connecting with the market price database, analyzes price fluctuation trends, and provides a reasonable price basis for settlement; establishes a price early warning mechanism, and issues early warning signals in a timely manner when price fluctuations exceed a certain range.

6. The civil air defense project settlement system based on big data according to claim 1 is characterized by: The settlement rule management module supports user-defined settlement rules to meet the settlement requirements of different projects; it also manages the settlement rules to ensure consistency and traceability. The settlement report in the settlement generation module includes the total project settlement price, the settlement price of each sub-project, the settlement price of material costs, the settlement price of labor costs, and the settlement price of equipment rental costs; and supports the export and printing of settlement reports.

7. The civil air defense project settlement system based on big data according to claim 1 is characterized by: In the settlement audit module, auditors can conduct online audits through the system, provide audit opinions and suggestions, and record the audit process to ensure the traceability of the audit; The analysis content in the data analysis and decision support module includes the composition of project costs, the impact of price fluctuations on project costs, and settlement cycle analysis; through data visualization technology, the analysis results are displayed in the form of charts and reports, which allows users to intuitively understand the project settlement status.

8. The civil air defense project settlement system based on big data according to claim 1 is characterized by: The user management module assigns different operating permissions according to the user's role and responsibilities to ensure the security and confidentiality of the system; and records the user's operation log to facilitate auditing and supervision of user behavior.

9. A settlement method for a civil air defense project settlement system based on big data according to any one of claims 1 to 8, characterized in that: The following steps are involved: Step 1: Data collection: Collect data related to civil air defense project settlement from external systems and manual input through the data collection module, and perform preliminary verification and cleaning on the collected data to ensure the accuracy and completeness of the data; Step 2, data storage: the cleaned data is classified and stored in the database of the data storage module, and distributed database technology is used to achieve efficient storage and management of data, and the data is encrypted; Step 3: Data processing: Use the data processing module to clean, integrate, convert, and mine the stored data, uncovering potential patterns and valuable information in the data to provide support for subsequent settlement work; Step 4: Calculate the quantity of work: Based on the engineering design drawings and relevant specifications, use the quantity calculation model established by the quantity calculation module, combine historical engineering data and the characteristics of the current project, calculate the quantity of work, and improve the accuracy and efficiency of the calculation; Step 5. Price Analysis: The price analysis module connects to the market price database to obtain the latest information on material prices, labor costs, and equipment rental prices, analyzes price fluctuation trends, provides a reasonable price basis for settlement, and establishes a price early warning mechanism; Step 6. Settlement rule development: The settlement rule management module is used to develop and manage the rules and standards for civil air defense project settlement. This module supports user-defined settlement rules to meet the settlement requirements of different projects and implements version management for settlement rules. Step 7, Settlement Generation: The settlement generation module automatically generates a settlement report based on the data provided by the data processing module, the engineering quantity calculated by the engineering quantity calculation module, the price information provided by the price analysis module, and the rules established by the settlement rule management module. It also supports exporting and printing the report. Step 8. Settlement Audit: The settlement audit module audits the rationality, accuracy, and compliance of the generated settlement reports. Auditors conduct online audits and provide comments and suggestions, and record the audit process to ensure traceability. Step 9: Data Analysis and Decision Support: Use the data analysis and decision support module to analyze and mine historical settlement data, and display the analysis results through data visualization technology to provide support for project management and decision-making; Step 10. User management: Manage system user information, assign user permissions, and record user operation logs through the user management module to ensure system security and confidentiality.

Images