Hierarchical database structure

This sort of organisation is well known in environmental science because it is the way flora and fauna taxonomies and soil classifications are organised. Each part of the hierarchy can be reached using a 'key' - a set of discriminating criteria that describes the data structure. Hierarchical structures allow quick and easy access to data where a one to many relationship exists.