× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



> From: Chris Bipes
>
> Yes but that is maintained by the DBM, called RRN.  So the rule is not
> broken.

I'm not going to spend a lot of time splitting hairs here, because what
we're debating is Dr. Codd's opinion, anyway.  But his words are:

"Each and every datum (atomic value) in a relational database is guaranteed
to be logically accessible by resorting to a combination of table name,
primary key value, and column name."

Forgive me if I'm misspeaking here, but as far as I can tell, the relative
record number is not considered a primary key, mostly because it's not part
of the actual data in the record.  Simply removing deleted records, for
instance with a RGZPFM, will change the RRN for a record, thereby changing
its "primary key".

AFAIK, databases that used RRNs for linkage were known as "network
databases" and while very fast, were susceptible to being completely
corrupted if a file got reorganized.

Joe


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.