Skip site navigation (1) Skip section navigation (2)

Re: Row vs. tuple

From: Sean Chittenden <sean(at)chittenden(dot)org>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Peter Eisentraut <peter_e(at)gmx(dot)net>, pgsql-docs(at)postgresql(dot)org
Subject: Re: Row vs. tuple
Date: 2003-03-15 21:03:21
Message-ID: 20030315210321.GO79234@perrin.int.nxad.com (view raw or flat)
Thread:
Lists: pgsql-docs
> > In some places the documentation uses the term "tuple" to mean
> > "row version" (in the MVCC sense).  This choice of terms is
> > puzzling me; where does it come from?  In the literature available
> > to me, the term "tuple" is used as the mathematical equivalent of
> > "row", meaning that table/row/column parallels
> > relation/tuple/attribute.
> 
> Well, "row version" isn't a particularly standard term either.  I'd
> prefer a one-word term.  I think that the use of "tuple" for this can be
> traced back to the Berkeley code.

How about:  s/(row|tuple)/record/

A "record" is a much less theoretical/mathematical term that I've had
good success in using when describing basic table theory to lay
people.  Seems easier to grasp on the uptake than a row (rows are
confused with columns if you're not familiar with databases, math, or
matrices.  "Do rows go vertically or horizontally?") or tuple
(heavily mathematical term or term used in DB theory, but no where
else).  A record, on the other hand, is something that everyone has a
conceptual picture of.  -sc

-- 
Sean Chittenden

In response to

Responses

pgsql-docs by date

Next:From: Tom LaneDate: 2003-03-15 21:31:22
Subject: Re: Row vs. tuple
Previous:From: Tom LaneDate: 2003-03-15 01:06:33
Subject: Re: Row vs. tuple

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group