Re: Does Codd's view of a relational database differ from that ofDate&Darwin?[M.Gittens]

From: Jon Heggland <heggland_at_idi.ntnu.no>
Date: Tue, 7 Jun 2005 16:48:20 +0200
Message-ID: <MPG.1d0fd208b526fdff989681_at_news.ntnu.no>


In article <e%hpe.7195$F7.5782_at_news-server.bigpond.net.au>, hobbit_at_southern_seaweed.com.op says...
> "Tony Andrews" <andrewst_at_onetel.com> wrote in message
> news:1118141746.220955.243690_at_o13g2000cwo.googlegroups.com...
> > Alexandr Savinov wrote:
> > <SNIP>
> >
> > Which part of the decomposition process reduces 1 row to 0 rows? I
> > must have missed that part...
>
> I imagine this can be done by querying the system table register
> for the name of a table, instead of querying a table for the name
> (value) of a key.
>
> Instead of writing or deleting a row, you could
> create or drop a table with zero rows.

In that case, you are using the rows in the "system table register" table for your information; the actual tables you create and drop are just irrelevant side effects -- you don't use them for anything at all.

Alternatively, if the "system table register" is not organized as a relational table, you are no longer using the relational model, and the whole point is lost.

-- 
Jon
Received on Tue Jun 07 2005 - 16:48:20 CEST

Original text of this message