CN112560260A - Rapid display method for cable material parameters based on three-dimensional model - Google Patents
Rapid display method for cable material parameters based on three-dimensional model Download PDFInfo
- Publication number
- CN112560260A CN112560260A CN202011459647.2A CN202011459647A CN112560260A CN 112560260 A CN112560260 A CN 112560260A CN 202011459647 A CN202011459647 A CN 202011459647A CN 112560260 A CN112560260 A CN 112560260A
- Authority
- CN
- China
- Prior art keywords
- cable
- information
- stock
- model
- attributes
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 239000000463 material Substances 0.000 title claims abstract description 82
- 238000000034 method Methods 0.000 title claims abstract description 16
- 238000010276 construction Methods 0.000 claims abstract description 23
- 239000004205 dimethyl polysiloxane Substances 0.000 claims abstract description 12
- 235000013870 dimethyl polysiloxane Nutrition 0.000 claims abstract description 12
- CXQXSVUQTKDNFP-UHFFFAOYSA-N octamethyltrisiloxane Chemical compound C[Si](C)(C)O[Si](C)(C)O[Si](C)(C)C CXQXSVUQTKDNFP-UHFFFAOYSA-N 0.000 claims abstract description 12
- 238000004987 plasma desorption mass spectroscopy Methods 0.000 claims abstract description 12
- 229920000435 poly(dimethylsiloxane) Polymers 0.000 claims abstract description 12
- 238000013507 mapping Methods 0.000 claims description 9
- 238000010586 diagram Methods 0.000 claims description 2
- 230000008676 import Effects 0.000 description 4
- 238000004519 manufacturing process Methods 0.000 description 4
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 238000000605 extraction Methods 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F30/00—Computer-aided design [CAD]
- G06F30/20—Design optimisation, verification or simulation
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/23—Updating
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/08—Logistics, e.g. warehousing, loading or distribution; Inventory or stock management
- G06Q10/087—Inventory or stock management, e.g. order filling, procurement or balancing against orders
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F2113/00—Details relating to the application field
- G06F2113/16—Cables, cable trees or wire harnesses
Abstract
The invention discloses a method for quickly displaying parameters of a cable material based on a three-dimensional model. Firstly, cable model and cable layout design is carried out on a PDMS platform, model information is stored, then a corresponding database is established, required information is poured in sequence, dynamic link between the PDMS platform and SQL Server software is established, and the purpose that the relevant database storage information can be taken out by clicking the corresponding cable model on the PDMS platform is achieved. The invention ensures that the information of the cable material is comprehensively and quickly displayed, realizes the function of tracking and inquiring the information of the ocean engineering cable material, accurately calls each cable material and the serial number information through the three-dimensional model in later construction, reduces the time consumed by inquiring the information and improves the overall construction efficiency.
Description
Technical Field
The invention relates to material information extraction in ocean engineering, in particular to a method for rapidly displaying information of a cable material used in oil and gas engineering.
Background
Ocean engineering modular structure makes and belongs to resource intensive trade, and the manufacture project is mostly "disposable" customization project, and the manufacturing cycle is long, the manufacturing management is complicated, and the manufacturing plan performability is poor, and at present, in the information display of cable material in the ocean engineering module, only can show the information of single cable material to only be limited to the text inquiry, cause cable material information display inconvenient, influence engineering efficiency of construction.
Disclosure of Invention
The invention aims to overcome the defects of the prior art and provides a method for quickly displaying parameters of a cable material based on a three-dimensional model, which can quickly call corresponding material information by clicking the cable model and improve the overall construction efficiency.
A method for rapidly displaying parameters of a cable material based on a three-dimensional model comprises the following steps:
firstly, designing cable models and cable layout on a PDMS platform, numbering all the cable models according to a design sequence, and recording cable model code information, cable model engineering codes and cable model supplier number information corresponding to each cable model number in an Excel table;
step two, establishing a cable material information database comprising a plurality of charts by using SQL Server, and establishing an incidence relation among the charts in an external key form in each chart, wherein the cable material information database comprises the following charts: a cable material profile table for storing properties of the cable used in a specific project, an existing product performance information table for all cable materials, a build information table for the cable materials planned to be used in the specific project, an existing stock information table for all cable materials, and an existing cross-section chart for all cable materials;
step three, all the data recorded in the Excel table in the step one are imported into each attribute of a cable material general table, and the data corresponding to each attribute set in the product performance information table, the building information table, the stock information table and the cross section chart in the step two are imported into each chart respectively;
step four, establishing a dynamic link between PDMS and SQL Server, then clicking the selected cable model in PDMS, extracting the cable model number defined by the cable model, and exporting the attribute information corresponding to the cable model number stored in the SQL Server database;
and fifthly, adding various kinds of information updated for the cable materials in the engineering to the corresponding attributes of the charts built in the third step, so that the newly added cable information can be conveniently extracted in the fourth step.
The invention has the beneficial effects that: the method has the advantages that the corresponding cable material information can be quickly extracted by establishing the dynamic link between the database and the three-dimensional model, the real-time performance is strong, the transferring efficiency is high, the method is suitable for ocean oil and gas engineering material platforms with a large number of cable models, and the whole construction efficiency can be improved by quickly extracting the engineering material information.
Drawings
Fig. 1 is a schematic flow chart of a method for rapidly displaying cable material information based on a three-dimensional model.
Detailed Description
The following are specific examples of the present invention, further describing the technical scheme of the present invention:
the method for rapidly displaying the parameters of the cable material based on the three-dimensional model shown in fig. 1 comprises the following steps:
firstly, designing cable models and cable layout on a PDMS platform, numbering all the cable models according to a design sequence, and recording cable model code information, cable model engineering codes and cable model supplier number information corresponding to each cable model number in an Excel table; if the cable model number information corresponding to the cable model with the number of 1 is D1, the cable model engineering number 001 and the cable model supplier number A1;
and step two, establishing a cable material information database comprising a plurality of charts by using SQL Server, and establishing an association relation among the charts in an external key form. The cable material information database comprises the following charts: a cable material profile table for storing properties of the cable used in a specific project, an existing product performance information table for all cable materials, a build information table for cable materials planned to be used in the specific project, an existing stock information table for all cable materials, and an existing cross-section chart for all cable materials;
as an embodiment of the present invention, the process of establishing each chart and the association relationship between each chart in the cable material information database is as follows:
in a first step, a cable material profile is created for storing attributes of the cable used for a particular project. The cable material profile attributes include a cable model number, a cable model code, a cable model engineering code, and a cable model supplier number. Setting attributes of the cable model number and the cable model code number as main keys of the table, and setting the attribute of the cable model number as a main index to ensure the unique identification of the attribute;
and secondly, establishing a product performance information table of all the existing cable materials. The product performance information table attributes comprise cable product numbers of all existing cable products, structural parameters of the cable products, order numbers of the cable products, material numbers of the cable products, rated currents of the cable products, rated voltages of the cable products and the like. Setting the cable product code attribute as the main key of the table, setting the cable product code attribute as an external key, and establishing a mapping relation with the cable model code attribute in the cable material information general table; such as: mapping an information row with the cable product code number D1 in the product performance information table and an information row with the cable model code number D1 in the cable material general table;
third, a table of build information for the cable material to be used in a particular project is planned. The attributes of the construction information table comprise the construction cable code, the construction project code, the use degree of the construction cable, the use amount of the cable in each project and the laying completion rate. Setting the attribute of the construction cable code as a main key and a main index of the table, carrying out unique identification of construction information search of construction cable materials, setting the attribute of the construction cable code as an external key, and constructing a mapping relation with the attribute of the cable model code in the cable material information general table;
and fourthly, establishing an existing stock information table of all cable materials. The inventory information table attributes include the inventory cable number, the inventory quantity of the inventory cable, the supplier number of the inventory cable, and the storage place of the inventory cable. Setting the stock cable code attribute as a main key and a main index of the table, wherein the stock cable code attribute is a unique identifier for searching stock information of cable materials, and the stock cable code attribute is set as an external key to construct a mapping relation with the cable model code attribute in the cable material information general table;
and fifthly, establishing a cross section information table of all the existing cable materials. The attributes of the cross section information table comprise stock cable codes, supplier numbers of the stock cables, cable cross section diagrams corresponding to the stock cables, materials of the stock cables and the like in the stock information table. Setting the stock cable code attribute as a main key and a main index of the table, wherein the stock cable code attribute is a unique identifier for searching cross section information of the cable material, and is set as an external key to construct a mapping relation with the cable model code attribute in the cable material information general table;
step three, all the data recorded in the Excel table in the step one are imported into each attribute in a cable material general table, and the data corresponding to each attribute set in each chart (a product performance information table, a building information table, an inventory information table and a cross section chart) in the step two are imported into each chart respectively; the attribute information in the product performance information table and the cross section information table is obtained from corresponding suppliers, the attribute information in the construction information table is obtained from a construction design department, and the attribute information in the inventory information table is obtained from a material inventory management department. Such as: in the same row in the database cable material profile, import 1 cable model number, import D1 electrical model cable number, import 001 engineering number, and import a1 supplier number;
step four, establishing a dynamic link between PDMS and SQLSever, then clicking the selected cable model in PDMS, extracting the cable model number defined by the cable model, and exporting the attribute information corresponding to the cable model number stored in the SQL Server database, such as: cable code, cross-sectional drawing and other detailed information;
and fifthly, adding various kinds of information updated for the cable materials in the engineering to the corresponding attributes of the charts built in the third step, so that the newly added cable information can be conveniently extracted in the fourth step.
The method can extract the corresponding cable material information through the three-dimensional model, has strong real-time performance and low engineering cost, and is suitable for the ocean oil and gas engineering material platform with a large amount of cable information, thereby improving the overall construction efficiency.
Claims (2)
1. A method for rapidly displaying parameters of a cable material based on a three-dimensional model is characterized by comprising the following steps:
firstly, designing cable models and cable layout on a PDMS platform, numbering all the cable models according to a design sequence, and recording cable model code information, cable model engineering codes and cable model supplier number information corresponding to each cable model number in an Excel table;
step two, establishing a cable material information database comprising a plurality of charts by using SQL Server, and establishing an incidence relation among the charts in an external key form in each chart, wherein the cable material information database comprises the following charts: a cable material profile table for storing properties of the cable used in a specific project, an existing product performance information table for all cable materials, a build information table for the cable materials planned to be used in the specific project, an existing stock information table for all cable materials, and an existing cross-section chart for all cable materials;
step three, all the data recorded in the Excel table in the step one are imported into each attribute of a cable material general table, and the data corresponding to each attribute set in the product performance information table, the building information table, the stock information table and the cross section chart in the step two are imported into each chart respectively;
step four, establishing a dynamic link between PDMS and SQL Server, then clicking the selected cable model in PDMS, extracting the cable model number defined by the cable model, and exporting the attribute information corresponding to the cable model number stored in the SQL Server database;
and fifthly, adding various kinds of information updated for the cable materials in the engineering to the corresponding attributes of the charts built in the third step, so that the newly added cable information can be conveniently extracted in the fourth step.
2. The method for rapidly displaying parameters of a cable material under the three-dimensional model according to claim 1, wherein: the process of establishing the graphs and the incidence relation among the graphs in the cable material information database is as follows:
the method comprises the steps that firstly, a cable material general table used for storing the attributes of a cable used for a specific project is established, the attributes of the cable material general table comprise a cable model number, a cable model code, a cable model project code and a cable model supplier code, the attributes of the cable model number and the cable model code are set as main keys of the table, and the attribute of the cable model number is set as a main index;
secondly, establishing a product performance information table of all existing cable materials, wherein attributes of the product performance information table comprise cable product numbers of all existing cable products, structural parameters of the cable products, order numbers of the cable products, material numbers of the cable products, rated currents of the cable products and rated voltages of the cable products, setting the cable product number attributes as main keys of the table, setting the cable product number attributes as external keys, and establishing a mapping relation with cable model number attributes in a cable material information overview table;
thirdly, planning a construction information table of the cable material used in the specific project, wherein the attributes of the construction information table comprise a construction cable code, a construction project code, the use degree of the construction cable, the use amount of the cable in each project and the laying completion rate, setting the construction cable code attribute as a main key and a main index of the table, setting the construction cable number attribute as an external key, and constructing a mapping relation with the cable model number attribute in the cable material information general table;
fourthly, establishing an existing stock information table of all cable materials, wherein the attributes of the stock information table comprise stock cable codes, stock of the stock cables, supply trade numbers of the stock cables and storage places of the stock cables, setting the stock cable code attributes as a main key and a main index of the table, setting the stock cable code attributes as external keys, and constructing a mapping relation with the cable model code attributes in the cable material information overview table;
and fifthly, establishing a cross section information table of all existing cable materials, wherein attributes of the cross section information table comprise stock cable codes, supplier numbers of the stock cables, cable cross section diagrams corresponding to the stock cables and materials of the stock cables in the stock information table, setting the stock cable code attributes as a main key and a main index of the table, setting the stock cable code attributes as external keys, and establishing a mapping relation with cable model code attributes in a cable material information overview table.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011459647.2A CN112560260A (en) | 2020-12-11 | 2020-12-11 | Rapid display method for cable material parameters based on three-dimensional model |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011459647.2A CN112560260A (en) | 2020-12-11 | 2020-12-11 | Rapid display method for cable material parameters based on three-dimensional model |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN112560260A true CN112560260A (en) | 2021-03-26 |
Family
ID=75062393
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202011459647.2A Pending CN112560260A (en) | 2020-12-11 | 2020-12-11 | Rapid display method for cable material parameters based on three-dimensional model |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112560260A (en) |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2015018308A (en) * | 2013-07-09 | 2015-01-29 | 日立Ｇｅニュークリア・エナジー株式会社 | Cable selection system and selection method |
| CN106095431A (en) * | 2016-06-08 | 2016-11-09 | 中国科学院武汉岩土力学研究所 | 3DGIS system based on Python and the method for quickly exploitation thereof |
| CN107832533A (en) * | 2017-11-15 | 2018-03-23 | 国网江苏省电力有限公司 | A kind of real-time monitoring and displaying method and system of transformer station based on three-dimensional information model |
-
2020
- 2020-12-11 CN CN202011459647.2A patent/CN112560260A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2015018308A (en) * | 2013-07-09 | 2015-01-29 | 日立Ｇｅニュークリア・エナジー株式会社 | Cable selection system and selection method |
| CN106095431A (en) * | 2016-06-08 | 2016-11-09 | 中国科学院武汉岩土力学研究所 | 3DGIS system based on Python and the method for quickly exploitation thereof |
| CN107832533A (en) * | 2017-11-15 | 2018-03-23 | 国网江苏省电力有限公司 | A kind of real-time monitoring and displaying method and system of transformer station based on three-dimensional information model |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110929042B (en) | Knowledge graph construction and query method based on power enterprise | |
| CN108509566B (en) | Network topology visualization method based on-cloud 95598 data release service system | |
| CN104778540A (en) | BOM (bill of material) management method and management system for building material equipment manufacturing | |
| CN105447253B (en) | A kind of integrated approach of three-dimensional process data | |
| CN111260413A (en) | Vector graph-based rapid calculation method for construction cost of power main network engineering | |
| CN109472446B (en) | BIM model-based engineering budget estimate planning method | |
| CN108280159B (en) | Method for converting graph database into relational database | |
| CN102999524B (en) | A kind of document associations search method and system | |
| CN101178732A (en) | Method for quick-speed realizing data store house process based on metadata | |
| CN109408906A (en) | The method of engineering quantity expression and statistics based on BIM model | |
| CN102375827A (en) | Method for fast loading versioned electricity network model database | |
| CN105426590A (en) | Machining process feature tree and construction method thereof | |
| CN114155341B (en) | Cross-platform consistency method for large-scale digital workshop three-dimensional model based on Unity platform | |
| CN111581700A (en) | Method for adding BIM attribute and outputting BIM attribute table based on CATIA model | |
| CN104881739A (en) | Marketing and distribution data consistency verification method based on IEC61970-61968 CIM standard | |
| CN102508971A (en) | Method for establishing product function model in concept design stage | |
| CN114153821A (en) | Electric quantity graph database construction and search method based on graph theory | |
| CN113762724A (en) | Method for collaborative design and management of power transmission and transformation project based on BIM technology | |
| CN105912723A (en) | Storage method of custom field | |
| CN112560260A (en) | Rapid display method for cable material parameters based on three-dimensional model | |
| CN112669055A (en) | Power transmission and transformation project exploitable estimation simulation group price method and device | |
| CN113221218B (en) | Factory digital design method based on BIM technology | |
| US7574329B1 (en) | Object model for decision and issue tracking | |
| CN112488642B (en) | Cloud file management method based on structured labels and taking object as core | |
| CN111832113B (en) | Aluminum alloy template matching method based on BIM technology |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20210326 |