Ship inspection data intelligent management system and method based on structured storage

Abstract

The invention relates to the technical field of ship data management, and particularly provides a ship inspection data intelligent management system and method based on structured storage, and the method comprises the following steps: obtaining a ship number, an inspection item and an inspection number, and constructing a data positioning layer; obtaining an inspection document, performing content analysis on the inspection document, and constructing a data structure layer; obtaining multi-source inspection data, associating the multimedia inspection data in the multi-source inspection data with the data content of the data structure layer, and constructing an association mapping layer; constructing a three-dimensional data storage structure based on the data positioning layer, the data structure layer and the association mapping layer; based on table cell index description, binding the multi-source inspection data to table cells with corresponding semantics, and performing cell data fusion to obtain a plurality of assembly cells; and dynamically reconstructing the inspection document based on all the assembly cells to obtain an interactive inspection document, so that the structural data storage of the inspection data is realized, and the inspection efficiency and the traceability positioning efficiency after data archiving are improved.

Description

Technical Field

[0001] This invention relates to the field of ship data management technology, and in particular to an intelligent management system and method for ship inspection data based on structured storage. Background Technology

[0002] In the mooring inspection phase of shipbuilding, the standardized recording and management of inspection data is a core element in ensuring the reliability of ship assembly and construction quality. Currently, inspection results are mainly recorded through paper media. However, this model has the following problems: paper records can only reflect the binary state of whether a process is completed or not, lacking process-related supporting materials such as images and videos. As a result, shipowners or third-party institutions still need to carry out onboard verification procedures during re-inspections, which require coordination of resources from multiple parties, including shipyards, classification societies, and supervisors.

[0003] Secondly, paper records are difficult to organize and retrieve data from, requiring manual review of numerous documents when searching for specific inspection items, resulting in low efficiency. Furthermore, data recorded in paper format is difficult to convert into electronic format, leading to a lack of effective data support for subsequent management tasks such as quality analysis and progress tracking.

[0004] The layered transmission model of manual recording, paper transfer, manual archiving, physical storage, and restricted access is cumbersome and inefficient, and is prone to problems such as omissions, errors, and storage loss, which affect the accuracy of inspection and the integrity of data management. Summary of the Invention

[0005] In view of the above-mentioned deficiencies mentioned in the background art, the present invention provides an intelligent management system and method for ship inspection data based on structured storage.

[0006] This invention provides an intelligent management method for ship inspection data based on structured storage, comprising the following steps:

[0007] S1. Obtain the vessel number, inspection items, and inspection number to construct the data positioning layer;

[0008] S2. Obtain the inspection document, parse the content of the inspection document, and obtain paragraph text data, table data, and multimedia data; the table data includes table cell coordinate mapping and table cell index description.

[0009] Based on the multimedia data, a multimedia ID corresponding to the multimedia data content is generated, and the multimedia ID is associated with paragraph text data and table data to construct a data structure layer;

[0010] S3. Obtain multi-source verification data uploaded collaboratively from several mobile devices. The multi-source verification data includes: electronic signatures, multimedia verification data, and result value data.

[0011] Associate multimedia verification data with the data content of the data structure layer to construct an association mapping layer;

[0012] A three-dimensional data storage structure is constructed based on the data positioning layer, data structure layer, and association mapping layer.

[0013] S4. Based on the table cell index description, bind the multi-source test data to the corresponding semantic table cells respectively, and perform cell data fusion in each table cell to obtain several assembly cells.

[0014] The inspection document is dynamically reconstructed based on all assembly cells to obtain an interactive inspection document.

[0015] In step S2, the content of the inspection document is parsed to obtain the table cell indicator descriptions. The specific process is as follows:

[0016] Iterate through each table cell. If a table cell contains a preset identifier, extract the corresponding preset identifier content to obtain the table cell indicator description.

[0017] If the preset identifier does not exist in the table cell, a cross-location process is triggered to obtain the table cell indicator description.

[0018] Furthermore, the specific process for obtaining the table cell indicator description is as follows:

[0019] Starting from a table cell that does not have a preset identifier, search upwards along the column where it is located, and take the table cell index description in the first non-empty cell obtained as the first semantic label;

[0020] Search to the left along the row it is in, and use the table cell index description in the first non-empty cell obtained as the second semantic label;

[0021] The first semantic tag and the second semantic tag are concatenated to obtain the standard semantic tag. The content of the standard semantic tag is extracted to obtain the table cell indicator description.

[0022] Specifically, in step S4, the multi-source test data are bound to the corresponding semantic table cells. When binding the result value data to the corresponding semantic table cell, a limit verification rule is set: if the result value exceeds the preset value range of this table cell, the result value is determined to be out of range and an early warning is issued.

[0023] Specifically, the paragraph text data in S2 includes text elements and attribute types of the text elements. The text elements include suggestive text descriptions of the requirements for the inspection indicators, the inspection operation steps, and the range of inspection values.

[0024] Furthermore, the interactive inspection document obtained in S4 includes a base layer and interactive media controls embedded in the assembly cells. The base layer includes a table frame and a text description.

[0025] The multimedia inspection data in S3 includes inspection images and inspection videos.

[0026] This invention also provides an intelligent management system for ship inspection data based on structured storage, comprising:

[0027] Data location module: used to obtain ship number, inspection items and inspection number, and to build a data location layer;

[0028] Document parsing module: Used to acquire inspection documents, parse the content of inspection documents, and obtain paragraph text data, table data, and multimedia data; table data includes table cell coordinate mapping and table cell index description; based on multimedia data, generate multimedia IDs corresponding to the multimedia data content, associate multimedia IDs with paragraph text data and table data, and construct a data structure layer;

[0029] Data storage module: used to acquire multi-source verification data uploaded collaboratively from several mobile devices. The multi-source verification data includes: electronic signatures, multimedia verification data, and result value data; associates the multimedia verification data with the data content of the data structure layer to build an association mapping layer; and constructs a three-dimensional data storage structure based on the data positioning layer, data structure layer, and association mapping layer.

[0030] Document Reconstruction Module: Based on the table cell index description, it binds multi-source test data to corresponding semantic table cells, performs cell data fusion in each table cell to obtain several assembled cells, and dynamically reconstructs the test document based on all assembled cells to obtain an interactive test document.

[0031] In addition, the present invention provides a computer-readable storage medium storing a computer program that, when run on a processor, causes the processor to execute the intelligent management method for ship inspection data based on structured storage as described above.

[0032] The present invention also provides an electronic device, characterized in that it includes: at least one memory for storing a program;

[0033] At least one processor is configured to execute a program stored in the memory, wherein when the program stored in the memory is executed, the processor is configured to execute the intelligent management method for ship inspection data based on structured storage as described above.

[0034] As described above, the intelligent management system and method for ship inspection data based on structured storage of the present invention has the following beneficial effects:

[0035] 1. Bind multi-source inspection data containing electronic signatures, multimedia inspection data, and result value data to the corresponding table cell descriptions, so that the inspection data record is no longer limited to the binary state of completion or incompleteness. Inspectors can directly photograph the readings of the test instruments and associate them with the corresponding cells. Ship owners can remotely check the original process images, reducing the coordination costs of multiple parties boarding the ship for re-inspection.

[0036] 2. Based on the ship number, inspection items, and inspection number, a data positioning layer is constructed. Based on the data positioning layer, data structure layer, and association mapping layer, a three-dimensional data storage structure is constructed, which can accurately locate and store equipment debugging data. All inspection data is automatically converted into structured electronic archives, supporting multi-condition combined queries and improving the efficiency of traceability and positioning after data archiving.

[0037] 3. Real-time collaborative data entry across multiple mobile devices eliminates the need for paper-based processing and manual data entry, improving inspection and data verification efficiency. The validation rules set in the table cells detect data exceeding thresholds and provide real-time alerts, thereby improving the accuracy of inspection data. Attached Figure Description

[0038] Figure 1 The diagram shown is a flowchart of the intelligent management method for ship inspection data based on structured storage provided by the present invention. Detailed Implementation

[0039] The following specific examples illustrate the implementation of the present invention. Those skilled in the art can easily understand other advantages and effects of the present invention from the content disclosed in this specification. The present invention can also be implemented or applied through other different specific embodiments, and various details in this specification can also be modified or changed based on different viewpoints and applications without departing from the spirit of the present invention.

[0040] This embodiment provides an intelligent management system and method for ship inspection data based on structured storage, including the following steps:

[0041] S1. Obtain the vessel number, inspection items, and inspection number to construct the data positioning layer;

[0042] S2. Obtain the inspection document, parse the content of the inspection document, and obtain paragraph text data, table data, and multimedia data; table cell data includes table cell coordinate mapping and table cell indicator description.

[0043] Based on the multimedia data, a multimedia ID corresponding to the multimedia data content is generated, and the multimedia ID is associated with paragraph text data and table data to construct a data structure layer;

[0044] S3. Obtain multi-source verification data uploaded collaboratively from several mobile devices. The multi-source verification data includes: electronic signatures, multimedia verification data, and result value data.

[0045] Associate multimedia verification data with the data content of the data structure layer to construct an association mapping layer;

[0046] A three-dimensional data storage structure is constructed based on the data positioning layer, data structure layer, and association mapping layer.

[0047] S4. Based on the table cell index description, bind the multi-source test data to the corresponding semantic table cells respectively, and perform cell data fusion in each table cell to obtain several assembly cells.

[0048] The inspection document is dynamically reconstructed based on all assembly cells to obtain an interactive inspection document.

[0049] The steps described above are explained in detail below:

[0050] Step S1: Obtain the vessel number, inspection items, and inspection number to construct a data location layer. Each vessel has a unique number. During mooring inspections, multiple inspection items are required, such as power unit inspection and hydraulic oil temperature inspection. Furthermore, multiple inspections may be conducted as needed, each with a different inspection number. Constructing a data location layer based on the vessel number, inspection items, and inspection number allows for precise location of inspection data, improving the efficiency of traceability and location after data archiving.

[0051] For example, if the inspection item is the steering gear equipment, create a directory: 01_ship number / 01_system / 001_inspection item name, and read the ID number before each level, which is the inspection item ID number 0101001.

[0052] Step S2 involves obtaining the inspection document and parsing its content. The obtained inspection document is an empty document that has not yet recorded any inspection data, and the tables in the inspection document are also empty tables with no inspection data entered.

[0053] The inspection document is accompanied by an inspection item code. Based on the inspection item code, the inspection document is associated with the inspection item in the data positioning layer and stored in the corresponding directory. For example, the inspection document of the servo motor equipment with the inspection item code is stored in the directory created in step S1.

[0054] The system reads the directory, parses the content of the inspection documents, and obtains paragraph text data, table data, and multimedia data. The paragraph text data includes text elements and their attribute types. The text elements include suggestive text descriptions of inspection indicator requirements, inspection operation steps, and inspection value ranges. Inspection indicator requirements can be explanatory text regarding the requirements for dynamic monitoring of hydraulic oil temperature.

[0055] The parsed table data includes table cell coordinate mappings and table cell indicator descriptions. The table cell coordinate mappings record the table cell's position within its parent table, including its row and column coordinates. The table cell indicator descriptions describe the cell's name. Multimedia data includes images and videos, such as device schematics and operation videos.

[0056] Users can directly define table cell requirements in inspection documents where inspection data has not yet been recorded by inserting special identifiers. For example, entering [RANGE: 10-15MPa] in the "Hydraulic Pressure" cell indicates that the numerical testing range is 10-15MPa, and marking "[Photograph]" in the "Pipeline Seal" cell requires taking a photograph. Users can also manually configure these requirements in the system interface, such as selecting the "Emergency Braking Test" cell and choosing the "[Video Recording]" option, or selecting the "[Signature]" option in the "Acceptance Confirmation" cell.

[0057] Furthermore, based on the multimedia data, a multimedia ID corresponding to the multimedia data content is generated, and the multimedia ID is associated with paragraph text data and table data to construct a data structure layer.

[0058] In step S2, the content of the inspection document is parsed to obtain the table cell indicator descriptions. The specific process is as follows:

[0059] Iterate through each table cell. If a table cell contains a preset identifier, such as "Power Unit - Lubricating Oil Temperature", extract the corresponding preset identifier content to obtain the table cell index description.

[0060] If the preset identifier does not exist in the table cell, a cross-location process is triggered to obtain the table cell indicator description.

[0061] Furthermore, the process of obtaining the table cell indicator description through the cross-location technique described above is as follows:

[0062] Starting from a table cell that does not have a preset identifier, search upwards along the column where it is located, and take the table cell index description in the first non-empty cell obtained as the first semantic label;

[0063] Search to the left along the row it is in, and use the table cell index description in the first non-empty cell obtained as the second semantic label;

[0064] The first semantic tag and the second semantic tag are concatenated to obtain the standard semantic tag. The content of the standard semantic tag is extracted to obtain the table cell indicator description.

[0065] Specifically, the first semantic tag obtained in the column direction can be the column header, and the second semantic tag obtained in the row direction can be the row header. In this embodiment, considering that the column direction of the table generally records the equipment category name and the row direction records the parameter name, the first semantic tag is the equipment category name, such as "power unit", and the second semantic tag is the parameter name, such as "lubricating oil temperature". The first semantic tag and the second semantic tag are concatenated to obtain the standard semantic tag "first semantic tag - second semantic tag", which corresponds to the table cell index description of "power unit - lubricating oil temperature".

[0066] In practical applications, the naming rules for table cell names can be customized according to the table structure, but the semantic tags in both the row and column directions can be extracted and concatenated using the cross-positioning method to obtain the table cell description.

[0067] Step S2 completes the rendering of three inspection item tables and loads several high-precision steering system schematics, including hydraulic circuit diagrams and electrical control diagrams. Finally, the document elements are visually reorganized and displayed on the ship inspection data intelligent management system interface, forming a digital inspection template containing text, tables, and images, which constitutes the data content of the data structure layer.

[0068] Furthermore, the data content of the data structure layer undergoes JSON serialization processing. Table structures, inspection indicator requirements, schematic diagrams, and other data are packaged and converted into standardized JSON string format data, which is then encrypted and sent to the server. The server distributes the standardized format data to several mobile devices, and then deserializes it to convert it into a visual electronic document. Based on the inspection content of the visual electronic document, inspectors on different mobile devices collaboratively record and upload inspection data remotely. The uploaded data can be read and viewed in real time within the intelligent ship inspection data management system, showing the inspectors for that project, the upload time, and simultaneously browsing multimedia files within the table cells to confirm the on-site inspection situation.

[0069] Step S3 acquires multi-source verification data collaboratively uploaded from several mobile devices. This multi-source verification data includes: electronic signatures, multimedia verification data, and result value data. The multimedia verification data is then associated with the data content of the data structure layer to construct an association mapping layer. The multimedia verification data includes verification images and videos. Based on the data positioning layer, data structure layer, and association mapping layer, a three-dimensional data storage structure is constructed.

[0070] Step S4 binds the multi-source test data to the corresponding semantic table cells based on the table cell index description. For example, when binding the multi-source test data, the measured speed value "1500rpm" is bound to the table cell with the index description "host parameter - rated speed".

[0071] When binding the result value data to the corresponding semantic table cell, set a limit validation rule: if the result value exceeds the preset value range of this table cell, the result value is determined to be out of range and a warning is issued.

[0072] Multi-source test data is fused within each table cell to obtain several assembled cells. The test document is then dynamically reconstructed based on all assembled cells to obtain an interactive test document. Specifically, the obtained interactive test document includes a base layer and interactive media controls embedded in the assembled cells. The base layer includes a table frame and text descriptions.

[0073] In this embodiment, the interactive verification document supports viewing electronic signatures, images, and videos. By clicking on a cell using the embedded interactive media control, users can play related videos / high-definition images and view electronic signatures.

[0074] The interactive inspection document also supports exporting a PDF report and storing the associated media data files in a specified local directory. For example, after completing the three inspection item tables, a servo motor inspection PDF report can be generated. Finally, the complete CV302_servo motor inspection.pdf report, along with several multimedia data files containing images and videos, will be stored in the preset directory / CV302 / Steering_System / IP-005 / Result.

[0075] This invention also provides an intelligent management system for ship inspection data based on structured storage, comprising:

[0076] Data location module: used to obtain ship number, inspection items and inspection number, and to build a data location layer;

[0077] Document parsing module: Used to acquire inspection documents, parse the content of inspection documents, and obtain paragraph text data, table data, and multimedia data; table data includes table cell coordinate mapping and table cell index description; based on multimedia data, generate multimedia IDs corresponding to the multimedia data content, associate multimedia IDs with paragraph text data and table data, and construct a data structure layer;

[0078] Data storage module: used to acquire multi-source verification data uploaded collaboratively from several mobile devices. The multi-source verification data includes: electronic signatures, multimedia verification data, and result value data; associates the multimedia verification data with the data content of the data structure layer to build an association mapping layer; and constructs a three-dimensional data storage structure based on the data positioning layer, data structure layer, and association mapping layer.

[0079] Document Reconstruction Module: Based on the table cell index description, it binds multi-source test data to corresponding semantic table cells, performs cell data fusion in each table cell to obtain several assembled cells, and dynamically reconstructs the test document based on all assembled cells to obtain an interactive test document.

[0080] This invention discloses an intelligent management system and method for ship inspection data based on structured storage. It binds multi-source inspection data, including electronic signatures, multimedia inspection data, and result value data, to corresponding table cells describing indicators. This frees inspection data recording from a binary state of completion or incompleteness. Inspectors can directly photograph instrument readings and associate them with corresponding cells, allowing ship owners to remotely verify original process images, reducing the coordination costs of multiple onboard re-inspections. Based on ship number, inspection items, and inspection numbers, this invention constructs a data positioning layer. Furthermore, based on the data positioning layer, data structure layer, and association mapping layer, it builds a three-dimensional data storage structure, enabling precise positioning and storage of equipment debugging data. All inspection data is automatically converted into structured electronic archives, supporting multi-condition combined queries and improving the efficiency of traceability and positioning after data archiving. In addition, several mobile terminals collaborate in real-time to fill in data, eliminating the "paper delivery and manual entry" steps, improving inspection and data verification efficiency. The limitation and verification rules set in the table cells detect data exceeding thresholds and provide real-time warnings, improving the accuracy of inspection data.

[0081] Furthermore, the present invention also provides a computer-readable storage medium storing a computer program that, when run on a processor, causes the processor to execute the intelligent management method for ship inspection data based on structured storage as described above.

[0082] Furthermore, the present invention also provides an electronic device, including at least one memory for storing a program; and at least one processor for executing the program stored in the memory. When the program stored in the memory is executed, the processor is used to execute the intelligent management method for ship inspection data based on structured storage as described above.

[0083] The above embodiments are merely illustrative of the principles and effects of the present invention and are not intended to limit the invention. Any person skilled in the art can modify or alter the above embodiments without departing from the spirit and scope of the present invention. Therefore, all equivalent modifications or alterations made by those skilled in the art without departing from the spirit and technical concept disclosed in the present invention should still be covered by the claims of the present invention.

Claims

1. A method for intelligent management of ship inspection data based on structured storage, characterized in that, Includes the following steps: S1. Obtain the vessel number, inspection items, and inspection number to construct the data positioning layer; S2. Obtain the inspection document, parse the content of the inspection document, and obtain paragraph text data, table data, and multimedia data; the table data includes table cell coordinate mapping and table cell index description. Based on the multimedia data, a multimedia ID corresponding to the multimedia data content is generated, and the multimedia ID is associated with paragraph text data and table data to construct a data structure layer; S3. Obtain multi-source verification data uploaded collaboratively from several mobile devices. The multi-source verification data includes: electronic signatures, multimedia verification data, and result value data. Associate multimedia verification data with the data content of the data structure layer to construct an association mapping layer; A three-dimensional data storage structure is constructed based on the data positioning layer, data structure layer, and association mapping layer. S4. Based on the table cell index description, bind the multi-source test data to the corresponding semantic table cells respectively, and perform cell data fusion in each table cell to obtain several assembly cells. The inspection document is dynamically reconstructed based on all assembly cells to obtain an interactive inspection document.

2. The intelligent management method for ship inspection data based on structured storage according to claim 1, characterized in that, In step S2, the content of the inspection document is parsed to obtain the table cell indicator descriptions. The specific process is as follows: Iterate through each table cell. If a table cell contains a preset identifier, extract the corresponding preset identifier content to obtain the table cell indicator description. If the preset identifier does not exist in the table cell, a cross-location process is triggered to obtain the table cell indicator description.

3. The intelligent management method for ship inspection data based on structured storage according to claim 2, characterized in that, The specific process for obtaining the table cell indicator description is as follows: Starting from a table cell that does not have a preset identifier, search upwards along the column where it is located, and take the table cell index description in the first non-empty cell obtained as the first semantic label; Search to the left along the row it is in, and use the table cell index description in the first non-empty cell obtained as the second semantic label; The first semantic tag and the second semantic tag are concatenated to obtain the standard semantic tag. The content of the standard semantic tag is extracted to obtain the table cell indicator description.

4. The intelligent management method for ship inspection data based on structured storage according to claim 1, characterized in that, In step S4, the multi-source test data are bound to the corresponding semantic table cells respectively. When binding the result value data to the corresponding semantic table cell, a limit verification rule is set: if the result value exceeds the preset value range of this table cell, the result value is determined to be out of range and an early warning is issued.

5. The intelligent management method for ship inspection data based on structured storage according to claim 1, characterized in that, The paragraph text data in S2 includes text elements and attribute types of the text elements. The text elements include suggestive text descriptions of the requirements for the inspection indicators, the inspection operation steps, and the range of inspection values.

6. The intelligent management method for ship inspection data based on structured storage according to claim 1, characterized in that, The interactive inspection document obtained in S4 includes a base layer and interactive media controls embedded in the assembly cells. The base layer includes a table frame and text description.

7. The intelligent management method for ship inspection data based on structured storage according to claim 1, characterized in that, The multimedia inspection data in S3 includes inspection images and inspection videos.

8. An intelligent management system for ship inspection data based on structured storage, characterized in that, include: Data location module: used to obtain ship number, inspection items and inspection number, and to build a data location layer; Document parsing module: Used to acquire inspection documents, parse the content of inspection documents, and obtain paragraph text data, table data, and multimedia data; table data includes table cell coordinate mapping and table cell index description; based on multimedia data, generate multimedia IDs corresponding to the multimedia data content, associate multimedia IDs with paragraph text data and table data, and construct a data structure layer; Data storage module: used to acquire multi-source verification data uploaded collaboratively from several mobile devices. The multi-source verification data includes: electronic signatures, multimedia verification data, and result value data; associates the multimedia verification data with the data content of the data structure layer to build an association mapping layer; and constructs a three-dimensional data storage structure based on the data positioning layer, data structure layer, and association mapping layer. Document Reconstruction Module: Based on the table cell index description, it binds multi-source test data to corresponding semantic table cells, performs cell data fusion in each table cell to obtain several assembled cells, and dynamically reconstructs the test document based on all assembled cells to obtain an interactive test document.

9. A computer-readable storage medium, characterized in that, The computer-readable storage medium stores a computer program that, when run on a processor, causes the processor to execute the intelligent management and processing method for ship inspection data as described in any one of claims 1 to 7.

10. An electronic device, characterized in that, include: At least one memory for storing programs; At least one processor is configured to execute a program stored in the memory, wherein when the program stored in the memory is executed, the processor is configured to execute the intelligent management method for ship inspection data as described in any one of claims 1 to 7.

Images