Key technology of data warehouse design in water and electricity engineering industry
Junzhi Li · Computer Integrated Manufacturing Systems · 2006
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.