The Application of Multidimensional Data Analysis in the EIA Database of Electric Industry

• Published in: Procedia environmental sciences Vol. 10; pp. 1210 - 1215
• Main Authors: Lei, Che, Feng, Ding, Wei, Cui, Ai-xin, Zhang, Zhen-hu, Chen
• Format: Journal Article
• Language: English
• Published: Elsevier B.V 2011
• Subjects: Data Warehouse; Environmental Impact Assessment; Multidimensional Data Analysis; Power industry; Multidimensional Data Analysis; Data Warehouse; Power industry; Environmental Impact Assessment
• ISSN: 1878-0296; 1878-0296
• DOI: 10.1016/j.proenv.2011.09.194

Multidimensional data analysis can observe and process data from several angles, obtaining useful information for management decision-making departments and providing effective support by turning business data into management data. Based on SQL Server 2008 and adopting Multidimensional data analysis technology to statistic and analyze the Environmental Impact Assessment (EIA) basic data of electric industry, we can get the analysis results of the distribution situation, investment, resource consumption, pollutants, and the environmental impact of power construction projects in different periods and different regions so as to make users analyze the construction and development of electric industry from multiple angles and provide effective scientific decisive data support for environmental management and decision-making.