Customization, extension and reuse of outdated hydrogeological software
DOI:
https://doi.org/10.1344/GeologicaActa2020.18.9Keywords:
Software improvement, Software customization, MIX, EasyQuim, EasyBal, BrineMIX.Abstract
Each scientist is specialized in his or her field of research and in the tools that he or she uses during the research in a specified site. Thus, he or she is the most suitable person for improving the tools by overcoming their limitations to realize faster and higher quality analysis. However, most scientists are not software developers. Hence, it is necessary to provide them with an easy approach that enables non-software developers to improve and customize their tools. This paper presents an approach for easily improving and customizing any hydrogeological software. It is the result of experiences with updating several interdisciplinary case studies. The main insights of this approach
have been demonstrated using four examples: MIX (FORTRAN-based), BrineMIX (C++-based), EasyQuim and EasyBal (both spreadsheet-based). The improved software has been proven to be a better tool for enhanced analysis by substantially reducing the computation time and the tedious processing of the input and output data files.
References
Aliane, N., 2010. Data acquisition and real-time control using spreadsheets: interfacing Excel with external hardware. ISA Transactions, July 2010, 49(3), 264-9. DOI: 10.1016/j.isatra.2010.03.009
Asuncion, H.U., 2013. Automated data provenance capture in spreadsheets, with case studies. Future Generation Computer Systems, October 2013, 29(8), 2169-2181. DOI: 10.1016/j.future.2013.04.009
Bea, S.A., Carrera, J., Ayora, C., Batlle, F., Saaltink, M.W., 2009. CHEPROO: A Fortran 90 object-oriented module to solve chemical processes in Earth Science models. Computers & Geosciences, 35 (6), 1098-1112. DOI: 10.1016/j.cageo.2008.08.010
Buccella, A., Cechich, A., Arias, M., Pol’la, M., Doldan, M.D.S., Morsan, E., 2013. Towards systematic software reuse of GIS:
Insights from a case study. Computers & Geosciences, 54, 9-20. DOI: 10.1016/j.cageo.2012.11.014
Buregio, V.A.D.A., Almeida, E.S.D., Lucredio, D., Meira, S.R.D.L., 2007. 31st IEEE Annual International Computer Software
and Applications (COMPSAC) Conference, Beijing (China), Short paper.
Cánovas, C.R., Olias, M., Vazquez-Suñé, E., Ayora, C., Nieto, J.M., 2012. Influence of releases from a fresh water reservoir on
the hydrochemistry of the Tinto River (SW Spain). Science of the Total Environment, 416, 418-428. DOI: 10.1016/j.scitotenv.2011.11.079
Carrera, J., Vázquez-Suñé, E., Castillo, O., Sánchez-Vila, X., 2004. A methodology to compute mixing ratios with uncertain
end-members. Water Resources Research, 40(12), n/a. DOI: 10.1029/2003WR002263
Criollo, R., Velasco, V., Vàzquez-Suñé, E., Serrano-Juan, A., Alcaraz, M., García-Gil, A., 2016. An integrated GIS-based tool for aquifer test analysis. Environmental Earth Sciences, 75, 1-11. DOI: 10.1007/s12665-016-5292-3
Criollo, R., Velasco, V., Nardi, A., de Vries, L.M., Riera, C., Scheiber, L., Jurado, A., Brouyère, S., Pujades, E., Rossetto, R., VázquezSuñé, E., 2019. AkvaGIS: An open source tool for water quantity and quality management. Computers & Geosciences, 127, 123-132. DOI: 10.1016/j.cageo.2018.10.012
Cunha, J., Mendes, J., Saraiva, J., Visser, J., 2014. Model-based programming environments for spreadsheets. Science of Computer Programming, 1, 1-22. DOI: 10.1016/j.scico.2014.02.002
Deursen, A.V., Klint, P., Visser, J., 2000. Domain-specific anguages: An annotated bibliography. ACM SIGPLAN Notices, 35(6),
-36.
Devanbu, P.T., Karstu, S., Melo, W.L., Thomas, W., 1996. Analytical and empirical evaluation of software reuse metrics. Berlin (Germany), 18th International Conference on Software Engineering (ICSE), 189-199.
Elmore, A., 2007. Applying one-dimensional mass transport model using groundwater concentration data. Journal of Environmental Engineering, 133(4), 372-379.
Ibrahim, D., 2009. Using the excel spreadsheet in teaching science subjects. Procedia-Social and Behavioral Sciences, 1(1), 309-312. DOI: 10.1016/j.sbspro.2009.01.058
Jannach, D., Schmitz, T., Hofer, B., Wotawa, F., 2014. Journal of Systems and Software. DOI: 10.1016/j.jss.2014.03.058
Jisc Digital Media, 2019. Accessed: November 10, 2019. Link: https://www.webarchive.org.uk/wayback/archive/20160101151319/http://www.jiscdigitalmedia.ac.uk/guides
Jones, W.R., Spence, M.J., Bowman, A.W., Evers, L., Molinari, D.A., 2014. A software tool for the spatiotemporal analysis and reporting of groundwater monitoring data. Environmental Modelling & Software, 55, 242-249. DOI: 10.1016/j.envsoft.2014.01.020
Jurado, A., Vàzquez-Suñé, E., Carrera, J., Tubau, I., Pujades, E., 2015. Quantifying chemical reactions by using mixing analysis. Science of the Total Environment, 502, 448-456. DOI: 10.1016/j.scitotenv.2014.09.036
Kruchten, P.A., 2003. The Rational Unified Process: An Introduction. Boston (MA United States). Addison-Wesley Longman Publishing Co., Inc.75 Arlington Street, Suite 300, 320pp. ISBN: 978-0-321-19770-2.
Krueger, C., 1992. Software reuse. ACM Computing Surveys, 24(2), 131-183.
Lucredio, D., Almeida, E.S.d., Prado, A.F.d., 2004. A Survey on Software Components Search and Retrieval. In: 30th IEEE EUROMICRO Conference, Component-Based Software Engineering Track. Rennes (France), IEEE Computer Society Press, Los Alamitos, 152- 159.
Lucrédio, D., dos Santos Brito, K., Alvaro, A., Garcia, V.C., de Almeida, E.S., de Mattos Fortes, R.P., Meira, S.L., 2008. Software reuse: The Brazilian industry scenario. Journal of Systems and Software, 81(6), 996-1013. DOI: 10.1016/j.jss.2007.08.036
Marcus, A., 1995, Principles of Effective Visual Communication for Graphical User Interface Design. In: Readings in Human-Computer Interaction. Baecker, Grudin, Buxton and Greenberg, Morgan Kaufman, Palo Alto, 2nd edition, 425-441. ISBN: 1-55860-246-1.
Molano, C., 2013. Groundwater Spreadsheets: Efficient and Practical Resource for Solving Simple and Complex Flow, Pollution, and Environmental Problems. William A. McEllhiney Distinguished Lecture Series in Water Well Technology, 2013 NGWA Groundwater Expo and Annual Meeting, NGWA.
Parkhurst, D.L., Appelo, C.A.J., 2013, Description of input and examples for PHREEQC version 3—A computer program for speciation, batch-reaction, one-dimensional transport, and inverse geochemical calculations. U.S. Geological Survey Techniques and Methods, book 6, chap. A43, 497pp. Available at: http://pubs.usgs.gov/tm/06/a43/
Phong. V.V., Kumar, P., Drewry, D.T., Quijano, J.C., 2012. A graphical user interface for numerical modeling of acclimation responses of vegetation to climate change. Computers & Geosciences, 49, 91-101. DOI: 10.1016/j.cageo.2012.07.007
Robin, B., 1995. Supporting geoscience with Graphical-UserInterface internet tools for the Macintosh. Computers & Geosciences, 21(6), 737-751.
Rossetto, R., De Filippis, G., Borsi, I., Foglia, L., Cannata, M., Criollo, R., Vázquez-Suñé, E., 2018. Integrating free and open source tools and distributed modelling codes in GIS environment for data-based groundwater management. Environmental Modelling and Software, 107, 210-230. DOI: 10.1016/j.envsoft.2018.06.007
Scheiber, L., Ayora, C., Vázquez-Suñé, E., Cendón, D., Soler, A., Custodio, E., Baquero, J.C., 2015. Recent and old groundwater
in the Niebla-Posadas regional aquifer (southern Spain): Implications for its management. Journal of Hydrology, 523, 624-635. DOI: 10.1016/j.jhydrol.2015.01.076
Scheiber, L., Ayora, C., Vázquez-Suñé, E., Cendón, D., Soler, A., Baquero, J.C., 2016. Origin of high ammonium, arsenic and
boron concentrations in the proximity of a mine: Natural vs. anthropogenic processes. Science of the Total Environment,
, 655-666. DOI: 10.1016/j.scitotenv.2015.09.098
Scheiber, L., Ayora, C., Vázquez-Suñé, E., 2018. Quantification of proportions of different water sources in a mining operation. Science of the Total Environment, 619-620, 587-620. DOI: 10.1016/j.scitotenv.2017.11.172
Serrano-Juan, A., Vázquez-Suñè, E., Monserrat, O., Crosetto, M., Hoffmann, C., Ledesma, A., Criollo, R., Pujades, E., Velasco, V., Garcia-Gil, A., Garcia-Alcaraz, M., 2016. GbSAR interferometry displacement measurements during dewatering in construction works. Case of La Sagrera railway station in Barcelona, Spain. Engineering Geology, 205, 104-115. DOI: 10.1016/j.enggeo.2016.02.014
Serrano-Juan, A., Pujades, E., Vázquez-Suñè, E., Velasco, V., Criollo, R., Jurado, A., 2018. Integration of groundwater bypass facilities in the bottom slab design for large underground structures. Tunnelling and underground space technology, 71, 231-243. DOI: 10.1016/j.tust.2017.07.020
Suri, P.K., Neeraj Garg, 2008. Simulator for evaluating Reliability of Reusable Components in a Domain Interconnection Network. International Journal of Computer Science and Network Security, 8(3), March 2008, 251-259.
Torlapati, J., Prabhakar Clement, T., 2013. Benchmarking a VisualBasic based multi-component one-dimensional reactive
transport modeling tool. Computers & Geosciences, 50, 72-83. DOI: 10.1016/j.cageo.2012.08.009
Tubau, I., Vàzquez-Suñé, E., Jurado, A., Carrera, J., 2014. Using EMMA and MIX analysis to assess mixing ratios and to identify hydrochemical reactions in groundwater. Science of the Total Environment, 470-471, 1120-1131. DOI: 10.1016/j.
scitotenv.2013.10.121
Tubau, I., Vazquez-Suñe, E., Carrera, J., Valhondo, C., Criollo, R., 2017. Quantification of groundwater recharge in urban
environments. Science of the Total Environment, 592, 391-402. DOI: 10.1016/j.scitotenv.2017.03.118
Vázquez-Suñé, E., Carrera, J., Tubau, I., Sánchez-Vila, X., Soler, A., 2010. An approach to identify urban groundwater recharge. Hydrology and Earth System Sciences (HESS), 14, 2085-2097. DOI: 10.5194/hess-14-2085-2010
Velasco, V., Tubau, I., Vázquez-Suñè, E., Gogu, R., Gaitanaru, D., Alcaraz, M., Serrano-Juan, A., Fernàndez-Garcia, D., Garrido, T., Fraile, J., Sanchez-Vila, X., 2014. GIS-based hydrogeochemical analysis tools (QUIMET). Computers & Geosciences, 70, 164-180. DOI: 10.1016/j.cageo.2014.04.013
Verplank, W.L., 1985. Graphics in human-computer communication: Principles of graphical user-interface design. Proceedings of the IFIP-IMIA Second Stockholm Conference on Communication in Health Care. Stockholm (Sweden), H.E.
Peterson and W. Schneider, 13-130.
Wang, J.-P., Huang, D., 2012. RosenPoint: A Microsoft Excelbased program for the Rosenblueth point estimate method and an application in slope stability analysis. Computers & Geosciences, 48, 239-243. DOI: 10.1016/j.cageo.2012.01.009
Wang, J.-P., Huang, D., Yang, Z., 2012. Deterministic seismic hazard map for Taiwan developed using an in-house Excelbased program. Computers & Geosciences, 48, 111-116. DOI: 10.1016/j.cageo.2012.05.014
Wang, J.-P., Huang, D., Cheng, C.-T., Shao, K.-S., Wu, Y.-C., Chang, C.-W., 2013. Seismic hazard analyses for Taipei city including deaggregation, design spectra, and time history with excel applications. Computers & Geosciences, 52, 146-154. DOI: 10.1016/j.cageo.2012.09.021
Downloads
Published
Issue
Section
License
Copyright (c) 2020 Geologica Acta
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
Copyright
Geologica Acta is the property of the UB, GEO3BCN, IDAEA and UAB. Geologica Acta must be cited for any partial or full reproduction. Papers are distributed under the Attribution-Share Alike Creative Commons License. This license allows anyone to reproduce and disseminate the content of the journal and even make derivative works crediting authorship and provenance and distributing possible derivative works under the same or an equivalent license.
Author Rights
Authors retain the copyright on their papers and are authorized to post them on their own web pages or institutional repositories. The copyright was retained by the journal from the year 2003 until 2009. In all cases, the complete citation and a link to the Digital Object Identifier (DOI) of the article must be included.
The authors can use excerpts or reproduce illustrations of their papers in other works without prior permission from Geologica Acta provided the source of the paper including the complete citation is fully acknowledged.
