This Paper presents an integrated diagnosis database technology based on UDA method applied in safety monitoring and diagnosis of oil pipelines and transferring pump units, based on which the massive historical data of pipelines and pump units can be recorded and centralized managed. The system can redisplay the record under different running states of pipelines including fault data, and distinguish different conditions of pipeline automatically by improved ISODATA clustering method, in order to ensure the high efficiency and safety of the pipeline transportation system. Crown Copyright (C) 2008 Published by Elsevier Ltd. All rights reserved.