Database notes: A method of microarray data storage using array data type

  • Authors:
  • Lam C. Tsoi;W. Jim Zheng

  • Affiliations:
  • Bioinformatics Graduate Program, College of Graduate Study, Medical University of South Carolina, 135 Cannon Street, Suite 303, Charleston, SC 29425, United States;Department of Biostatistics, Bioinformatics and Epidemiology, and Bioinformatics Core Facility, Hollings Cancer Center, Medical University of South Carolina, 135 Cannon Street, Suite 303, Charlest ...

  • Venue:
  • Computational Biology and Chemistry
  • Year:
  • 2007

Quantified Score

Hi-index 0.00

Visualization

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.