基于数据仓库的水利工程信息管理系统设计

摘要

In view of the problem that current business - oriented water information management system obtain difficultly hidden information problem, the hydraulic engineering information management system was design based on data warehouse and OLAP technology. The Java served as the development language, SQL Server 2005 as back - end database, and the SQL Server data warehouse tools was used to build the data warehouse. According to requirements analysis, the access channels, departments and funds were confirmed as the three implicit information, which were implemented through the fact table and dimension table design with the efficient star query model as a conceptual model.%针对我国当前业务型的水利信息管理系统难以获取隐含信息的问题,提出基于数据仓库技术和OLAP技术设计开发水利工程信息管理系统的解决方案.系统使用Java作为开发语言,后台数据库采用SQL Server 2005系统,使用SQL Server中的数据仓库工具建立数据仓库.根据需求分析,系统确定获取渠道、科室和资金3个主题的隐含信息,并采用查询效率较高的星型模型作为概念模型,通过事实表设计和维度表设计来完成3个主题设计的具体实现.