Title :
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
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;
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
DOI :
10.1109/ICBBE.2009.5162797
