Establishment of Water Environmental Data Mart

摘要：

The concepts of data warehouse, data mart, On-Line Analytical Processing (OLAP) are introduced into the domain of Environmental Decision Support System. A Water Environmental Data Mart (WEDM) is developed with a citys water environmental operation database as data source, and with star schema as data framework. Two main parts are included in WEDM, the Extract-Cleanse-Transform-Load tool, and the universal OLAP tool whose functions include SQL, classifying statistic, and data visualization. The WEDM can provide multidimensional, multi-leveling, integrated, dynamic, flexible querying and analyzing, which is not offered by previous environmental operation database system. Three examples show the functions of proposing decision support information of WEDM.

关键词： water environment data warehouse data mart On-Line Analytical Processing

作者: Liao Zhenliang Dong Shufu

作者单位: State Key Lab of Pollution Control and Resource Reuse Tongji University Shanghai,China Architectural Design & Research Institute Tongji University Shanghai,China

会议类型: 国际会议

会议名称: The 3rd International Conference on Bioinformatics and Biomedical Engineering(iCBBE 2009)(第三届生物信息与生物医学工程国际会议)

会议地点: 北京

会议语种:英文

页码: 1-4

在线出版日期: 2009-06-11（万方平台首次上网日期，不代表论文的发表时间）