Design of cloud data warehouse and its application in smart grid

With the rapid development of information technology, enterprises have carried out application system construction on a large scale, which generates vast amount of data. Because traditional data warehouse can´t meet the demand of processing vast amount of data, the data warehouse based on cloud computing technology was born. The paper puts forward a kind of cloud data warehouse platform and has implemented it. The platform builds on top of Hadoop ecosystem the core of which are Hadoop, HBase, Hive and so on. And the platform also adds ETL, OLAP analysis, Data Mining and BI Report. At the same time, the platform is applied to the field of smart grid in this paper. The paper also uses OLAP to analyse user´s power consumption data, and combines data mining technology to solve the problem of analysis of user´s power consumption behaviours. Finally, the paper also analyses the defect of cloud data warehouse and the focus of the research direction in the future.