Design and Analysis of a Relational Database for Behavioral Experiments Data Processing

International journal of online engineering

Nina Sinyagina¹  Radoslava Stankova Kraleva²  Petia Koprinkova-Hristova³  Nadejda Bocheva⁴  Velin Spasov Kralev⁵ 

[1] , Blagoevgrad, Bulgaria;Department of Informatics,Faculty of Mathematics and Natural Sciences,South-West University "Institute of Information and Communication Technologies,Bulgarian Academy of Sciences, Sofia, Bulgaria;Institute of Neurobiology,Bulgarian Academy of Sciences,Sofia, Bulgaria;Neofit Rilski"

关键词: experimental data;    database;    relational database;    relational database schema design;    normal forms;    integrity;    database rules;   

DOI  :  

学科分类：社会科学、人文和艺术（综合）

来源: International Association of Online Engineering

【 摘 要 】

In this paper, the results of a comparative analysis between different approaches to experimental data storage and processing are presented. Several studies related to the problem and some methods for solving it have been discussed. Different types of databases, ways of using them and the areas of their application are analyzed. For the purposes of the study, a relational database for storing and analyzing a specific data from behavioral experiments was designed. The methodology and conditions for conducting the experiments are described. Three different indicators were analyzed, respectively: memory required to store the data, time to load the data from an external file into computer memory and iteration time across all records through one cycle. The obtained results show that for storing a large number of records (in the order of tens of millions of rows), either dynamic arrays (stored on external media in binary file format), or an approach based on a local or remote database management system can be used. Regarding the data loading time, the fastest approach was the one that uses dynamic arrays. It outperforms significantly the approaches based on a local or remote database. The obtained results show that the dynamic arrays and the local data sets approaches iterated much faster across all data records than the remote database approach. The paper concludes with proposal for further developments towards using of web services.

【 授权许可】

Unknown