Related Experiment Video
Updated: Jun 10, 2025

Heuristic Mining of Hierarchical Genotypes and Accessory Genome Loci in Bacterial Populations
Published on: December 7, 2021
The relational modeling of hierarchical data in biodiversity databases
1Department of Biology Education & Herbarium collections (PRC), Faculty of Science, Charles University, Viničná 7, Praha 128 00, Czech Republic.
Most biodiversity databases lack formal taxon hierarchy structures, hindering data usability. The Closure Table model is ideal but rarely implemented, despite its suitability for relational databases and ontologies.
Area of Science:
- Biodiversity Informatics
- Database Management
- Taxonomy
Background:
- Taxon hierarchy modeling is crucial for unifying biodiversity data.
- Existing biodiversity databases vary in their handling and presentation of hierarchical data.
- Formalized data structures are essential for robust data analysis and integration.
Purpose of the Study:
- To compare 25 biodiversity databases based on their taxon hierarchy modeling capabilities.
- To identify prevalent data structures used for representing taxonomic relationships.
- To assess the availability and suitability of hierarchical data structures for researchers.
Main Methods:
- Analysis of database documentation and demo installations.
- Examination of data structures using R packages.
- Review of public interfaces for databases lacking other documentation.
Main Results:
- Twelve out of 25 databases (nearly half) lacked formalized taxon hierarchy data structures.
- The Adjacency List model, storing only parent IDs, is the most common but least effective method.
- The Closure Table model, suitable for relational databases and ontologies, is sporadically used.
Conclusions:
- Current biodiversity databases pay insufficient attention to modeling and providing taxon hierarchy data structures.
- The lack of formalized hierarchy hinders data usability and integration for researchers.
- Adoption of the Closure Table model is recommended for improved biodiversity data management.
Related Concept Videos
Evolutionary Relationships through Genome Comparisons
Phylogeny
Phylogenetic Trees
The Tree of Life - Bacteria, Archaea, Eukaryotes
Taxonomy
Hierarchy of Taxonomy
The hierarchy that Carolus Linnaeus first...
Applications of Molecular Taxonomy

