Re: Character string relation and functional dependencies

From: Jonathan Leffler <>
Date: Thu, 06 Dec 2007 14:38:48 -0800
Message-ID: <>

Tegiri Nenashi wrote:
> On Dec 6, 9:40 am, (rpost) wrote:

>> Another difference is that database tables are finite and variable,

> Oh, relations in database world are certainly not restricted by finite
> cardinality.

I thought that computers are finite, so the relations containable in them are too - even if damn large. There's a big difference between very large and infinite.

One ultimate limitation is the uniqueness requirement. Suppose you have a table with two integer columns. Since the range of the integer types are finite (even if your DBMS handles multi-precision integers), then the maximum number of distinct rows in the relation is also finite.

Jonathan Leffler                   #include <disclaimer.h>
Guardian of DBD::Informix v2007.0914 -- whirlpool 2007-12-06 21:00:03
Received on Thu Dec 06 2007 - 23:38:48 CET

Original text of this message