Jove
Visualize
Contact Us
JoVE
x logofacebook logolinkedin logoyoutube logo
ABOUT JoVE
OverviewLeadershipBlogJoVE Help Center
AUTHORS
Publishing ProcessEditorial BoardScope & PoliciesPeer ReviewFAQSubmit
LIBRARIANS
TestimonialsSubscriptionsAccessResourcesLibrary Advisory BoardFAQ
RESEARCH
JoVE JournalMethods CollectionsJoVE Encyclopedia of ExperimentsArchive
EDUCATION
JoVE CoreJoVE BusinessJoVE Science EducationJoVE Lab ManualFaculty Resource CenterFaculty Site
Terms & Conditions of Use
Privacy Policy
Policies

Related Experiment Videos

A method of microarray data storage using array data type.

Lam C Tsoi1, W Jim Zheng

  • 1Bioinformatics Graduate Program, College of Graduate Study, Medical University of South Carolina, Charleston, SC 29425, USA. tsoi@musc.edu

Computational Biology and Chemistry
|March 30, 2007
PubMed
Summary
This summary is machine-generated.

Related Concept Videos

You might also read

Related Articles

Articles linked to this work by shared authors, journal, and citation graph.

Sort by
Same author

Activation of MyD88/IRAK1 axis and downstream proinflammatory signaling in healthy adult and neonatal African American skin.

JID innovations : skin science from molecules to population health·2026
Same author

Multiomic Analysis Reveals an IFN-driven Cellular Landscape Effectively Targeted by Ruxolitinib in Hailey-Hailey Disease.

bioRxiv : the preprint server for biology·2026
Same author

Disease-specific differences in particulate matter handling drive pathogenic responses in human derived nasal epithelial cells.

bioRxiv : the preprint server for biology·2026
Same author

A specialized population of hair afferents dedicated to transmitting mechanical itch.

Neuron·2026
Same author

A longitudinal atlas of human psoriatic skin reveals the mechanisms of anti-IL-23 therapy in disrupting the type 17 inflammatory circuit.

Immunity·2026
Same author

mFABIO: An integrative multi-tissue TWAS fine-mapping approach to prioritize potentially causal genes and tissues underlying binary traits.

PLoS genetics·2026
Same journal

An interpretable framework for cancer drug response prediction using integrated drug and multi-omics data with a hybrid Bi-LSTM-GRU network.

Computational biology and chemistry·2026
Same journal

SegMWB: A lightweight deep learning framework for microscopic image classification.

Computational biology and chemistry·2026
Same journal

Protein dynamic simulations: From early inception to clinical translation over half a century.

Computational biology and chemistry·2026
Same journal

Integrated omics and virtual screening predict Tabularin as a dual inhibitor of the prognostic microRNAs mir-19a and mir-32 in colorectal cancer.

Computational biology and chemistry·2026
Same journal

In silico characterization of acetyl-CoA carboxylase from Staphylococcus aureus and Escherichia coli: A comparative analysis.

Computational biology and chemistry·2026
Same journal

An optimized cascaded transformer with progressive attention for lung and colon cancer diagnosis from histopathological images.

Computational biology and chemistry·2026
See all related articles

Designing efficient microarray databases is crucial for gene expression analysis. A new PostgreSQL schema using array data types improves storage and retrieval efficiency for microarray data.

Area of Science:

  • Bioinformatics
  • Database Management
  • Genomics

Background:

  • Microarray databases are essential for gene expression analysis but face challenges in efficient data storage and integration.
  • Current methods often struggle with space optimization and integrating diverse data types like gene information, probe annotations, and experimental details.

Purpose of the Study:

  • To propose and implement a novel database schema for storing microarray data.
  • To enhance the efficiency and reduce the space usage of microarray data storage.

Main Methods:

  • Utilized an object-relational database management system (PostgreSQL).
  • Implemented a new schema leveraging PostgreSQL's variable-length array data type.
  • Stored all microarray data from a single chip within an array data structure.

Related Experiment Videos

Main Results:

  • Successfully stored microarray data from the same chip in an array structure.
  • Demonstrated increased data retrieval efficiency.
  • Achieved significant improvements in space efficiency for storing microarray datasets.

Conclusions:

  • The proposed schema effectively addresses the challenges of storing large-scale microarray data.
  • Employing array data types in PostgreSQL offers a robust solution for enhancing microarray database performance.
  • This approach improves the overall utility and accessibility of gene expression data.