Relational and non-relational database efficiency comparision with DNA microarray data storing

Damian Zapart, Tomasz Waller, Magdalena Tkacz

Abstract


The paper compares the efficiency of two versions of database management systems from the possibility of using them in storing data from DNA microarray point of view. In comparative analysis 3 methods of storing data were taken into account: basing on non-relational model (noSQL) and the method of storing microarray data according to the relational model called entity-attribute-value. Microsoft SQL Server 2012 system was used to implementation of relational database. Implementation of non-relational database was performed in Raven DB. Evaluation of efficiency of each of the method of storing data was based on CPU sampling using Micrisoft Visual Studio Profiler.

Keywords


relational database; non-relational database; entity-attribute-value model; Microsoft SQL Server; Raven DB; NoSQL; DNA microarrays

Full Text:

PDF (Polski)

References


Gramacki A., Gramacki J.: Modelowanie typu Entity-Attribute-Value w bazach danych. PAK, Vol. 53, nr 5/2007.

Hong-Hai D., Toralf K., Erhard R.: Comparative Evaluation of Microarray-based Gene Expression Databases. Conference paper. BTW 2003, Datenbanksysteme für Business, Technologie und Web, Tagungsband der 10. BTW-Konferenz, Leipzig 2003.

Tsoi L. C., Zheng W. J.: A Method of Microarray Data Storage Using Array Data Type. Comput. Biol. Chem., 2007.

Masys D.: Database designs for microarray data. Pharmacogenomics J., Vol. 1(4), 2001,s.232-233.

Jarząb B., Gubała E., Lange D.: Mikromacierze DNA i profil ekspresji genów raka brodawkowatego tarczycy. IV Konferencja Sekcji Endokrynologii Molekularnej PTE, Poznań 2004.

Chang F., Dean J., Ghemawat S., Hsieh W. C., Wallach D. A., Burrows M., ChandraT., Fikes A., Gruber R. E.: Bigtable: A Distributed Storage System for Structured Data. Google, Inc., 2006.

Lakshman A., Malik P.: Cassandra - A Decentralized Structured Storage System. Facebook 2009.

Peng D., Dabek F.: Large-scale Incremental Processing Using Distributed Transactions and Notifications. Google, Inc.

Scholz J.: Coping with Dynamic, Unstructured Data Sets - NoSQL a Buzzword or a Savior? TU Vienn.

Neubauer P.: Graph Databases, NoSQL and Neo4j. 2010.

Crockford D.: The application/json Media Type for JavaScript Object Notation (JSON). 2006.




DOI: http://dx.doi.org/10.21936/si2012_v33.n2A.166