Re: does a table always need a PK?

Bob,

"Bob Badour" <bbadour_at_golden.net> kirjoitti viestissä news:OYy2b.694$FE.81687684_at_mantis.golden.net...
> "Heikki Tuuri" <Heikki.Tuuri_at_innodb.com> wrote in message
...
> > if I can recall, the 1970 paper is not formulated as mathematical axioms
> > either. Or is it? Do you remember?
>
> rtfm: http://www.acm.org/classics/nov95/

it is not. I did not find mathematical axioms there. Have you studied mathematics?

For example, where in the 1970 paper is the following rule formalized?

http://www.cis.ohio-state.edu/~sgomori/570/coddsrules.html:

"
9. Logical Data Independence
Application programs and terminal activities remain logically unimpaired when information preserving changes of any kind that theoretically permit unimpairment are made to the base tables. "

Or:

"
6. View Updating Rule
All views that are theoretically updateable are also updateable by the system.
"

?

...
> > "* FirstSQL/J Object/Relational DBMS "
> >
> > By the way, FirstSQL probably is not Codd-12-relational? Why do you
claim
> it
> > to be an 'object/relational' database then? Is it 'Lee
> > Fesperman -relational'?
>
> It was me who pointed out SQL is not particularly relational--not Lee.
> FirstSQL, of course, suffers some of the same problems all SQL dbmses
> suffer. Unlike MySQL, I would count FirstSQL a dbms or at least a
> significant subset of such a system.

Lee's claims are grossly contradictory. He claims that 'the relational model' is not vague and claims that his database is 'object/relational'. But it turns out that his database is not Codd-12-relational. I have not seen such hypocrisy from other database vendors.

> > > He has stubbornly refused to educate himself, clinging to 'thumbnail'
> > > descriptions of the relational model.
> >
> > No, not at all. I looked at the 1970 paper 1.5 years ago.
>
> Looking and learning are two different things. If you know what is in the
> 1970 paper, why would you argue that the 12 rules are insufficiently
formal?

The 1970 paper seems to be insufficiently formal.

...
> six months later, you finally condescended to read the paper, and now you
> are a database vendor who claims to have read the paper and who continues
to
> spout the most absurd, ridiculous nonsense. Is that an accurate summary?

No. Look above who is talking nonsense.

Best regards,

Heikki Tuuri
Innobase Oy
http://www.innodb.com
Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - a hot backup tool for MySQL Received on Tue Aug 26 2003 - 10:08:37 CEST