The Research Of Oil Pipe Project Quality Supervision Management Data Warehouse System

Business processes and quality inspection of oil pipe project quality supervisionmanagement are very complicated. Now the Office Automation system can only cope withtransactional processes. As the quality inspection data constantly accumulate and theusers’need of diagnoses for pipe inspection increases, service level needs to enhancefurther and the quality of service also need to improve. On the one hand a unifiedmanagement and effective organization of the data, on the other hand the data need bemanaged in a unifed way, on the other hand quality inspection data need be analysedstatistically from multi-angle, multi-level way in order to give the corresponding diagnosticconclution and decision support.The ideas of building oil pipe project quality supervision management data warehousesystem is based on the analysis of existing systems and operations, which adopts theories andtechniques of data warehouse to propose. To meet the need of management and statisticalanalysis of historical data of pipe project quality supervision, this study designs theme of thedata warehouse, offer data organization module based on predicate and effectively organizequality supervision data from an analytical perspective. For the need of the multi-dimensionanalysis, the thesis builds oil pipe project quality supervision management multi-dimensiondata orgnaniztion module and offer the formal description of the model and proposemulti-dimension analysis methods and algorithms based on MDX. Oil pipe project qualitysupervision management data warehouse system and ETL sub-system are developed. Theresearch of the system effectively improves the business level, the level of the Institute andmeets customers’ various statistical analysis needs.