Establishment Of Water Environmental Data Mart

Liao Zhenliang,Dong Shufu
DOI: https://doi.org/10.1109/ICBBE.2009.5162797
2009-01-01
Abstract: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 city's 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.
What problem does this paper attempt to address?