Method for generating engineering safety monitoring report

Abstract

The invention discloses a method for generating an engineering safety monitoring report, belongs to the technical field of engineering safety monitoring report compilation, and can solve the problem of low efficiency of an existing method. The method comprises the following steps: S1, constructing a visualization generation module of each presentation form in a plurality of presentation forms of monitoring contents according to an association relationship between the monitoring contents of a target project and a monitoring database; s2, constructing a monitoring report template of the target project according to a visualization generation module; and S3, according to the monitoring report template, generating a safety monitoring report of the target project by using the monitoring database. The method is used for compiling the engineering safety monitoring report.

Description

Technical Field

[0001] The invention relates to a method for generating an engineering safety monitoring report, and belongs to the technical field of engineering safety monitoring report compilation. Background Art

[0002] The project safety monitoring report is a systematic and objective analysis of the project's safety monitoring data, including daily, weekly, monthly and annual reports, which runs through the project construction and operation stages. The safety monitoring report can provide timely, accurate and comprehensive information support for technical personnel, help to timely discover and solve safety hazards in the project, and thus ensure the safe and stable operation of the project.

[0003] At present, the analysis and preparation of engineering safety monitoring reports are mainly done manually, resulting in low efficiency in the generation of safety monitoring reports. Especially for projects such as water conservancy and hydropower, which have long construction and operation periods, their safety monitoring reports have the characteristics of long time span, numerous monitoring data, and large amount of analysis data. The workload of manual analysis and preparation of safety monitoring reports is huge, which further reduces the generation efficiency. Summary of the invention

[0004] The present invention provides a method for generating an engineering safety monitoring report, which can solve the problem of low efficiency of the existing method.

[0005] The present invention provides a method for generating an engineering safety monitoring report, the method comprising: S1. Constructing a visualization generation module for each of a plurality of presentation forms of the monitoring content according to the association relationship between the monitoring content of the target project and the monitoring database; S2. Constructing a monitoring report template for the target project according to the visualization generation module; S3. Generate a safety monitoring report for the target project using the monitoring database according to the monitoring report template.

[0006] Optionally, the multiple presentation forms include process diagrams, lists, and text.

[0007] Optionally, constructing a visualization generation module for a process diagram of the monitoring content specifically includes: A data extraction unit is constructed by using a data acquisition algorithm; the data extraction unit is used to extract monitoring data corresponding to the monitoring content from the monitoring database; Constructing a visualization analysis unit according to the monitoring data; the visualization analysis unit is used to generate a process diagram of the monitoring content according to the monitoring data; A visualization generation module for constructing a process diagram of the monitoring content is constructed according to the data extraction unit and the visualization analysis unit.

[0008] Optionally, constructing a visualization generation module for the text of the monitoring content specifically includes: A text instruction unit for monitoring content is constructed using structured query language; the text instruction unit is used to generate text generation instructions for monitoring content, and adjust the text generation instructions using a grammar error correction algorithm; Constructing a text generation unit according to the adjusted text generation instruction; the text generation unit is used to generate the text of the monitoring content according to the adjusted text generation instruction; A visualization generation module for the text of the monitored content is constructed according to the text instruction unit and the text generation unit.

[0009] Optionally, constructing a visualization generation module for the text of the monitoring content specifically includes: Using structured query language to construct a text template of the monitoring content; Constructing a text replacement unit according to the text template; A visualization generation module for the text of the monitored content is constructed according to the text template and the text replacement unit.

[0010] Optionally, constructing a visualization generation module for the text of the monitoring content specifically includes: Using a pre-trained language model to construct a text generation framework for the monitoring content; A visualization generation module for the text of the monitored content is constructed according to the text generation framework.

[0011] Optionally, the S2 specifically includes: S21, constructing a visualized monitoring report page according to the monitoring content, and establishing a mapping relationship between the monitoring content in the monitoring report page and the visualization generation module; S22: construct a monitoring report template for the target project according to the monitoring report page, the visualization generation module and the mapping relationship.

[0012] Optionally, the S22 specifically includes: Constructing a content replacement unit for monitoring content in the monitoring report page according to the monitoring report page, the visualization generation module and the mapping relationship; A monitoring report template for the target project is constructed according to the monitoring report page and the content replacement unit.

[0013] Optionally, before S1, the method further includes: A plurality of monitoring data of the target project are fused and processed, and a monitoring database of the target project is constructed according to the fused monitoring data.

[0014] Optionally, the S3 specifically includes: According to the monitoring database, constructing a report generation unit using the monitoring report template; Constructing a report optimization unit and a report early warning unit according to the report generation unit; A safety monitoring report of the target project is generated according to the report generating unit, the report optimizing unit and the report early warning unit.

[0015] The beneficial effects that the present invention can produce include: The present invention constructs a visualization generation module for each presentation form of the monitoring content, and constructs a monitoring report template according to the visualization generation module. Then, based on the monitoring report template, a safety monitoring report is generated using the monitoring data in the monitoring database, thereby enabling automatic and efficient generation of the safety monitoring report, thereby improving the generation efficiency and quality of the monitoring report. BRIEF DESCRIPTION OF THE DRAWINGS

[0016] Figure 1 A flowchart of a method for generating an engineering safety monitoring report provided by an embodiment of the present invention; Figure 2 A schematic diagram of a visualization interface of a visualization subunit provided in an embodiment of the present invention; Figure 3 A schematic diagram of a visual interface of a text instruction unit and a text generation unit provided in an embodiment of the present invention; Figure 4 A schematic diagram of generating text based on a context-aware method provided by an embodiment of the present invention; Figure 5 A schematic diagram of a text generation instruction based on a text template provided in an embodiment of the present invention; Figure 6 A schematic diagram of a monitoring report template provided in an embodiment of the present invention. DETAILED DESCRIPTION

[0017] The present invention is described in detail below in conjunction with embodiments, but the present invention is not limited to these embodiments.

[0018] The embodiment of the present invention provides a method for generating a project safety monitoring report, such as Figure 1 As shown, the method includes: S1. According to the association between the monitoring content of the target project and the monitoring database, a visualization generation module for each of the multiple presentation forms of the monitoring content is constructed.

[0019] Specifically, the monitoring content refers to indicators such as settlement, temperature, humidity, displacement, and water level at a specific engineering site on the project. The correlation relationship refers to the correspondence between the monitoring content and the monitoring data in the monitoring database. The correlation relationship is determined by factors such as the construction method of the monitoring database and the data storage method of the monitoring equipment at the engineering site. Based on the correlation relationship, the monitoring data corresponding to the monitoring content in the monitoring database can be quickly extracted to facilitate subsequent analysis and processing of the monitoring content.

[0020] Before S1, the method may further include: The multiple monitoring data of the target project are fused and processed, and a monitoring database of the target project is constructed based on the fused multiple monitoring data.

[0021] Furthermore, multiple monitoring data of the target project are fused and processed, including: Determine the data formats of multiple monitoring data of the target project, and physically fuse the monitoring data of different data formats. At the same time, perform feature fusion on the historical data, real-time data and predicted data in the multiple monitoring data of the target project.

[0022] Specifically, the monitoring data of the project is often provided by different construction units, and each construction unit may use different data sources, resulting in different data formats of the monitoring data. Therefore, this embodiment requires physical fusion of monitoring data in different data formats. In practice, the data sources mainly include the following three types: (1) Databases, including MySQL, PostgreSQL, MongoDB, etc. (2) API interfaces, including RESTful, GraphQL, etc. (3) Local files, including CSV, Excel, JSON, etc.

[0023] This embodiment converts the monitoring data from the above three data sources into a preset data format and stores it in a monitoring database, thereby realizing the physical fusion of multi-source monitoring data.

[0024] At the same time, in order to ensure the objectivity of the monitoring data, this embodiment performs feature fusion on historical data, real-time data and predicted data. The specific steps of feature fusion are as follows: (1) Use timestamps to mark the time information of historical data, real-time data, and predicted data to establish a unified spatiotemporal coordinate system; (2) By performing sliding window regression analysis on historical data, outliers can be dynamically removed from real-time data, and systematic deviations can be corrected for predicted data, thus achieving intelligent processing of outliers. (3) Perform deep feature fusion on the historical data, real-time data, and predicted data processed in the previous step; (4) Perform a credibility assessment on the data after feature fusion. If it fails the credibility assessment, further correct the systematic bias and perform feature fusion again until it passes the credibility assessment.

[0025] This embodiment stores the fused multiple monitoring data in a preset database, thereby forming a monitoring database for the target project.

[0026] Specifically, the multiple presentation forms in S1 may include process diagrams, lists, and texts. The process diagrams include process line diagrams and characteristic value diagrams, etc. The characteristic values ​​refer to the maximum value, minimum value, average value, etc. of the monitored content; the lists include instrument statistics tables, monitoring instrument verification tables, characteristic value tables, etc.; the texts include concluding texts, which mainly summarize the cumulative measurement range and variation range of a certain engineering part, as well as the dynamic analysis and summary of the monitoring data of the engineering part, such as "the temperature measurement value is between X℃ and Y℃".

[0027] Specifically, the safety monitoring report is periodic, and a process line diagram, characteristic value diagram, instrument statistics table, monitoring instrument verification table, characteristic value table, and concluding text, etc., should be generated for each engineering part in each cycle. Since the format of the monitoring report of each cycle remains roughly unchanged, only the monitoring data changes, the monitoring report of each cycle only needs to replace the process line diagram, characteristic value diagram, characteristic value table, and concluding text, etc. Therefore, this embodiment can construct the presentation forms that need to be replaced, such as the process line diagram, characteristic value diagram, characteristic value table, and concluding text, into a visual generation module, so that these modules can be quickly called when the safety monitoring report is generated later, thereby improving the generation efficiency of the safety monitoring report.

[0028] Accordingly, S1 may specifically include: According to the relationship between the monitoring content of the target project and the monitoring database, a visualization generation module of the process diagram, list and text of the monitoring content is constructed.

[0029] Specifically, the visualization generation module for constructing the process diagram of the monitoring content may include: A data extraction unit is constructed by using a data acquisition algorithm; the data extraction unit is used to extract monitoring data corresponding to the monitoring content from the monitoring database; Construct a visualization analysis unit according to the monitoring data; the visualization analysis unit is used to generate a process diagram of the monitoring content according to the monitoring data; A visualization generation module for constructing a process diagram of monitoring content is constructed based on the data extraction unit and the visualization analysis unit.

[0030] In this embodiment, the data collection algorithm includes an intelligent data engine, and the data extraction unit can automatically analyze the association between the monitoring content and the monitoring database based on the intelligent data engine, thereby extracting the monitoring data corresponding to the monitoring content from the monitoring database.

[0031] In this embodiment, the visualization analysis unit is constructed according to the monitoring data; the visualization analysis unit is used to generate a process diagram of the monitoring content according to the monitoring data, which may specifically include: A time series analysis subunit is constructed based on the monitoring data; the time series analysis subunit is used to perform time series analysis on the monitoring data to obtain the change process information of the monitoring content; A visualization subunit is constructed according to the change process information of the monitored content; the visualization subunit is used to convert the change process information of the monitored content into a process diagram of the monitored content and present it visually.

[0032] The visualization interface of the visualization subunit of this embodiment is as follows: Figure 2 As shown. Through this visual interface, users can select the engineering parts and indicators for the process diagram to be generated, and can modify the style and content of the process diagram, and finally store the modified style template of the process diagram as a digital resource. When drawing the process diagram later, the style template of the process diagram can be called by starting the visual generation module of the process diagram to quickly draw the process diagram.

[0033] Furthermore, this embodiment can also use the symmetric encryption algorithm AES to encrypt and store the style template of the process diagram, ensuring the non-repetitiveness and confidentiality of the style template. At the same time, this embodiment adopts the digital resource hot-swap mode to manage the style template, which can realize the use of the style template as needed, and the use of the style template as needed, which is convenient for adjusting the style template.

[0034] Since the process diagram includes a process line diagram and a characteristic value diagram, the present embodiment can construct a visualization generation module for the process line diagram and a visualization generation module for the characteristic value diagram respectively according to the above method. The style template of the process line diagram provided in the present embodiment is as follows: Figure 2 shown.

[0035] Specifically, this embodiment can generate the text of the monitoring content based only on the dynamic construction method of the structured query language (SQL); it can also generate the text of the monitoring content based on the structured query language and the context-aware method; it can also generate the text of the monitoring content based on the structured query language and the pre-trained language model.

[0036] When the text of the monitoring content is generated only based on the dynamic construction method of the structured query language, the visualization generation module for constructing the text of the monitoring content may specifically include: A text instruction unit for monitoring content is constructed using structured query language; the text instruction unit is used to generate text generation instructions for monitoring content, and the text generation instructions are adjusted using a grammar error correction algorithm; Constructing a text generation unit according to the adjusted text generation instruction; the text generation unit is used to generate the text of the monitoring content according to the adjusted text generation instruction; A visualization generation module for the text of the monitoring content is constructed according to the text instruction unit and the text generation unit.

[0037] Specifically, the text instruction unit and the text generation unit can be implemented as follows: Figure 3 The visual interface shown interacts with the user, and the visual presentation of the text instruction unit is Figure 3 In the "sql content" input box, the visual presentation of the text generation unit is Figure 3 The "Execute SQL" button and the text display box that pops up after executing the text generation instruction.

[0038] Specifically, the text generation instruction is a query statement written in a structured query language, which can instruct the text generation unit to call monitoring data corresponding to the monitoring content from the monitoring database and generate the text of the monitoring content.

[0039] Specifically, users can Figure 3 Enter the text generation instruction written in structured query language in the "sql content" input box, and after clicking the "execute sql" button, the text generation unit generates the text of the monitoring content according to the text generation instruction and displays the generated text in the pop-up text display box.

[0040] Furthermore, in order to reduce grammatical errors in text generation instructions and improve the accuracy of sentences, the present embodiment also uses a grammatical error correction algorithm to adjust the text generation instructions written by the user. The grammatical error correction algorithm can mark errors in the text generation instructions and give modification suggestion prompt information so that the customer can modify them in time. On the other hand, it can also optimize and simulate the text generation instructions that the user has not completed or has completed, and generate multiple optimized instructions for the user to choose, thereby improving the accuracy of the instructions and the user's experience.

[0041] When the text of the monitoring content is generated based on the structured query language and the context-aware method, the visualization generation module for constructing the text of the monitoring content may specifically include: Use structured query language to construct text templates for monitoring content; A text replacement unit is constructed according to the text template and using a context-aware method; the text replacement unit is used to generate a text generation instruction according to the text template, and generate a text of the monitored content according to the text generation instruction; A visualization generation module for the text of the monitored content is constructed based on the text template and the text replacement unit.

[0042] Specifically, the text template is a query statement written in structured query language, which uses dynamic placeholders to represent information such as project location, indicators, time, etc. After calling the text template, the text replacement unit replaces the corresponding dynamic placeholders with the actual information of the monitoring content to quickly generate text generation instructions, and then extracts the monitoring data corresponding to the monitoring content from the monitoring database according to the text generation instructions to generate the text of the monitoring content. It can be seen that this method is more friendly to users with weak foundation in structured query language. Figure 4 As shown in the figure, users do not need to write structured query language, but only need to select the text template of structured query language and the project location, section and other information of the monitoring content on the visual interface to automatically generate the following Figure 5 The text generation instructions shown are as follows. After clicking the "Execute SQL" button, the generated text can be displayed in the pop-up text display box.

[0043] When the text of the monitoring content is generated based on the structured query language and the pre-trained language model, the visualization generation module for constructing the text of the monitoring content may specifically include: Use pre-trained language models to build a text generation framework for monitoring content; A visualization generation module for the text of the monitoring content is constructed based on the text generation framework.

[0044] Specifically, the steps for constructing the text generation framework are as follows: (1) Collect a large amount of text generation instructions written in the structured query language and the text generated after executing the text generation instructions to form raw data, and perform feature extraction on the raw data. For example, temperature measurement data can be converted into feature vectors containing minimum value, maximum value, monthly variation, annual variation, and number of abnormal points. The feature vectors of the raw data are combined into a training data set.

[0045] (2) Use the training dataset to fine-tune the pre-trained language model so that it can understand the semantic logic of specific industries such as engineering monitoring, thereby constructing a text generation framework for monitoring content.

[0046] Using this method, the text generation framework can dynamically generate text according to data features without the need for fixed text templates. At the same time, users can score or modify the generated text. The text generation framework can perform online learning and optimization based on user feedback to gradually improve the quality of text generation.

[0047] Specifically, the visualization generation module for constructing a list of monitoring contents may include: A visualization generation module for constructing a list of monitored contents based on the text of the monitored contents.

[0048] Specifically, the visualization generation module of the list first obtains the text of the monitored content, and then typesets and presents the text in a table form to obtain a list of the monitored content.

[0049] S2. Construct a monitoring report template for the target project based on the visualization generation module.

[0050] S2 can specifically include: S21. Construct a visualized monitoring report page according to the monitoring content, and establish a mapping relationship between the monitoring content in the monitoring report page and the visualization generation module; S22. Construct a monitoring report template for the target project according to the monitoring report page, the visualization generation module and the mapping relationship.

[0051] S22 may specifically include: According to the monitoring report page, the visualization generation module and the mapping relationship, a content replacement unit of the monitoring content in the monitoring report page is constructed; Construct a monitoring report template for the target project based on the monitoring report page and content replacement units.

[0052] Specifically, this embodiment uses a rich text editing component to construct a visual monitoring report page, which supports users to complete the customized design of the monitoring report template through graphical operations. The rich text editing component breaks through the format limitations of the traditional template system, is compatible with nested applications of multi-level titles, mixed layout styles, and dynamic placeholders, realizes the three-dimensional spatial positioning of template elements, and can support users to define and edit monitoring report templates.

[0053] Specifically, constructing a mapping relationship between the monitoring content and the visualization generation module in the monitoring report page refers to establishing a corresponding relationship between the monitoring report page and the storage locations of different visualization generation modules, so that the monitoring report page can call the corresponding visualization generation module in time according to the presentation form of the monitoring content.

[0054] Specifically, the monitoring report page uses dynamic placeholders to represent different visualization generation modules at the preset positions of the monitoring content to be generated. After the content replacement unit calls the corresponding visualization generation module according to the mapping relationship, it replaces the corresponding dynamic placeholder on the monitoring report page with the visualization generation module, and the required monitoring report template can be quickly generated. Figure 6 shown.

[0055] Specifically, the content replacement unit may replace the dynamic placeholder with the visualization generation module according to the mapping relationship and based on a regular expression and / or a context-aware method.

[0056] Furthermore, when the name of the visualization generation module is consistent with the name of the presentation form of the monitoring content at a preset position in the monitoring report page, this embodiment can automatically insert the visualization generation module into the preset position of the monitoring report page according to the name.

[0057] Furthermore, this embodiment uses a storage method combining a non-relational database and a relational database to store the monitoring report template. Specifically, the metadata of the monitoring report template is stored in a MongoDB database, which can retain the complete typesetting style information of the template, and the configuration parameters of the monitoring report template are versioned through a MySQL database. At the same time, a two-way synchronization mechanism is established between the MongoDB database and the MySQL database to ensure the consistency of the template data.

[0058] S3. Generate a safety monitoring report for the target project using the monitoring database according to the monitoring report template.

[0059] S3 can specifically include: According to the monitoring database, a report generation unit is constructed using the monitoring report template; Construct a report optimization unit and a report early warning unit according to the report generation unit; A safety monitoring report for the target project is generated according to the report generation unit, the report optimization unit and the report early warning unit.

[0060] Specifically, the report generating unit may start the monitoring report template according to a preset generating strategy, and generate a safety monitoring report based on the monitoring data in the format of the monitoring report template.

[0061] Generation strategies can include scheduled generation, event triggering and manual triggering, among which scheduled generation means automatically generating reports at a set time, event triggering means automatically generating reports when new monitoring data is collected, and manual triggering means generating reports in real time according to user instructions.

[0062] After the report generation unit starts the monitoring report template, the monitoring report template enables the corresponding visualization generation module, and the visualization generation module calls the monitoring data in the monitoring database, thereby generating a safety monitoring report according to the style of the monitoring report template.

[0063] Specifically, this embodiment adopts a caching strategy to improve the response speed of the report generation unit, and constructs a caching system for high-frequency reports based on four dimensions: report access frequency, data freshness, computing resource consumption, and user weight coefficient. At the same time, a cache pre-generation module is equipped to render predictive high-demand reports in advance to improve report visualization efficiency.

[0064] Specifically, the report optimization unit can identify format anomalies of the report through the visual rendering engine, and adjust the format of the report using a layout reconstruction algorithm to ensure that the format is presented completely.

[0065] Specifically, the report warning unit can use the Laida to accurately identify abnormal points such as inflection points of process lines and characteristic values, as well as value mutation points, and calculate the data deviation of the abnormal points. When the data deviation of the abnormal point exceeds a preset threshold, the report warning unit issues a warning to the user.

[0066] The present invention constructs a visualization generation module for each presentation form of the monitoring content, and constructs a monitoring report template according to the visualization generation module. Then, based on the monitoring report template, a safety monitoring report is generated using the monitoring data in the monitoring database, thereby enabling automatic and efficient generation of the safety monitoring report, thereby improving the generation efficiency and quality of the monitoring report.

[0067] The above are only a few embodiments of the present application and do not constitute any form of limitation to the present application. Although the present application is disclosed as above with preferred embodiments, it is not intended to limit the present application. Any technician familiar with the profession, without departing from the scope of the technical solution of the present application, using the technical content disclosed above to make slight changes or modifications are equivalent to equivalent implementation cases and fall within the scope of the technical solution.

Claims

1. A method for generating a project safety monitoring report, characterized in that: The method comprises: S1. Constructing a visualization generation module for each of a plurality of presentation forms of the monitoring content according to the association relationship between the monitoring content of the target project and the monitoring database; S2. Constructing a monitoring report template for the target project according to the visualization generation module; S3. Generate a safety monitoring report for the target project using the monitoring database according to the monitoring report template.

2. The method according to claim 1, characterized in that Multiple presentation formats include process diagrams, lists, and text.

3. The method according to claim 2, characterized in that The visualization generation module of the process diagram of the monitoring content is constructed, specifically including: A data extraction unit is constructed by using a data acquisition algorithm; the data extraction unit is used to extract monitoring data corresponding to the monitoring content from the monitoring database; Constructing a visualization analysis unit according to the monitoring data; the visualization analysis unit is used to generate a process diagram of the monitoring content according to the monitoring data; A visualization generation module for constructing a process diagram of the monitoring content is constructed according to the data extraction unit and the visualization analysis unit.

4. The method according to claim 2, characterized in that: Constructing a visualization generation module for the text of the monitoring content, specifically including: A text instruction unit for monitoring content is constructed by using structured query language; the text instruction unit is used to generate text generation instructions for monitoring content, and adjust the text generation instructions by using a grammar error correction algorithm; Constructing a text generation unit according to the adjusted text generation instruction; the text generation unit is used to generate the text of the monitoring content according to the adjusted text generation instruction; A visualization generation module for the text of the monitored content is constructed according to the text instruction unit and the text generation unit.

5. The method according to claim 2, characterized in that: Constructing a visualization generation module for the text of the monitoring content, specifically including: Using structured query language to construct a text template of the monitoring content; Constructing a text replacement unit according to the text template; A visualization generation module for the text of the monitored content is constructed according to the text template and the text replacement unit.

6. The method according to claim 2, characterized in that Constructing a visualization generation module for the text of the monitoring content, specifically including: Using a pre-trained language model to construct a text generation framework for the monitoring content; A visualization generation module for the text of the monitored content is constructed according to the text generation framework.

7. The method according to claim 1, characterized in that The S2 specifically includes: S21, constructing a visualized monitoring report page according to the monitoring content, and establishing a mapping relationship between the monitoring content in the monitoring report page and the visualization generation module; S22: construct a monitoring report template for the target project according to the monitoring report page, the visualization generation module and the mapping relationship.

8. The method according to claim 7, characterized in that The S22 specifically includes: Constructing a content replacement unit for monitoring content in the monitoring report page according to the monitoring report page, the visualization generation module and the mapping relationship; A monitoring report template for the target project is constructed according to the monitoring report page and the content replacement unit.

9. The method according to claim 1, characterized in that: Before S1, the method further includes: A plurality of monitoring data of the target project are fused and processed, and a monitoring database of the target project is constructed according to the fused monitoring data.

10. The method according to claim 1, characterized in that The S3 specifically includes: According to the monitoring database, constructing a report generation unit using the monitoring report template; Constructing a report optimization unit and a report early warning unit according to the report generation unit; A safety monitoring report of the target project is generated according to the report generating unit, the report optimizing unit and the report early warning unit.

Images