The Design And The Practice Of The Petrochemical Sales Operation Analysis System

The necessity and feasibility of development of the CNPC petrochemical sales operation analysis system(CPSOAS)is analyzed as the exordium of this thesis.Namely,based on both the petrochemical automatic monitor & control and operating management had been completed,the application system is developed in order to improve the level of detailed management and scientific decision-making.The supporting technologies and relevant innovation are introduced in the subsequent chapters of the thesis.The supporting technologies include the data warehouse,OLAP,ETL and among them the Oracle is chosen for the functions of cluster,database link and log reduction.On the other hand,the innovation presents on the OLAP data making like coming up with the strategy for analyzing and designing the dimension granularity,clarifying the procedure of choosing dimensions and confirming measurements.It especially establishes the extended snowflake model(or extended star model)which is based on the chosen ROLAP mode.In the thesis,the technical features of design and actualization are described.The high-level system design,the main business functions and the system data warehouse design are described.The three dimension data architecture model consisting of data deployment topology,data subject classification and data partition storage are discussed.The system detailed design especially including the multi-dimension analysis and key indexes early warning is introduced.The non-function demands including efficiency,compatibility,usability,reliability,security,maintainability,and portability are explained.The operation statuses of CPSOAS and the effect of applying CPSOAS are analyzed in the thesis.The key business issues resolved by CPSOAS are illustrated with the overall effect analysis.The characters of the system developing process are explained.Both the operating instances of the major database service and the human-machine interface for showing the business statuses are introduced.According to the actual workflow,the following activities are described: the issues are discovered by the early warning function,the experts are found by the expert library function,the statuses of the issues are paid close attention continually by the multi-dimensional analysis and the managing means are adopted at the monthly analysis according to the report produced by the CPSOAS.CPSOAS has been implemented for one year and the operation is stable,which achieved expected results.The author of this thesis,as a core technicist,has participated in the whole process of the program including requiring,modeling,designing and developing.Moreover,the author was also the major designer who completed the design and achievement of the extended snowflake model(or star model)which reach an excellent performance on the ETL efficiency,inquiring response time and a good balance between facilities costs and the operation management.The construction of CPSOAS is consistent with the sustainable development strategy of information construction of CNPC.It reached the goal of information construction of 12 th Five-Year plan of CNPC and provided the model and experiences for the construction of similar systems.