Method and system for establishing a database of marine materials for a ship

Abstract

This invention provides a method and system for establishing a marine engineering materials database. The method includes: a data table construction step: constructing a relational data table structure, including a test material information table, which contains at least a first material identifier, a second material identifier, and a third material identifier; an automatic classification step: automatically determining the material type of a data entry based on the combination of values ​​of the first, second, and third material identifiers; an interface construction step: constructing a binary data interface between the database and CAE software; and a data security processing step: serializing and encrypting the data in the database, binding it to an authorization license, and generating an encrypted data file for offline use by the CAE software. The method for establishing a marine engineering materials database described in this invention features standardized data management; seamless integration between the database and CAE software; and high data security.

Description

Technical Field

[0001] This invention relates to the field of computer-aided engineering, and more specifically, to a method and system for establishing a database of marine engineering materials. Background Technology

[0002] CAE (Computer Aided Engineering) refers to computer-aided engineering in engineering design for fields such as shipbuilding and marine engineering. Shipbuilding and marine engineering equipment is a massive system, and its reliability requirements are increasingly stringent. This places ever-higher demands on the industry's CAE capabilities. Currently, my country is making great efforts to overcome the challenges of developing domestically produced CAE solvers and software engineering, and the application of domestically produced CAE software in the shipbuilding and marine engineering industry will continue to grow in the future.

[0003] In engineering simulation design, engineers often require precise material data. Current solutions rely on fragmented resources, such as scattered test data, standards, manuals, and papers, with some data requiring further testing. Since most marine engineering designers are not materials scientists, the preparation and sampling of marine engineering material samples are often not standardized, leading to inaccurate and unreliable material data. This is particularly true for welded joint data, which significantly impacts structural performance and safety and is often scarce and difficult to obtain. All these issues affect CAE design results. The consequence is wasted time searching for material data rather than on engineering research. Furthermore, material data sources are often fragmented, incomplete, and have low usability, resulting in numerous data silos within the project team. Sometimes, it's necessary to redo prototype fabrication and CAE analysis, severely reducing the efficiency and accuracy of proposed solutions and wasting considerable human and material resources.

[0004] High-strength steel is a primary material for ship structures, and the performance of high-strength steel for ships is a necessary prerequisite for the simulation of ship structure and overall performance, serving as the foundation for ship design and production design. However, current ship material data suffers from uneven distribution, high dispersion, complex influencing factors, severe data silos, and a weak connection between material properties and structural properties, failing to effectively leverage the value of data resources to assist in structural design.

[0005] a) Lack of unified standards for materials data management. Materials research, production, and application departments often organize data on a project or batch basis. Because the required data formats are not standardized, important parameters are easily missed or inconsistent, affecting the application of materials data in structural design.

[0006] b) Lack of advance planning for material data management and application. Since most material performance tests are based on research or quality inspection purposes, the future management and application of material data are not uniformly considered. Furthermore, the requirements for data content and format differ significantly from the application direction of ship structural design, meaning that most existing material data cannot be directly applied in ship design.

[0007] c) There are instances of repeated material testing and inconsistent material parameters in ship structural design. Due to differences in material data specifications and other requirements, it is necessary to supplement material data testing to meet the needs of ship structural design. Furthermore, this data is scattered across different units and departments, creating data silos. Therefore, different design departments conduct repeated testing on the same type of material, resulting in inconsistent material parameters and consequently discrepancies in structural design and analysis results.

[0008] d) The material parameters used in ship structural design lack statistical verification. Due to the existence of data silos in materials, the material parameters obtained by various design departments lack comparison with historical big data, which may lead to deviations in the design scheme due to the unrepresentative nature of material properties.

[0009] The existing patent CN116991844A discloses a fastener and material database that can connect and communicate data from different stages in the display of fastener material data. This is beneficial for professionals in different job categories to have a holistic understanding of fastener manufacturing. It adopts a B / S architecture and has basic management functions such as adding, deleting, modifying, and querying data, as well as hierarchical user permission management. However, this database does not consider the application in CAE integrated design, and it is mainly written using a foreign database backend. It also lacks batch data management functions, which is not conducive to large-scale data supplementation by steel mills, shipyards, etc. Furthermore, this database cannot meet the special requirements of the shipbuilding and marine engineering industry for integrated management and CAE access to welding joint data, dynamic / fatigue / corrosion and other multi-condition data.

[0010] Patent CN117034448A discloses a vehicle component material database system and a vehicle R&D system. This system can store material information, including at least basic material information, material performance information, and material approval information. The system may include a first sub-database, a second sub-database, a third sub-database, a query module, a calling module, and an interactive interface. The first sub-database stores basic material information categorized by material standard grades; the second sub-database stores material performance information for typical components; and the third sub-database stores material approval information categorized by supplier information. The query module can be used to query the material information stored in the first, second, and third sub-databases; the calling module can be used to call the material information stored in the first, second, and third sub-databases; and the interactive interface allows users to interact with the system to obtain material information. Although the system includes the basic data required for CAE analysis and management functions, its data types are relatively simple, and it does not consider the application requirements of a standalone software version.

[0011] Patent CN107563063A discloses a method for obtaining CAE simulation parameter data for acoustic materials. It provides a method for acquiring the basic data involved in the current process of establishing acoustic models of automobiles and their components. Basic data such as density ρ, thickness h, Young's modulus E, structural damping loss factor η, Poisson's ratio υ, porosity φ, and flow resistance σ can be obtained directly through experimental testing. Geometric bending coefficient α∞, viscous characteristic length Λ, and thermal characteristic length Λ′, however, need to be calculated using CAE methods based on the tested basic data, and then used in subsequent material-level, component-level, and vehicle-level modeling processes. However, this patent does not address the design of the database.

[0012] Existing database technologies suffer from problems such as data fragmentation, inconsistent formats, disconnect from CAE analysis, and poor data security.

[0013] In view of this, the present invention is hereby proposed. Summary of the Invention

[0014] The purpose of this invention is to propose a method and system for establishing a database of marine engineering materials, so as to solve the problems of data dispersion, inconsistent format, disconnect from CAE analysis, and poor data security in existing databases.

[0015] To achieve the above objectives, the technical solution of the present invention is implemented as follows:

[0016] A method for establishing a database of marine engineering materials, the method comprising the following steps:

[0017] Data table construction steps: Construct a relational data table structure, which includes an experimental material information table, and the experimental material information table contains at least a first material identifier, a second material identifier, and a third material identifier;

[0018] Automatic classification step: Based on the combination of the values ​​of the first material identifier, the second material identifier, and the third material identifier, the material type of the data entry is automatically determined. The material type includes base material, hull steel plate welded joint, hull dissimilar steel welded joint, and weld metal deposited.

[0019] Interface construction steps: Construct a binary data interface between the database and the CAE software. The data format defined by the binary data interface includes a file header, a data area, and an index area.

[0020] Data security processing steps: Serialize and encrypt the data in the database, bind it with the license, and generate an encrypted data file for offline use by CAE software.

[0021] Furthermore, in the automatic classification step:

[0022] When the first material identifier and the second material identifier have the same value and neither is a default value, and the third material identifier is not a default value, it is determined to be a hull steel plate welded joint.

[0023] When the first material identifier and the second material identifier have different values ​​and neither is a default value, and the third material identifier is not a default value, it is determined to be a dissimilar steel welding joint for the hull.

[0024] When both the first material identifier and the second material identifier are default values, and the third material identifier is not a default value, it is determined to be weld metal.

[0025] When the first material identifier is not a default value, and both the second and third material identifiers are default values, it is determined to be a matrix material.

[0026] Furthermore, in the binary data interface, the file header includes a magic number, a version number, an encryption flag, and a data area start offset.

[0027] Furthermore, in the binary data interface, the data area stores data records according to a predefined data type.

[0028] Furthermore, in the binary data interface, the index area stores indexes of key fields required by the CAE software.

[0029] Furthermore, the data security processing steps specifically include:

[0030] Perform a physical backup of the database;

[0031] Read data from the backup database and serialize it into binary data;

[0032] The serialized binary data is encrypted using an algorithm;

[0033] The encrypted data is written to an encrypted data file, and the decryption key is bound to the license.

[0034] Furthermore, the establishment method also includes: integrating a decryption module into the CAE software, wherein the decryption module decrypts the encrypted data file in real time after obtaining a valid license, loads the decrypted data into memory for CAE analysis, and clears the decrypted data in memory after the calculation is completed.

[0035] A second aspect of the present invention provides a system for establishing a ship and marine engineering materials database based on any one of the methods described in the invention, the system comprising:

[0036] A data storage module is used to store relational data constructed according to the data table structure, wherein the data table structure includes at least a base material data table, a welding material data table, a mechanical property data table, a fatigue performance data table, and a corrosion performance data table;

[0037] The automatic classification module is used to automatically determine the material type based on the combination of identifiers in the test material information table;

[0038] The interface module is used to enable data interaction with CAE software according to the binary data format.

[0039] The security management module is used to perform data serialization, encryption, decryption, and license verification.

[0040] Furthermore, the data storage module uses the domestic DM database as the lowest level of storage, the backend uses the Solon framework, and the frontend uses the Vue framework.

[0041] Furthermore, the system also includes a permission management module, which is configured to support at least three roles: database maintenance personnel, material testing personnel, and ship structure design and engineering technicians, and assigns different data operation permissions to different roles.

[0042] This invention proposes a method and system for establishing a database of marine engineering materials. Compared with the prior art, the method and system for establishing a database of marine engineering materials described in this invention have the following advantages:

[0043] (1) Data management standardization: Through innovative data table structure and automatic classification rules, unified management of base material, weld joint and corrosion data is realized. Data types can be automatically identified without manual labeling, avoiding the problems of missing important parameters and inconsistent formats.

[0044] (2) Efficient CAE analysis: Through a custom binary data interface, the database and CAE software are seamlessly integrated. Engineers can directly call standardized material data in the CAE environment, which greatly shortens the CAE analysis preprocessing time, avoids repeated testing, and improves the efficiency and accuracy of the proposed solution.

[0045] (3) Data security and controllability: Through a complete technical solution of serialization, encryption and authorization binding, data assets are securely protected, offline use scenarios are supported, piracy is effectively curbed, and the requirements of information technology innovation are met.

[0046] (4) Independent and controllable: The entire chain of independent and controllable technology stack, including the domestic DM database, Solon backend framework, Vue frontend framework and SM4 national cryptographic algorithm, is adopted, which reduces the risk of supply chain. Attached Figure Description

[0047] Figure 1 This is one of the DFD diagrams of a marine engineering materials database according to an embodiment of the present invention;

[0048] Figure 2 This is the second DFD diagram of a marine engineering materials database according to an embodiment of the present invention;

[0049] Figure 3 This is the third DFD diagram of a marine engineering materials database according to an embodiment of the present invention;

[0050] Figure 4 This is a data flow diagram of a ship and marine engineering materials database according to an embodiment of the present invention;

[0051] Figure 5 This is a graph showing the mechanical properties of high-strength steel materials for ships, as described in an embodiment of the present invention, from a marine engineering materials database. Detailed Implementation

[0052] To make the technical means and objectives and effects of the present invention easier to understand, the embodiments of the present invention will be described in detail below with reference to specific illustrations.

[0053] It should be noted that all directional and positional terms used in this invention, such as "up," "down," "left," "right," "front," "back," "vertical," "horizontal," "inner," "outer," "top," "bottom," "lateral," "longitudinal," and "center," are only used to explain the relative positional relationships and connections between components in a specific state (as shown in the accompanying drawings). They are merely for the convenience of describing the invention and do not require the invention to be constructed and operated in a specific orientation; therefore, they should not be construed as limitations on the invention. Furthermore, descriptions involving "first," "second," etc., are for descriptive purposes only and should not be construed as indicating or implying their relative importance or implicitly specifying the number of technical features indicated.

[0054] In the description of this invention, unless otherwise explicitly specified and limited, the terms "installation," "connection," and "linking" should be interpreted broadly. For example, they can refer to a fixed connection, a detachable connection, or an integral connection; they can refer to a mechanical connection; they can refer to a direct connection or an indirect connection through an intermediate medium; and they can refer to the internal communication between two components. Those skilled in the art can understand the specific meaning of the above terms in this invention based on the specific circumstances.

[0055] In the description of this specification, the references to terms such as "one embodiment," "some embodiments," "illustrative embodiment," "example," "specific example," or "some examples," etc., indicate that a specific feature, structure, material, or characteristic described in connection with that embodiment or example is included in at least one embodiment or example of the invention. In this specification, the illustrative expressions of the above terms do not necessarily refer to the same embodiment or example. Furthermore, the specific features, structures, materials, or characteristics described may be combined in any suitable manner in one or more embodiments or examples.

[0056] The present invention will now be described in detail with reference to the accompanying drawings and embodiments.

[0057] Example 1

[0058] Existing database technologies suffer from problems such as data fragmentation, inconsistent formats, disconnect from CAE analysis, and poor data security.

[0059] To address the above issues, this invention accumulates data on ship structural steel and welded joints by strictly adhering to standardized testing methods, covering aspects such as mechanics, corrosion, fatigue, and physical properties. It also completes the structured summarization of the data and integrates it into domestic CAE software, facilitating comprehensive structural design and analysis of ship and marine engineering steel structures that consider strength, fatigue, corrosion, and processing.

[0060] Furthermore, to ensure complete autonomy and control over the database, a domestically developed database backend framework was adopted during development. This also took into account future offline use of genuine CAE software and data security issues.

[0061] The applicant proposes a method for establishing a database of marine engineering materials, the method comprising the following steps:

[0062] Data table construction steps: Construct a relational data table structure, which includes an experimental material information table, and the experimental material information table contains at least a first material identifier, a second material identifier, and a third material identifier;

[0063] Automatic classification step: Based on the combination of the values ​​of the first material identifier, the second material identifier, and the third material identifier, the material type of the data entry is automatically determined. The material type includes base material, hull steel plate welded joint, hull dissimilar steel welded joint, and weld metal deposited.

[0064] Interface construction steps: Construct a binary data interface between the database and the CAE software. The data format defined by the binary data interface includes a file header, a data area, and an index area.

[0065] Data security processing steps: Serialize and encrypt the data in the database, bind it with the license, and generate an encrypted data file for offline use by CAE software.

[0066] The method for establishing a marine engineering materials database described in this invention not only standardizes data management, avoiding problems such as data dispersion and inconsistent formats, but also achieves seamless integration between the database and CAE software; furthermore, it offers high data security.

[0067] Compared to traditional query or text file reading methods, this invention uses a binary data interface with an index area, which is customized for CAE software to read material parameters in batches and at high frequencies. This greatly improves the data reading speed and significantly reduces the preprocessing waiting time for CAE analysis.

[0068] Specifically, during the data table construction process, considering that the design of marine engineering structures typically includes the design and verification of strength, impact, corrosion, and fatigue, the overall data content is determined as follows, which includes data on the material matrix and welds.

[0069] The collected data were summarized and organized, and the data on high-strength steel materials for ships were mainly divided into three categories: the mechanical properties of the steel matrix (including strength, fatigue, and dynamic load), the mechanical properties of welded joints of steel for ships (including strength, fatigue, and dynamic load), and the corrosion performance of steel for ships. Several data points for each category are shown in Tables 1 to 4. Figure 5As shown, the mechanical property data of high-strength steel materials for ships mainly include static properties, fatigue properties, and dynamic properties. Since the formats of the mechanical property data for the steel plate matrix and weld are similar, the physical properties, quasi-static mechanical properties, dynamic mechanical properties, stress-strain curves, and fatigue performance information for both are unified in the same table (MATERIAL_PHYSICAL_PROPERTY_DATA, MATERIAL_QUASISTATIC_DATA, MATERIAL_DYNAMIC_DATA, STRAIN_STRESS_CURVE_DATA, MATERIAL_FATIGUE_DATA). Furthermore, in the test material information data table (MATERIAL_INFORMATION), the naming rules for base material, weld joints, and deposited metal in the database are unified. The data classification and source can be determined by the value of the keywords in the table, eliminating the need for the data administrator to label the type.

[0070] Table 1 Basic Information of Steel Matrix for Shipbuilding

[0071]

[0072] Table 2 Basic Information on Ship Welding Materials

[0073]

[0074] Table 3. Mechanical and Fatigue Properties of Ship Steel and Joints (Basic Information Table)

[0075]

[0076] Table 4. List of Corrosion Performance Data for Marine Steel and Joints

[0077]

[0078] Explanation of the data in Tables 1-4:

[0079] (1) BASE_METAL_INFORMATION (Steel Plate Substrate Information Data Table for Shipbuilding): This table is mainly used to describe the basic information of steel plate materials, such as grade, furnace number, batch number, and specifications, and assigns a unique and automatically incrementing steel plate number (Steel_ID), starting from the default value of 0. Double-layer metal composite plates are also considered part of the substrate.

[0080] (2) BASE_METAL_COMPOSITION_DATA (Material Chemical Composition Data Table for Ship Steel Plates): It is mainly used to describe the chemical composition information of steel plate materials corresponding to different Steel_IDs, and is usually derived from material quality inspection data.

[0081] (3) WELDING_MATERIAL_INFORMATION (Basic Information Data Table for Weld Metal): It is mainly used to describe the basic information such as welding material grade, furnace number, batch number, and specifications, and assigns a unique and automatically incrementing welding material number (WELDING_MATERIAL_ID), which starts from the default value 0.

[0082] (4) WELDING_MATERIAL_COMPOSITION_DATA (Weld Metal Chemical Composition Data Table): It is mainly used to describe the chemical composition information of welding materials or deposited metals corresponding to different WELDING_MATERIAL_IDs, and usually comes from material quality inspection data.

[0083] (5) WELD_MECHANICAL_PROPERTY_DATA (Mechanical Properties Data Table of Weld Metal): It is mainly used to describe the basic mechanical properties of various welding materials or deposited metals corresponding to different WELDING_MATERIAL_IDs. It is usually derived from material quality inspection data.

[0084] (6) MATERIAL_INFORMATION (Ship Steel and Joint Performance Specimen Information Table): This table is mainly used to describe the specimen information corresponding to various test data in the material data sub-database. It is assigned a unique and automatically incrementing number (JOINT_ID). STEEL_ID (Steel Plate 1 number and Steel Plate 2 number) and WELDING_MATERIAL_ID (Welding Material number) are used as attributes and foreign keys. When the numbers of Steel Plate 1 and Steel Plate 2 are the same and not 0, and the welding material number is not 0, it is a hull steel plate welded joint; when the numbers of Steel Plate 1 and Steel Plate 2 are different and not 0, and the welding material number is not 0, it is a hull dissimilar steel welded joint; when the numbers of Steel Plate 1 and Steel Plate 2 are both 0, and the welding material number is not 0, it is a welding material deposited metal specimen; when the number of Steel Plate 1 is not 0, and the numbers of Steel Plate 2 and welding material are 0, it is a base material type specimen. These data may overlap with the content in Tables 2 and 3, but Tables 2 and 3 are typically used as part of the basic material information (usually sourced from the product's accompanying warranty certificate) for reference.

[0085] Subsequent material performance data will be managed and applied using JOINT_ID as the primary key. Considering user query habits and information redundancy, information such as steel plate number (STEEL_ID) and steel plate grade (STEEL_BRAND_NAME), welding material number (WELDING_MATERIAL_ID) and welding material grade (WELDING_MATERIAL_BRAND_NAME) will still be retained in other performance data tables.

[0086] (7) MATERIAL_COHENSIVE_DATA (Ship steel composite plate bonding strength performance data table): mainly used to provide parameters such as bonding strength of composite plate material at different temperatures corresponding to JOINT_ID.

[0087] (8) MATERIAL_FATIGUE_DATA (Fatigue performance data table for ship steel and joints): It is mainly used to provide fatigue performance parameters such as fatigue limit and fatigue life of various materials corresponding to JOINT_ID.

[0088] (9) MATERIAL_PHYSICAL_PROPERTY_DATA: This is mainly used to provide the basic physical properties of the base material or weld, such as elastic modulus, Poisson's ratio, thermal conductivity, and other material parameters commonly used in structural simulation.

[0089] (10) MATERIAL_QUASISTATIC_DATA (Material Quasi-Static Mechanical Properties Data Table): Mainly used to provide parameters such as yield strength and other parameters of quasi-static mechanical properties of various materials at different temperatures corresponding to JOINT_ID.

[0090] (11) MATERIAL_DYNAMIC_DATA (Dynamic mechanical properties data table for steel and joints for ships): It is mainly used to provide the dynamic mechanical properties of various materials corresponding to JOINT_ID under different temperatures and strain rates, such as dynamic yield strength and other parameters.

[0091] (12) STRAIN_STRESS_CURVE_DATA (Stress-strain curve data table for steel and joints for ships): mainly used to provide stress-strain curves of various materials at different temperatures and strain rates corresponding to JOINT_ID.

[0092] (13) CORROSION_MATERIAL_DATA (Corrosion test material information table for ship steel and joints): It is mainly used to provide basic information such as material grade, furnace number, and batch number for corrosion testing of various materials corresponding to JOINT_ID. SERIAL_NO is used as the primary key of the corrosion-related performance data table, and JOINT_ID is used as the foreign key to link with the material information.

[0093] (14) CORROSION_SEAENVIR_DATA (Corrosion test environment data table for ship steel and joints): It is mainly used to provide information on the corrosion test environment or test conditions of various materials corresponding to JOINT_ID, such as test location, environment type, test zone, corrosive medium information, etc.

[0094] (15) CORROSION_TEST_DATA (Corrosion test data table for steel and joints for ships): It is mainly used to store the combination of different corrosion test materials and test environment, and is given a unique number, and serves as an identifier for material corrosion data such as corrosion rate and pitting depth.

[0095] (16) CORROSION_RATE_DATA (Corrosion Rate Data Table for Ship Steel and Joints): Mainly used to provide corrosion rate information for various materials under different test environments corresponding to JOINT_ID.

[0096] (17) PIT_DEPTH_DATA (Data table of pitting depth of steel and joints for ships): mainly used to provide information on pitting depth of various materials corresponding to JOINT_ID under different test environments or test conditions.

[0097] (18) OCP_TEST_DATA (Open circuit potential test data table for steel and joints for ships): It is mainly used to provide open circuit potential information for various materials corresponding to JOINT_ID under different test environments or test conditions.

[0098] (19) POLAR_TEST_DATA (Test data table of kinetic polarization of steel and joints for ships): mainly used to provide kinetic polarization characteristic information of various materials under different test conditions corresponding to JOINT_ID.

[0099] Specifically, in the automatic classification step:

[0100] When the first material identifier and the second material identifier have the same value and neither is a default value, and the third material identifier is not a default value, it is determined to be a hull steel plate welded joint.

[0101] When the first material identifier and the second material identifier have different values ​​and neither is a default value, and the third material identifier is not a default value, it is determined to be a dissimilar steel welding joint for the hull.

[0102] When both the first material identifier and the second material identifier are default values, and the third material identifier is not a default value, it is determined to be weld metal.

[0103] When the first material identifier is not a default value, and both the second and third material identifiers are default values, it is determined to be a matrix material.

[0104] Specifically, in the binary data interface, the file header includes a magic number, a version number, an encryption flag, and a data area start offset.

[0105] Specifically, in the binary data interface, the data area stores data records according to a predefined data type.

[0106] Specifically, in the binary data interface, the index area stores the indexes of key fields required by the CAE software.

[0107] The index area is used to respond to query requests from CAE software and provides a fast index for key fields in the data area to improve data reading speed.

[0108] Specifically, the data security processing steps include:

[0109] Perform a physical backup of the database;

[0110] Read data from the backup database and serialize it into binary data according to the binary data format described above;

[0111] The serialized binary data is encrypted using the national cryptographic algorithm SM4.

[0112] The encrypted data is written to an encrypted data file, and the decryption key is bound to the license.

[0113] Specifically, the establishment method further includes: integrating a decryption module into the CAE software; the decryption module decrypts the encrypted data file in real time after obtaining a valid license, loads the decrypted data into memory for CAE analysis, and clears the decrypted data from memory after the calculation is completed.

[0114] More specifically, to protect the intellectual property rights of single-machine genuine products, or for needs involving data migration, offline analysis, and long-term archiving, full database encryption is performed by specifying encryption algorithms such as AES and SM4, and specifying license files. Sensitive information in the tables is also encrypted separately to ensure:

[0115] (1) The core material data exists locally in encrypted form and does not rely on a network-accessible database.

[0116] (2) Authorization verification and data decryption are bound together to ensure that only legitimate users can access the data.

[0117] (3) Even if the locally encrypted file is copied, it cannot be decrypted without authorization.

[0118] The specific steps are as follows:

[0119] I. Physical backup and encryption of database content

[0120] After performing a physical backup using the dm_bak tool of the DM database, the server uses a Java program to read the data from DM, serialize it into binary data, and then encrypt the serialized binary data using the SM4 algorithm.

[0121] II. Decrypting and Reading CAE Software

[0122] In CAE software, the key obtained by purchasing a genuine software license code (decrypt_key) bound to the machine is verified to decrypt the file.

[0123] Considering the possibility of decrypted data being dumped from memory, a decryption module is integrated into the CAE software, along with anti-debugging measures (such as debugger detection and code obfuscation) to increase the difficulty of cracking. For sensitive data (such as material performance parameters), decryption is performed as needed during calculation, and the data is promptly cleared afterward. Furthermore, license verification is performed when reading critical data during program execution to prevent unauthorized or expired use.

[0124] After installing the genuine licensed software, you need to deploy a local license server and start the service, configure firewall rules, and configure the license server address (via configuration file or registry). Ensure that CAE clients can access it. Then complete an end-to-end test, which may include the following:

[0125] (1) Valid authorization: able to read material data and perform calculations normally.

[0126] (2) Invalid authorization: Error message: Unable to read data.

[0127] (3) Network failure: Determine whether to allow the use of offline caching (if any) based on the policy.

[0128] (4) File corruption / missing: The message "Material data file is corrupt, please contact the administrator" is displayed.

[0129] Ensure valid authorization, i.e., achieve local deployment.

[0130] A second aspect of the present invention provides a system for establishing a ship and marine engineering materials database based on any one of the methods described in the invention, the system comprising:

[0131] A data storage module is used to store relational data constructed according to the data table structure, wherein the data table structure includes at least a base material data table, a welding material data table, a mechanical property data table, a fatigue performance data table, and a corrosion performance data table;

[0132] The automatic classification module is used to automatically determine the material type based on the combination of identifiers in the test material information table;

[0133] The interface module is used to enable data interaction with CAE software according to the binary data format.

[0134] The security management module is used to perform data serialization, encryption, decryption, and license verification.

[0135] Specifically, the data storage module uses the domestic DM database as the lowest level of storage, the backend uses the Solon framework, and the frontend uses the Vue framework.

[0136] The framework uses the domestic DM8 database as the underlying storage, which is perfectly compatible with Oracle and SQL platforms, facilitating the migration of historical databases. Based on the domestic backend framework Solon, it connects to the DM8 database via JDBC to achieve data access and management, achieving the goal of lightweight and high performance. The frontend uses Vue as the core framework, which is suitable for building complex ship material data management interfaces. Element Plus is used as the UI component library to visualize material data display and quickly build tables, pop-ups, forms, upload windows, and other interfaces related to material data entry, query, and approval.

[0137] The front-end, back-end, and underlying frameworks used in the above technology stack are all independently controllable. In databases with millions of records, this technology approach is characterized by its extreme simplicity and high performance, with a startup speed more than 5 times faster than traditional Spring Boot and lower memory usage. It is particularly suitable for scenarios with insufficient computing power, such as shipyards, research institutes, and steel mills, and reduces supply chain risks, meeting the requirements of domestic IT innovation. By writing a binary data interface between the marine engineering CAE software and the database, data reading during the simulation design process can be achieved. This binary data interface is implemented using a binary data format, and the data format defined by the binary data interface includes:

[0138] (1) File header: contains metadata such as magic number (used to quickly identify file type), version number, encryption flag, and data area start offset.

[0139] (2) Data area: The actual data records are stored compactly according to the predefined data types (integers, floating-point numbers, strings).

[0140] (3) Index area: mainly contains indexes of key fields required by CAE software to improve the software reading speed.

[0141] Specifically, the system also includes a permission management module, such as... Figures 1-4 As shown in Table 5, the permission management module is configured to support at least three roles: database maintenance personnel, material testing personnel, and ship structure design and engineering technicians, and different data operation permissions are assigned to different roles.

[0142] The system of the ship and marine engineering materials database is mainly for ship structure design work, and the main users are ship structure design and engineering technicians, database maintenance personnel and material testing personnel.

[0143] Ship structural design and engineering technicians: Primarily responsible for using the material data provided by the system to conduct structural design, verification, and simulation analysis. These users must have knowledge of ship design or structural simulation and use the database according to the user manual; no prior knowledge of the database system itself is required. Different data can be viewed or used depending on the user's access permissions.

[0144] Database maintenance personnel: These personnel are primarily responsible for entering and managing material data. These users need basic knowledge of ship materials and design simulation, the ability to review ship material data, the ability to use the database according to the user manual, and a certain understanding of the software system. Responsibilities include creating users, managing user passwords and granting access permissions; maintaining and managing the computer system and its software, requiring a deep understanding of the software; monitoring the system's daily operation, performing routine system backups to ensure reliable operation, and handling common system malfunctions.

[0145] Materials testing personnel: This database system can also be used by materials testing personnel in shipyards, steel mills, or applied research departments. Materials testing personnel can conduct incoming ship materials inspections and enter the test results into the database, which can provide the historical performance levels of the batch of materials.

[0146] Table 5 User Roles and Permissions

[0147]

[0148] In summary, the key points and protection points of this invention are:

[0149] 1. This invention adopts a fully domestic technology stack, ensuring that the database itself and the domestic CAE software are independently controllable throughout the entire chain.

[0150] 2. The data table design in this invention allows welding materials, substrates, and corrosion test conditions to be independent of each other and freely combined, reducing the data size of a single table.

[0151] 3. This invention takes into account the current application status of the shipbuilding industry, and can cover four major working conditions: strength, fatigue, dynamic load and corrosion. The data content is authoritative and valuable, and is one of the protection points.

[0152] 3. The database application mode of this invention is flexible, supporting both B / S architecture and encrypted file usage, which can adapt to different forms of applications and ensure data security and intellectual property rights. At present, domestic related material databases are mostly used for data management, and rarely consider how to apply them in product design or how to encrypt them in software distribution.

[0153] While the present invention has been disclosed above, it is not limited thereto. Any person skilled in the art can make various modifications and alterations without departing from the spirit and scope of the invention; therefore, the scope of protection of the present invention should be determined by the scope defined in the claims.

Claims

1. A method for establishing a database of marine engineering materials, characterized in that, The establishment method includes the following steps: Data table construction steps: Construct a relational data table structure, which includes an experimental material information table, and the experimental material information table contains at least a first material identifier, a second material identifier, and a third material identifier; Automatic classification step: Based on the combination of the values ​​of the first material identifier, the second material identifier, and the third material identifier, the material type of the data entry is automatically determined. The material type includes base material, hull steel plate welded joint, hull dissimilar steel welded joint, and weld metal deposited. Interface construction steps: Construct a binary data interface between the database and the CAE software. The data format defined by the binary data interface includes a file header, a data area, and an index area. Data security processing steps: Serialize and encrypt the data in the database, bind it with the license, and generate an encrypted data file for offline use by CAE software.

2. The method for establishing a marine engineering materials database according to claim 1, characterized in that, In the automatic classification step: When the first material identifier and the second material identifier have the same value and neither is a default value, and the third material identifier is not a default value, it is determined to be a hull steel plate welded joint. When the first material identifier and the second material identifier have different values ​​and neither is a default value, and the third material identifier is not a default value, it is determined to be a dissimilar steel welding joint for the hull. When both the first material identifier and the second material identifier are default values, and the third material identifier is not a default value, it is determined to be weld metal. When the first material identifier is not a default value, and both the second and third material identifiers are default values, it is determined to be a matrix material.

3. The method for establishing a marine engineering materials database according to claim 2, characterized in that, In the binary data interface, the file header includes a magic number, version number, encryption flag, and data area start offset.

4. The method for establishing a marine engineering materials database according to claim 2, characterized in that, In the binary data interface, the data area stores data records according to a predefined data type.

5. The method for establishing a marine engineering materials database according to claim 2, characterized in that, In the binary data interface, the index area stores the indexes of key fields required by the CAE software.

6. The method for establishing a marine engineering materials database according to claim 1, characterized in that, The data security processing steps specifically include: Perform a physical backup of the database; Read data from the backup database and serialize it into binary data; The serialized binary data is encrypted using an algorithm; The encrypted data is written to an encrypted data file, and the decryption key is bound to the license.

7. The method for establishing a marine engineering materials database according to claim 1, characterized in that, The establishment method further includes: integrating a decryption module into the CAE software, wherein the decryption module decrypts the encrypted data file in real time after obtaining a valid license, loads the decrypted data into memory for CAE analysis, and clears the decrypted data in memory after the calculation is completed.

8. A system for establishing a ship and marine engineering materials database based on the method for establishing a ship and marine engineering materials database according to any one of claims 1 to 7, characterized in that, The system includes: A data storage module is used to store relational data constructed according to the data table structure, wherein the data table structure includes at least a base material data table, a welding material data table, a mechanical property data table, a fatigue performance data table, and a corrosion performance data table; The automatic classification module is used to automatically determine the material type based on the combination of identifiers in the test material information table; The interface module is used to enable data interaction with CAE software according to the binary data format. The security management module is used to perform data serialization, encryption, decryption, and license verification.

9. The system for a shipbuilding and marine engineering materials database according to claim 8, characterized in that, The data storage module uses the domestic DM database as the lowest level of storage, the backend uses the Solon framework, and the frontend uses the Vue framework.

10. The system for a marine engineering materials database according to claim 8, characterized in that, The system also includes a permission management module, which is configured to support at least three roles: database maintenance personnel, material testing personnel, and ship structure design and engineering technicians, and assigns different data operation permissions to different roles.

Images