Method and equipment for automatically extracting ship final assembly construction work object quantity and storage medium

Abstract

The invention relates to an automatic extraction method and device for ship final assembly construction work object quantity and a storage medium. A work object quantity database provides a basis for working hour calculation or dispatching to extract a work object quantity table corresponding to a work item. Therefore, automatic extraction of the amount of the work object can be performed in a numerical value setting mode of each attribute in the work item attribute table in combination with the numerical values in the design drawing of the work item, the work object scale corresponding to the work item is formed, manual participation is reduced, data quality is high, and work efficiency is improved. The working object quantity data can be obtained timely, efficiently and accurately according to the required granularity when the class working hours are measured and calculated, so that the obtaining efficiency is improved.

Description

Technical Field

[0001] The present application relates to the technical field of ship assembly and construction, and in particular to a method, device and storage medium for automatically extracting material quantities from ship assembly and construction operations. Background Art

[0002] Shipbuilding operations volume data can provide input for work-hour calculations based on the original unit method and at the production-based dispatching level. It also serves as the basis for load balancing and production efficiency assessment for production teams and workstations. Shipbuilding operations volume data is typically obtained through production design data. The data output from production design for shipbuilding operations suffers from a wide variety of types, diverse data structures, decentralized data storage, and inconsistent data management. There is also a significant discrepancy between the granularity of production design data and that of operations used for work-hour calculations (or dispatching management). Improving the digital management capabilities of shipbuilding enterprises requires the acquisition of volume information. Therefore, research on automated extraction of shipbuilding operations volume data is essential. Current traditional methods rely on manual or semi-automatic queries by production managers or time management personnel based on data tables, extracting data from different types of design data. This makes it difficult to determine data version updates, resulting in low efficiency and data quality, making it difficult to meet the demand for timely and high-quality volume data. Summary of the Invention

[0003] Based on this, in order to effectively improve the timeliness, efficiency and accuracy of the work quantity requirements for ship assembly and construction, the present application provides a method, equipment and storage medium for automatic extraction of work quantity for ship assembly and construction, which solves the technical problems that traditional acquisition methods have low efficiency and insufficient data version management resulting in low data quality, and it is difficult to obtain work quantity data in a timely, efficient and accurate manner according to the required granularity when formulating measurement working hours.

[0004] The present application provides a method for automatically extracting the material quantity of ship assembly construction operations, comprising the steps of: The characteristics of shipbuilding intermediate products are sorted out to form a shipbuilding operation breakdown structure. The shipbuilding operation breakdown structure includes three operation type levels in a tree structure: main work type, secondary work type, and process, as well as work packages / work orders that combine secondary work type, process, and work object. Split the processing material quantity according to the operation items, select the operation quantity based on the working time calculation requirements, and generate the operation quantity corresponding to each operation item; Sorting out the combination rules of the work quantity objects of each work project, and constructing a structured quantity database from the perspective of production design output. The structured quantity database includes a detailed design data attribute table corresponding to each work project; Attributes associated with the main type of work, the sub-type of work, the process, and the work package / work order are extracted from the design data attribute table of the physical quantity structured database, and reorganized to form an operation item attribute table, wherein the operation item attribute table includes a main type of work hierarchical attribute table, a sub-type of work hierarchical attribute table, a process hierarchical attribute table, and a work package / work order attribute table. The main type of work hierarchical attribute table, the sub-type of work hierarchical attribute table, the process hierarchical attribute table, and the work package / work order physical quantity attribute table are constructed into an operation physical quantity database; In response to the work quantity table corresponding to the target work project used for man-hour calculation or work assignment, the work project attribute table corresponding to the target work project is obtained, and the value of each attribute in the work project attribute table is set according to the value in the design drawing of the target work project to form the work quantity table corresponding to the target work project.

[0005] Furthermore, the shipbuilding intermediate product characteristics are sorted out to form a shipbuilding operation breakdown structure, which includes three operation type levels of main work, auxiliary work, and process in a tree structure, as well as work packages / work orders combining auxiliary work, process, and work objects, including: Based on the ship assembly construction project decomposition and work package decomposition structure, the ship construction intermediate product characteristics are obtained as the ship construction operation decomposition structure; Decomposing the shipbuilding operation structure into hull, outfitting and painting according to the operation type; For each job type, the job type levels are set up in a tree structure from high to low, including the main job type, auxiliary job type, and process type, as well as the work package / work order that combines the auxiliary job type, process, and job object; The main work types include processing, assembly, and loading, which are subdivisions of the work types; The secondary work types include pre-treatment, steel plate cutting, profile cutting, and processing, which are subdivisions of the primary work types; The process includes steel plate pretreatment and profile pretreatment, which are subdivisions of the auxiliary work; The sub-work types and the operation objects are combined to form a work package, and the process and the operation object are combined to form a work order. The work package / work order is a project split of the sub-work types and the process based on the operation object.

[0006] Furthermore, the process of splitting the processing material quantity according to the operation items, selecting the operation material quantity based on the working time calculation requirement, and forming the operation material quantity corresponding to each operation item includes: Sorting out the material requirements of each level of the operation type, and determining the selection targets of the operation materials based on the processes with the manufacturing characteristics of intermediate products in ship assembly and construction; Select the amount of work that has a linear functional relationship with the workload and determine the unit of the work amount; When a work item contains multiple work quantities, select the representative quantity that has the greatest impact on work time consumption as the work quantity for work time calculation; When there is no work quantity that presents a linear functional relationship with the work workload, the work quantity of a single task is selected based on the work content and the specifications, weight, form, and characteristic attribute data of the work object; Summarize and generate the work quantity corresponding to each work item.

[0007] Furthermore, the physical quantity combination rules of the work objects of each work package / work order are sorted out, and a physical quantity structured database is constructed from the perspective of production design output. The physical quantity structured database includes a design data attribute table corresponding to each work item, including: According to the granularity of each level of the operation type, a combination of operation objects corresponding to various granularity levels is formed, wherein the operation objects at the main work type level, the auxiliary work type level, and the process level are the operation quantities of the entire ship, and the operation objects of the process work package / work order are the operation quantities of the corresponding construction section, construction section, or construction area; Sort out the work quantities of work packages / work orders and form the work quantity combination rules of work packages / work orders; The design data output by the production design is sorted and obtained, including hull design data, outfitting design data, and painting design data; the hull design data includes steel plate / profile preprocessing data, steel plate blanking data, parallel blanking and processing data, section steel blanking and processing data, plate processing data, structural parts data, structural weld data, and painting data; the outfitting design data includes pipe and outfitting installation pallets, unit installation pallets, iron outfitting installation pallets, equipment installation pallets, electrical outfitting installation pallets, electrical equipment installation lists, cable laying, refrigeration / air conditioning / ventilation installation pallets, and interior installation pallets; the painting design data includes painting data; The design data output by the production design is converted into a design data attribute table corresponding to each operation item, and the design data attribute table is stored in a physical quantity structured database.

[0008] Furthermore, converting the design data output by the production design into a design data attribute table corresponding to each operation item, and storing the design data attribute table in a physical quantity structured database includes: The design data attribute table stored in the physical quantity structured database is a data attribute framework of three hull categories, one outfitting category, and one painting category; The design data attribute tables of the three types of hulls include a steel plate blanking or CNC cutting data attribute frame, a parts processing data attribute frame and a structural weld data attribute frame.

[0009] Furthermore, after constructing the physical quantity structured database, the following steps are further included: A quantity unit check is performed on the operation quantity corresponding to the attribute in the design data attribute table in the quantity structured database, so that the quantity unit of the same operation quantity is kept the same.

[0010] Furthermore, after constructing the operation material quantity database, the method further includes: The version of the work package / work order quantity attribute table in the operation quantity database is controlled to be updated according to the construction status of the work package / work order; the construction status of the work package / work order includes three states: "not started", "under construction", and "completed"; the construction status is "not started" when there is no work package / work order, the actual working hours of the work package / work order are not reported, and the project is not set to completion; the construction status is "under construction" when the actual working hours of the work package / work order are reported and the project is not set to completion; the construction status is "completed" when the project of the work package / work order is set to completion.

[0011] Furthermore, the method further comprises: Formulate a configuration table for the output mode of a series of ships, form a correspondence between each built ship number and the designed ship number, and use it as the basis for generating quantity data. Set the attributes of the configuration table for the output mode of a series of ships to include "serial number", "built ship number", "designed ship number", "completion", and "remarks"; Regularly check whether the product "Completion" content corresponding to the design drawing ship number in the series ship drawing configuration table is completed, and the physical quantity data of unfinished products is automatically updated according to the latest version of the design drawing.

[0012] On the other hand, a computer device is provided, comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein when the processor executes the computer program, the steps of the method for automatically extracting the material quantity of ship assembly construction operations are implemented.

[0013] On the other hand, a computer-readable storage medium is provided, on which a computer program is stored, and when the computer program is executed by a processor, the steps of the method for automatically extracting the material quantity of ship assembly construction operations are implemented.

[0014] The above-mentioned method, device and storage medium for automatically extracting material quantities from ship assembly and construction operations form a decomposition structure for ship construction operations by sorting out the characteristics of intermediate products in ship assembly and construction for man-hour calculation. The processing material quantities are then split according to the operation items to form the operation material quantities corresponding to each operation item. The combination rules of the operation material quantity objects of each operation item are then sorted out to construct a material quantity structured database from the perspective of production design output. The material quantity structured database stores a design data attribute table with the design data in the production design output drawing as attributes. Then, the attributes associated with the main type of work, the secondary type of work, the process, and the work package / work order are extracted across multiple design data attribute tables. The main type of work hierarchical attribute table, the secondary type of work hierarchical attribute table, the process hierarchical attribute table and the work package / work dispatch hierarchical attribute table are reorganized to form an operation quantity database. The operation quantity database provides a basis for calculating working hours or extracting the operation quantity table corresponding to the target operation project through dispatching, thereby realizing the automatic extraction of operation quantity by setting the value of each attribute in the operation project attribute table in combination with the value in the design drawing of the target operation project, forming the operation quantity table corresponding to the target operation project, reducing human participation and improving data quality. When calculating working hours, the operation quantity data can be obtained in a timely, efficient and accurate manner according to the required granularity, thereby improving the acquisition efficiency. BRIEF DESCRIPTION OF THE DRAWINGS

[0015] Figure 1 This is a flow chart of a method for automatically extracting material quantities from ship assembly and construction operations provided in Example 1 of the present application.

[0016] Figure 2 This is a flow chart of a method for automatically extracting material quantities from ship assembly and construction operations provided in Example 2 of the present application.

[0017] Figure 3 This is a diagram of the internal structure of a computer device provided in Example 3 of the present application. DETAILED DESCRIPTION

[0018] In order to make the purpose, technical solutions and advantages of this application more clear, the following further describes this application in detail with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are only used to explain this application and are not intended to limit this application.

[0019] Example 1 This application provides a method for automatically extracting operational quantities from ship assembly and construction. To address the problems of diverse data types, diverse data structures, decentralized data storage, and inconsistent data management in the production design output of operational quantities for ship assembly and construction, a "structuralized quantity database" is constructed to perform initial data processing based on the production design output, generating unified and standardized structural quantity data. To address the significant discrepancy between the granularity of production design quantity data and operational quantities used for man-hour calculation (or work dispatch management), an "operational quantity database" is constructed to generate relatively uniformly formatted operational quantities and related attribute data for each operation level, providing a foundation for subsequent automatic calculation of planned man-hours or work dispatch management of operational quantities.

[0020] like Figure 1 As shown, the method for automatically extracting the material quantity of ship assembly construction operations provided by this application includes the following steps: Step S1) sorting out the construction work breakdown structure of shipbuilding intermediate products for man-hour calculation; Step S2) sorting out the selection of work quantities based on the work time calculation requirements; Step S3) sorting out the combination rules of the work quantity objects for man-hour calculation; Step S4) Constructing a “physical quantity structured database” framework from the perspective of production design output; Step S5) First data processing (standardization inspection of quantity units and verification of weld data quality); Step S6) Constructing a "work quantity database" framework from the perspective of man-hour calculation; Step S7) Second data processing (calibration for work quantity application); Step S8) Formulate an automatic extraction strategy for the work quantity.

[0021] According to the extraction method, the work quantity required for man-hour calculation (or work dispatch) is automatically extracted.

[0022] The characteristics of intermediate products in ship assembly construction, specifically those related to man-hour calculation, were analyzed to develop an operation breakdown structure (OBS) for intermediate product construction. This OBS is based on the ship assembly construction engineering and work package decomposition structures. The hierarchy below the operation type level is organized into three levels: main work, secondary work, and process, in a tree-like structure. Work packages / work orders, which combine secondary work, processes, and work objects, are then added.

[0023] Type of work, divided into hull, outfitting and painting; The main work type level includes processing, assembly, loading, etc., which is a subdivision of the operation type; The auxiliary trade level includes pre-treatment, steel plate cutting, profile cutting, processing, etc., which is a subdivision of the main trade; Processes, such as steel plate pretreatment and profile pretreatment, are subdivisions of auxiliary tasks. Generally, the structural rules of auxiliary tasks and process levels are combined with the work objects to form work packages / work orders for ship assembly and construction. An example is shown in Table 1.

[0024] Table 1 Ship assembly construction project decomposition and work package breakdown structure Furthermore, the work material quantity requirements at each level of the work type for working hour calculation are sorted out, the selection of work material quantity is clarified, and the material quantity unit is determined.

[0025] The selection of operation materials is based on the operation items with the characteristics of manufacturing intermediate products in ship assembly and construction.

[0026] The selection of operation materials should generally try to choose materials that have a linear functional relationship with the operation workload.

[0027] When a work task includes multiple work quantities, select one representative quantity that has the greatest impact on labor time consumption as the basis for labor time calculation.

[0028] For tasks without work quantities (where a suitable work quantity cannot be found to measure the workload), a single task is described using attribute data such as the work content and the specifications, weight, form, and characteristics of the work object.

[0029] Through this step, the operation quantity demand rules for each level of operation type are formed.

[0030] Furthermore, the material quantity requirements of each level of work types for work time calculation are sorted out to clarify the combination of work objects.

[0031] The combination of work objects varies depending on the granularity of each level of the work type. Generally, the main work type, secondary work type, and process level are used to organize the overall ship's material quantities. The work quantities of work packages / work orders are used to plan the work hours for the work packages / work orders. The granularity of these quantities must correspond to the corresponding construction section, overall construction section, or construction area.

[0032] For special processes, the work volume of the same segment needs to be further divided according to different working conditions and facilities. For example, the processing process needs to be further divided according to the type of processing; In certain cases, it is also necessary to split the workload according to the operation phase. For example, the workload of pipe and outfitting should be further divided into "section pre-installation", "assembly installation", "dockyard operation", "dock operation", "sea trial delivery operation" and other workloads according to the operation phase.

[0033] Through this step, the work quantity combination rules of the work package / work order are formed.

[0034] Furthermore, a "physical structured database" framework is constructed from the perspective of production design output.

[0035] The hull design data required for production management mainly include steel plate / profile preprocessing data, steel plate cutting data, parallel cutting and processing data, steel section cutting and processing data, plate processing data, structural parts data, structural weld data, painting data, etc.

[0036] The outfitting design data required for production management mainly includes pipe outfitting installation pallets, unit installation pallets, iron outfitting installation pallets, equipment installation pallets, electrical outfitting installation pallets, electrical equipment installation lists, cable laying, refrigeration / air conditioning / ventilation installation pallets, interior installation pallets, etc.

[0037] The painting design data required for production management mainly includes painting data.

[0038] By organizing various data attributes based on the operation object, the operation quantity, and data quality verification, the design data structure was simplified and unified while meeting the requirements. This research resulted in the development of a "physical quantity structured database" framework for three hull categories, one outfitting category, and one painting category.

[0039] Ship hull frame structure 1, steel plate blanking or CNC cutting data attribute framework, including "Serial Number," "Project Number," "Section Number," "Cutting Layout," "Plate Thickness (mm)," "Cut Length (mm)," "Cutting Path (mm)," "Marking Length (mm)," "Plate Thickness (mm)," "Marking Path (mm)," "Material Weight (kg)," "Part Weight (kg)," and "Remarks." This applies to steel plate / profile preprocessing data, steel plate blanking data, parallel blanking, and processing data types, as shown in Table 2.

[0040] Table 2 Steel plate blanking or CNC cutting data attribute table Hull frame structure 2: Part processing data attribute framework, including "Serial Number," "Project Number," "Processing Series," "Processing Type," "Section Number," "Processing Series," "Plate Frame Name," "Part Type," "Quantity," "Weight," "Material Flow," and "Remarks." This applies to steel cutting and processing data, plate processing data, and structural part data types, as shown in Table 3.

[0041] Table 3 Structural parts data attribute table Serial number property Remark 1 Project No. 2 Processing series 3 Processing type Since the formats and attributes for exterior panel processing and profile processing are unified, it's necessary to differentiate between processing types. Processing codes are written for those that require processing. For example, F represents "bracket processing (folding) on ​​this side," K represents "hem folding (folding)" for large components, and X represents "no processing," etc. 4 Segment number 5 Board rack name 6 Part Type 7 quantity 8 weight 9 Material flow 10 Remark Ship frame structure 3, structural weld data attribute framework, includes "serial number", "ship number", "section number", "joint name", "component 1 ID", "component 2 ID", "component 1 name", "component 2 name", "plate thickness 1", "plate thickness 2", "material 1", "material 2", "weld leg height", "weld type", "weld length", "weld posture", "construction stage", and "remarks". (See Table 4).

[0042] Table 4 Structural weld data attribute table Serial number property Remark 1 Serial number 2 Ship number 3 Segment number 4 Joint Name 5 Part 1 ID 6 Part 2 ID 7 1 person for parts and materials 8 2 people for parts and materials 9 Plate thickness 1 10 Plate thickness 2 11 Material 1 12 Material 2 13 Welding foot height 14 Welding type 15 Welding length 16 Welding posture 17 Construction phase 18 Remark Outfitting frame structures have attributes including "Project Number," "Pallet Name," "Pallet Number," "Section Number," "Phase," "Professional," "Issuance Date," "Material Code," "Installation Component Number," "Material Name," "Specification," "Material," "Length," "Auxiliary Quantity," "Auxiliary Unit," "Gross Weight," "Gross Weight Unit," "Unit Weight," "Remarks," "Entry Date," "Entry Person," "Modification Date," and "Modification Person." These attributes apply to pipe and outfitting installation pallets, unit installation pallets, iron and steel outfitting installation pallets, equipment installation pallets, electrical outfitting installation pallets, electrical equipment installation lists, refrigeration / air conditioning / ventilation installation pallets, and interior installation pallets, as shown in Table 5.

[0043] Table 5 Data attribute table of outfitting installation tray Serial number property Remark 1 Project No. 2 Pallet Name 3 Pallet number 4 Segment number Segment, total segment, area 5 stage 6 major Pipeline outfitting, electrical outfitting, iron outfitting, interior decoration, etc. 7 Issue time 8 Material Code 9 Mounting Part Number 10 Material Name 11 Specification 12 Material 13 length Only used for pipes and spiral ducts 14 Auxiliary quantity 15 Auxiliary units Units other than kilograms (weight) are shown in Appendix 1. 16 Gross weight 17 Gross weight unit Unit: kilogram 18 Unit weight 19 Remark 20 Entry date 21 Data entry personnel 22 Modification Date 23 Editor For painted frame structures, the attributes include "project number," "section," "serial number," "painting location," "total area (m2)," "rust removal level," "number of passes," "theoretical coating rate," "repair rate," and "repair area (m2)." See Table 6.

[0044] Table 6 Coating data attribute table Serial number property Remark 1 Project No. 2 Segment Segment / Total Segment / Area 3 Serial number 4 Painting area 5 Total area (m2) 6 Rust removal level 7 number of times 8 Theoretical coating rate 9 Repair rate Only the rear area is painted 10 Repair area (m2) Only the rear area is painted Furthermore, the first data processing is based on the "physical structured database".

[0045] In order to ensure the standardization of the quantity data, the inspection shall be carried out according to the selected quantity units of each operation, and the measurement units of the quantity shall be the same.

[0046] Due to differences in the timing of extraction from the hull design model and the varying application of modeling standards and specifications by designers, data on material and weld properties for individual sections may contain errors. This data quality is improved by verifying the matching of the primary flow of structural part data in the structural parts list with the weld data in the structural weld data. Normally, the phases corresponding to part names should be consistent in the "Structural Parts List" and "Structural Weld List" phases. The data for the three possible abnormalities should not exceed 5% of the total data.

[0047] Abnormal situation 1: The part name exists in the "Structural Parts List" but does not exist in the "Structural Weld List"; Abnormal situation 2: The part name does not exist in the "Structural Parts List" but exists in the "Structural Weld List"; Abnormal situation 3: The phase corresponding to the part name exists in both the "Structural Parts List" and the "Structural Weld List", but the phases are inconsistent.

[0048] When a certain proportion of "Abnormal Situation 1" and "Abnormal Situation 2" appears, it means that a certain proportion of model data was not extracted during the data extraction of a single segment. It is recommended that the design software information officer and the hull professional designer jointly check the cause (possibly due to incorrect extraction rules, non-standard model establishment rules, etc.) and clarify the data quality improvement method.

[0049] If a certain proportion of "Abnormal Case 3" occurs, it indicates that the design model has been significantly modified between the time when the two types of data for that single segment were extracted. It is recommended that the design data be re-extracted and released.

[0050] Furthermore, the framework of the "operation quantity database" for each operation level is constructed from the perspective of working time calculation.

[0051] For work projects designed to calculate working hours, a "work quantity database" is constructed for each level of work, secondary work, and process, as well as for work packages / work orders. For work items at higher levels, the same database framework can be used, including attributes such as "serial number," "vessel number," "work code," "work content," "work quantity unit," "work quantity," "completeness," and "remarks." "Completeness" is the ratio of published quantity pallets for that category to the total quantity pallets. This is shown in Table 7.

[0052] Table 7: Main / Secondary Work Type Hierarchical Attributes of “Work Quantity Database” Serial number property Remark 1 Serial number 2 Ship number 3 Job Code 4 Assignment Content 5 Operation quantity unit 6 Work volume 7 Completeness The numerator is the number of existing pallets; the denominator is the total number of pallets. 8 Remark The database framework for work packages / work orders includes the attributes "Serial Number," "Vessel Number," "Work Package / Work Order Code," "Work Package / Work Order Content," "Work Quantity Unit (or Single Task Description)," "Generation / Update Date," and "Remarks." The "Work Package / Work Order Code" serves as a keyword for quantity indexing during work dispatches; the "Generation / Update Date" provides a note for different design data versions, useful for manual verification of anomalies. The granularity of the work object for work content should be consistent with the granularity of the work quantity combinations at each level of the work type, as shown in Table 8.

[0053] Table 8 Work package / work order attribute table of "Work quantity database" Serial number property Remark 1 Serial number 2 Ship number 3 Work package / work order code 4 Work package / work order content 5 Unit of work quantity (or description of a single task) 6 Creation / Update Date When reading imported data, note "manually verified data" 7 Remark Furthermore, a second data processing is performed for physical quantity applications. The physical quantity data for work packages / work orders in the "Work Physical Quantity Database" is directly used for work package / work order dispatch management. The physical quantity data version must be updated based on the work package / work order's construction status. Work package / work order construction statuses include "Not Started," "Under Construction," and "Completed." If there are no work packages / work orders (not compiled), actual work hours for the work packages / work orders have not been reported, and the project has not been marked as completed, the status is "Not Started." If actual work hours for the work packages / work orders have been reported, but the project has not been marked as completed, the status is "Under Construction." If the project has been marked as completed, the status is "Completed." For projects marked as "Under Construction" or "Completed," if the current version of the physical quantity data differs from the physical quantity data in the dispatch system (for example, a difference greater than 5%), a physical quantity data discrepancy checklist is generated for each project, which serves as a basis for the time management personnel to decide whether to update the data.

[0054] Furthermore, an automatic extraction strategy for the work volume is formulated.

[0055] Considering that a common drawing generation method uses a single set of design data for a series of ships (or parts thereof), a configuration table for the series of ships' drawing generation methods was developed to establish a correspondence between each ship construction number and the design drawing number, serving as the basis for generating quantity data. Attributes include "Serial Number," "Building Number," "Design Drawing Number," "Completion Status," and "Remarks." The "Completion Status" status annotation is used in the automatic generation strategy, as shown in Table 9.

[0056] Table 9 Series Ship Drawing Output Configuration Table Because each product and data type has a high volume of updates, to reduce server computing resources, before updating a specific product category, the design quantity data for that category is compared with the total quantities in the "Operational Quantity Database." If the total quantities remain unchanged, no data update is required for that product. This method avoids multiple calculations and updates for the same data.

[0057] The automatic update strategy for the operation quantity at each level adopts the method of automatically updating the quantity data of the unfinished ships in the "Completion" of the product corresponding to the product design drawing number in Table 9 "Series Ship Drawing Configuration Table" at 24:00 at night.

[0058] The above-mentioned method for automatically extracting the operation quantity of ship assembly and construction is achieved by sorting out the characteristics of intermediate products of ship assembly and construction for man-hour calculation, sorting out the needs for man-hour calculation, clarifying the selection of operation quantities and clarifying the combination of operation quantity objects, constructing a "structured quantity database" framework based on the production design output perspective, performing the first data processing (standardization inspection of quantity units and verification of weld data quality), constructing a "operation quantity database" framework from the perspective of man-hour calculation, performing the second data processing (proofreading for operation quantity application), and formulating an automatic extraction strategy for operation quantities. It realizes the automatic extraction of operation quantities required for man-hour calculation (or dispatching), improves the efficiency and quality of quantity acquisition, and provides a basis for the application of operation quantities for subsequent automatic calculation of planned man-hours or dispatching management.

[0059] This application addresses the problems of a wide variety of data types, diverse data structures, scattered data storage, and inconsistent data management in the production design output of operational quantities for ship assembly and construction. By doing so, a "quantity structured database" is constructed to achieve the first data processing based on the perspective of production design output, thereby forming unified and standardized quantity structured data. In response to the problem of significant discrepancies in the granularity of production design quantity data and operational quantities for man-hour calculation (or work dispatch management), an "operation quantity database" is constructed to form relatively uniformly formatted operational quantities and related attribute data for each operation level, thereby providing a basis for subsequent automatic calculation of planned man-hours or work dispatch management of operational quantities.

[0060] Example 2 Embodiment 2 includes all the technical features of embodiment 1. In embodiment 2, a method for automatically extracting the material quantity of ship assembly construction operations is provided, including the steps of: Step S11) sorting out the characteristics of the shipbuilding intermediate products to form a shipbuilding operation breakdown structure, wherein the shipbuilding operation breakdown structure includes three levels of main work, secondary work, and process in a tree-like structure, as well as work packages / work orders combining secondary work, process, and work objects; Step S12) Split the processed material quantity according to the operation items, select the operation quantity based on the working time calculation requirements, and generate the operation quantity corresponding to each operation item; Step S13) sorting out the combination rules of the work quantity objects of each work item, and constructing a structured quantity database from the perspective of production design output, wherein the structured quantity database includes a design data attribute table corresponding to each work item; Step S14) extracting attributes associated with the main type of work, the sub-type of work, the process, and the work package / dispatch from the design data attribute table of the physical quantity structured database, and reorganizing them to form an operation item attribute table. The operation item attribute table includes a main type of work hierarchical attribute table, a sub-type of work hierarchical attribute table, and a process hierarchical and work package / dispatch physical quantity attribute table. The main type of work hierarchical attribute table, the sub-type of work hierarchical attribute table, the process hierarchical attribute table, and the work package / dispatch physical quantity attribute table are constructed into an operation physical quantity database. Step S15) In response to the work quantity table corresponding to the target work item for man-hour calculation or work dispatch, the work item attribute table corresponding to the target work item is obtained, and the value of each attribute in the work item attribute table is set according to the value in the design drawing of the target work item to form the work quantity table corresponding to the target work item.

[0061] Furthermore, the shipbuilding intermediate product characteristics are sorted out to form a shipbuilding operation decomposition structure, which includes three levels of main work types, secondary work types, and processes in a tree-like structure, as well as work packages / work orders that combine secondary work types, processes, and work objects, including: Based on the ship assembly construction project decomposition and work package decomposition structure, the ship construction intermediate product characteristics are obtained as the ship construction operation decomposition structure; Decomposing the shipbuilding operation structure into hull, outfitting and painting according to the operation type; For each job type, the job type levels are set up in a tree structure from high to low: main job type, sub-job type, and process type, as well as work packages / work orders that combine sub-job type, process, and job object; The main work types include processing, assembly, and loading, which are subdivisions of the work types; The secondary work types include pre-treatment, steel plate cutting, profile cutting, and processing, which are subdivisions of the primary work types; The process includes steel plate pretreatment and profile pretreatment, which are subdivisions of the auxiliary work; The sub-jobs and the work objects are combined to form work packages, and the processes and the work objects are combined to form work orders. The work packages / work orders are the project splitting of the sub-jobs and processes based on the work objects.

[0062] Furthermore, the process of splitting the processing material quantity according to the operation items, selecting the operation material quantity based on the working time calculation requirement, and forming the operation material quantity corresponding to each operation item includes: Sorting out the material requirements for each level of operation type, and determining the selection targets for material requirements based on operation projects with the characteristics of manufacturing intermediate products in ship assembly and construction; Select the amount of work that has a linear functional relationship with the workload and determine the unit of the work amount; When a task contains multiple work quantities, select the representative quantity that has the greatest impact on work time consumption as the work quantity for work time calculation; When there is no work quantity that presents a linear functional relationship with the work workload, the work quantity of a single task is selected based on the work content and the specifications, weight, form, and characteristic attribute data of the work object; Summarize and generate the work quantity corresponding to each work item.

[0063] Furthermore, the combination rules of the work quantity objects of each work item are sorted out, and a structured quantity database is constructed from the perspective of production design output. The structured quantity database includes a design data attribute table corresponding to each work item, including: According to the granularity of each level of the operation type, a combination of operation objects corresponding to various granularity levels is formed, wherein the operation objects at the main work type level, the auxiliary work type level, and the process level are the operation quantities of the entire ship, and the operation objects of the work package / work order are the operation quantities of the corresponding construction section, the overall construction section, or the construction area; Sort out the work quantity objects of work packages / work orders and form the work quantity combination rules of work packages / work orders; The design data output by the production design is sorted and obtained, including hull design data, outfitting design data, and painting design data; the hull design data includes steel plate / profile preprocessing data, steel plate blanking data, parallel blanking and processing data, section steel blanking and processing data, plate processing data, structural parts data, structural weld data, and painting data; the outfitting design data includes pipe and outfitting installation pallets, unit installation pallets, iron outfitting installation pallets, equipment installation pallets, electrical outfitting installation pallets, electrical equipment installation lists, cable laying, refrigeration / air conditioning / ventilation installation pallets, and interior installation pallets; the painting design data includes painting data; The design data output by the production design is converted into a design data attribute table corresponding to each operation item, and the design data attribute table is stored in a physical quantity structured database.

[0064] Furthermore, converting the design data output by the production design into a design data attribute table corresponding to each operation item, and storing the design data attribute table in a physical quantity structured database includes: The design data attribute table stored in the physical quantity structured database is a data attribute framework of three hull categories, one outfitting category, and one painting category; The design data attribute tables of the three types of hulls include a steel plate blanking or CNC cutting data attribute frame, a parts processing data attribute frame, and a structural weld data attribute frame; The attributes of the steel plate blanking or CNC cutting data attribute framework include "serial number", "project number", "segment number", "cutting layout", "plate thickness (mm)", "cutting length (mm)", "cutting path length (mm)", "marking length (mm)", "plate thickness (mm)", "marking path length (mm)", "material weight (kg)", "part weight (kg)", and "remarks", which are applicable to steel plate / profile preprocessing data, steel plate blanking data, parallel blanking and processing data types; The attributes of the part processing data attribute framework include "serial number", "project number", "processing series", "processing type", "segment number", "processing series", "plate rack name", "part type", "quantity", "weight", "material flow direction", and "remarks", which are applicable to steel blanking and processing data, plate processing data, and structural part data types; The attributes of the structural weld data attribute framework include "serial number", "vessel number", "section number", "joint name", "component 1 ID", "component 2 ID", "component 1 name", "component 2 name", "plate thickness 1", "plate thickness 2", "material 1", "material 2", "weld leg height", "welding type", "welding length", "welding posture", "construction stage", and "remarks". The attributes of the outfitting frame structure frame include "project number", "pallet name", "pallet number", "section number", "stage", "professional", "issuance time", "material code", "installation part number", "material name", "specification", "material", "length", "auxiliary quantity", "auxiliary unit", "total weight", "total weight unit", "unit weight", "remarks", "entry date", "entry person", "modification date", "modification person"; The attributes of the painted frame structure frame include "project number", "section", "serial number", "painting location", "total area (m2)", "rust removal level", "number of times", "theoretical coating rate", "repair rate", "repair area (m2)", and "remarks".

[0065] Furthermore, after constructing the physical quantity structured database, the following steps are further included: A quantity unit check is performed on the operation quantity corresponding to the attribute in the design data attribute table in the quantity structured database, so that the quantity unit of the same operation quantity is kept the same.

[0066] Furthermore, after constructing the operation material quantity database, the method further includes: The version of the work package / work order quantity attribute table is controlled and updated according to the construction status of the work package / work order; the construction status of the work package / work order includes three states: "not started", "under construction", and "completed"; the construction status is "not started" when there is no work package / work order, the actual working hours of the work package / work order are not reported, and the project is not set to completion; the construction status is "under construction" when the actual working hours of the work package / work order are reported and the project is not set to completion; the construction status is "completed" when the project of the work package / work order is completed.

[0067] Furthermore, the method further comprises: Formulate a configuration table for the output mode of a series of ships, form a correspondence between each built ship number and the designed ship number, and use it as the basis for generating quantity data. Set the attributes of the configuration table for the output mode of a series of ships to include "serial number", "built ship number", "designed ship number", "completion", and "remarks"; Regularly check whether the product "Completion" content corresponding to the design drawing ship number in the series ship drawing configuration table is completed, and the physical quantity data of unfinished products is automatically updated according to the latest version of the design drawing.

[0068] The above-mentioned method for automatically extracting the material quantity of ship assembly and construction operations forms a decomposition structure of ship construction operations by sorting out the intermediate product characteristics of ship assembly and construction for man-hour calculation, splitting the processing material quantity according to the operation items to form the operation material quantity corresponding to each operation item, and then sorting out the combination rules of the operation material quantity objects of each operation item, constructing a material quantity structured database from the perspective of production design output, storing a design data attribute table with the design data in the production design drawing as the attribute in the material quantity structured database, and then extracting the attributes associated with the main type of work, the sub-type of work, the process and the work package / work order across multiple design data attribute tables, and re-forming The main work type level attribute table, the auxiliary work type level attribute table, the process level and the work package / dispatch quantity attribute table are constructed into an operation quantity database. The operation quantity database provides a basis for calculating working hours or dispatching to extract the operation quantity table corresponding to the target operation project, so as to realize the automatic extraction of operation quantity by setting the value of each attribute in the operation project attribute table in combination with the value in the design drawing of the target operation project, and form the operation quantity table corresponding to the target operation project, which reduces human participation and has high data quality. When calculating working hours, the operation quantity data can be obtained in a timely, efficient and accurate manner according to the required granularity, thereby improving the acquisition efficiency.

[0069] Example 3 In one embodiment, a computer device is provided. The computer device may be a server, and its internal structure diagram may be as follows: Figure 3 As shown. The computer device includes a processor, memory, network interface, and database connected via a system bus. The processor of the computer device is used to provide computing and control capabilities. The memory of the computer device includes a non-volatile storage medium and an internal memory. The non-volatile storage medium stores an operating system, a computer program, and a database. The internal memory provides an environment for the operation of the operating system and computer program in the non-volatile storage medium. The database of the computer device is used to store data for automatically extracting material quantities of ship assembly and construction operations. The network interface of the computer device is used to communicate with an external terminal via a network connection. When executed by the processor, the computer program implements a method for automatically extracting material quantities of ship assembly and construction operations.

[0070] Those skilled in the art will understand that Figure 3 The structure shown in the figure is only a block diagram of a part of the structure related to the solution of the present application, and does not constitute a limitation on the computer device to which the solution of the present application is applied. The specific computer device may include more or fewer components than shown in the figure, or combine certain components, or have a different component arrangement.

[0071] In one embodiment, a computer device is provided, including a memory, a processor, and a computer program stored in the memory and executable on the processor. When the processor executes the computer program, the following steps are performed: The characteristics of shipbuilding intermediate products are sorted out to form a shipbuilding operation breakdown structure. The shipbuilding operation breakdown structure includes three operation type levels in a tree structure: main work type, secondary work type, and process, as well as work packages / work orders that combine secondary work type, process, and work object. Split the processing material quantity according to the operation items, select the operation quantity based on the working time calculation requirements, and generate the operation quantity corresponding to each operation item; Sorting out the combination rules of the work quantity objects of each work item, and constructing a structured quantity database from the perspective of production design output. The structured quantity database includes a design data attribute table corresponding to each work item; Attributes associated with the main type of work, the sub-type of work, the process, and the work package / dispatch are extracted from the design data attribute table of the physical quantity structured database, and reorganized to form an operation item attribute table, wherein the operation item attribute table includes a main type of work hierarchical attribute table, a sub-type of work hierarchical attribute table, a process hierarchical attribute table, and a work package / dispatch physical quantity attribute table. The main type of work hierarchical attribute table, the sub-type of work hierarchical attribute table, the process hierarchical attribute table, and the work package / dispatch physical quantity attribute table are constructed into an operation physical quantity database; In response to the work quantity table corresponding to the target work project used for man-hour calculation or work assignment, the work project attribute table corresponding to the target work project is obtained, and the value of each attribute in the work project hierarchical attribute table is set according to the value in the design drawing of the target work project to form the work quantity table corresponding to the target work project.

[0072] Regarding the specific limitations on the steps implemented when the processor executes the computer program, please refer to the limitations on the method for automatically extracting the material quantity of ship assembly and construction operations mentioned above, which will not be repeated here.

[0073] In one embodiment, a computer-readable storage medium is provided, on which a computer program is stored. When the computer program is executed by a processor, the following steps are implemented: The characteristics of shipbuilding intermediate products are sorted out to form a shipbuilding operation breakdown structure. The shipbuilding operation breakdown structure includes three levels of main work types, secondary work types, and processes in a tree-like structure, as well as work packages / work orders that combine secondary work types, processes, and work objects. Split the processing material quantity according to the operation items, select the operation quantity based on the working time calculation requirements, and generate the operation quantity corresponding to each operation item; Sorting out the combination rules of the work quantity objects of each work item, and constructing a structured quantity database from the perspective of production design output. The structured quantity database includes a design data attribute table corresponding to each work item; Attributes associated with the main type of work, the sub-type of work, the process, and the work package / dispatch are extracted from the design data attribute table of the physical quantity structured database, and reorganized to form an operation item attribute table, wherein the operation item attribute table includes a main type of work hierarchical attribute table, a sub-type of work hierarchical attribute table, and a process hierarchical and work package / dispatch physical quantity attribute table. The main type of work hierarchical attribute table, the sub-type of work hierarchical attribute table, the process hierarchical attribute table, and the work package / dispatch physical quantity attribute table are constructed into an operation physical quantity database; In response to the work quantity table corresponding to the target work project used for man-hour calculation or work assignment, the work project hierarchical attribute table corresponding to the target work project is obtained, and the value of each attribute in the work project attribute table is set according to the value in the design drawing of the target work project to form the work quantity table corresponding to the target work project.

[0074] Regarding the specific limitations on the steps implemented when the computer program is executed by the processor, please refer to the limitations on the method for automatically extracting the material quantity of ship assembly construction operations mentioned above, which will not be repeated here.

[0075] Those skilled in the art will understand that all or part of the processes in the above-mentioned embodiments can be implemented by instructing the relevant hardware through a computer program. The computer program can be stored in a non-volatile computer-readable storage medium. When the computer program is executed, it can include the processes of the embodiments of the above-mentioned methods. Among them, any reference to memory, storage, database or other media used in the embodiments provided in this application may include non-volatile and / or volatile memory. Non-volatile memory may include read-only memory (ROM), programmable ROM (PROM), electrically programmable ROM (EPROM), electrically erasable programmable ROM (EEPROM) or flash memory. Volatile memory may include random access memory (RAM) or external cache memory. By way of illustration and not limitation, RAM is available in many forms such as static RAM (SRAM), dynamic RAM (DRAM), synchronous DRAM (SDRAM), double data rate SDRAM (DDRSDRAM), enhanced SDRAM (ESDRAM), Synchronous Link DRAM (SLDRAM), Rambus direct RAM (RDRAM), direct memory bus dynamic RAM (DRDRAM), and memory bus dynamic RAM (RDRAM), etc.

[0076] The technical features of the above embodiments can be combined arbitrarily. To make the description concise, not all possible combinations of the technical features in the above embodiments are described. However, as long as there is no contradiction in the combination of these technical features, they should be considered to be within the scope of this specification.

[0077] The above-described embodiments merely represent several implementation methods of the present application. While the descriptions are relatively specific and detailed, they should not be construed as limiting the scope of the invention. It should be noted that a person of ordinary skill in the art may make various modifications and improvements without departing from the spirit of the present application, and such modifications and improvements are intended to fall within the scope of protection of the present application. Therefore, the scope of protection of the present application shall be determined by the appended claims.

Claims

1. A method for automatically extracting the material quantity of ship assembly construction work, characterized in that: Including steps: The characteristics of shipbuilding intermediate products are sorted out to form a shipbuilding operation breakdown structure. The shipbuilding operation breakdown structure includes three operation type levels in a tree structure: main work type, secondary work type, and process, as well as work packages / work orders that combine secondary work type, process, and work object. Split the processing material quantity according to the operation items, select the operation quantity based on the working time calculation requirements, and generate the operation quantity corresponding to each operation item; Sorting out the combination rules of the work quantity objects of each work item, and constructing a structured quantity database from the perspective of production design output. The structured quantity database includes a design data attribute table corresponding to each work item; Attributes associated with the main type of work, the sub-type of work, the process, and the work package / dispatch are extracted from the design data attribute table of the physical quantity structured database, and reorganized to form an operation item attribute table, wherein the operation item attribute table includes a main type of work hierarchical attribute table, a sub-type of work hierarchical attribute table, a process hierarchical attribute table, and a work package / dispatch physical quantity attribute table. The main type of work hierarchical attribute table, the sub-type of work hierarchical attribute table, the process hierarchical attribute table, and the work package / dispatch physical quantity attribute table are constructed into an operation physical quantity database; In response to the work quantity table corresponding to the target work project used for man-hour calculation or work assignment, the work project attribute table corresponding to the target work project is obtained, and the value of each attribute in the work project attribute table is set according to the value in the design drawing of the target work project to form the work quantity table corresponding to the target work project.

2. The method for automatically extracting the material quantity of ship assembly and construction work according to claim 1, characterized in that: The shipbuilding intermediate product characteristics are sorted out to form a shipbuilding operation breakdown structure, which includes three operation type levels of main work, auxiliary work, and process in a tree structure, as well as work packages / work orders combining auxiliary work, process, and work objects, including: Based on the ship assembly construction project decomposition and work package decomposition structure, the ship construction intermediate product characteristics are obtained as the ship construction operation decomposition structure; Decomposing the shipbuilding operation structure into hull, outfitting and painting according to the operation type; For each job type, the job type levels are set up in a tree structure from high to low, including the main job type, auxiliary job type, and process type, as well as the work package / work order that combines the auxiliary job type, process, and job object; The main work types include processing, assembly, and loading, which are subdivisions of the work types; The secondary work types include pre-treatment, steel plate cutting, profile cutting, and processing, which are subdivisions of the primary work types; The process includes steel plate pretreatment and profile pretreatment, which are subdivisions of the auxiliary work; The sub-work types and the operation objects are combined to form a work package, and the process and the operation object are combined to form a work order. The work package / work order is a project split of the sub-work types and the process based on the operation object.

3. The method for automatically extracting the material quantity of ship assembly construction work according to claim 1, characterized in that: The process of splitting the processing material quantity according to the operation items, selecting the operation material quantity based on the working time calculation requirements, and forming the operation material quantity corresponding to each operation item includes: Sorting out the material requirements for each level of operation type, and determining the selection targets for material requirements based on operation projects with the characteristics of manufacturing intermediate products in ship assembly and construction; Select the amount of work that has a linear functional relationship with the workload and determine the unit of the work amount; When a task contains multiple work quantities, select the representative quantity that has the greatest impact on work time consumption as the work quantity for work time calculation; When there is no work quantity that presents a linear functional relationship with the work workload, the work quantity of a single task is selected based on the work content and the specifications, weight, form, and characteristic attribute data of the work object; Summarize and generate the work quantity corresponding to each work item.

4. The method for automatically extracting the material quantity of ship assembly and construction work according to claim 1, characterized in that: The combination rules of the work quantity objects of each work item are sorted out, and a structured quantity database is constructed from the perspective of production design output. The structured quantity database includes a design data attribute table corresponding to each work item, including: According to the granularity of each level of the operation type, a combination of operation objects corresponding to various granularity levels is formed, wherein the operation objects at the main work type level, the auxiliary work type level, and the process level are the operation quantities of the entire ship, and the operation objects of the work package / work order are the operation quantities of the corresponding construction section, construction section, or construction area; Sort out the operation quantities at each level of the operation type and form the combination rules of the operation quantities at each level of the operation type; The design data output by the production design is sorted and obtained, including hull design data, outfitting design data, and painting design data; the hull design data includes steel plate / profile preprocessing data, steel plate blanking data, parallel blanking and processing data, section steel blanking and processing data, plate processing data, structural parts data, structural weld data, and painting data; the outfitting design data includes pipe and outfitting installation pallets, unit installation pallets, iron outfitting installation pallets, equipment installation pallets, electrical outfitting installation pallets, electrical equipment installation lists, cable laying, refrigeration / air conditioning / ventilation installation pallets, and interior installation pallets; the painting design data includes painting data; The design data output by the production design is converted into a design data attribute table corresponding to each operation item, and the design data attribute table is stored in a physical quantity structured database.

5. The method for automatically extracting the material quantity of ship assembly and construction work according to claim 4, characterized in that: The converting the design data outputted by the production design into a design data attribute table corresponding to each operation item, and storing the design data attribute table in a physical quantity structured database includes: The design data attribute table stored in the physical quantity structured database is a data attribute framework of three hull categories, one outfitting category, and one painting category; The design data attribute tables of the three types of hulls include a steel plate blanking or CNC cutting data attribute frame, a parts processing data attribute frame and a structural weld data attribute frame.

6. The method for automatically extracting the material quantity of ship assembly construction work according to claim 1, characterized in that: After constructing the physical quantity structured database, the following steps are also included: A quantity unit check is performed on the operation quantity corresponding to the attribute in the design data attribute table in the quantity structured database, so that the quantity unit of the same operation quantity is kept the same.

7. The method for automatically extracting the material quantity of ship assembly construction work according to claim 1, characterized in that: After constructing the operation material quantity database, the following steps are further included: The version of the work package / work order quantity attribute table is updated based on the construction status of the work package / work order. The construction status of a work package / work order includes "Not Started," "Under Construction," and "Completed." The construction status is "Not Started" when there is no work package / work order, the actual working hours for the work package / work order are not reported, and the project is not set to "Complete." The construction status is "Under Construction" when the actual working hours for the work package / work order are reported, but the project is not set to "Complete." The construction status is "Completed" when the project of the work package / work order is set to "Complete." 8. The method for automatically extracting the material quantity of ship assembly and construction work according to claim 1, characterized in that: The method further comprises: Develop a configuration table for the production of drawings of a series of ships, establish a correspondence between each ship under construction number and the ship number of the design drawing, and use this as the basis for generating quantity data. Set the attributes of the configuration table for the production of drawings of a series of ships to include "Serial Number", "Construction Number", "Design Drawing Number", "Completion Status", and "Remarks"; Regularly check whether the product corresponding to the design drawing ship number in the series ship drawing configuration table is completed, and automatically update the physical quantity data of unfinished products according to the latest version of the design drawing.

9. A computer device comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein: When the processor executes the computer program, the steps of the method according to any one of claims 1 to 7 are implemented.

10. A computer-readable storage medium having a computer program stored thereon, characterized in that: When the computer program is executed by a processor, the steps of the method according to any one of claims 1 to 7 are implemented.

Images