基于BI的水利普查成果数据展现分析研究

Research on display and analysis of water census achievement data based on BI

第一次全国水利普查设计了8大专题共33小类近一亿个基本对象,水利普查数据具有数据量大,结构复杂且包含层级关系等特性。为了从多角度展现与分析水利普查成果数据,文中基于商务智能(Business Intelligence),运用Oracle BIEE工具设计了一套展现模式,在管理工具上构建物理层、逻辑层、展现层的三层模型,实现OLAP操作并生成报表组成仪表盘,为水利普查成果数据分析提供保障。

The first China census for water designed 8 major thematics with 33 subcategories including nearly 100 million basic objects. Water census data have features such as a large amount of data,complex structure and it contains hierarchical relationships. This article is based on BI （ Business Intelligence） in order to display and analyse the water census data from multiple angles. It uses Oracle BIEE tool to design a display mode. Firstly, it uses management tools to build the physical layer,logic layer, presentation layer of the three-tier model, and then it achieves OLAP operations and generates reports to form dashboards and provide protection for the analysis of water census achievement data.