Research On Data Warehouse Technology In Ethylene Energy-Efficiency Management

With more and more importance being attached to energy savings, there exist a great number of the requests for research on how to save energy, especially for these energy-intensive enterprises. For ethylene equipment, which is one of the most energy-intensive equipments in the petrol-chemical industry, it means considerable economical benefits and significantly social benefits.Considering these data being dispersive geographically and multiple factors influenced, an energy efficiency data management solution is proposed based on data warehouse. Data warehouse is to integrate these energy data consistently, and support these energy efficiency analysis methods.In the research, a multiple-rules energy efficiency value (EEV) indicators is present to evaluate the energy state of ethylene equipment more comprehensively and systemically firstly. In order to exert the advantages of EEV, an EEV virtual benchmarking method is given based on the EEV hierarchical model. Next, a data warehouse prototype is designed based on the research on EEV indicators, mainly from the respects of material, technique, geography and time. After that, it is noted that these are lots of data warehouse evolution requirements resulted from data sources updates, enterprise rearrangements and WHAT-IF analysis. Therefore, a data warehouse evolution framework is present to handle the evolution requirements of data warehouse. To improve the actual performance of materialized views' selection, a more robust and accurate view usage-probability model called R/S-3A is given.