Re: foundations of relational theory? - some references for the truly starving
Date: 23 Oct 2003 17:30:55 GMT
Message-ID: <bn938f$uds29$1_at_ID-125932.news.uni-berlin.de>
Centuries ago, Nostradamus foresaw when michael_at_preece.net (Mike Preece) would write:
> It might be worth mentioning at this stage that the amount of data you
> can store in a Pick item will require far less physical disk space
> than on any other (uncompressed) database. There are two reasons for
> this:
> 1) because every field is of variable length - every datum is just as
> long as it needs to be and no more and empty fields occupy no space at
> all (other than single character system delimiters) - and
This all seems to be nonsense.
Relational database systems commonly use the very same techniques such that every datum is only as long as it needs to be, where NULL columns consume as little as 1 bit.
There is no theoretical reason for relational databases to consume more than other sorts, and these days, it tends to be also true in practice...
-- output = reverse("moc.enworbbc" "_at_" "enworbbc") http://cbbrowne.com/info/sap.html Points are awarded for getting the last word in. Drawing the conversation out so long that the original message disappears due to being indented off the right hand edge of the screen is one way to do this. Another is to imply that anyone replying further is a hopeless cretin and is wasting everyone's valuable time. -- from the Symbolics Guidelines for Sending MailReceived on Thu Oct 23 2003 - 19:30:55 CEST