Establishment of Water Environmental Data Mart

Author

Liao Zhenliang ; Dong Shufu

Author_Institution

State Key Lab. of Pollution Control & Resource Reuse, Tongji Univ., Shanghai, China

fYear

2009

fDate

11-13 June 2009

Firstpage

1

Lastpage

4

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.

Keywords

SQL; data mining; data visualisation; data warehouses; decision support systems; environmental science computing; pattern classification; query processing; SQL; WEDM; data framework; data visualization; data warehouse; environmental decision support system; extract-cleanse-transform-load tool; integrated dynamic flexible querying; multidimensional multileveling querying; online analytical processing; star schema; statistic classification; universal OLAP tool; water environmental data mart; water environmental operation database; Data analysis; Data mining; Data visualization; Data warehouses; Database systems; Decision support systems; Multidimensional systems; Statistics; Visual databases; Water resources;

fLanguage

English

Publisher

ieee

Conference_Titel

Bioinformatics and Biomedical Engineering , 2009. ICBBE 2009. 3rd International Conference on

Conference_Location

Beijing

Print_ISBN

978-1-4244-2901-1

Electronic_ISBN

978-1-4244-2902-8

Type

conf

DOI

10.1109/ICBBE.2009.5162797

Filename

5162797