{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,10,1]],"date-time":"2026-10-01T12:58:38Z","timestamp":1790859518689,"version":"4.1.0"},"reference-count":46,"publisher":"Oxford University Press (OUP)","license":[{"start":{"date-parts":[[2024,10,10]],"date-time":"2024-10-10T00:00:00Z","timestamp":1728518400000},"content-version":"vor","delay-in-days":283,"URL":"https:\/\/creativecommons.org\/licenses\/by\/4.0\/"}],"funder":[{"DOI":"10.13039\/501100021337","name":"Institute of Botany of the Czech Academy of Sciences","doi-asserted-by":"publisher","award":["RVO 67985939"],"award-info":[{"award-number":["RVO 67985939"]}],"id":[{"id":"10.13039\/501100021337","id-type":"DOI","asserted-by":"publisher"}]},{"DOI":"10.13039\/501100021337","name":"Institute of Botany of the Czech Academy of Sciences","doi-asserted-by":"publisher","award":["RVO 67985939"],"award-info":[{"award-number":["RVO 67985939"]}],"id":[{"id":"10.13039\/501100021337","id-type":"DOI","asserted-by":"publisher"}]}],"content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":[],"published-print":{"date-parts":[[2024,10,10]]},"abstract":"<jats:title>Abstract<\/jats:title>\n               <jats:p>The unifying element of all biodiversity data is the issue of taxon hierarchy modeling. We compared 25 existing databases in terms of handling taxa hierarchy and presentation of this data. We used documentation or demo installations of databases as a source of information and next in line was the analysis of structures using R packages provided by inspected platforms. If neither of these was available, we used the public interface of individual databases. For almost half (12) of the databases analyzed, we did not find any formalized taxa hierarchy data structure, providing only biological information about taxon membership in higher ranks, which is not fully formalizable and thus not generally usable. The least effective Adjacency List model (storing parentId of a taxon) dominates among the remaining providers. This study demonstrates the lack of attention paid by current biodiversity databases to modeling taxon hierarchy, particularly to making it available to researchers in the form of a hierarchical data structure within the data provided. For biodiversity relational databases, the Closure Table type is the most suitable of the known data models, which also corresponds to the ontology concept. However, its use is rather sporadic within the biodiversity databases ecosystem.<\/jats:p>","DOI":"10.1093\/database\/baae107","type":"journal-article","created":{"date-parts":[[2024,10,10]],"date-time":"2024-10-10T15:58:11Z","timestamp":1728575891000},"source":"Crossref","is-referenced-by-count":6,"title":["The relational modeling of hierarchical data in biodiversity databases"],"prefix":"10.1093","volume":"2024","author":[{"ORCID":"https:\/\/orcid.org\/0000-0002-9655-6278","authenticated-orcid":false,"given":"Petr","family":"Novotn\u00fd","sequence":"first","affiliation":[{"name":"Department of Biology Education & Herbarium collections (PRC), Faculty of Science, Charles University , Vini\u010dn\u00e1 7, Praha 128 00,","place":["Czech Republic"]}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Jan","family":"Wild","sequence":"additional","affiliation":[{"name":"Institute of Botany of the Czech Academy of Sciences , Z\u00e1mek 1, Pr\u016fhonice 252 43,","place":["Czech Republic"]}],"role":[{"vocabulary":"crossref","role":"author"}]}],"member":"286","published-online":{"date-parts":[[2024,10,10]]},"reference":[{"key":"2025030713434970200_R1","doi-asserted-by":"publisher","DOI":"10.1002\/widm.1394","article-title":"A survey of biodiversity informatics: concepts, practices, and challenges","volume":"11","author":"Gadelha","year":"2021","journal-title":"WIREs Data Mining Knowl Discov"},{"key":"2025030713434970200_R2","doi-asserted-by":"publisher","first-page":"626","DOI":"10.1038\/s41559-023-02008-w","article-title":"Better incentives are needed to reward academic software development","volume":"7","author":"Merow","year":"2023","journal-title":"Nat Ecol Evol"},{"key":"2025030713434970200_R3","doi-asserted-by":"publisher","first-page":"29","DOI":"10.1016\/j.shpsc.2011.10.003","article-title":"Re-thinking organisms: the impact of databases on model organism biology","volume":"43","author":"Leonelli","year":"2012","journal-title":"Stud Hist Philos Sci C"},{"key":"2025030713434970200_R4","first-page":"45","article-title":"Biological taxonomy and ontology development: scope and limitations","volume":"7","author":"Franz","year":"2010","journal-title":"Biodivers Inform"},{"key":"2025030713434970200_R5","doi-asserted-by":"publisher","first-page":"12","DOI":"10.1111\/2041-210X.13802","article-title":"Harmonizing taxon names in biodiversity data: a review of tools, databases and best practices","volume":"14","author":"Greni\u00e9","year":"2023","journal-title":"Meth Ecol Evol"},{"key":"2025030713434970200_R6","doi-asserted-by":"publisher","first-page":"283","DOI":"10.2307\/1224098","article-title":"A taxonomic information model for botanical databases: the IOPI Model","volume":"46","author":"Berendsohn","year":"1997","journal-title":"TAXON"},{"key":"2025030713434970200_R7","doi-asserted-by":"publisher","first-page":"153","DOI":"10.11646\/zootaxa.1950.1.12","article-title":"Principles for a names-based cyberinfrastructure to serve all of biology","volume":"1950","author":"Patterson","year":"2008","journal-title":"Zootaxa"},{"key":"2025030713434970200_R8","doi-asserted-by":"crossref","first-page":"937","DOI":"10.1007\/3-540-45545-0_106","volume-title":"Computational Science \u2014 ICCS 2001","author":"Yoon","year":"2001"},{"key":"2025030713434970200_R9","doi-asserted-by":"crossref","first-page":"309","DOI":"10.1007\/978-3-540-45091-7_22","volume-title":"Conceptual Structures for Knowledge Creation and Communication","author":"Priss","year":"2003"},{"key":"2025030713434970200_R10","volume-title":"Joe Celko\u2019s Trees and Hierarchies in SQL for Smarties","author":"Celko","year":"2012"},{"key":"2025030713434970200_R11","doi-asserted-by":"publisher","first-page":"55","DOI":"10.2307\/1223932","article-title":"The prometheus taxonomic model: a practical approach to representing multiple classifications","volume":"49","author":"Pullan","year":"2000","journal-title":"TAXON"},{"key":"2025030713434970200_R12","doi-asserted-by":"publisher","first-page":"223","DOI":"10.2307\/1224663","article-title":"Data model and comparison and query methods for interacting classifications in a taxonomic database","volume":"45","author":"Zhong","year":"1996","journal-title":"TAXON"},{"key":"2025030713434970200_R13","doi-asserted-by":"publisher","first-page":"1229","DOI":"10.1093\/bioinformatics\/bty792","article-title":"Phylolink: phylogenetically-based profiling, visualisations and metrics for biodiversity","volume":"35","author":"Miller","year":"2019","journal-title":"Bioinformatics"},{"key":"2025030713434970200_R14","doi-asserted-by":"publisher","first-page":"1242","DOI":"10.1111\/geb.13497","article-title":"A review of the heterogeneous landscape of biodiversity databases: opportunities and challenges for a synthesized biodiversity knowledge base","volume":"31","author":"Feng","year":"2022","journal-title":"Glob Ecol Biogeogr"},{"key":"2025030713434970200_R15","doi-asserted-by":"publisher","first-page":"1687","DOI":"10.1111\/nph.18961","article-title":"The big four of plant taxonomy\u2013a comparison of global checklists of vascular plant names","volume":"240","author":"Schellenberger Costa","year":"2023","journal-title":"New Phytol"},{"key":"2025030713434970200_R16","article-title":"List of Darwin Core Terms","author":"Darwin Core Maintenance Group","year":"2023"},{"key":"2025030713434970200_R17","doi-asserted-by":"publisher","first-page":"108","DOI":"10.1080\/13658816.2015.1077962","article-title":"Towards a national bio-environmental data facility: experiences from the Atlas of Living Australia","volume":"30","author":"Belbin","year":"2016","journal-title":"Int J Geog Inf Sci"},{"key":"2025030713434970200_R18","doi-asserted-by":"publisher","DOI":"10.7287\/peerj.preprints.2615v2","article-title":"Cyberinfrastructure for an integrated botanical information network to investigate the ecological impacts of global climate change on plant biodiversity","author":"Enquist","year":"2016","journal-title":"PeerJ Pre Prints"},{"key":"2025030713434970200_R19","doi-asserted-by":"publisher","first-page":"31","DOI":"10.1016\/j.biocon.2013.11.003","article-title":"The eBird enterprise: an integrated approach to development and application of citizen science","volume":"169","author":"Sullivan","year":"2014","journal-title":"Biol Conserv"},{"key":"2025030713434970200_R20","doi-asserted-by":"publisher","DOI":"10.3897\/BDJ.2.e1079","article-title":"The Encyclopedia of Life v2: providing global access to knowledge about life on earth","volume":"2","author":"Parr","year":"2014","journal-title":"Biodivers Data J"},{"key":"2025030713434970200_R21","author":"GBIF"},{"key":"2025030713434970200_R22","doi-asserted-by":"publisher","first-page":"16","DOI":"10.1111\/jbi.13623","article-title":"GIFT \u2013 A global inventory of floras and traits for macroecology and biogeography","volume":"47","author":"Weigelt","year":"2020","journal-title":"J Biogeograph"},{"key":"2025030713434970200_R23","article-title":"Integrated Digitized Biocollections","author":"iDigBio","year":"2023"},{"key":"2025030713434970200_R24","author":"iNaturalist"},{"key":"2025030713434970200_R25","doi-asserted-by":"publisher","first-page":"151","DOI":"10.1016\/j.tree.2011.09.007","article-title":"Integrating biodiversity distribution knowledge: toward a global map of life","volume":"27","author":"Jetz","year":"2012","journal-title":"Trends Ecol Evol"},{"key":"2025030713434970200_R26","doi-asserted-by":"publisher","first-page":"2905","DOI":"10.1111\/j.1365-2486.2011.02451.x","article-title":"TRY \u2013 a global database of plant traits","volume":"17","author":"Kattge","year":"2011","journal-title":"Glob Change Biol"},{"key":"2025030713434970200_R27","doi-asserted-by":"publisher","DOI":"10.1371\/journal.pbio.1000309","article-title":"VertNet: a new model for biodiversity data sharing","volume":"8","author":"Constable","year":"2010","journal-title":"PLoS Biol"},{"key":"2025030713434970200_R28","doi-asserted-by":"publisher","DOI":"10.1038\/s41597-020-00702-z","article-title":"LCVP, The Leipzig catalogue of vascular plants, a new taxonomic reference list for all known vascular plants","volume":"7","author":"Freiberg","year":"2020","journal-title":"Scientific Data"},{"key":"2025030713434970200_R29","doi-asserted-by":"publisher","DOI":"10.1038\/s41597-021-00997-6","article-title":"The world checklist of vascular plants, a continuously updated resource for exploring global plant diversity","volume":"8","author":"Govaerts","year":"2021","journal-title":"Scientific Data"},{"key":"2025030713434970200_R30","doi-asserted-by":"publisher","first-page":"1311","DOI":"10.1002\/tax.12373","article-title":"World Flora Online: placing taxonomists at the heart of a definitive and comprehensive global resource on the world\u2019s plants","volume":"69","author":"Borsch","year":"2020","journal-title":"Taxon"},{"key":"2025030713434970200_R31","article-title":"World Plants: Plant List. World Plants 16.2. Synonymic Checklist and Distribution of the World Flora","author":"Hassler","year":"2023"},{"key":"2025030713434970200_R32","article-title":"Introduction","author":"BG-BASE"},{"key":"2025030713434970200_R33","article-title":"Software for Natural History Management","author":"BRAHMS"},{"key":"2025030713434970200_R34","article-title":"Collection Management System","author":"EMu"},{"key":"2025030713434970200_R35","article-title":"Software for Biological Collections and Samples","author":"Specify Collections Consortium"},{"key":"2025030713434970200_R36","doi-asserted-by":"publisher","first-page":"117","DOI":"10.3897\/zookeys.420.7089","article-title":"Avibase \u2013 a database system for managing and organizing taxonomic concepts","volume":"420","author":"Lepage","year":"2014","journal-title":"ZooKeys"},{"key":"2025030713434970200_R37","doi-asserted-by":"publisher","DOI":"10.3897\/BDJ.8.e53014","article-title":"Biologer: an open platform for collecting biodiversity data","volume":"8","author":"Popovi\u0107","year":"2020","journal-title":"Biodivers Data J"},{"key":"2025030713434970200_R38","article-title":"Dyntaxa taxon concept administration and how to handle information related to taxa - ETC\/BD Technical paper N\u00b08\/2015","volume-title":"Eionet Portal","author":"Kindwall","year":"2015"},{"key":"2025030713434970200_R39","doi-asserted-by":"publisher","DOI":"10.1038\/s41597-021-00919-6","article-title":"The Finnish biodiversity information facility as a best-practice model for biodiversity data infrastructures","volume":"8","author":"Schulman","year":"2021","journal-title":"Scientific Data"},{"key":"2025030713434970200_R40","doi-asserted-by":"publisher","DOI":"10.3897\/BDJ.10.e80167","article-title":"Pladias platform: technical description of the database structure","volume":"10","author":"Novotn\u00fd","year":"2022","journal-title":"Biodivers Data J"},{"key":"2025030713434970200_R41","doi-asserted-by":"crossref","DOI":"10.3897\/biss.2.25560","article-title":"TaxonWorks","volume-title":"Biodiversity Information Science and Standards","author":"Dmitriev","year":"2018"},{"key":"2025030713434970200_R42","doi-asserted-by":"publisher","first-page":"99","DOI":"10.1007\/s13752-017-0259-5","article-title":"Taxonomy for humans or computers? Cognitive pragmatics for big data","volume":"12","author":"Sterner","year":"2017","journal-title":"Biol Theory"},{"key":"2025030713434970200_R43","doi-asserted-by":"publisher","DOI":"10.1371\/journal.pbio.2006125","article-title":"The next generation of natural history collections","volume":"16","author":"Schindel","year":"2018","journal-title":"PLoS Biol"},{"key":"2025030713434970200_R44","doi-asserted-by":"publisher","DOI":"10.1186\/2041-1480-5-40","article-title":"Making species checklists understandable to machines \u2013 a shift from relational databases to ontologies","volume":"5","author":"Laurenne","year":"2014","journal-title":"J Biomed Semant"},{"key":"2025030713434970200_R45","article-title":"Database model for taxonomic and observation data","author":"Lindstr\u00f6m","year":"2006"},{"key":"2025030713434970200_R46","first-page":"63","article-title":"Querying ontologies in relational database systems","author":"Tri\u00dfl","year":"2005"}],"container-title":["Database"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/academic.oup.com\/database\/article-pdf\/doi\/10.1093\/database\/baae107\/60003083\/baae107.pdf","content-type":"application\/pdf","content-version":"vor","intended-application":"syndication"},{"URL":"https:\/\/academic.oup.com\/database\/article-pdf\/doi\/10.1093\/database\/baae107\/60003083\/baae107.pdf","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2025,3,7]],"date-time":"2025-03-07T13:44:06Z","timestamp":1741355046000},"score":1,"resource":{"primary":{"URL":"https:\/\/academic.oup.com\/database\/article\/doi\/10.1093\/database\/baae107\/7817843"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2024]]},"references-count":46,"URL":"https:\/\/doi.org\/10.1093\/database\/baae107","relation":{},"ISSN":["1758-0463"],"issn-type":[{"value":"1758-0463","type":"electronic"}],"subject":[],"published-other":{"date-parts":[[2024]]},"published":{"date-parts":[[2024]]},"article-number":"baae107"}}