Development of Data Mart in DSS in Water Environment
Jiang Zi-we · Jiangsu Environmental Science and Technology · 2007
Treatment to the aquatic environment is a systemic project, which needs large investment, has lasting influence and requires scientifically decision. In recent years, Decision Support System (DSS) applied to the aquatic environment develops rapidly. Being one of the two supports, exploitation of the aquatic environment's database is getting more and more important. And technology of the data storage and data mart is a crucial progress of the technology of the data base. This article discusses the process of the developing data mart in aquatic environment on the base of aquatic environment data base. According to the title of the integrating treatment to the aquatic environment and adopting the starring model, we reform the existing database. The article first introduces the ECTL tools' development, which means transferring the data base to the data mart and includes the tools of Extract, Clean, Transform and Load. Then the article introduces the Online Analytical Processing (OLAP) tools, which develops homologizing online analysis tools to achieve application of the data mart, including searching, classifying and visualizing. The case is applied to reflect the ability of decision support information by aquatic environment data mart.