The Applied Research on the Statistic Data Warehouse Based on the Snowflake Mode

Abstract

A lot of economic data is operated in the basic statistic department. In this paper, we build a statistic data warehouse based on snowflake schema for the local authority. Using the technology of On-line analysis processing, we extract the integrated statistical information from the economic operating data of the basic statistic department. We integrate the data of statistical indicators to form a digital, informational and service platform for the statistical agency. Moreover, we present the results of the analysis with a variety of forms to the decision makers and provide quantitative basis of statistical analysis for the local authority.