Database Design Based On APDM Pipeline Integrity

Undoubtedly, oil and natural gas pipeline transportation is the most economical, the most reasonable mode of transportation, but pipeline security is a deep-rooted problem. For a huge long-distance pipeline engineering, from engineering design to construction, to operations, each stage will produce large amounts of data, the use of traditional paper material management way already far can't satisfy the current pipeline management needs, data can be hard to get sharing and effective analysis using, cause data using low efficiency. To solve this problem, experts in the industry suggest pipeline integrity management, is a kind of good method to solve pipeline operation safety problems at the present.Pipeline Integrity Management is a pipeline safety objectives and continuous improvement of management system, which covering pipeline design, construction, operation, management, and decommissioning. Data management is the first step of the implementation of pipeline integrity management cycle, and, is the most critical step. In the pipeline integrity management process, the integrity of the pipeline is constraints in the HCA analysis, integrity analysis, evaluation and analysis accuracy. The pipeline integrity management to deal with a large amount of data, especially spatial data, the best method is to use the geographic information system as the platform.This project studies the database of pipeline integrity based on the APDM model, including integrity database design, data needs analysis, data acquisition, data storage and simple introduction about later data maintenance aspects of content. This thesis uses the PIS of Xi'An MeiHang as the project background. The key of the thesis is the oil pipeline data analysis, acquisition and storage according to the reality of the situation.Because the pipeline integrity database is based on APDM model, this article first simple introduces the structure and principles of APDM data model. Secondly, this paper analysis massive pipeline data, and establish the data model of Pipeline Integrity according the characteristics of China's pipeline. This model covers pipeline centerline, pipeline facilities, around public facilities, geographical environment and in all content and logic. Then this paper emphatically introduces the data needs analysis, data acquisition and data inventory.Finally, this paper summarized to have of put in storage pipeline integrity of data described later period maintenance. Using GIS technology to combine the traditional pipeline data with spatial information in accordance with APDM pipe model and the actual pipeline needs, and realize the management of the spatial location of the pipeline and logical relations of pipeline facilities. By establishing flexible regulatory mechanisms, it can be automatic linkage Processing according with APDM Pipe Model in creating, altering, maintain pipeline, ensuring the integrity data consistent with integrity and relation.