Design and implementation of central heating data warehouse system

This paper uses data warehouse technology to complete the heating data storage, and online analytical processing (OLAP) based on data warehouse for data analysis. After analysis of the data accumulated in Tianjin heating information system and the heating analysis system requirements, a centralized heating data warehouse is designed and established. Based on the data warehouse, the heating data cube is established. In order to take full use of the heating data, a series of forms for reporting statistics generated after multidimensional data analysis operations.