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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2003-03-15 21:31:22 | Re: Row vs. tuple |
Previous Message | Tom Lane | 2003-03-15 01:06:33 | Re: Row vs. tuple |