An approach of ensuring interoperability of multi-dimensional data warehouses for monitoring of water resources
Abstract
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. https://doi.org/10.3846/jeelm.2021.14112
This work is licensed under a Creative Commons Attribution 4.0 International License.
References
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. https://pure.au.dk/portal/en/persons/brian-kronvang(7766931c-a3c9-4a38-9d22-e4cc3a2f4607)/publications/survey-on-project-results(6e88fea0-7e9d-11dd-a5a8-000ea68e967b)/export.html
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. https://doi.org/10.1016/j.measurement.2016.12.042
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. https://eur-lex.europa.eu/legal-content/EN/TXT/?uri=CELEX%3A52012DC0670
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. https://doi.org/10.1007/s10661-019-7974-2
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. https://doi.org/10.1016/j.wasman.2007.02.022
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. https://doi.org/10.5772/20143
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. https://doi.org/10.15388/Informatica.2016.107
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. https://doi.org/10.3846/20294913.2015.1069417
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. http://extwprlegs1.fao.org/docs/pdf/lit163657.pdf
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. https://doi.org/10.1155/2015/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. https://helcom.fi/wp-content/uploads/2019/08/HELCOM15in1994.pdf
HELCOM. (2007). HELCOM Baltic Sea action plan. Adopted on 15 November 2007 in Krakow, Poland by the HELCOM Extraordinary Ministerial Meeting. https://www.helcom.fi/wp-content/uploads/2019/08/BSAP_Final.pdf
HELCOM. (2021). HELCOM Baltic Sea action plan (BSAP updated). Reaching good environmental status for the Baltic Sea. https://helcom.fi/baltic-sea-action-plan/
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. https://doi.org/10.1109/BigData.2014.7004486
Khouri, S., BoukhariI, I., Bellatreche, L., Sardet, E., Jean, S., & Baron, M. (2012). Ontology-based structured web data warehouses for https://doi.org/10.1016/j.compind.2012.08.001
Maia, R. (2017). The WFD Implementation in the European Member States. Water Resource Management, 31, 3043–3060 (2017). https://doi.org/10.1007/s11269-017-1723-5
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. https://doi.org/10.1007/s11356-016-8204-x
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. https://doi.org/10.3390/w11101970
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. https://doi.org/10.1016/j.envsoft.2003.12.019
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. https://am.lrv.lt/uploads/am/documents/files/Strateginis%20planavimas/Ataskaitos/NAAS%20leidinys%20EN.pdf
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. https://www.eea.europa.eu/publications/TECH07
Official Statistics Portal. (2019). Department of Statistics to the Government of the Republic of Lithuania. https://osp.stat.gov.lt/pradinis
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. https://doi.org/10.1016/j.envsoft.2003.03.007
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. https://e-seimas.lrs.lt/portal/legalAct/lt/TAD/6378f2b0023211e6bf4ee4a6d3cdb874
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). http://www.eea.europa.eu/publications/technical_report_2002_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. https://sustainabledevelopment.un.org/content/documents/1427crp_10.pdf
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. https://eur-lex.europa.eu/legal-content/EN/TXT/?uri=celex%3A32000L0060
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. https://e-seimas.lrs.lt/portal/legalAct/lt/TAD/c1259440f7dd11eab72ddb4a109da1b5?jfwid=-whxwii77y
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. http://elibrary.lt/resursai/LR_ministerijos/AM/dokumentai/VAMP.pdf
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. https://doi.org/10.1007/s00128-015-1558-9
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. https://sustainabledevelopment.un.org/content/documents/Agenda21.pdf
United Nations General Assembly. (2015). Transforming our World: The 2030 Agenda for Sustainable Development. United Nations General Assembly. https://www.unfpa.org/resources/transforming-our-world-2030-agenda-sustainable-development
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. https://doi.org/10.15388/Informatica.2016.91
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. https://doi.org/10.1016/j.measurement.2016.12.042
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. https://eur-lex.europa.eu/legal-content/EN/TXT/?uri=CELEX%3A52012DC0670
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. https://doi.org/10.1007/s10661-019-7974-2
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. https://doi.org/10.1016/j.wasman.2007.02.022
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. https://doi.org/10.5772/20143
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. https://doi.org/10.15388/Informatica.2016.107
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. https://doi.org/10.3846/20294913.2015.1069417
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. http://extwprlegs1.fao.org/docs/pdf/lit163657.pdf
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. https://doi.org/10.1155/2015/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. https://helcom.fi/wp-content/uploads/2019/08/HELCOM15in1994.pdf
HELCOM. (2007). HELCOM Baltic Sea action plan. Adopted on 15 November 2007 in Krakow, Poland by the HELCOM Extraordinary Ministerial Meeting. https://www.helcom.fi/wp-content/uploads/2019/08/BSAP_Final.pdf
HELCOM. (2021). HELCOM Baltic Sea action plan (BSAP updated). Reaching good environmental status for the Baltic Sea. https://helcom.fi/baltic-sea-action-plan/
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. https://doi.org/10.1109/BigData.2014.7004486
Khouri, S., BoukhariI, I., Bellatreche, L., Sardet, E., Jean, S., & Baron, M. (2012). Ontology-based structured web data warehouses for https://doi.org/10.1016/j.compind.2012.08.001
Maia, R. (2017). The WFD Implementation in the European Member States. Water Resource Management, 31, 3043–3060 (2017). https://doi.org/10.1007/s11269-017-1723-5
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. https://doi.org/10.1007/s11356-016-8204-x
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. https://doi.org/10.3390/w11101970
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. https://doi.org/10.1016/j.envsoft.2003.12.019
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. https://am.lrv.lt/uploads/am/documents/files/Strateginis%20planavimas/Ataskaitos/NAAS%20leidinys%20EN.pdf
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. https://www.eea.europa.eu/publications/TECH07
Official Statistics Portal. (2019). Department of Statistics to the Government of the Republic of Lithuania. https://osp.stat.gov.lt/pradinis
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. https://doi.org/10.1016/j.envsoft.2003.03.007
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. https://e-seimas.lrs.lt/portal/legalAct/lt/TAD/6378f2b0023211e6bf4ee4a6d3cdb874
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). http://www.eea.europa.eu/publications/technical_report_2002_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. https://sustainabledevelopment.un.org/content/documents/1427crp_10.pdf
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. https://eur-lex.europa.eu/legal-content/EN/TXT/?uri=celex%3A32000L0060
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. https://e-seimas.lrs.lt/portal/legalAct/lt/TAD/c1259440f7dd11eab72ddb4a109da1b5?jfwid=-whxwii77y
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. http://elibrary.lt/resursai/LR_ministerijos/AM/dokumentai/VAMP.pdf
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. https://doi.org/10.1007/s00128-015-1558-9
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. https://sustainabledevelopment.un.org/content/documents/Agenda21.pdf
United Nations General Assembly. (2015). Transforming our World: The 2030 Agenda for Sustainable Development. United Nations General Assembly. https://www.unfpa.org/resources/transforming-our-world-2030-agenda-sustainable-development
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. https://doi.org/10.15388/Informatica.2016.91