CN112052659A - Safety monitoring report generation method based on data self-adaptation - Google Patents
Safety monitoring report generation method based on data self-adaptation Download PDFInfo
- Publication number
- CN112052659A CN112052659A CN202010948712.1A CN202010948712A CN112052659A CN 112052659 A CN112052659 A CN 112052659A CN 202010948712 A CN202010948712 A CN 202010948712A CN 112052659 A CN112052659 A CN 112052659A
- Authority
- CN
- China
- Prior art keywords
- report
- safety monitoring
- template
- attribute group
- curve
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000012544 monitoring process Methods 0.000 title claims abstract description 36
- 238000000034 method Methods 0.000 title claims abstract description 22
- 238000005259 measurement Methods 0.000 claims abstract description 8
- 238000004519 manufacturing process Methods 0.000 claims abstract description 4
- 238000004364 calculation method Methods 0.000 claims description 4
- XLYOFNOQVPJJNP-UHFFFAOYSA-N water Substances O XLYOFNOQVPJJNP-UHFFFAOYSA-N 0.000 abstract description 2
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 238000004458 analytical method Methods 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/186—Templates
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/30—Information retrieval; Database structures therefor; File system structures therefor of unstructured textual data
- G06F16/33—Querying
- G06F16/3331—Query processing
- G06F16/334—Query execution
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Computational Linguistics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Audiology, Speech & Language Pathology (AREA)
- General Health & Medical Sciences (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention belongs to the technical field of safety monitoring of water conservancy and hydropower engineering, and discloses a safety monitoring report generation method based on data self-adaptation; 1) element attribute definition: the element attribute group includes attributes "element type", "selection manner", "engineering site", "measurement point", "physical quantity", "cell number", and "ID"; 2) manufacturing a template: replacing specific curve, report and character elements in the report one by using the element attribute group, storing the attribute group in a database and simultaneously inserting the ID of the attribute group into the replaced object so as to form a report template; 3) and (3) generating a report: searching all IDs in the template, finding out an attribute group of any ID from a database, calling a corresponding program to generate a corresponding curve, a report and characters by combining the time obtained from the interface, and replacing the curve, the report and the characters into the template, thereby finally forming a complete safety monitoring report; the automatic replacement of timely reports, curves and characters in the safety monitoring report of the hydraulic and hydroelectric engineering is realized.
Description
Technical Field
The invention belongs to the technical field of safety monitoring of water conservancy and hydropower engineering, and particularly relates to a safety monitoring report generating method based on data self-adaptation.
Background
In the safety monitoring work of the hydraulic and hydroelectric engineering, in order to facilitate management, an engineering is required to be divided into a plurality of engineering parts. Several sets of one or more monitoring instruments are contained under each engineering site.
The final outcome of the security monitoring work is presented in the form of a monitoring report. The monitoring results of the measuring points under each engineering part are respectively displayed in the monitoring report, and mathematical statistics and analysis are assisted, so that the purpose of discussing the safety of the engineering parts is finally achieved. In the monitoring report, the display modes of the monitoring data and the statistical result mainly include reports, curves and characters. The monitoring report is mainly composed of three elements of a report form, a curve and a character. Most curves, reports and partial characters in the monitoring reports have timeliness, but the report structure changes little in adjacent time periods.
Disclosure of Invention
The invention aims to provide a safety monitoring report generation method based on data self-adaptation, which realizes automatic replacement of time-efficient reports, curves and characters in safety monitoring reports of hydraulic and hydroelectric engineering and relieves users from complicated monitoring report compiling work.
The principle of the invention is as follows: a set of element attributes is studied to unambiguously describe curve, report and text elements in a monitoring report. The specific curves, statements and text elements are represented in the template by the set of attributes. When the report is generated, the attribute groups are translated, and curves, reports and characters corresponding to the attribute groups are generated and replaced by combining the report generation time constraint.
The technical scheme of the invention is as follows:
1) element attribute definition: the element attribute group includes attributes "element type", "selection manner", "engineering site", "measurement point", "physical quantity", "cell number", and "ID";
2) manufacturing a template: replacing specific curve, report and character elements in the report one by using the element attribute group, storing the attribute group in a database and simultaneously inserting the ID of the attribute group into the replaced object so as to form a report template;
3) and (3) generating a report: and searching all IDs in the template, finding out the attribute group of any ID from the database, calling a corresponding program to generate a corresponding curve, report and characters by combining the time obtained from the interface, and replacing the curve, report and characters into the template, thereby finally forming a complete safety monitoring report.
Further, in step 1), the type of the report element is defined by "element type".
Further, in step 1), three attributes of a selection mode, an engineering part and a measuring point are used for defining a measuring point range, namely a monitoring point range for calculation or statistics, wherein the selection mode can be a forward selection mode or a reverse selection mode. When the selection is positive selection, the measuring point range is a set of all measuring points in the measuring points; when the reverse selection is carried out, the measuring point range is a difference set obtained by subtracting all measuring points in the measuring points under the engineering part.
Further, the statistical physical quantity of the report element is defined by "physical quantity" in step 1).
Further, in step 1), the number of the measuring points which are allowed to be contained in each display unit in the report element at most is defined by the number of the units, and the number is only used in the curve.
Further, in step 1), the association code of the report element is defined by "ID" for associating the report template with the element attribute group obtained by the present definition method.
Compared with the prior art, the invention has the beneficial effects that:
1) the scheme adopts a mode of combining positive selection and negative selection of the measuring points, greatly increases the flexibility and the applicability of the report template, and avoids frequent modification of the template.
2) The scheme is simple and practical, and can be used for enabling common users to conveniently customize and modify the required report template and generate the corresponding report by being assisted with corresponding software development.
3) After the scheme is used and a corresponding computer processing program is developed by combining with a programming technology, the template is defined only once, and different times can be recorded infinitely and corresponding reports can be generated. The workload of writing the report can be greatly reduced.
Drawings
FIG. 1 is a flow chart of the present invention's work flow in report template customization.
FIG. 2 is a flow chart of the operation of the present invention in report generation.
Detailed Description
As shown in fig. 1-2, in order to make the objects, technical solutions and advantages of the present invention more clearly understood, the present invention will be further described in detail with reference to the accompanying drawings and examples. It should be understood that the specific embodiments described herein are merely illustrative of the invention and are not intended to limit the invention.
The specific implementation steps are as follows:
1) element attribute definition: the element attribute group includes attributes "element type", "selection manner", "engineering site", "measurement point", "physical quantity", "cell number", and "ID"; wherein:
a. the type of the report element is defined by an "element type". Namely: the type of the report, curve or text to which it belongs.
b. The measuring point range is defined by three attributes of 'selection mode', 'engineering position' and 'measuring point', namely the monitoring point range for calculation or statistics. The "selection mode" can be a positive selection mode or a negative selection mode. When the selection is positive selection, the measuring point range is a set of all measuring points in the measuring points; when the reverse selection is carried out, the measuring point range is a difference set obtained by subtracting all measuring points in the measuring points under the engineering part.
c. The statistical physical quantity of the report element is defined by "physical quantity", namely: the physical quantity of the measuring point needs to be calculated.
d. The number of the measuring points which are allowed to be contained in each display unit in the report element at most is defined by the number of the units, and the units are only used in the curve.
e. The association code of the report element is defined by 'ID' and is used for associating the report template with the element attribute group obtained by the definition method. It is proposed to use a globally unique identifier GUID code.
2) Manufacturing a template: replacing specific curve, report and character elements in the report one by using the element attribute group, storing the attribute group in a database and simultaneously inserting the ID of the attribute group into the replaced object so as to form a report template;
3) and (3) generating a report: and for any ID in the retrieval template, finding out an attribute group from the database, calling a corresponding program to generate a corresponding curve, report and character by combining the time obtained from the interface, and replacing the curve, report and character into the template, thereby finally forming a complete safety monitoring report.
DETAILED DESCRIPTION OF EMBODIMENT (S) OF INVENTION
Suppose that the next project site 1 of a project comprises a plurality of safety monitoring measuring points: p1, P2, P3, P4, P5, P6, P7, P8; the monitored physical quantity comprises transverse deformation and vertical deformation.
Example 1
If there is a table of the transverse deformation characteristic values of the measuring points P3, P5 and P7 at a certain position (represented by position A) of the report, the steps of making the template and generating the report are as follows:
(1) template customization, the element attribute group is defined as: element type is a characteristic value table; selecting the mode as positive selection; engineering site 1; measurement points { P3, P5, P7 }; a physical quantity is transverse deformation; the number of units is 1; ID-BA 0B3D7F-9042-4275-8A8D-533D1284DB 1A.
The meaning is that there are elements in the report: the ID code is BA0B3D7F-9042-4275-8A8D-533D1284DB1A, the element type is a characteristic value table, the measuring points are P3, P5 and P7, and the transverse deformation is calculated.
Note that: as the process proceeds, a new point P9 is added under the process site 1. Because the positive selection mode is adopted in the definition, the measuring point ranges are still P3, P5 and P7.
(2) The element attribute set is saved to the database while the ID code is inserted at the reported location a.
(3) And (3) repeating the operations (1) and (2) according to the needs to finally form a report template.
(4) When a report needs to be generated, all the ID codes present in the report are retrieved. For any ID code, the element attribute group is retrieved from the database, and the corresponding data processing program is called according to the meaning and the report generation time read from the interface to obtain the corresponding table and graph. In this example, the feature value table generation program is invoked to calculate the statistical table of the lateral deformation results of P3, P5 and P7 within the time period T (time period T is read from the system interface). And deleting the ID code at the report position A and inserting the statistical table obtained by the calculation. After all the ID codes in the system are processed, a monitoring report of the time period T (obtained from the interface) is generated.
Example 2
If one needs to insert the full process curve at some point (indicated by position B) under the engineered site 1 except for P3, P5 and P7. The physical quantity of the drawing is transverse deformation, and each drawing comprises at most 3 measuring points.
The steps of making the template and generating the report are as follows:
(1) customizing the template, wherein the element attribute group is defined as: element type is the whole process curve; selecting in a reverse mode; engineering site 1; measurement points { P3, P5, P7 }; a physical quantity is transverse deformation; the number of units is 3; BE99a581-B525-453A-8C08-F2DC76E 56641.
The meaning is that there are elements in the report: the ID code is BE99A581-B525-453A-8C08-F2DC76E56641, the element type is a whole process curve, the measuring points are P1, P2, P4, P4, P6 and P8, a transverse deformation curve is drawn, and each figure shows 3 measuring point data.
Note that: as the process proceeds, a new point P9 is added under the process site 1. Since the present definition adopts a reverse selection mode, the measuring point range is automatically changed into P1, P2, P4, P4, P6, P8 and P9.
(2) The report template customization and report generation work are completed according to the operations (2), (3) and (4) in the embodiment 1.
Example 3
If a maximum value statistical word needs to be inserted at a report (indicated by position C) for all the other measurement points under the engineering site 1 except for P3, P5 and P7. The statistical physical quantity is the lateral deformation.
The steps of making the template and generating the report are as follows:
(1) customizing the template, wherein the element attribute group is defined as: element type is maximum value statistical character; selecting in a reverse mode; engineering site 1; measurement points { P3, P5, P7 }; a physical quantity is transverse deformation; the number of units is 1; the ID is 69DA057E-C561-498B-B758-EE1BC68CE 26B.
The significance is as follows: there are elements in the report: the ID code is 69DA057E-C561-498B-B758-EE1BC68CE26B, the element type is the maximum value statistical character, the measuring points are P1, P2, P4, P4, P6 and P8, and the statistical physical quantity is transverse deformation.
Note that: if the measuring points are changed along with the progress of the engineering, the measuring point range is the same as that of 'example 2'. The unit quantity attribute is only suitable for curves and reports, and the element type is characters, so that the achievement is not influenced.
(2) The report template customization and report generation work are completed according to the operations (2), (3) and (4) in the embodiment 1.
The foregoing shows and describes the general principles, essential features, and advantages of the invention. It will be understood by those skilled in the art that the present invention is not limited to the embodiments described above, which are described in the specification and illustrated only to illustrate the principle of the present invention, but that various changes and modifications may be made therein without departing from the spirit and scope of the present invention, which fall within the scope of the invention as claimed. The scope of the invention is defined by the appended claims and equivalents thereof.
Claims (6)
1. A safety monitoring report generation method based on data self-adaptation is characterized in that:
the method comprises the following specific steps:
1) element attribute definition: the element attribute group includes attributes "element type", "selection manner", "engineering site", "measurement point", "physical quantity", "cell number", and "ID";
2) manufacturing a template: replacing specific curve, report and character elements in the report one by using the element attribute group, storing the attribute group in a database and simultaneously inserting the ID of the attribute group into the replaced object so as to form a report template;
3) and (3) generating a report: and searching all IDs in the template, finding out the attribute group of any ID from the database, calling a corresponding program to generate a corresponding curve, report and characters by combining the time obtained from the interface, and replacing the curve, report and characters into the template, thereby finally forming a complete safety monitoring report.
2. The method for generating a safety monitoring report based on data self-adaptation according to claim 1, characterized in that: in step 1), the type of the report element is defined by the "element type".
3. The method for generating a safety monitoring report based on data self-adaptation according to claim 1, characterized in that: in the step 1), three attributes of 'selection mode', 'engineering position' and 'measuring point' are used for defining measuring point range, namely monitoring point range for calculation or statistics, and the 'selection mode' can be a forward selection mode or a reverse selection mode. When the selection is positive selection, the measuring point range is a set of all measuring points in the measuring points; when the reverse selection is carried out, the measuring point range is a difference set obtained by subtracting all measuring points in the measuring points under the engineering part.
4. The method for generating a safety monitoring report based on data self-adaptation according to claim 1, characterized in that: the statistical physical quantity of the reporting element is defined in step 1) by the "physical quantity".
5. The method for generating a safety monitoring report based on data self-adaptation according to claim 1, characterized in that: in step 1), the number of the measuring points which are allowed to be contained in each display unit in the report element at most is defined by the number of the units, and the units are only used in the curve.
6. The method for generating a safety monitoring report based on data self-adaptation according to claim 1, characterized in that: in step 1) the association code of the report element is defined by "ID" for associating the report template with the set of element attributes obtained by the present definition method.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010948712.1A CN112052659A (en) | 2020-09-10 | 2020-09-10 | Safety monitoring report generation method based on data self-adaptation |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010948712.1A CN112052659A (en) | 2020-09-10 | 2020-09-10 | Safety monitoring report generation method based on data self-adaptation |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN112052659A true CN112052659A (en) | 2020-12-08 |
Family
ID=73610165
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010948712.1A Pending CN112052659A (en) | 2020-09-10 | 2020-09-10 | Safety monitoring report generation method based on data self-adaptation |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112052659A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114492357A (en) * | 2022-01-10 | 2022-05-13 | 长江勘测规划设计研究有限责任公司 | Automatic water engineering safety monitoring report generation method based on template customization |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20050234886A1 (en) * | 2004-04-16 | 2005-10-20 | Karim Mohraz | Report designer tool and method |
| CN102650984A (en) * | 2011-02-24 | 2012-08-29 | 鸿富锦精密工业（深圳）有限公司 | Test report generation system and method |
| CN106407171A (en) * | 2016-11-03 | 2017-02-15 | 华能澜沧江水电股份有限公司 | System and method for generating safety monitoring custom report based on tree structure |
| CN111444293A (en) * | 2020-04-17 | 2020-07-24 | 重庆市勘测院 | Intelligent report generation method for multi-source heterogeneous safety monitoring data |
-
2020
- 2020-09-10 CN CN202010948712.1A patent/CN112052659A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20050234886A1 (en) * | 2004-04-16 | 2005-10-20 | Karim Mohraz | Report designer tool and method |
| CN102650984A (en) * | 2011-02-24 | 2012-08-29 | 鸿富锦精密工业（深圳）有限公司 | Test report generation system and method |
| CN106407171A (en) * | 2016-11-03 | 2017-02-15 | 华能澜沧江水电股份有限公司 | System and method for generating safety monitoring custom report based on tree structure |
| CN111444293A (en) * | 2020-04-17 | 2020-07-24 | 重庆市勘测院 | Intelligent report generation method for multi-source heterogeneous safety monitoring data |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114492357A (en) * | 2022-01-10 | 2022-05-13 | 长江勘测规划设计研究有限责任公司 | Automatic water engineering safety monitoring report generation method based on template customization |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103902671B (en) | A kind of dynamic integrity method and system of isomerous multi-source data | |
| CN109871415B (en) | User portrait construction method and system based on graph database and storage medium | |
| CN111538731B (en) | Automatic report generation system for industrial data | |
| CN112347071B (en) | Power distribution network cloud platform data fusion method and power distribution network cloud platform | |
| CN110442595B (en) | Method and device for constructing universal SQL report data set | |
| CN113032633B (en) | Method for customizing table by using reference data item | |
| CN109064126B (en) | Hydropower engineering metering information management method based on quality driving | |
| CN112651218A (en) | Automatic generation method and management method of bidding document, medium and computer | |
| CN112464632A (en) | Form style dynamic storage and conversion method under excel report | |
| CN105279269A (en) | SQL generating method and system for supporting table free association | |
| CN112052659A (en) | Safety monitoring report generation method based on data self-adaptation | |
| CN114328452A (en) | Data auditing method, device, platform, electronic equipment and storage medium | |
| CN106815320B (en) | Investigation big data visual modeling method and system based on expanded three-dimensional histogram | |
| CN114968348A (en) | Data analysis method and device, electronic equipment and storage medium | |
| CN115934716A (en) | Method for importing Excel table data into database based on metadata definition and implementation | |
| CN113807573A (en) | Construction prediction analysis method and system based on data management and three-dimensional search | |
| CN109325017B (en) | Database design method of radionuclide migration diffusion numerical simulation system | |
| CN113487266A (en) | Method, system, equipment and storage medium for automatically generating material codes and bill of materials of dynamic parameters | |
| CN115617790A (en) | Data warehouse creation method, electronic device and storage medium | |
| CN106022944B (en) | Data volume conversion method and device for conventional and streamline models in numerical reservoir simulation | |
| Heavey et al. | A model management systems approach to manufacturing systems design | |
| CN116911642B (en) | Multi-dimensional multi-state oriented hydroelectric generating set equipment index calculation system and method | |
| CN112001008A (en) | Bridge construction monitoring data integrated management system based on Revit software | |
| CN118535887B (en) | Efficient fine tuning evaluation method and system for large language model | |
| CN118261137B (en) | Unified management method for water control account data of coal mine |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |