User Ratings

Your rating: None (1 vote)
Your rating: None (1 vote)
Your rating: None (1 vote)
Add your comments

Creating Databases for Biological Information: An Introduction

Lincoln Stein1

1Cold Spring Harbor Laboratory, Cold Spring Harbor, New York

Unit Number: 
Unit 9.1
DOI: 
10.1002/0471250953.bi0901s00
Online Posting Date: 
January, 2003
GO TO THE FULL TEXT:
PDF or HTML at Wiley Online Library
Are you the author of this protocol? Login or register and return to this page.

Abstract

The essence of bioinformatics is dealing with large quantities of information. Whether it be sequencing data, microarray data files, mass spectrometric data (e.g., fingerprints), the catalog of strains arising from an insertional mutagenesis project, or even large numbers of PDF files, there inevitably comes a time when the information can simply no longer be managed with files and directories. This is where databases come into play. This unit briefly reviews the characteristics of several database management systems, including flat file, indexed file, and relational databases, as well as ACeDB. It compares their strengths and weaknesses and offers some general guidelines for selecting an appropriate database management system.

     
 
GO TO THE FULL PROTOCOL:
PDF or HTML at Wiley Online Library

Table of Contents

  • Unit Introduction
  • DBMS Characteristics
  • The ACeDB Data Management System
  • Choosing a DBMS
  • Figures
     
 
GO TO THE FULL PROTOCOL:
PDF or HTML at Wiley Online Library

Figures

  • Figure 9.1.1
    A relational schema for protein sequences separates information in distinct tables to minimize redundancy.

  • Figure 9.1.2
    A flat-file representation of the same data will cause two proteins that share the same function of taxon to duplicate the information in “common_name,” “genus,” “species,” “go-accession,” and “description.”

  • Figure 9.1.3
    The protein database as an ACeDB schema.

Looking for Answers?
Do you have tips, tricks, or improvements to share?

Join the Conversation

Post new comment

The content of this field is kept private and will not be shown publicly.
CAPTCHA
This question is for testing whether you are a human visitor and to prevent automated spam submissions.