水电工程行业中数据仓库设计的关键技术  

Key technology of data warehouse design in water and electricity engineering industry

作　　者：李军治[1] 夏国平[1] 史晓霞[2] 

机构地区：[1]北京航空航天大学经济管理学院,北京100083 [2]北京建筑工程学院电气工程与自动化系,北京100044

出　　处：《计算机集成制造系统》2006年第1期144-148,共5页Computer Integrated Manufacturing Systems

基　　金：国家自然科学基金资助项目(70371004);航空科学基金(04JK51057)~~

摘　　要：为了提高数据仓库的开发效率,提出了一种复杂报表驱动的设计方法,分析了这种方法与应用驱动和数据驱动两种方法之间的不同,指出了复杂报表驱动方法的4个特点,定义了用这种方法进行数据仓库开发应该遵循的5个步骤。通过对该方法在国内某水电工程集团的应用,详细阐述了在数据仓库开发的需求分析与设计过程中如何执行复杂报表驱动方法的5个步骤,证明了这种方法的优越性。最后,针对水电工程行业中数据析取环节存在的特殊问题,对数据析取的过程进行了研究,并提出了适用于水电工程行业的数据析取解决方案。To improve the development efficiency of data warehouse, a complex table-driven method to build a data warehouse was proposed. Then the differences between the proposed method and the data-driven or application driven method was analyzed and four characteristics of complex table-driven method were illuminated. After that five steps to build a data warehouse which were needed to be followed were defined. Through the ease study on the application of the proposed method in a large water and electricity engineering enterprise of China, how to execute the five steps of complex table driven method during the requirement analysis and data warehouse design were discussed in particular and the superiority of the method was also proved. Finally, to solve specific problems in data extraction from multiple data sources particularly some unformatted EXCEL-tables in the case, the process of dataextraction was studied, and then a data-extraction solution for water and electricity engineering industry was proposed.

关 键 词：数据仓库 数据析取 水电工程 报表驱动 

分 类 号：TP391[自动化与计算机技术—计算机应用技术]