Tired of losing valuable data? Build your lab ecological database as a cornerstone for long-term approaches
DOI:
https://doi.org/10.25260/EA.22.32.1.0.1785Keywords:
relational database, graphical user interface, shiny, step by step guideAbstract
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.
![Tired of losing valuable data? Build your lab ecological database as a cornerstone for long-term approaches](https://ojs.ecologiaaustral.com.ar/public/journals/1/article_1785_cover_es_ES.png)
Downloads
Additional Files
Published
How to Cite
Issue
Section
License
Copyright (c) 2022 Juan Alberti, Octavio Massone
![Creative Commons License](http://i.creativecommons.org/l/by/3.0/88x31.png)
This work is licensed under a Creative Commons Attribution 3.0 Unported License.
Authors retain their rights as follows: 1) by granting the journal the right to its first publication, and 2) by registering the published article with a Creative Commons Attribution License (CC-BY 4.0), which allows authors and third parties to view and use it as long as they clearly mention its origin (citation or reference, including authorship and first publication in this journal). Authors can make other non-exclusive distribution agreements as long as they clearly indicate their origin and are encouraged to widely share and disseminate the published version of their work.