An approach of ensuring interoperability of multi-dimensional data warehouses for monitoring of water resources

    Dalė Dzemydienė Affiliation
    ; Saulius Maskeliūnas Affiliation
    ; Vytautas Radzevičius Affiliation


The realization of really working, on-line system for evaluation of pollution of water processes requires to represent the complexity of such phenomenon. The multi-layered structure of distributed information systems under different responsibilities identify some problems for developing of an adequate decision support system (DSS) working on-line. The aim of this research is to develop the interoperable infrastructure of multi-dimensional data warehouses working on-line for integration of monitoring data, enabling the conditions for more adequate decisions. The design approach includes the constructions of the knowledge base with some layers of representation, including the domain specific ontology, which are needful for evaluation of impacts of water pollution. The results are integrated with the structures of the ISMA database, EuroWaterNet, Water Resource Management Information System – WRMIS, following the requirements of EU Water Framework Directive (2004). The presented results on integration of information sources and collaboration workflows help in searching of suitable indicators for revealing the situations of water pollution from wastewater bodies and can help to retrieve the main objects which influence the monitoring of effluxes in the Baltic Sea.

Keyword : environment monitoring, information system, distributed data warehouses, water pollution, interoperability, decision support system (DSS)

How to Cite
Dzemydienė, D., Maskeliūnas, S., & Radzevičius, V. (2021). An approach of ensuring interoperability of multi-dimensional data warehouses for monitoring of water resources. Journal of Environmental Engineering and Landscape Management, 29(1), 9-20.
Published in Issue
Jan 29, 2021
Abstract Views
PDF Downloads
Creative Commons License

This work is licensed under a Creative Commons Attribution 4.0 International License.


Andersen, J. M., Nordemann, P., Kronvang, B., Friberg, N., Larsen, S. E., Skovgaard, H., & Schwærter, S. (2002). Survey on Project Results: Component B: Water Monitoring. Phase I-III. Series: EU PHARE Twinning Project LI99/IB/ EN-01: Strengthening of Environmental Monitoring Capacities in Lithuania. National Environmental Research Institute, Aarhus County.

Baltrėnas, P., Januševičius, T., & Chlebnikovas, A. (2017). Research into the impact of speed bumps on particulate matter air pollution. Measurement, 100, 62–67.

COM. (2012). Report from the Commission to the European Parliament and the Council on the Implementation of the Water Framework Directive (2000/60/EC) River Basin Management Plans. COM (2012) 670 Final.

Danish Co-operation for the Environment in Eastern Europe. (2004). Implementation of the EU Water Framework Directive, Lithuania (Technical Report of the project DANCEE).

de Souza Fraga, M., da Silva, D. D., Alden Elesbon, A. A., & Guedes, H. A. S. (2019). Methodological proposal for the allocation of water quality monitoring stations using strategic decision analysis. Journal of Environmental Monitoring and Assessment, 191, 776.

den Boer, J., den Boer, E., & Jager, J. (2007). LCA-IWM: A decision support tool for sustainability assessment of waste management systems. Waste Management, 27(8), 1032–1045.

Dzemydiene, D., & Maskeliunas, S. (2011). Development of multi-componential decision support system in dynamically changing application domain of environment protection. In Chiang Jao (Ed.), Efficient decision support systems − practice and challenges from current to future (pp. 405−422). InTech.

Dzemydienė, D., Maskeliūnas, S., Dzemydaitė, G., & Miliauskas, A. (2016). Semi-automatic service provision based on interaction of data warehouses for evaluation of water resources. Informatica, 27(4), 709–722.

Dzemydienė, D., Maskeliūnas, S., Miliauskas, A., Naujikienė, R., & Dzemydaitė, G. (2015). E-service composition for decision support, based on monitoring of contamination processes and analysis of water resource data. Technological and Economic Development of Economy, 21(6), 869–884.

Government of the Republic of Lithuania. (2009). Resolution No. 1247 of the 16 September, 2009. Amending Resolution No 1160 of the Government of the Republic of Lithuania of 11 September 2003 on the Approval and Implementation of the National Strategy for Sustainable Development.

Gricius, G., Drungilas, D., Andziulis, A., Dzemydienė, D., Voznak, M., Kurmis, M., & Jakovlev, S. (2015). Advanced approach of multiagent based buoy communication. The Scientific World Journal, 2015, Article ID 569841.

HELCOM. (1994). Report of the 15th Meeting of the Helsinki Commission - Baltic Marine Environment Protection Commission – held in Helsinki, form 8 to 11 March 1994. Recommendation 15/1 Adopted 8 March 1994, having regard to Article 13, Paragraph b) of the Helsinki Convention on the Protection of the Marine Environment of the Baltic Sea Area.

HELCOM. (2007). HELCOM Baltic Sea action plan. Adopted on 15 November 2007 in Krakow, Poland by the HELCOM Extraordinary Ministerial Meeting.

HELCOM. (2021). HELCOM Baltic Sea action plan (BSAP updated). Reaching good environmental status for the Baltic Sea.

Kadadi, A., Agrawal, R., Nyamful, C., & Atiq, R. (2014). Challenges of data integration and interoperability in big data. In IEEE International Conference on Big Data (pp. 38–40). Washington, DC.

Khouri, S., BoukhariI, I., Bellatreche, L., Sardet, E., Jean, S., & Baron, M. (2012). Ontology-based structured web data warehouses for

Maia, R. (2017). The WFD Implementation in the European Member States. Water Resource Management, 31, 3043–3060 (2017).

Marčiulaitienė, E., Šerevičienė, V., Baltrėnas, P., & Baltrėnaitė, E. (2017). The characteristics of BTEX concentration in various types of environment in the Baltic Sea region, Lithuania. Environmental Science and Pollution Research, 24(4), 4162–4173.

Mėžinė, J., Ferrarin, C., Vaičiūtė, D., Idzelytė, R., Zemlys, P., & Umgiesser, G. (2019). Sediment transport mechanisms in a lagoon with high river discharge and sediment loading. Water, 11(10), 1970.

Mysiak, J., Giupponi, C., & Rosato, P. (2005). Towards the development of a decision support system for water resource management. Environmental Modelling & Software, 20(2), 203–214.

Ministry of Environment of the Republic of Lithuania. (2015). National Environmental Protection Strategy. Resolution on the Approval of the National Environmental Protection Strategy. 16 April 2015. No XII-1626. Vilnius.

Nixon, S., Grath, J., & Bøgestrand, J. (1998). EuroWaterNet. The European Environment Agency’s monitoring and information network for inland water resources. Technical guidelines for implementation. (Technical Report 7). European Environment Agency.

Official Statistics Portal. (2019). Department of Statistics to the Government of the Republic of Lithuania.

Poch, M., Comas, J., Rodríguez-Roda, I., Sànchez-Marrè, M., & Cortés, U. (2004). Designing and building real environmental decision support systems. Environmental Modelling & Software, 19(9), 857–873.

Republic of Lithuania Law on Environmental Protection. (2016). Article of Ministry of Environment Protection of Republic of Lithuania, backgrounded on 21 January, 1992, No I-2223, as last amended on 14 May 2015 – No XII-1718, Consolidated version valid as of 1 April 2016.

Saarenmaa, H., Martin, J., Jensen, S., Peifer, H., & McInnes, G. (2002). Development of common tools and an information infrastructure for the shared European environmental information system (EEA Technical Report No. 83).

Swanson, D. A., Pintér, L., Bregha, F., Volkery, A., & Jacob, K. (2004). National strategies for sustainable development: Challenges, approaches and innovations in strategic and co-ordination actions. International Institute of Sustainable Development.

The European Parliament and the Council of the EU. (2000). Directive 2000/60/EC of the European Parliament and of the Council of 23 October 2000 establishing a framework for Community action in the field of water policy. Official Journal L 327, 22/12/2000, p. 0001 – 0073.

The Government of the Republic of Lithuania. (2020). Resolution of the Government of the Republic of Lithuania on the approval of the National Progress Plan for 2021–2030, 2020 September 9, No. 998.

The Ministry of Environment of the Republic of Lithuania. (1998). The State Environmental Monitoring Programme. Approved by the Government of the Republic of Lithuania, Protocol No 27 on 1 July 1998. 96 p.

Tiwari, A. K., De Maio, M., Singh, P. K., & Mahato, M. K. (2015). Evaluation of surface water quality by using GIS and a heavy metal pollution index (HPI) model in a Coal Mining Area, India. Bulletin of Environmental Contamination and Toxicology, 95(3), 304–310.

United Nations Division for Sustainable Development. (1992). Agenda 21. United Nations Conference on Environment & Development (UNCED), Rio de Janerio, Brazil, 3 to 14 June 1992.

United Nations General Assembly. (2015). Transforming our World: The 2030 Agenda for Sustainable Development. United Nations General Assembly.

Van Dijk, D., & Hendrix, E. M. T. (2016). Pipe replacement in a water supply network: Coordinated versus uncoordinated replacement and budget effects. Informatica, 27(2), 387–403.