| 环境影响评价数据仓库模型的构建研究 |
| |
| 作者单位： | ;1.北京信息科技大学信息管理学院;2.中国人民大学信息学院;3.环境保护部环境工程评估中心数值模拟重点实验室 |
| |
| 摘 要： | 随着环境影响评价基础数据库数据中心数据量的逐年指数增长,数据库服务器对客户端的响应时间也随之延长,对数据高效管理的要求也日益明显.结合环评基础数据库项目建设过程中数据分析和挖掘预测的需求,提出基于ODS的环评数据仓库的总体架构,构建基于OLAP技术的面向多主题的数据仓库模型,研究遗漏值、数据异常等不同问题的数据清理和填充方案,构建基于DS-ODS-DW的数据加载模型.研究实现基于基础数据库的统计分析和数据挖掘功能,为数据管理者提供数据预测与决策支持功能.通过模型在数据分析和数据挖掘方面的应用案例,验证了该模型和方法的合理性和有效性.
|
| 关 键 词： | 环境影响评价 数据仓库 操作数据存储 文件组 分区 |
Research of Construction of Environmental Impact Assessment Data Warehouse |
| |
| Institution: | ,College of Information management,Beijing Information Science & Technology University,College of Imformatian,Renmin University of China,Key Laboratory of Numerical Simulation,Appraisal Centre for Environmental and Engineering,Ministry of Environmental Protection |
| |
| Abstract: | With the exponential growth of data of data center of the environmental impact assessment(EIA)basic database,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 database,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. |
| |
| Keywords: | environmental impact assessment data warehouse operational data store file group partition |
| 本文献已被 CNKI 等数据库收录！ |
|
