Control Model Design And Implementation Of Total Quantity Of Pollutants Based On Data Warehouse Technology

Along with rapid growing in computer science, enterprise information construction present flourishing feature, it is important of enterprise development. But there is a history reason, many cell information management systems in enterprise construction causes information island that let resource cannot be shared friendly, data warehouse technology is one of method that solve information island. Based on the background, Chengdu Environmental Protection Agency proposed project that based on data warehouse technology to achieve total control of pollutants in environmental protection monitor system.The thesis base on researching data warehouse, on-line analysis dealing and refer IBM DWE technology, analyzed environment protection system project feasibility base on the technology application; and expatiated home and abroad present development status and trends of data warehouse technology and pollution gross control, besides analyzed intensively project that based on data warehouse technology to achieve total control of pollutants in environmental protection monitor system. According to total amount of pollutant control requirements that be proposed by Chengdu Environmental Protection Agency , proposed resolve scheme in detail, process details as follows:(1) analyzed EPA six source data base in grain, solved difficulty problem that Chengdu Environmental Protection Agency do not know own information for many years.(2) Extracted data index prepare for data modeling.(3) In terms of project requirement, abstract environmental protection system business theme.(4) Design data warehouse modeling based on business theme of total control of pollutants.(5) Total control of pollutants physical modeling encased data warehouse, design fact table.(6) OLAP optimized CUBE. (7) Offer OLAP lie table, as science gist for leader's decision-making .(8) Through writing code, amend multidimensional query and exhibit graphics.By a list of job, completed pollution gross control task in environment protection monitor system through data warehouse technology. Realized load source data, create, analyze and lay out many dimensions data collection of pollution emission gross, in the end educe data analysis report, and released to server by WEB way, in order to operator work conveniently.Finally conclude this papaer, and make a prospect for how to utilize data mining technology to consummate pollution gross control next step.