Ship body information database building method for realizing product data management

Abstract

A hull information database building method for realizing product data management comprises the following steps: building a hull three-dimensional model in ship design software, respectively extracting the hull three-dimensional model to a post-processing platform for storage and processing, and carrying out the processes of user authority configuration, automatic data checking, drawing information back-writing database and the like. Database information and three-dimensional models of different platforms form an SQL database in a unified publishing mode through an integration platform, and the problems of data asynchronization and data islands in multi-software collaborative design are solved through a unique data source and a unique code. And checking the data integrity and the accuracy of time logic. And managing the ship body design information database according to the assembling PBOM, the welding PBOM and the jacking PBOM. According to the hull design database building method, the integrity, accuracy and consistency of design database information are guaranteed, and effective organization and presentation are carried out in a product data management system.

Description

Technical Field

[0001] The present invention belongs to the field of marine ship design and construction, and in particular relates to a method for building a hull information database for realizing product data management. Background Art

[0002] In the context of the integration of digital economy and real economy, the shipbuilding industry has developed into a key industry for digital transformation. my country's shipbuilding industry is not digital enough in the fields of ship design, manufacturing, operation and supply chain management, and needs to further strengthen its digital capabilities. The digital transformation of enterprises requires the integration of various data resources inside and outside the enterprise to achieve data interconnection, and product data management is an important foundation for the digital transformation of enterprises. A complete database is the basic support for product data management. More than 80% of the data information of the hull structure comes from the design stage. Therefore, the construction of the hull design information database is a key link in realizing product data management throughout the life cycle of the hull structure and promoting the digital transformation of the enterprise's production and manufacturing model.

[0003] Traditional hull structure design relies on drawings and forms as information transmission media, resulting in a considerable amount of data not being stored in the design software, and requiring multiple design software to collaborate on the design, which poses a great challenge to the integrity and accuracy of the data source of the hull design database; Hull design is a spiral process with huge data and frequent changes, which brings great challenges to the coordination and management of hull design data; The amount of hull design data is huge, and how to effectively organize and manage the data in the product data management system according to the actual production needs of shipbuilding enterprises is a difficult point; In the scope of publicly reported literature in China, the research on the application of product data management in ship design and BOM-based hull data management focuses on theoretical research and feasibility analysis. At present, domestic shipbuilding companies are still in the exploratory stage for the actual application of product data management, and there are no relevant literature reports on the specific methods of building a hull design information database. Summary of the invention

[0004] In order to solve the above problems, the present invention provides a method for building a hull information database for realizing product data management, ensuring the integrity, accuracy and consistency of the design database information, and effectively organizing and presenting it in the product data management system. The technical solution adopted is: A method for building a hull information database to achieve product data management, the specific steps are: S1: Hull design data information extraction A 3D hull model is established in the ship design software and extracted to each post-processing platform for storage and processing to form an independent database. The integrity and reliability of the design information data source are ensured through user authority configuration, automatic data verification, and drawing information back-writing to the database.

[0005] S2: Hull design data information summary The database information and 3D models of different platforms are published in a unified manner through an integrated platform to form an SQL database. The data asynchrony and data island problems in multi-software collaborative design are solved through a unique data source and unique coding.

[0006] Build a structured database framework, determine the unique data source for each piece of data in the hull design database, and each design platform independently transmits data information to the hull data information database. During the data writing process, the Modle_Name in the 3D model is used as the unique identity code for each part, and single-piece management is performed among multiple identical parts in the database.

[0007] According to the unique data source determined by the constructed structured data framework, the data transmitted by each design platform is screened to form a hull design database.

[0008] S3: Hull design data information verification Verify the data integrity and accuracy of time logic, and verify whether the hull design database contains data of all design platforms.

[0009] Compare the part counts in the hull design database with the part counts in the 3D model.

[0010] Check whether the last modification time of the parts data in the hull design database in the three-dimensional model and each design platform meets the logic.

[0011] S4: Hull design data information presentation The traditional EBOM and PBOM are integrated into one PBOM, and the hull design information database is managed according to assembly PBOM, welding PBOM and nesting PBOM.

[0012] Organize the assembly PBOM data and welding PBOM data according to the logic of overall segment, segment and assembly.

[0013] Among them, PBOM (Process Bill of Materials).

[0014] EBOM (Engineering Bill of Materials).

[0015] The above-mentioned method for building a hull information database for realizing product data management further comprises: in step S1, during the automatic data verification process, the design platform issues an alarm for abnormal data in the copied three-dimensional model, reminding the designer to verify the three-dimensional model to improve data accuracy.

[0016] The method for building a hull design database of the present invention ensures the integrity, accuracy and consistency of the design database information, and effectively organizes and presents it in a product data management system. BRIEF DESCRIPTION OF THE DRAWINGS

[0017] Figure 1 It is a schematic diagram of the process of building a hull design information database; Figure 2 It is a schematic diagram of hull design information data extraction; Figure 3 It is a summary of hull design information data; Figure 4 It is hull assembly welding PBOM (by section); Figure 5 It is hull resistance welding PBOM (by workstation); Figure 6 It is PBOM, the hull steel; Figure 7 It is a hull cutting PBOM; Figure 8 It is a hull pallet PBOM. DETAILED DESCRIPTION

[0018] The present invention will be further described in conjunction with the accompanying drawings.

[0019] Hull design data information extraction: The permissions for designers to use each post-processing platform are limited through permission configuration. Designers enter the correct user name and password to log in to the platform. Each designer can only change the data range assigned by the administrator to prevent data information from being tampered with by others. Designers have no change authority after data is submitted.

[0020] Designers use the extraction function to copy the basic information in the 3D model to an independent storage area for storage and data processing (assembly data processing is completed on the assembly design platform, outer plate frame and marking data processing is completed on the surface design platform, part processing data processing is completed on the part design platform, steel plate cutting data processing is completed on the nesting platform, and welding data processing is completed on the welding platform.

[0021] During the database storage process, the validity of the data extracted to each post-processing platform is verified through non-null constraints, unique constraints, primary key constraints, and check constraints. Alarms are issued for abnormal data to remind designers to check the three-dimensional model and improve data accuracy.

[0022] In the process of generating drawings and forms on each post-processing platform, the data information generated by the calculation (such as the correspondence between drawings and parts, statistical information, update time, etc.) is synchronously written into the database to improve the integrity of the database.

[0023] Form an independent information database for each post-processing platform (assembly database, surface database, parts database, nesting database, welding database) Hull design data information summary: According to the basic project data, block construction data, assembly basic data, steel material warehouse data, nesting diagram data, surplus material data, parts processing data, basic parts data, block welding data, block tightness data, assembly welding data, and assembly tightness data, a structured hull design information database framework is built. A unique data source is determined for each piece of data in the hull design database, effectively solving the problem of data confusion caused by inconsistent data on different design platforms (such as Figure 3 as shown).

[0024] Each design platform independently transmits data information to the hull data information database. Because it is normal for the design platforms to progress asynchronously during the design process, the independent transmission of data information by each platform is more flexible than the unified transmission of all platforms. For data changes on a single platform, only targeted updates are required.

[0025] Because each design platform adopts a solution of independently transmitting data, the Modle_Name of each part is used as the unique identity code during the data writing process, and multiple identical parts in the database are managed as single parts to achieve accurate matching after the data information of different platforms is transmitted separately.

[0026] According to the unique data source determined by the constructed structured data framework, the data transmitted by each design platform is uploaded independently to form a hull design database to solve the collaborative design problems of each platform.

[0027] Upload design drawings and lightweight 3D models into the hull design database.

[0028] Hull design data information verification: Before data is released, the data integrity of the hull design database is checked through non-null constraints, unique constraints, and primary key constraints to avoid data omissions and data duplication on a certain design platform during the multi-software collaborative design process.

[0029] Before data is released, the accuracy of the data is checked by comparing the part attribute information in the hull design database with the attribute information in the 3D model to avoid the situation where the 3D model is modified but not transferred to the database.

[0030] Before data is released, a logical check is performed on the change time of the part data in the hull design database at each link through check constraints to ensure the consistency of information in each platform database and avoid inconsistent versions of part information on each platform.

[0031] Hull design data information presentation: In the product data management system, the tree-like presentation of PBOM data is carried out, and the basic information of the project is presented under the ship name node. The general assembly construction information, pre-assembly construction information, and block construction information are presented under the general assembly, pre-assembly, and block nodes respectively. The assembly information is presented under the assembly node. The basic information of parts and the assembly information of parts are presented under the part node, which is conducive to the management and release of data information at different stages in the design stage (such as Figure 4 as shown).

[0032] In the product data management system, the welding PBOM data is presented in a tree-like manner, and the project welding information is presented under the ship name node. The general group welding information, pre-group welding information, and segment welding information are presented under the general group, pre-group, and segment nodes respectively. The assembly welding information is presented under the assembly node, which is conducive to the management and release of data information at different stages in the design stage.

[0033] The traditional assembly welding PBOM organization only has a segmented organization mode. The present invention adds PBOM data and welding PBOM data organized according to the logic of the construction station (such as Figure 5 As shown in the figure, the project workstation-level assembly information and workstation-level welding information are presented under the workstation node to meet the different needs of construction production management and information extraction.

[0034] The traditional nesting PBOM puts steel and cutting information together, which is not conducive to supply chain management. The present invention divides the nesting PBOM into cutting PBOM and steel PBOM for separate management, and adds a tray PBOM to guide the production department to sort parts (such as Figures 6-8 shown) In the product data management system, the steel PBOM data is presented in a tree-like manner. The steel warehouse information is presented under the steel warehouse node, the order list information is presented under each order node, and the surplus warehouse information is presented under the surplus warehouse node. Figure 6 shown.

[0035] In the product data management system, the tree-like presentation of the PBOM data is performed, the basic information of the project is presented under the ship number node, the batch nesting information is presented under each batch node, the cross-channel nesting information is presented under each cross-to node, the nesting cutting information is presented under each nesting diagram node, and the part processing information is presented under each part, such as Figure 7 shown.

[0036] In the product data management system, the tree-like presentation of pallet PBOM data is used for refined matching of parts, such as Figure 8 shown.

Claims

1. A method for building a hull information database to achieve product data management, characterized in that: The specific steps are: S1: Hull design data information extraction A 3D model of the hull is established in the ship design software and extracted to each post-processing platform for storage and processing to form an independent database. The integrity and reliability of the design information data source are ensured through user authority configuration, automatic data verification, and drawing information back-writing to the database process; S2: Hull design data information summary The database information and 3D models of different platforms are uniformly published through the integrated platform to form an SQL database, and the data asynchronization and data island problems in multi-software collaborative design are solved through a unique data source and unique coding; Build a structured database framework, determine the unique data source for each piece of data in the hull design database, and each design platform independently transmits data information to the hull data information database. During the data writing process, the Modle_Name in the 3D model is used as the unique identity code for each part, and single-piece management is performed for multiple identical parts in the database; According to the unique data source determined by the structured data framework, the data transmitted by each design platform is filtered to form a hull design database; S3: Hull design data information verification Verify the data integrity and accuracy of time logic, and verify whether the hull design database contains data of all design platforms; Compare the number of parts in the hull design database with the number of parts in the 3D model; Check whether the last modification time of the parts data in the hull design database in the three-dimensional model and each design platform meets the logic. If it does not meet the logic, mark the wrong data with ERROR; S4: Hull design data information presentation Integrate the traditional EBOM and PBOM into one PBOM, and manage the hull design information database according to assembly PBOM, welding PBOM, and nesting PBOM; Organize the assembly PBOM data and welding PBOM data according to the logic of overall segment, segment and assembly.

2. A method for building a hull information database for realizing product data management according to claim 1, characterized in that: In step S1, during the automatic data verification process, the design platform issues an alarm for abnormal data in the copied three-dimensional model, reminding the designer to verify the three-dimensional model to improve data accuracy.

Images