🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: comp.os.vms
Article #15842

Re: The Minimum You Need to Know to Be an OpenVMS Application Developer

#15842
From: Neil Rieck
Date: Mon, 17 Apr 2006 23:16
50 lines
4336 bytes
The following 3.5 paragraphs are taken from the introduction to chapter #14
(Oracle-RDB). Publication of this teaser was authorized by the author,
Roland Hughes.

    ###

RDB is quite simply the best relational database ever released on the
OpenVMS platform. This database was originally created by Digital Equipment
Corporation (DEC) back in the 1980's. It was at least a decade, if not
multiple decades, ahead of its time. The database is now owned by Oracle
Corporation but is still the premier fault tolerant cluster aware database.
RDB stands for Relational Data Base. DEC continued its tradition of plain
names when it created this product.

When RDB first came out, it was so far ahead of its time that it eclipsed
the hardware of its day. The old VAX boxes with RA series drives simply
didn't have enough horsepower to run the thing well. The I/O speed of the RA
series disks was slow by just about everybody's standards. They were built
to be reliable, not fast. People don't think much about hard drives these
days. The technology has improved to the point that we tend to upgrade long
before the failure occurs. Back in the day when RA series disk drives
reigned, a five year MTBF (Mean Time Before Failure) was a lofty goal.

Security is one of the many selling points for RDB. It uses OpenVMS built-in
security including accounts and ACL rights identifiers. There is no
secondary maintenance issue about setting up user accounts inside the
database. You can assign ACL security at both the database and table level.

RDB offers complete integration with CDD. When you create a database with
the DICTIONARY IS REQUIRED clause all entries created or altered in the
database are automatically kept in sync with the CDD. Having this level of
integeration >>> [58 pages follow]

    ###

Once you read the text and try out the examples of chapter #13 (MySQL) and
chapter #14 (RDB) you will have a really good feeling for the pros and cons
of these two products. This is just the book I needed since one of my legacy
OpenVMS systems currently contains 100+ RMS index files and we were
exploring relational database alternatives. Click the following link to
order the book.

http://www.islandco.com/theminimum.html

Neil Rieck
Kitchener/Waterloo/Cambridge,
Ontario, Canada.
http://www3.sympatico.ca/n.rieck/links/cool_openvms.html
http://www3.sympatico.ca/n.rieck/links/openvms_demos.html
http://www3.sympatico.ca/n.rieck/links/cool_openvms.html#TMYNTKTBA-OpenVMS-AD
Technical Details
Message-ID: <clV0g.2290$wK1.134150@news20.bellglobal.com>
Path: arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!wns13feed!worldnet.att.net!207.35.177.252!nf3.bellglobal.com!nf1.bellglobal.com!nf2.bellglobal.com!news20.bellglobal.com.POSTED!not-for-mail
References: <JuBUf.747$yn4.684@bignews7.bellsouth.net> <1143148384.154972.133010@i40g2000cwc.googlegroups.com> <1143163657.604824.255260@g10g2000cwb.googlegroups.com> <877j6klgi2.fsf@wolfe.cbbrowne.com> <4429EC72.73334148@NeOaSrPtAhMlNiOnWk.net> <87r74lc3dy.fsf@wolfe.cbbrowne.com> <HeGWf.4228$C85.3494@dukeread10> <1143715636.348936.63310@t31g2000cwb.googlegroups.com> <1144703149.339176.316470@v46g2000cwv.googlegroups.com> <5pK%f.4667$fo1.219282@news20.bellglobal.com> <443fa1ff$0$4421$ba620dc5@nova.planet.nl> <edO%f.5391$L.198071@news20.bellglobal.com>

Show Full Headers
Complete Article Headers
X-Google-Thread: f7344,a423e09250cec1b9
X-Google-Thread: 1164f8,a423e09250cec1b9
X-Google-Thread: 1094ae,a423e09250cec1b9
X-Google-Thread: fcd99,a423e09250cec1b9
X-Google-Attributes: gidf7344,gid1164f8,gid1094ae,gidfcd99,public
X-Google-Language: ENGLISH,ASCII-7-bit
Path: arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!wns13feed!worldnet.att.net!207.35.177.252!nf3.bellglobal.com!nf1.bellglobal.com!nf2.bellglobal.com!news20.bellglobal.com.POSTED!not-for-mail
From: "Neil Rieck" <n.rieck@sympatico.ca>
Newsgroups: comp.os.vms,comp.sys.dec,de.comp.os.vms,fr.comp.os.vms
References: <JuBUf.747$yn4.684@bignews7.bellsouth.net>   <1143148384.154972.133010@i40g2000cwc.googlegroups.com>   <1143163657.604824.255260@g10g2000cwb.googlegroups.com>   <877j6klgi2.fsf@wolfe.cbbrowne.com>   <4429EC72.73334148@NeOaSrPtAhMlNiOnWk.net>   <87r74lc3dy.fsf@wolfe.cbbrowne.com>   <HeGWf.4228$C85.3494@dukeread10>   <1143715636.348936.63310@t31g2000cwb.googlegroups.com> <1144703149.339176.316470@v46g2000cwv.googlegroups.com> <5pK%f.4667$fo1.219282@news20.bellglobal.com> <443fa1ff$0$4421$ba620dc5@nova.planet.nl> <edO%f.5391$L.198071@news20.bellglobal.com>
Subject: Re: The Minimum You Need to Know to Be an OpenVMS Application Developer
Lines: 56
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
X-RFC2646: Format=Flowed; Original
Message-ID: <clV0g.2290$wK1.134150@news20.bellglobal.com>
Date: Mon, 17 Apr 2006 19:16:27 -0400
NNTP-Posting-Host: 65.95.28.216
X-Complaints-To: abuse@sympatico.ca
X-Trace: news20.bellglobal.com 1145315784 65.95.28.216 (Mon, 17 Apr 2006 19:16:24 EDT)
NNTP-Posting-Date: Mon, 17 Apr 2006 19:16:24 EDT
Organization: Bell Sympatico