Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / General DB Topics / DB Theory / July 2005

Tip: Looking for answers? Try searching our database.

DBKEY Datatype

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
David  Cressey - 25 Jul 2005 15:08 GMT
Marshall,

This is an offshoot of the topic where you are exploring the comparison of
graph databases with systems of relations.
It's so tangential that I chose to start a new thread, rather than hijack
your thread.

When DEC built Rdb, in the early 1980s,  they included a datatype called
DBKEY.  The contents of a DBKEY, in some address space, was really the
address of another record.  Yeah, "record".

Their nomenclature at the time was to talk about "relations", "records",
"fields", and "global fields".  A few years later, they were talking about
"tables", "rows", "columns" and "domains", after they adopted SQL.   But the
SW engineering was really the same idea.

In any event,  the availability of DBKEY as a datatype meant that a DB
designer could, if he (meaning he or she) wanted to, extend the relational
model by implementing his own arbitrary graph  scheme.  The documentation
warned people against using this facility,  but there it was... enough rope
to hang yourself.

The consequences of "pinning" rows of a table in the DB address space were,
of course, devastating.  But the people who went down that road generally
had to learn it for themselves.

BTW,  the SW engineering that went into Rdb, and earlier into VAX DBMS (a
CODASYL style database)  was truly superb.  Some of the cleanest
implementation ever.  DEC Rdb still survives as "Oracle Rdb".
Paul - 25 Jul 2005 17:53 GMT
>BTW,  the SW engineering that went into Rdb, and earlier into VAX DBMS (a
>CODASYL style database)  was truly superb.  Some of the cleanest
>implementation ever.  DEC Rdb still survives as "Oracle Rdb".

It also survives as Interbase and Firebird. Jim Starkey the original
designer/coder of Dec Rdb later went on to found Groton database
systems (hence the .gdb suffixes on Interbase database files), bought
by Asford-Tate bought by Borland.

He is now back in the frame and active on the Firebird project and
lists.

Paul...

Signature

plinehan __at__ yahoo __dot__ __com__

XP Pro, SP 2,

Oracle, 9.2.0.1.0 (Enterprise Ed.)
Interbase 6.0.1.0;

When asking database related questions, please give other posters
some clues, like operating system, version of db being used and DDL.
The exact text and/or number of error messages is useful (!= "it didn't work!").
Thanks.

Furthermore, as a courtesy to those who spend
time analysing and attempting to help, please
do not top post.

David  Cressey - 26 Jul 2005 13:48 GMT
> >BTW,  the SW engineering that went into Rdb, and earlier into VAX DBMS (a
> >CODASYL style database)  was truly superb.  Some of the cleanest
[quoted text clipped - 9 lines]
>
> Paul...

I've talked to Jim Starkey, and I don't think it's quite right to call him
"the original designer/coder of DEC Rdb".

Jim built Rdb/ELN, a product that is quite different, internally,  from
Rdb/VMS.  The fact that both Rdb/ELN and Rdb/VMS conformed to the same DSRI
was undoubtedly due, in part, to Starkey's inputs.   I agree that the
influence of Rdb in Interbase is evident.

I don't know anything at all about Firebird.  Any pointers?
Alfredo Novoa - 26 Jul 2005 15:15 GMT
>I don't know anything at all about Firebird.  Any pointers?

http://firebird.sourceforge.net/

Regards
Paul - 26 Jul 2005 15:41 GMT
>I've talked to Jim Starkey, and I don't think it's quite right to call him
>"the original designer/coder of DEC Rdb".

OK, my bad.

>Jim built Rdb/ELN, a product that is quite different, internally,  from
>Rdb/VMS.  

What does the ELN stand for?

> The fact that both Rdb/ELN and Rdb/VMS conformed to the same DSRI
>was undoubtedly due, in part, to Starkey's inputs.   I agree that the
>influence of Rdb in Interbase is evident.

DRSI?

>I don't know anything at all about Firebird.  Any pointers?

It's actually a pretty amazing powerful db with a *_tiny_* footprint
compared to the likes of Oracle, but is still capable of doing a good
part of what Oracle does. The server it 1.5 MB, yes, that's MB. The
download for server, including all tools &c. is 3.6 MB. It can work
with multi 100GB of data with hundreds of concurrent users.

http://firebird.sourceforge.net/
http://www.ibphoenix.com

Should get you started. Look in the history here
http://www.ibphoenix.com/main.nfs?a=ibphoenix&page=ibp_history

Paul...

Signature

plinehan __at__ yahoo __dot__ __com__

XP Pro, SP 2,

Oracle, 9.2.0.1.0 (Enterprise Ed.)
Interbase 6.0.1.0;

When asking database related questions, please give other posters
some clues, like operating system, version of db being used and DDL.
The exact text and/or number of error messages is useful (!= "it didn't work!").
Thanks.

Furthermore, as a courtesy to those who spend
time analysing and attempting to help, please
do not top post.

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.