EPICURE Design Note 62.0<P> <b> VAX/Rdb Relational Database</b>

EPICURE Design Note 62.0

VAX/Rdb Relational Database

Debra S. Baddorf Document styling produced by

Originally written for CS425

IIT Computer Science Database course

30-NOV-1986

OUTLINE

    OUTLINE
    INTRODUCTION
    DDL - Data Definition Language
      Define Database
      Define Field
      Define Relation
      Define Index
      Define Protection
      Define View
      Change Relation
      Constraints
      Entity Deletions
    DML - Data Manipulation Language
      Transactions
      Data Updates
      Selecting Data
      Relational Operators
      Statistical Expressions
    RELATIONAL ALGEBRA SET OPERATIONS
      Selection
      Projection
      Product
      Join
      Intersection
      Union
      Division
      Difference
    GENERAL TOPICS
      Query Optimization
      Embedded Rdb Commands
      Journaling
      Locking
      Security
      Data Integrity - Rollback
      Relational Integrity
        entity integrity
        referential integrity
      Tuple Value Restrictions
        integrity constraints
        functional dependencies
    REFERENCES

INTRODUCTION

Digital's VAX Rdb/VMS (Relational DataBase) has relational conceptual and external models. Rdb/VMS runs on Digital's VAX or MicroVAX computers under the VMS or MicroVMS operating systems. There is also Rdb/ELN which runs under VAXELN, which has no general purpose operating system. Rdb supports concurrent use (maximum 512 users), providing both locking and rollback facilities. An Rdb database can span multiple disks, so the size of the database is limited only by the amount of storage available.

DDL - Data Definition Language
DML - Data Manipulation Language
RELATIONAL ALGEBRA SET OPERATIONS Some examples have been shown about the record selection capabilities of Rdb, but in order to claim it as a ``relationally complete'' system I'd like to (try to) prove that Rdb's query language can perform all of the relational algebra set operations. In the process I will show more examples of data retrieval.
GENERAL TOPICS

References

1
C.J.Date An Introduction to Database Systems 1985 Addison-Wesley

2
VAXELN Technical Summary 1984, Digital Equipment Corporation
3
VAX Rdb/VMS Guide to Data Manipulation December 1985, Digital Equipment Corporation
4
VAX Rdb/VMS Guide to Database Administration and Maintenance December 1985, Digital Equipment Corporation
5
VAX Rdb/VMS Guide to Database Design and Definition December 1985, Digital Equipment Corporation
6
VAX Rdb/VMS Reference Manual August 1986, Digital Equipment Corporation

Keywords: EPICURE, RDCS, Rdb, Relational, Database

Distribution: normal, Joel Butler, Bob Trendler

Security, Privacy, Legal

rwest@fsus04.fnal.gov