环境影响评价数据仓库模型的构建研究

Research of Construction of Environmental Impact Assessment Data Warehouse

随着环境影响评价基础数据库数据中心数据量的逐年指数增长,数据库服务器对客户端的响应时间也随之延长,对数据高效管理的要求也日益明显.结合环评基础数据库项目建设过程中数据分析和挖掘预测的需求,提出基于ODS的环评数据仓库的总体架构,构建基于OLAP技术的面向多主题的数据仓库模型,研究遗漏值、数据异常等不同问题的数据清理和填充方案,构建基于DS-ODS-DW的数据加载模型.研究实现基于基础数据库的统计分析和数据挖掘功能,为数据管理者提供数据预测与决策支持功能.通过模型在数据分析和数据挖掘方面的应用案例,验证了该模型和方法的合理性和有效性.

With the exponential growth of data of data center of the environmental impact assessment （EIA） basic data- base, the database server＇s response time to the client becomes longer, and the demand for efficient data management becomes more obvious. Combined with the demand of data analysis and data mining during the construction process of the EIA basic da- tabase, the overall architectures of EIA data warehouse（DW） based on ODS is put forward. The Multi-theme DW based on OLAP and the physical storage model based on file group and partition are built. The different methods of Data cleaning and data filing are studied. The data loading model based on DA-ODS-DW is built. The study realize Statistical Analysis and Data Mining based on the basic database, which provide Data Forecasting and decision support for the management. The legitimacy and effectiveness of the model and methods are verified by the Applications in data analysis and data mining.