cdt glossary - TABLE (was: Base Normal Form)
From: mAsterdam <mAsterdam_at_vrijdag.org>
Date: Sat, 09 Jul 2005 18:28:50 +0200
Message-ID: <42cffb48$0$2663$e4fe514c_at_news.xs4all.nl>
>
> Whether a table is a list or a bag, but if David meant SQL tables then
> the answer is "bag" I guess.
Date: Sat, 09 Jul 2005 18:28:50 +0200
Message-ID: <42cffb48$0$2663$e4fe514c_at_news.xs4all.nl>
Jan Hidders wrote:
> mAsterdam wrote:
>> David Cressey wrote: >>> Jan Hidders wrote: >>>> David Cressey wrote: >>>>> Jan Hidders wrote: >>>>> >>>>>> I think that would be very confusing. First, his table actually has >>>>>> ordering, functions don't. >>>>> >>>>> It's not clear to me that a table has ordering, if I understand you >>>>> correctly. >>>> >>>> Since you did not really define the notion of "table" but distinguished >>>> it from relation I made a guess that by table you meant something where >>>> the tuples were ordered as in a list. But since it's your term you get >>>> to define it, so if you say it is a bag, then it is a bag. Is it? >>> >>> Actually, I didn't think there would be any discussion of the word >>> "table". >>> >>> All I mean by "table" is the same thing that the word means in common >>> SQL >>> parlance. And that's what I expected everyone to understand that I >>> meant. >>> Oh, well. >>> >>> I'd be very surprised if the cdt glossary has no entry for "table". >>> It seems a curious omission. >> >> Which misunderstanding is there about "table"?
>
> Whether a table is a list or a bag, but if David meant SQL tables then
> the answer is "bag" I guess.
The current (0.0.4) glossary entry,
> [Table/Row/Column] (SQL-DBMS)
> Table: A collection of columns (the table header) and rows (the body).
> Row: A collection of values, conforming to the table header columns.
>
> One table may contain data about one entity,
> about several entities, about one or several
> relationships or any combination.
> A column can be seen as the attribute of the
> entity/one of the entities/relationships
> about which the table is concerned.
, says nothing about the rows being ordered or not. Should it? Received on Sat Jul 09 2005 - 18:28:50 CEST