Analysis of entity-attribute-value model applications in freely available database management systems for dna microarray data processing

• Autorzy: Waller T. , Zapart D. , Tkacz M. , Wróbel Z.
• Języki publikacji: EN

Abstrakty

EN

Large volumes of data are generated during DNA microarrays experiments. Database management systems (DBMS) are increasingly applied to these data, providing optimum processing and management from multiple microarray experiments. In this study, freely accessible DBMS software versions were compared (Microsoft SQL Server 2008 Express Edition, Oracle Database 10g Express Edition, DB2 Express-C 9.7.2, MySQL 5.1, and PostgreSQL 9.0). We examined them in the context of possible Entity-Attribute-Value (EAV) application as an optimal organization method for microarray data. It was confirmed in the comparative analysis of component data processing methods, consistent with the EAV model, that efficient methods for microarray data analysis are available in Microsoft SQL Server 2008 Express Edition and PostgreSQL 9.0 systems. Also, DNA microarray data processing was confirmed to be more efficient with Microsoft SQL Server 2008 Express Edition as compared with PostgreSQL 9.0. The EAV method was also shown to be suitable for use with open-source versions of DBMS software as an optimum storage model for DNA microarray data. In terms of data processing methods and performance, the Microsoft SQL Server 2008 Express Edition proved to be the best among compared database systems.

Słowa kluczowe

EN

entity-attribute-value model; relational database management system; DNA microarray

PL

system zarządzania relacyjną bazą danych; mikromacierz DNA

• Wydawca: University of Silesia, Institute of Informatics, Computer Systems Department
• Czasopismo: Journal of Medical Informatics & Technologies
• Rocznik: 2012
• Tom: Vol. 20
• Strony: 59--63
• Opis fizyczny: Bibliogr. 17 poz., rys., tab.

Twórcy

autor

Waller T.

• Institute of Computer Science, Division of Biomedical Computer Systems, University of Silesia, Katowice, PL

autor

Zapart D.

autor

Tkacz M.

autor

Wróbel Z.

Bibliografia

• [1] TSOI L.C. ZHENG W.J.: A Method of Microarray Data Storage Using Array Data Type, 2007, Comput Biol Chem, Vol. 31, No. 2, pp. 143-147.
• [2] MASYS D.: Database designs for microarray data, 2001, The Pharmacogenomics Journal, Vol. 1, pp. 232–233
• [3] SPLENDIANI A., BRANDIZI M., EVEN G., OTTAVIO B., Pavelka N., PELIZZOLA M., MAYHAUS M., FOTI M., MAURI G., RICCIARDI-CASTAGNOLI P.: The Genopolis Microarray Database. BMC Bioinformatics 2007, 8(Suppl 1):S21.
• [4] KILLION P., SHERLOCK G., IYER V.: The Longhorn Array Database (LAD): An Freely-accessible, MIAME compliant implementation of the Stanford Microarray Database (SMD), 2003, BMC Bioinformatics, pp. 4-32.
• [5] SHAH S. P., HUANG Y., XU T., YUEN M., LING J., OUELLETTE F.: Atlas – a data warehouse for integrative bioinformatics, 2005, BMC Bioinformatics, pp. 6-34.
• [6] GRAMACKI A., GRAMACKI J.: Modelowanie typu Entity-Attribute-Value w bazach danych, 2007, Pomiary Automatyka Kontrola, No. 5, pp. 54-56.
• [7] HONG-HAI D., TORALF K., ERHARD R.: Comparative Evaluation of Microarray-based Gene Expression Databases, BTW 2003, In Proc. 10. Fachtagung Datenbanksysteme für Business, Technologie und Web, Leipzig.
• [8] LENOIR T., GIANNELLA E.: The emergence and diffusion of DNA microarray technology, 2006, Journal of Biomedical Discovery and Collaboration, 1:1.
• [9] PostgreSQL 9.0.5 Documentation - http://www.postgresql.org/
• [10] Microsoft SQL Server 2008 Books Online (October 2009) - http://technet.microsoft.com/
• [11] MySQL 5.1 Reference Manual - http://dev.mysql.com/doc/
• [12] Oracle Database 10g Documentation Library - http://docs.oracle.com/
• [13] DB2 database product documentation - https://www-304.ibm.com/support/
• [14] RUSSELL S., MEADOWS L., RUSSELL R.: Microarray Technology in Practice, 2009, Elsevier Inc.
• [15] THALLINGER G.G. et al., TAMEE: data management and analysis for tissue microarrays, 2007, BMC Bioinformatics, pp. 8-81.
• [16] JOHNSON S.B.: Generic data modeling for clinical repositories, 1996, J Am Med Inform Assoc, No. 3, pp. 328-339.
• [17] NADKARNI P.M. et al.: Organization of heterogeneous scientific data using the EAV/CR representation, 1999, J Am Med Inform Assoc, Vol. 6, pp. 478-493.