Tired of losing valuable data? Build your lab ecological database as a cornerstone for long-term approaches

Juan Alberti; Octavio Massone

doi:10.25260/EA.22.32.1.0.1785

Authors

Juan Alberti Instituto de Investigaciones Marinas y Costeras (IIMyC), FCEyN, UNMdP-CONICET
Octavio Massone Instituto de Investigaciones Marinas y Costeras (IIMyC), FCEyN, UNMdP-CONICET

DOI:

https://doi.org/10.25260/EA.22.32.1.0.1785

Keywords:

relational database, graphical user interface, shiny, step by step guide

Abstract

Long-term ecological data is essential to identify impacts of global change or to analyse the response of local systems to perturbations. Thus, ecologists are facing the compromise to collect and process longer-term data while specific funding for those purposes is extremely scarce. Although more funding to gather and store long term data would be ideal, it is unlikely to occur, at least in the short term. Another (most plausible) option could be to dive among the many spreadsheets belonging to one or more colleagues with shared variables and from several projects over the years. Obviously, this might be an extremely time-consuming and tedious task. To simplify this and save time, it would be ideal to store as much data as possible (individual or lab generated) in a single comprehensive database. Given that the process of building, maintaining and doing queries on such databases could be scary for ecologists not familiarized, here we provide a step-by-step guide to build 1) a generic and versatile ecological database, and 2) a graphical user interface to load, update, verify, view and download data. The scripts to build them are programmed on open-software (MariaDB and R), and we also provide instructions to change them according to many usual situations.

References

Bakker, J. P., H. Olff, J. H. Willems, and M. Zobel. 1996. Why do we need permanent plots in the study of long-term vegetation dynamics? Journal of Vegetation Science 7:147-156. https://doi.org/10.2307/3236314.

Callahan, J. T. 1984. Long-Term Ecological Research. BioScience 34:363-367. https://doi.org/10.2307/1309727.

Chang, W., J. Cheng, J. Allaire, Y. Xie, and J. McPherson. 2020. shiny: web application framework for R.

Dirzo, R., H. S. Young, M. Galetti, G. Ceballos, N. J. B. Isaac, and B. Collen. 2014. Defaunation in the Anthropocene. Science 345:401-406. https://doi.org/10.1126/science.1251817.

Estes, J. A., J. Terborgh, J. S. Brashares, M. E. Power, J. Berger, W. J. Bond, S. R. Carpenter, T. E. Essington, R. D. Holt, J. B. C. Jackson, R. J. Marquis, L. Oksanen, T. Oksanen, R. T. Paine, E. K. Pikitch, W. J. Ripple, S. A. Sandin, M. Scheffer, T. W. Schoener, J. B. Shurin, A. R. E. Sinclair, M. E. Soulé, R. Virtanen, and D. A. Wardle. 2011. Trophic downgrading of planet earth. Science 333:301-306. https://doi.org/10.1126/science.1205106.

Hughes, B. B., R. Beas-Luna, A. K. Barner, K. Brewitt, D. R. Brumbaugh, E. B. Cerny-Chipman, S. L. Close, K. E. Coblentz, D. Nesnera, K. L, S. T. Drobnitch, J. D. Figurski, B. Focht, M. Friedman, J. Freiwald, K. K. Heady, W. N. Heady, A. Hettinger, A. Johnson, K. A. Karr, B. Mahoney, M. M. Moritsch, A.-M. K. Osterback, J. Reimer, J. Robinson, T. Rohrer, J. M. Rose, M. Sabal, L. M. Segui, C. Shen, J. Sullivan, R. Zuercher, P. T. Raimondi, B. A. Menge, K. Grorud-Colvert, M. Novak, and M. H. Carr. 2017. Long-term studies contribute disproportionately to ecology and policy. BioScience 67:271-281. https://doi.org/10.1093/biosci/biw185.

Jackson, J. B. C., M. X. Kirby, W. H. Berger, K. A. Bjorndal, L. W. Botsford, B. J. Bourque, R. H. Bradbury, R. Cooke, J. Erlandson, J. A. Estes, T. P. Hughes, S. Kidwell, C. B. Lange, H. S. Lenihan, J. M. Pandolfi, C. H. Peterson, R. S. Steneck, M. J. Tegner, and R. R. Warner. 2001. Historical overfishing and the recent collapse of coastal ecosystems. Science 293:629-637. https://doi.org/10.1126/science.1059199.

Komatsu, K. J., M. L. Avolio, N. P. Lemoine, F. Isbell, E. Grman, G. R. Houseman, S. E. Koerner, D. S. Johnson, K. R. Wilcox, J. M. Alatalo, J. P. Anderson, R. Aerts, S. G. Baer, A. H. Baldwin, J. Bates, C. Beierkuhnlein, R. T. Belote, J. Blair, J. M. G. Bloor, P. J. Bohlen, E. W. Bork, E. H. Boughton, W. D. Bowman, A. J. Britton, J. F. Cahill, E. Chaneton, N. R. Chiariello, J. Cheng, S. L. Collins, J. H. C. Cornelissen, G. Du, A. Eskelinen, J. Firn, B. Foster, L. Gough, K. Gross, L. M. Hallett, X. Han, H. Harmens, M. J. Hovenden, A. Jagerbrand, A. Jentsch, C. Kern, K. Klanderud, A. K. Knapp, J. Kreyling, W. Li, Y. Luo, R. L. McCulley, J. R. McLaren, J. P. Megonigal, J. W. Morgan, V. Onipchenko, S. C. Pennings, J. S. Prevéy, J. N. Price, P. B. Reich, C. H. Robinson, F. L. Russell, O. E. Sala, E. W. Seabloom, M. D. Smith, N. A. Soudzilovskaia, L. Souza, K. Suding, K. B. Suttle, T. Svejcar, D. Tilman, P. Tognetti, R. Turkington, S. White, Z. Xu, L. Yahdjian, Q. Yu, P. Zhang, and Y. Zhang. 2019. Global change effects on plant communities are magnified by time and the number of global change factors imposed. Proceedings of the National Academy of Sciences 116:17867-17873. https://doi.org/10.1073/pnas.1819027116.

Lindenmayer, D. B., G. E. Likens, A. Andersen, D. Bowman, C. M. Bull, E. Burns, C. R. Dickman, A. A. Hoffmann, D. A. Keith, M. J. Liddell, A. J. Lowe, D. J. Metcalfe, S. R. Phinn, J. Russell‐Smith, N. Thurgate, and G. M. Wardle. 2012. Value of long-term ecological studies. Austral Ecology 37:745-757. https://doi.org/10.1111/j.1442-9993.2011.02351.x.

Magurran, A. E., S. R. Baillie, S. T. Buckland, J. M. Dick, D. A. Elston, E. M. Scott, R. I. Smith, P. J. Somerfield, and A. D. Watt. 2010. Long-term datasets in biodiversity research and monitoring: assessing change in ecological communities through time. Trends in Ecology and Evolution 25:574-582. https://doi.org/10.1016/j.tree.2010.06.016.

Millennium Ecosystem Assessment Panel. 2005. Ecosystems and human well-being: synthesis. Island Press, Washington, U.S.A.

Mills, J. A., C. Teplitsky, B. Arroyo, A. Charmantier, Peter. H. Becker, T. R. Birkhead, P. Bize, D. T. Blumstein, C. Bonenfant, S. Boutin, A. Bushuev, E. Cam, A. Cockburn, S. D. Côté, J. C. Coulson, F. Daunt, N. J. Dingemanse, B. Doligez, H. Drummond, R. H. M. Espie, M. Festa-Bianchet, F. Frentiu, J. W. Fitzpatrick, R. W. Furness, D. Garant, G. Gauthier, P. R. Grant, M. Griesser, L. Gustafsson, B. Hansson, M. P. Harris, F. Jiguet, P. Kjellander, E. Korpimäki, C. J. Krebs, L. Lens, J. D. C. Linnell, M. Low, A. McAdam, A. Margalida, J. Merilä, A. P. Møller, S. Nakagawa, J.-Å. Nilsson, I. C. T. Nisbet, A. J. van Noordwijk, D. Oro, T. Pärt, F. Pelletier, J. Potti, B. Pujol, D. Réale, R. F. Rockwell, Y. Ropert-Coudert, A. Roulin, J. S. Sedinger, J. E. Swenson, C. Thébaud, M. E. Visser, S. Wanless, D. F. Westneat, A. J. Wilson, and A. Zedrosser. 2015. Archiving primary data: solutions for long-term studies. Trends in Ecology and Evolution 30:581-589. https://doi.org/10.1016/j.tree.2015.07.006.

R Core Team. 2021. R: a language and environment for statistical computing. R Foundation for Statistical Computing, Vienna, Austria.

Reich, P. B., D. Tilman, F. Isbell, K. Mueller, S. E. Hobbie, D. F. B. Flynn, and N. Eisenhauer. 2012. Impacts of biodiversity loss escalate through time as redundancy fades. Science 336:589-592. https://doi.org/10.1126/science.1217909.

Silvertown, J., P. R. Poulton, A. E. Johnston, G. Edwards, M. Heard, and P. M. Biss. 2006. The Park Grass Experiment 1856-2006: its contribution to ecology. Journal of Ecology 94:801-814. https://doi.org/10.1111/j.1365-2745.2006.01145.x.

Silvertown, J., J. Tallowin, C. Stevens, S. A. Power, V. Morgan, B. Emmett, A. Hester, P. J. Grime, M. Morecroft, R. Buxton, P. Poulton, R. Jinks, and R. Bardgett. 2010. Environmental myopia: a diagnosis and a remedy. Trends in Ecology and Evolution 25:556-561. https://doi.org/10.1016/j.tree.2010.06.015.

Smith, J. B., S. H. Schneider, M. Oppenheimer, G. W. Yohe, W. Hare, M. D. Mastrandrea, A. Patwardhan, I. Burton, J. Corfee-Morlot, C. H. D. Magadza, H.-M. Füssel, A. B. Pittock, A. Rahman, A. Suarez, and J.-P. van Ypersele. 2009. Assessing dangerous climate change through an update of the Intergovernmental Panel on Climate Change (IPCC) ‘reasons for concern.’ Proceedings of the National Academy of Sciences 106:4133. https://doi.org/10.1073/pnas.0812355106.

Song, J., S. Wan, S. Piao, A. K. Knapp, A. T. Classen, S. Vicca, P. Ciais, M. J. Hovenden, S. Leuzinger, C. Beier, P. Kardol, J. Xia, Q. Liu, J. Ru, Z. Zhou, Y. Luo, D. Guo, J. Adam Langley, J. Zscheischler, J. S. Dukes, J. Tang, J. Chen, K. S. Hofmockel, L. M. Kueppers, L. Rustad, L. Liu, M. D. Smith, P. H. Templer, R. Quinn Thomas, R. J. Norby, R. P. Phillips, S. Niu, S. Fatichi, Y. Wang, P. Shao, H. Han, D. Wang, L. Lei, J. Wang, X. Li, Q. Zhang, X. Li, F. Su, B. Liu, F. Yang, G. Ma, G. Li, Y. Liu, Y. Liu, Z. Yang, K. Zhang, Y. Miao, M. Hu, C. Yan, A. Zhang, M. Zhong, Y. Hui, Y. Li, and M. Zheng. 2019. A meta-analysis of 1,119 manipulative experiments on terrestrial carbon-cycling responses to global change. Nature Ecology and Evolution 3:1309-1320. https://doi.org/10.1038/s41559-019-0958-3.

Turner, M. G., S. L. Collins, A. L. Lugo, J. J. Magnuson, T. S. Rupp, and F. J. Swanson. 2003. Disturbance dynamics and ecological response: the contribution of long-term ecological research. BioScience 53:46-56. https://doi.org/10.1641/0006-3568(2003)053[0046:DDAERT]2.0.CO;2.

Venter, O., E. W. Sanderson, A. Magrach, J. R. Allan, J. Beher, K. R. Jones, H. P. Possingham, W. F. Laurance, P. Wood, B. M. Fekete, M. A. Levy, and J. E. M. Watson. 2016. Sixteen years of change in the global terrestrial human footprint and implications for biodiversity conservation. Nature Communications 7:12558. https://doi.org/10.1038/ncomms12558.

Young, H. S., D. J. McCauley, M. Galetti, and R. Dirzo. 2016. Patterns, causes, and consequences of anthropocene defaunation. Annual Review of Ecology, Evolution and Systematics 47:333-358. https://doi.org/10.1146/annurev-ecolsys-112414-054142.