GMOD

Databases: Tables, Rows, and Columns

Introduces some basic relational database terminology.

Tables

A database table is just that, a table with rows and columns. Different tables contain information about different types of things.

Rows

Each row in a database table represents one instance of the type of object described in that table. A row is also called a record.

Columns

The columns in a table are the set of facts that we keep track of about that type of object. A column is also called an attribute.

Example

The Instructors table.

Instructors Table

Columns / Attributes
Rows /

Records
Participant Affiliation Email
Scott Cain Ontario Institute for Cancer Research scott@scottcain.net
Tim Carver Sanger Institute tjc@sanger.ac.uk
Dave Clements NESCent clements@nescent.org
Stephen Ficklin Clemson University ficklin@clemson.edu
Syed Haider EBI syed@ebi.ac.uk
Ian Holmes UC Berkeley ihh@berkeley.edu
Carson Holt University of Utah carson.holt@utah.ed
Robin Houston Sanger Institute rh11@sanger.ac.uk
Ed Lee Lawrence Berkeley National Lab elee@berkeleybop.org
Sheldon McKay Cold Spring Harbor Laboratory mckays@cshl.edu
Joshua Orvis Institute for Genome Sciences jorvis@som.umaryland.edu
Mitch Skinner UC Berkeley mitch_skinner@berkeley.edu
Giles Velarde Wellcome Trust Sanger Institute gv1@sanger.ac.uk
Junjun Zhang Ontario Institute for Cancer Research Junjun.Zhang@oicr.on.ca

Documentation

Community

Tools