A relational database for trial-based behavioral experiments

We describe a relational database (RDB) structure suitable for trial-based experiments such as human psychophysics and neural recording studies in trained animals. An RDB is a collection of tables, each composed of columns. Some of the tables contain columns that reference specific columns of other tables. This referencing system links the tables to each other and makes it possible to extract any subset of the data with trivial commands. An equally important advantage of an RDB is that it imposes a consistent data format on applications that generate and analyze data. The result is a centralization and standardization of data storage that facilitates the pooling, cross-checking and re-analysis of data from various experiments. We present a robust RDB structure originally designed for neurophysiological data; however, it is abstract enough to accommodate data from a variety of trial-based experimental designs. Moreover, we demonstrated the advantages of this RDB structure and indicated its implementation in other laboratories.