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

为了提高数据仓库的开发效率，提出了一种复杂报表驱动的设计方法，分析了这种方法与应用驱动和数据驱动两种方法之间的小同，指出了复杂报表驱动方法的4个特点，定义了用这种方法进行数据仓库开发应该遵循的5个步骤。通过对该方法在国内某水电工程集团的应用，详细阐述了在数据仓库开发的需求分析与设计过程中如何执行复杂报表驱动方法的5个步骤，证明了这种方法的优越性。最后，针对水电工程行业中数据析取环节存在的特殊问题，对数据析取的过程进行了研究，并提出了适用于水电工程行业的数据析取解决方案。

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

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.