APPLICATION OF THE RELATIONAL DATABASE APPROACH TO A NESTED STUDY OF BIOLOGICAL AND PHYSICAL DATA FROM A LOWLAND RIVER

In recent years there has been a tendency to consider a wide range of factors when addressing questions of stream ecology. This is particula rly true in the study of managed streams where anthropogenic activitie s are superimposed over natural environmental change. The increasing c omplexity and number of data items and their links require more sophis ticated methods of collation. Relational database design is examined a nd the translation of the logical data model into a table design and e stablishment of the database structure is described. Implementation in to a particular Relational Database Management System (RDBMS), in this case Microsoft Access, enables specific questions to be addressed to the database. This paper examines the use of databases in facilitating collation and analysis of relatively complex studies. This is illustr ated with reference to a multiscale study on the River Frome in Dorset and presents examples of the results of specific questions ranging fr om simple generation of lists to the linking of faunal groups to locat ion down the river system and substratum type. The benefits of databas e management to ecologists are discussed. (C) 1997 by John Wiley & Son s, Ltd.