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

Authors

  • Radoslava Stankova Kraleva Department of Informatics, Faculty of Mathematics and Natural Sciences, South-West University "Neofit Rilski", Blagoevgrad, Bulgaria https://orcid.org/0000-0003-3322-7298
  • Velin Spasov Kralev Department of Informatics, Faculty of Mathematics and Natural Sciences, South-West University "Neofit Rilski", Blagoevgrad, Bulgaria https://orcid.org/0000-0002-7780-8281
  • Nina Sinyagina Department of Informatics, Faculty of Mathematics and Natural Sciences, South-West University "Neofit Rilski", Blagoevgrad, Bulgaria
  • Petia Koprinkova-Hristova Institute of Information and Communication Technologies, Bulgarian Academy of Sciences, Sofia, Bulgaria https://orcid.org/0000-0002-0447-9667
  • Nadejda Bocheva Institute of Neurobiology, Bulgarian Academy of Sciences, Sofia, Bulgaria https://orcid.org/0000-0001-7792-7742

DOI:

https://doi.org/10.3991/ijoe.v14i02.7988

Keywords:

experimental data, database, relational database, relational database schema design, normal forms, integrity, database rules,

Abstract


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.

Author Biographies

Radoslava Stankova Kraleva, Department of Informatics, Faculty of Mathematics and Natural Sciences, South-West University "Neofit Rilski", Blagoevgrad, Bulgaria

Radoslava Kraleva defended her PhD Thesis “Acoustic-Phonetic Modeling for Children's Speech Recognition in Bulgarian” in 2014. Most of her publications are focused into the study of children and their interaction with computer technologies, including recognition of children's speech in Bulgarian. Currently, she is working on her post-doctoral research related to the design and development of interactive mobile applications for children and the study of human-computer interface for young children. Now she is a chief assistant professor at the Departement of Informatics, South-West University in Bulgaria. She has developed several academic courses and curricula.

Velin Spasov Kralev, Department of Informatics, Faculty of Mathematics and Natural Sciences, South-West University "Neofit Rilski", Blagoevgrad, Bulgaria

Velin Kralev received PhD degree in Informatics from South-West University, Blagoevgrad, Bulgaria in 2010. Since 2004 he has been a chief assistant professor at the South-West University, Blagoevgrad, Bulgaria. His research interests include modeling, synthesis and analysis of various algorithms, development of client-server and multi-tier computing information systems, through the use of component-oriented software technology, database design, and object-oriented programming.

Nina Sinyagina, Department of Informatics, Faculty of Mathematics and Natural Sciences, South-West University "Neofit Rilski", Blagoevgrad, Bulgaria

Nina Sinyagina has received her PhD degree in Sankt-Peterburg Technical University in 1972. She has been researcher and Head of Department at the Central Institute for Computing Systems and Technology, Sofia in period 1973-1988, and Head of Department at the Institute for Instrumentation and Computer Technology, Sofia. From 1998 she was Director of research group in the Institute for parallel processing of information, Bulgarian Academy of Sciences. From 2004 and now she is professor in the South-West University, Blagoevgrad. Her main research areas are: Pattern recognition, Artificial Intelligence, Computer architectures, Database, Computer Security, Operational Systems, and Computer Networks. She was tutor and supervisor of 35 PhD students and over 70 MSc students. She has more, than 70 publications in Bulgaria and more than 20 publications in foreign scientific journals and International conferences proceedings.  She is author and co-author of 15 scientific books and manuals.

Petia Koprinkova-Hristova, Institute of Information and Communication Technologies, Bulgarian Academy of Sciences, Sofia, Bulgaria

Petia Koprinkova-Hristova received MSc degree in Biotechnics from the Technical University - Sofia in 1989 and PhD degree on Process Automation from Bulgarian Academy of Sciences in 2001. Since 2003 she is Associate Professor in the Institute of Control and System Research and from January 2012 - in the Institute of Information and Communication Technologies, Bulgarian Academy of Sciences. Her main research interests are in the field of Intelligent Systems using mainly neural networks, fuzzy and neuro-fuzzy approaches. Currently she is a member of European Neural Network Society (ENNS) executive committee and member of the Union of Automatics and Informatics in Bulgaria.

Nadejda Bocheva, Institute of Neurobiology, Bulgarian Academy of Sciences, Sofia, Bulgaria

Nadejda Bocheva is Associate Professor at Institute of Neurobiology (former Institute of Physiology), Bulgarian Academy of Sciences. She received a Ph.Degree in biology in 1986 from Institute of Physiology, Bulgarian Academy of Sciences. In 2006 she became Associate Professor in psychophysiology. At present she is head of Department of Sensory Neurobiology at the Institute of Neurobiology. Her research interests are in human visual information processing, spatial vision, motion perception, visual recovery of 3D shape, cognitive neuroscience and aging. She is a Fulbright fellow and has a Fogarthy international collaborative Award in 2002.She is member of American Psychological Association and of the Sofia section of the Bulgarian Physiological Society.

Downloads

Published

2018-02-28

How to Cite

Kraleva, R. S., Kralev, V. S., Sinyagina, N., Koprinkova-Hristova, P., & Bocheva, N. (2018). Design and Analysis of a Relational Database for Behavioral Experiments Data Processing. International Journal of Online and Biomedical Engineering (iJOE), 14(02), pp. 117–132. https://doi.org/10.3991/ijoe.v14i02.7988

Issue

Vol. 14 No. 02 (2018)

Section

Papers