a relational database for trial-based behavioral experiments：一种基于关系数据库的实验性行为实验.pdfVIP

Journal of Neuroscience Methods 141 (2005) 75–82 A relational database for trial-based behavioral experiments David C. Bradley a,∗, Massimo Mascarob , Satish Santhakumar a a Department of Psychology, The University of Chicago, 5048 South University Avenue, Green 314, Chicago, IL 60637, USA b Department of Statistics, The University of Chicago, 5734 South University Avenue, Green 314, Chicago, IL 60637, USA Received 19 December 2003; received in revised form 22 May 2004; accepted 27 May 2004 Abstract 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. © 2004 Elsevier B.V. All rights reserved. Keywords: Trial-based; Relational database; SQL 1. Introduction for extensive searching. The primitive database functions of spreadsh