Molecular Biophysics & Biochemistry 447b3 / 747b3Bioinformatics

Table of Contents

Molecular Biophysics & Biochemistry 447b3 / 747b3Bioinformatics

Relational Databases

UnstructuredData

Semi-Structured Data

Structured Data

Survey 1

Survey 2

Turn the Survey into a Table (I)

Turn the Survey into a Table (II)

Turn the Survey into a Table (III)

Statistics are only Possible on Standarized Values

SQL

matches table

matches table 2

structures table

folds table

Structure of a Table

What is a Key?

SQL Select on a Single Table

SQL Select on a Single Table, Example

SQL Select on a Single Table, Example 2

Joins

SQL Select on Multiple Tables

Foreign Key

Selection as Array Lookup

SQL Select on Multiple Tables

ER-diagrams

Aggregate Functions--Statistics on Attributes

RDB’s can encode complex data:Encoding Trees in RDBs

Further topics

Forms & reports [user views]

Normalization

Email: Mark.Gerstein@Yale.edu

Home Page: http://bioinfo.mbb.yale.edu/course

Other information:
All overheads are copyright 1998, Mark Gerstein, All Rights Reserved