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

Abstract: 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 case 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 data-extraction was studied, and then a data-extraction solution for water and electricity engineering industry was proposed.

Key words: data warehouse, data-extract, water and electricity engineering, table-driven