Spatial Data Warehouse Modeling at the Watershed Scale. Part 1: Design Aspects


(*) Corresponding author


Authors' affiliations


DOI's assignment:
the author of the article can submit here a request for assignment of a DOI number to this resource!
Cost of the service: euros 10,00 (for a DOI)

Abstract


Gathering, analyzing and synthesizing large and complex sets of hydraulic, terrestrial, atmospheric, biological and socio-economic data are critical for any decision making process in the water sector. This paper aims to propose a practical approach for increasing the effectiveness of sustainable management of water resources within integrated water resources management (IWRM) framework and climate change context. The article advocates that the designed decision support system (DSS) is a prerequisite in proper IWRM. In fact, it offers a dedicated management system, to assist decision makers and policy makers of water in providing timely, well informed and reproducible answers to important questions, as well as transforming data into knowledge and understandable results through innovative techniques. However, to provide a Decision Support System allowing both access to geographic data needed for IWRM and steering business processes through reliable indicators, it is imperative that the system must be able to combine the geographic information system technology with Business Intelligence, so called Geo-BI (Geo-Business Intelligence). To this end, this paper presents a study that revolves around the concept of Geo-BI and aims to model a Multidimensional Decision Support System, which is a part of an extensive process of spatial data warehouse construction.
Copyright © 2015 Praise Worthy Prize - All rights reserved.

Keywords


Integrated Management of Water Resources (IWRM); Sustainable Development; Climate Change; Business Intelligence (BI); Multidimensional Analysis; Simulation Models; GIS; Geo-Spatial BI

Full Text:

PDF


References


E. Malinowski, E. Zimanyi, Advanced Data warehouse Design: From Conventional and Temporal Applications, Springer-Verlag Berlin Heidelberg (2008).
http://dx.doi.org/10.1007/978-3-540-74405-4_3

M. Trinidad, S. Encinas, Data warehouses in a medical environment : design and experimentation, Réseaux et télécommunications [cs.NI]. Université Joseph-Fourier - Grenoble I, 2005 (June 2005).

M. Dominique Van Damme, Implementation of datawarehouses at National Forest Inventory (September 2010).

Sandro Bimonte, Anne Tchounikine, Michela Bertolotto, Integration of Geographic Information into Multidimensional Models, Computational Science and Its Applications – ICCSA 2008, Volume 5072 of the series Lecture Notes in Computer Science pp 316-329.
http://dx.doi.org/10.1007/978-3-540-69839-5_24

T. Bouadi, Interactive multidimensional analysis of simulation results : decision support in the agroecology field (November 2013).

Lian Duan; Li Da Xu, "Business Intelligence for Enterprise Systems: A Survey," in Industrial Informatics, IEEE Transactions on , vol.8, no.3, pp.679-687, Aug. 2012.
http://dx.doi.org/10.1109/tii.2012.2188804

D. Ouazar, The foundations for sustainable development in water resources management (2011).
http://dx.doi.org/10.1007/s11269-011-9843-9

MD. Hasnaoui, D. Ouazar, N. Aqid, M. Alaoui, Hypsometrical Approach as a Decision Tool for Rational Management and Planning of Watersheds to Meet Sustainable Development, Journal of Sustainable Watershed Science and Management, Volume 2, Issue 1, 2015, pp. 99-107.
http://dx.doi.org/10.5147/jswsm.2013.0126

Gurram, D., Narasinga Rao, M.R., A decision support system for predicting heart disease using multilayer perceptron and factor analysis, (2015) International Review on Computers and Software (IRECOS), 10 (8), pp. 799-804.
http://dx.doi.org/10.15866/irecos.v10i8.6177

Torres Farinha, J., Fonseca, I., Oliveira, R., Barbosa, F., The Convergence between Predictive Maintenance and Augmented Reality to Aid Renewable Energy Equipment Availability, (2014) International Journal on Engineering Applications (IREA), 2 (5), pp.152-162.
http://dx.doi.org/10.15866/irea.v2i5.1916

Adla, A., Laskri, M., Soubie, J., A Cooperative Framework for Intelligent Decision Support Systems, (2015) International Journal on Information Technology (IREIT), 3 (1), pp. 1-10.

Jovanovic, V., Njegus, A., The Use of GIS in Tourism Supply and WEB Portal Development, (2013) International Journal on Information Technology (IREIT), 1 (5), pp. 292-299.

J. Barde, A metadata service for integrated management of knowledges related to coastal areas, Multimedia Tools and Applications, March 2005, Volume 25, Issue 3, pp 419-429.
http://dx.doi.org/10.1007/s11042-005-6544-5

Khomsi, A., Chao, J., El Mansouri, B., Sbai, M., ArcFem: New Software Module in ArcGIS for Numerical Modeling., (2014) International Journal on Information Technology (IREIT), 2 (3), pp. 70-79.

H. Alexander, D. Cheng, and D. Ouazar, Coastal aquifer Management, Monitoring, Modeling and cases studies (December 18, 2003 by CRC Press).
http://dx.doi.org/10.1201/9780203493496

Global Water Partnership Technical Advisory Committee, Integrated Water Resources Management (2000).

R. Kimball, M. Ross, The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling (Wiley, 3rd Edition 2013).
http://dx.doi.org/10.1145/945721.945741

R. Kimball, the Data Warehouse ETL Toolkit (2004).

N. Stefanovic, J. Han, K. Koperski, Object-Based Selective Materialization for Efficient Implementation of Spatial Data Cubes", IEEE Transactions on knowledge and Data Engineering (2000)
http://dx.doi.org/10.1109/69.895803

Gómez, L., Kuijpers, B., Moelans, B., & Vaisman, A. (2009). A Survey of Spatio-Temporal Data Warehousing. International Journal of Data Warehousing and Mining (IJDWM), 5(3), 28-55.
http://dx.doi.org/10.4018/jdwm.2009070102

W.H. Inmon, DW 2.0: The Architecture for the Next Generation of Data Warehousing (2008).
http://dx.doi.org/10.1016/b978-0-12-374319-0.00001-4


Refbacks

  • There are currently no refbacks.



Please send any question about this web site to info@praiseworthyprize.com
Copyright © 2005-2024 Praise Worthy Prize