文档介绍：Databases for Microarrays
Vidhya Jagannathan
SIB, Lausanne
Overview
Microarray data in a nutshell
Why databases?
What data to represent?
What is a database?
Different data models
E-R modelling
Microarray Databases
Standards being developed
Vidhya Jagannathan, SIB, Lausanne
Microarray Experiment
Vidhya Jagannathan, SIB, Lausanne
Microarray Data in a Nutshell
Lots of data to be managed before and after the experiment.
Data to be stored before the experiment .
Description of the array and the sample.
Direct access to all the cDNA and gene sequences, annotations, and physical DNA resources.
Data to be stored after the experiment
Raw Data - scanned images.
Gene Expression Matrix - Relative expression levels observed on various sites on the array.
Hence we can see that database software capable of dealing with larger volumes of numeric and image data is required.
Vidhya Jagannathan, SIB, Lausanne
Why Databases?
Tailored to datatype
Tailored to the Scientists
Intuitive ways to query the data
Diagrams, forms, point and click, text etc.
Support for efficient answering of queries.
Query optimisation, indexes, compact physical storage.
Vidhya Jagannathan, SIB, Lausanne
Data Representation
Goal: Represent data in an intuitive and convenient manner
Without unnecessary replication of information
Making it easy to write queries to find required information
Supporting efficient retrieval of required information
Vidhya Jagannathan, SIB, Lausanne
What is a Database?
A database is anised collection of pieces of structured electronic information.
Example 1: Libraires use a database system to keep track of library inventory and loans.
Example 2: All airlines use database system to manage their flights and reservations.
The collection of records kept for mon purpose such as these is known as a database.
The records of the database normally reside on a hard disk and the records are retrieved puter memory only when they are accessed.
So the reasons are obvious why we need