A construction data processing method and system

Abstract

The application discloses a kind of construction data processing method and system, it is related to data processing technical field, including control center, the control center is connected with data acquisition module, construction processing module, terminal analysis module and data integration module;Comprehensive operation data in the process of construction is collected by data acquisition module;Comprehensive operation data is converted in construction processing module signal, obtains comprehensive operation signal, sets adjustment window function and generates initial frequency spectrum graph to the one-way action and fourier transform of comprehensive operation signal;Frequency transformation is carried out to initial frequency spectrum graph in terminal analysis module, obtains difference frequency, according to difference frequency, sets comprehensive extraction filter group and generates comprehensive frequency spectrum graph to the filter response of sample signal spectrum;According to comprehensive frequency spectrum graph, coincidence comparison and coincidence deletion are carried out to comprehensive operation data in data integration module, obtain data integration report;Improve construction efficiency and safety, help control cost, optimize resource allocation.

Description

Technical Field

[0001] This invention relates to the field of data processing technology, specifically a method and system for processing construction data. Background Technology

[0002] Construction data processing refers to the activities of organizing, analyzing, and managing various data collected during the construction process. This data may include information from multiple aspects such as engineering design drawings, construction progress, resource consumption, quality control, safety management, and cost budgeting. Data collection, organization, and analysis are crucial stages in construction, but traditional data processing methods are inefficient and produce unstable data, failing to meet the needs of modern construction management. Therefore, efficient processing of construction data to improve construction safety has significant theoretical and practical implications.

[0003] How to utilize data processing technology to perform signal conversion on the collected comprehensive operation data to obtain a comprehensive operation signal, set an adjustment window function to perform unidirectional action and Fourier transform on the comprehensive operation signal and generate an initial spectrum; set a comprehensive extraction filter group to filter the spectrum of the sample signal and generate a comprehensive spectrum; and perform overlap comparison and overlap deletion on the comprehensive operation data based on the comprehensive spectrum to obtain a data integration report are the problems we need to solve. To this end, we now provide a construction data processing method and system. Summary of the Invention

[0004] The purpose of this invention is to provide a method and system for processing building construction data.

[0005] The objective of this invention can be achieved through the following technical solutions:

[0006] A construction data processing system includes a control center, which is connected to a data acquisition module, a construction processing module, a terminal analysis module, and a data integration module.

[0007] The data acquisition module is used to collect comprehensive operational data and statistical time during the construction process;

[0008] The process of obtaining the adjustment window function based on the signal window includes:

[0009] The obtained integrated operation data is converted into integrated operation signals and integrated frequencies.

[0010] Set the data collection period based on the obtained statistical time, and set the signal window based on the comprehensive operation signal according to the data collection period;

[0011] Set the adjustment window function based on the obtained signal window.

[0012] The process of generating an initial spectrogram based on the obtained sample signal spectrum includes:

[0013] The obtained adjustment window function is used to apply a one-way action to the integrated operation signal to obtain the upgraded operation signal;

[0014] Perform a Fourier transform on the obtained stage operation signal to obtain the sample signal spectrum, and generate an initial spectrum diagram based on the obtained sample signal spectrum.

[0015] The process of obtaining the differential frequency includes:

[0016] Set the filter frequency based on the obtained composite frequency;

[0017] The obtained filter frequencies are statistically analyzed to obtain the filter frequency range;

[0018] The normalized frequency is obtained based on the obtained filter range;

[0019] The obtained normalized frequency is mapped onto the initial spectrum to obtain the differential frequency.

[0020] The process of taking logarithmic values ​​and discretizing features from sample responses to generate a comprehensive spectrogram includes:

[0021] Set up a comprehensive extraction filter group based on the obtained differential frequency;

[0022] The sample signal spectrum is filtered according to the set comprehensive extraction filter group to obtain the sample response;

[0023] The logarithmic value of the obtained sample response is taken to obtain the comprehensive energy;

[0024] The obtained comprehensive energy is discretized to obtain the stage spectrum parameters;

[0025] A comprehensive spectrum diagram is generated based on the obtained stage spectrum parameters.

[0026] The process of generating a data integration report based on a single aggregated dataset includes:

[0027] The obtained integrated spectrum diagram is correlated with the corresponding integrated operation data;

[0028] The obtained composite spectrograms are compared for overlap to obtain duplicate spectrograms and special spectrograms;

[0029] Obtain the comprehensive operation data associated with the repeated spectrum map, and record it as the pre-repeated operation data. Perform overlap comparison on the pre-repeated operation data to obtain the repeated operation data and the special operation data.

[0030] The duplicate data and duplicate spectrograms obtained are deduplicated to obtain a single composite data and a single spectrogram;

[0031] A data integration report is generated based on the statistical time frame, using the obtained single comprehensive data, single spectrogram, special feature comprehensive data, and special feature spectrogram.

[0032] Based on the above-mentioned construction data processing system, the present invention also provides a construction data processing method, comprising the following steps:

[0033] Step 1: Collect comprehensive operational data and statistical time during the construction process;

[0034] Step 2: Perform signal conversion on the collected integrated operation data to obtain the integrated operation signal and integrated frequency, set the signal window, obtain the adjustment window function based on the signal window, apply the obtained adjustment window function to the integrated operation signal in one direction and perform Fourier transform to obtain the sample signal spectrum, and generate the initial spectrum diagram based on the obtained sample signal spectrum.

[0035] Step 3: Obtain the filtering range based on the comprehensive frequency, obtain the normalized frequency based on the obtained filtering range, map the obtained normalized frequency onto the initial spectrum diagram to obtain the differential frequency, set the comprehensive extraction filter group based on the obtained differential frequency to filter the sample signal spectrum to obtain the sample response, perform logarithmic value taking and feature discretization on the sample response and generate the comprehensive spectrum diagram.

[0036] Step 4: Compare the composite spectrum to obtain duplicate spectrums, delete duplicate composite operation data corresponding to the duplicate spectrums to obtain single composite data, and generate a data integration report based on the single composite data.

[0037] Compared with the prior art, the beneficial effects of the present invention are as follows: Signal conversion is performed on the collected integrated operation data to obtain the integrated operation signal and integrated frequency; a signal window is set; an adjustment window function is obtained based on the signal window; the integrated operation signal is unidirectionally acted upon and Fourier transform is performed based on the obtained adjustment window function to obtain the sample signal spectrum; an initial spectrum diagram is generated based on the obtained sample signal spectrum; converting the data into a spectrum diagram form that can be intuitively displayed is a visualization process for the data, which is beneficial for subsequent frequency setting and frequency variation of the initial spectrum diagram to obtain differential frequencies; the obtained differential frequencies are used to construct an integrated extraction filter group.

[0038] The comprehensive extraction filter group performs filtering response and logarithmic value on the spectrum of the sample signal to obtain comprehensive energy. The obtained comprehensive energy is then discretized to obtain stage spectrum parameters. A comprehensive spectrum map is generated based on the obtained stage spectrum parameters. The comprehensive spectrum map obtained from the comprehensive extraction filter group is used to extract features again from the initial spectrum map, retaining important frequency components, reducing computational complexity, and improving the data processing speed.

[0039] By comparing and deleting duplicates in the comprehensive operation data using a comprehensive spectrum diagram, a data integration report is obtained; this reduces data storage space, facilitates communication and transmission between different construction departments, and better coordinates construction progress and resource allocation. Attached Figure Description

[0040] To more clearly illustrate the technical solutions in the embodiments of the present invention or the prior art, the drawings used in the description of the embodiments or the prior art will be briefly introduced below. Obviously, the drawings described below are only some embodiments of the present invention. For those skilled in the art, other drawings can be obtained based on these drawings without creative effort.

[0041] Figure 1 This is a schematic diagram of the present invention. Detailed Implementation

[0042] The technical solution of the present invention will be clearly and completely described below with reference to the embodiments. Obviously, the described embodiments are only some embodiments of the present invention, and not all embodiments. Based on the embodiments of the present invention, all other embodiments obtained by those skilled in the art without creative effort are within the scope of protection of the present invention.

[0043] like Figure 1 As shown, a construction data processing system includes a control center, which is connected to a data acquisition module, a construction processing module, a terminal analysis module, and a data integration module.

[0044] The data acquisition module is used to collect comprehensive operational data during the construction process, and the specific process includes:

[0045] Set up an engineering data acquisition terminal to collect comprehensive data during the construction process, obtain comprehensive operation data, and mark the time of collection of comprehensive operation data as the statistical time;

[0046] It should be further clarified that, in the specific implementation process, the comprehensive operational information includes all data generated during the construction process, including design data, construction organization data, construction personnel data, building material data, equipment data, quality control data, safety management data, cost data, schedule data, environmental monitoring data, coordination and communication data, and customer feedback data. Therefore, processing and analyzing the comprehensive operational data involves processing and analyzing the design data, construction organization data, construction personnel data, building material data, equipment data, quality control data, safety management data, cost data, schedule data, environmental monitoring data, coordination and communication data, and customer feedback data included in the comprehensive operational data separately.

[0047] The construction processing module is used to perform signal conversion on the collected comprehensive operation data to obtain the comprehensive operation signal and comprehensive frequency, set a signal window, obtain an adjustment window function based on the signal window, apply a one-way action to the comprehensive operation signal and perform a Fourier transform based on the obtained adjustment window function to obtain the sample signal spectrum, and generate an initial spectrum diagram based on the obtained sample signal spectrum. The specific process includes:

[0048] The obtained integrated operation data is converted into integrated operation signals and integrated frequencies.

[0049] The obtained composite frequency is labeled as f. 综 The integrated frequency is the number of times the integrated operation signal is sampled per second;

[0050] It should be further explained that, in the specific implementation process, signal conversion of comprehensive operation data involves converting all the data included in the comprehensive operation data, such as design data, construction organization data, construction personnel data, building material data, equipment data, quality control data, safety management data, cost data, schedule data, environmental monitoring data, coordination and communication data, and customer feedback data, into signal signals to obtain design data signals, construction organization data signals, construction personnel data signals, building material data signals, equipment data signals, quality control data signals, safety management data signals, cost data signals, schedule data signals, environmental monitoring data signals, coordination and communication data signals, and customer feedback data signals.

[0051] The acquisition period is set according to the obtained statistical time, and the signal window is set according to the obtained comprehensive operation signal based on the acquisition period. The signal window includes window length, front-end parameters and window coefficient.

[0052] The obtained window length is labeled as N, the obtained front-end parameter is labeled as β, and the obtained window coefficient is labeled as Q;

[0053] Furthermore, the window length is a limitation on the length range of the integrated operation signal within the signal window, the front-end parameter is between 4 and 6, and the window coefficient depends on the window length and the front-end parameter, and is obtained according to the Kaiser function, i.e., Q = Kaiser(N, β).

[0054] Based on the obtained signal window, set the adjustment window function, and label the obtained adjustment window function as T(n), where, I0(·) represents the zero-order Bessel function, which is used to control the shape and index number of the adjustment window function. n is an integer from 0 to N-1, where n represents each sample point in the adjustment window function.

[0055] The obtained adjustment window function is used to apply a unidirectional effect to the comprehensive operation signal to obtain the incremental operation signal. The obtained incremental operation signal is denoted as W(n), where... And 0≤n≤N-1, X 综 Indicates integrated operation signal;

[0056] Perform a Fourier transform on the obtained stage operation signal to obtain the sample signal spectrum, and generate an initial spectrum diagram based on the obtained sample signal spectrum.

[0057] The terminal analysis module is used to obtain a filtering range based on the comprehensive frequency, obtain a normalized frequency based on the obtained filtering range, map the obtained normalized frequency onto the initial spectrum diagram to obtain a differential frequency, set a comprehensive extraction filter group based on the obtained differential frequency to filter the sample signal spectrum to obtain a sample response, perform logarithmic value taking and feature discretization on the sample response, and generate a comprehensive spectrum diagram. The specific process includes:

[0058] Set the filter frequency based on the obtained comprehensive frequency, and mark the obtained filter frequency as LP;

[0059] The obtained filter frequencies are statistically analyzed to obtain the filter frequency range, which is then denoted as {LP}, where {LP} = [0, f 综 '*W], where W represents the frequency range determined by the integrated operation signal, f 综 ' represents the difference between the maximum and minimum values ​​of the filter frequency;

[0060] The normalized frequency is obtained based on the obtained filter range, and the obtained normalized frequency is denoted as f. 归 ,in,

[0061] The obtained normalized frequency is mapped onto the initial spectrum to obtain the differential frequency, which is denoted as C. d represents the number of sample points in the spectrum of the sample signal in the initial spectrum diagram;

[0062] Based on the obtained differential frequency, set up a comprehensive extraction filter group, mark the number of filters in the comprehensive extraction filter group as B, and mark the filters in the comprehensive extraction filter group as stable triangular filters.

[0063] The stable triangular filter is determined by three consecutive differential frequencies. The three consecutive differential frequencies are labeled as the left differential frequency, the center differential frequency, and the right differential frequency, respectively. The obtained left differential frequency is labeled as C1, the obtained right differential frequency is labeled as C2, and the obtained center differential frequency is labeled as C0.

[0064] The sample signal spectrum is filtered according to the set integrated extraction filter group to obtain the sample response, and the obtained sample response is labeled as H. B (C), where, And C1≠B C ≠C2, B C Indicates the differential frequency of the filter;

[0065] The logarithm of the obtained sample responses is taken to obtain the comprehensive energy, which is denoted as S(d), where, Z 样 (d) is the spectrum of the sample signal;

[0066] The obtained comprehensive energy is discretized to obtain the stage spectrum parameters;

[0067] It should be further explained that, in the specific implementation process, the feature discretization is to perform a discrete cosine transform on the comprehensive energy to obtain the stage spectrum parameters;

[0068] A comprehensive spectrum diagram is generated based on the obtained stage spectrum parameters.

[0069] The data integration module is used to compare the composite spectrum to obtain duplicate spectrum maps, delete duplicate composite operation data corresponding to the duplicate spectrum maps, obtain single composite data, and generate a data integration report based on the single composite data. The specific process includes:

[0070] The obtained integrated spectrum diagram is correlated with the corresponding integrated operation data;

[0071] The obtained composite spectrograms are compared for overlap to obtain duplicate spectrograms and special spectrograms;

[0072] Furthermore, the overlap comparison involves mapping two composite spectrograms to the same spectrogram for comparison. If the spectral curves in the spectrograms overlap at the same statistical time, the two overlapping spectrograms are marked as duplicate spectrograms. In particular, the special spectrogram indicates that the two composite spectrograms being compared do not overlap, that is, there is no spectrogram identical to the composite spectrogram being compared, and it is denoted as a special spectrogram.

[0073] Obtain the comprehensive operation data associated with the repeated spectrum map, and record it as the pre-repeated operation data. Perform overlap comparison on the pre-repeated operation data to obtain the repeated operation data and the special operation data.

[0074] Specifically, the special task data refers to the two comprehensive task data being compared that do not overlap, that is, there is no task data that is the same as the comprehensive task data being compared, and this is recorded as special task data;

[0075] The duplicate data and duplicate spectrograms obtained are deduplicated to obtain a single composite data and a single spectrogram;

[0076] Furthermore, deduplication means removing one of two duplicate composite job data and keeping the other. Deduplication of duplicate spectrograms also means keeping one composite spectrogram. By processing the composite job data to obtain the composite spectrogram and deduplicating the spectrogram, a single composite job data is obtained, which helps to reduce storage space and increase data cleanliness.

[0077] A data integration report is generated based on the statistical time frame, using the obtained single comprehensive data, single spectrogram, special edition comprehensive data, and special edition spectrogram.

[0078] It should be further explained that, in the specific implementation process, the comprehensive operation data in the data integration report is generated according to the time sequence of the statistical time, and there are no duplicate comprehensive spectrum diagrams and comprehensive operation data; the data is effectively cleaned, and subtle changes in the data can be easily observed based on the spectrum diagram of the obtained comprehensive operation data.

[0079] Based on the above-mentioned construction data processing system, the present invention also provides a construction data processing method, comprising the following steps:

[0080] Step 1: Collect comprehensive operational data and statistical time during the construction process;

[0081] Step 2: Perform signal conversion on the collected integrated operation data to obtain the integrated operation signal and integrated frequency, set the signal window, obtain the adjustment window function based on the signal window, apply the obtained adjustment window function to the integrated operation signal in one direction and perform Fourier transform to obtain the sample signal spectrum, and generate the initial spectrum diagram based on the obtained sample signal spectrum.

[0082] Step 3: Obtain the filtering range based on the comprehensive frequency, obtain the normalized frequency based on the obtained filtering range, map the obtained normalized frequency onto the initial spectrum diagram to obtain the differential frequency, set the comprehensive extraction filter group based on the obtained differential frequency to filter the sample signal spectrum to obtain the sample response, perform logarithmic value taking and feature discretization on the sample response and generate the comprehensive spectrum diagram.

[0083] Step 4: Compare the composite spectrum to obtain duplicate spectrums, delete duplicate composite operation data corresponding to the duplicate spectrums to obtain single composite data, and generate a data integration report based on the single composite data.

[0084] This invention proposes a method and system for processing construction data. Through data processing technology, it performs signal conversion on collected comprehensive operation data to obtain comprehensive operation signals and comprehensive frequencies. A signal window is set, and an adjustment window function is obtained based on the signal window. The obtained adjustment window function is then used to apply a one-way action to the comprehensive operation signal and perform a Fourier transform to obtain the sample signal spectrum. An initial spectrum diagram is generated based on the obtained sample signal spectrum. Converting the data into a visually representable spectrum diagram is a visualization process that facilitates subsequent frequency setting and variation of the initial spectrum diagram to obtain differential frequencies. These differential frequencies are then used to construct a comprehensive extraction filter group.

[0085] The comprehensive extraction filter group performs filtering response and logarithmic value on the spectrum of the sample signal to obtain comprehensive energy. The obtained comprehensive energy is then discretized to obtain stage spectrum parameters. A comprehensive spectrum map is generated based on the obtained stage spectrum parameters. The comprehensive spectrum map obtained from the comprehensive extraction filter group is used to extract features again from the initial spectrum map, retaining important frequency components, reducing computational complexity, and improving the data processing speed.

[0086] By comparing and deleting duplicates in the comprehensive operation data using a comprehensive spectrum diagram, a data integration report is obtained; this reduces data storage space, facilitates communication and transmission between different construction departments, and better coordinates construction progress and resource allocation.

[0087] The preferred embodiments of the present invention disclosed above are merely illustrative of the invention. These preferred embodiments do not exhaustively describe all details, nor do they limit the invention to any specific implementation. Clearly, many modifications and variations can be made based on the content of this specification. This specification selects and specifically describes these embodiments to better explain the principles and practical applications of the invention, thereby enabling those skilled in the art to better understand and utilize the invention. The invention is limited only by the claims and their full scope and equivalents.

Claims

1. A construction data processing system, comprising a control center, characterized in that, The control center is connected to a data acquisition module, a construction processing module, a terminal analysis module, and a data integration module; The data acquisition module is used to collect comprehensive operational data and statistical time during the construction process; The construction processing module is used to perform signal conversion on the collected comprehensive operation data to obtain the comprehensive operation signal and comprehensive frequency, set a signal window, obtain an adjustment window function based on the signal window, apply a one-way action to the comprehensive operation signal and perform a Fourier transform based on the obtained adjustment window function to obtain the sample signal spectrum, and generate an initial spectrum diagram based on the obtained sample signal spectrum. The terminal analysis module is used to obtain the filtering range based on the comprehensive frequency, obtain the normalized frequency based on the obtained filtering range, map the obtained normalized frequency to the initial spectrum diagram to obtain the differential frequency, set the comprehensive extraction filter group to filter the sample signal spectrum based on the obtained differential frequency to obtain the sample response, perform logarithmic value taking and feature discretization on the sample response and generate a comprehensive spectrum diagram. The data integration module is used to compare the composite spectrum to obtain duplicate spectrums, delete duplicate composite operation data corresponding to the duplicate spectrums, obtain single composite data, and generate a data integration report based on the single composite data.

2. The construction data processing system according to claim 1, characterized in that, The process of obtaining the adjustment window function based on the signal window includes: The obtained integrated operation data is converted into integrated operation signals and integrated frequencies. Set the data collection period based on the obtained statistical time, and set the signal window based on the comprehensive operation signal according to the data collection period; Set the adjustment window function based on the obtained signal window.

3. The construction data processing system according to claim 2, characterized in that, The process of generating an initial spectrogram based on the obtained sample signal spectrum includes: The obtained adjustment window function is used to apply a one-way action to the integrated operation signal to obtain the upgraded operation signal; Perform a Fourier transform on the obtained stage operation signal to obtain the sample signal spectrum, and generate an initial spectrum diagram based on the obtained sample signal spectrum.

4. A construction data processing system according to claim 3, characterized in that, The process of obtaining the differential frequency includes: Set the filter frequency based on the obtained composite frequency; The obtained filter frequencies are statistically analyzed to obtain the filter frequency range; The normalized frequency is obtained based on the obtained filter range; The obtained normalized frequency is mapped onto the initial spectrum to obtain the differential frequency.

5. A construction data processing system according to claim 4, characterized in that, The process of taking logarithmic values ​​and discretizing features from sample responses to generate a comprehensive spectrogram includes: Set up a comprehensive extraction filter group based on the obtained differential frequency; The sample signal spectrum is filtered according to the set comprehensive extraction filter group to obtain the sample response; The logarithmic value of the obtained sample response is taken to obtain the comprehensive energy; The obtained comprehensive energy is discretized to obtain the stage spectrum parameters; A comprehensive spectrum diagram is generated based on the obtained stage spectrum parameters.

6. A construction data processing system according to claim 5, characterized in that, The process of generating a data integration report based on a single aggregated dataset includes: The obtained integrated spectrum diagram is correlated with the corresponding integrated operation data; The obtained composite spectrograms are compared for overlap to obtain duplicate spectrograms and special spectrograms; Obtain the comprehensive operation data associated with the repeated spectrum map, and record it as the pre-repeated operation data. Perform overlap comparison on the pre-repeated operation data to obtain the repeated operation data and the special operation data. The duplicate data and duplicate spectrograms obtained are deduplicated to obtain a single composite data and a single spectrogram; A data integration report is generated based on the statistical time frame, using the obtained single comprehensive data, single spectrogram, special feature comprehensive data, and special feature spectrogram.

7. A construction data processing method for a construction data processing system according to any one of claims 1 to 6, characterized in that, Includes the following steps: Step 1: Collect comprehensive operational data and statistical time during the construction process; Step 2: Perform signal conversion on the collected integrated operation data to obtain the integrated operation signal and integrated frequency, set the signal window, obtain the adjustment window function based on the signal window, apply the obtained adjustment window function to the integrated operation signal in one direction and perform Fourier transform to obtain the sample signal spectrum, and generate the initial spectrum diagram based on the obtained sample signal spectrum. Step 3: Obtain the filtering range based on the comprehensive frequency, obtain the normalized frequency based on the obtained filtering range, map the obtained normalized frequency onto the initial spectrum diagram to obtain the differential frequency, set the comprehensive extraction filter group based on the obtained differential frequency to filter the sample signal spectrum to obtain the sample response, perform logarithmic value taking and feature discretization on the sample response and generate the comprehensive spectrum diagram. Step 4: Compare the composite spectrum to obtain duplicate spectrums, delete duplicate composite operation data corresponding to the duplicate spectrums to obtain single composite data, and generate a data integration report based on the single composite data.

Images