title: A method of microarray data storage using array data type.
abstract: A well-designed microarray database can provide valuable information on gene expression levels. However, designing an efficient microarray database with minimum space usage is not an easy task since designers need to integrate the microarray data with the information of genes, probe annotation, and the descriptions of each microarray experiment. Developing better methods to store microarray data can greatly improve the efficiency and usefulness of such data. A new schema is proposed to store microarray data by using array data type in an object-relational database management system--PostgreSQL. The implemented database can store all the microarray data from the same chip in an array data structure. The variable-length array data type in PostgreSQL can store microarray data from same chip. The implementation of our schema can help to increase the data retrieval and space efficiency.
authors: Bioinformatics Graduate Program, College of Graduate Study, Medical University of South Carolina, Charleston, SC 29425, USA. tsoi@musc.edu
authors: Lam C
authors: LC
authors: Tsoi
authors: W Jim
authors: WJ
authors: Zheng
mesh_terms: D003628:Database Management Systems; D030541:Databases, Genetic; D016247:Information Storage and Retrieval / Q000379:methods; D020411:Oligonucleotide Array Sequence Analysis / Q000379:methods*; D012985:Software Design