A large-scale stream benthic diatom database

A relational database linking benthic diatom records, taxonomic nomenclature including synonyms, and corresponding environmental data has been built in MS Access. It allowed flexible and long-term use of a relatively important amount of data (∼3000 records) gathered in the framework of the EC-funded PAEQANN project, gathering precise and documented information both about benthic diatoms and quantitative or semi-quantitative environmental data. Such a database has been shown to be a useful tool for the definition of benthic diatom typology at a multi-regional scale, the prediction of the impact of environmental characteristics on the structure of diatom communities, and additionally for a new insight on the auto-ecology of some taxa. This database could serve as a template for further work on diatoms and, after some implementation, on other freshwater communities. It could also be the basis for wider typology of stream diatoms, extended to other regions.