UniVerse and Unidata Essentials
The Essentials course is available for both UniVerse and Unidata. It is
intended for users who are new to this style of database. It introduces the
major concepts of the multivalue data model and the associated processing
Emphasis is placed on aspects that will be of great value to all users of
the product whether they are in a system administration, development or
management role. The course includes many practical exercises to explore the
The course materials include a detailed student manual which will be a
useful book for future reference.
The main topics covered are:
The multivalue data model. This section discusses the general
relational database model and the extensions to provide the multivalued
fields that make this database so powerful and easy to use.
The command environment. This module explores the concepts of accounts,
the important system files, command syntax and the command stack editor.
The file system: File types and sizing. This module introduces the
student to the different types of file supported by the database and explains
why they are necessary and how to choose the appropriate type for each file.
The module includes extensive discussion of how each file type operates and a
detailed description of the process of setting file configuration parameters.
The Editor. All users need a good basic understanding of the editor
even if they will use other editing tools for most of their work. In this
module we meet the main editor commands and see how they allow us to create
and modify data stored in database files.
The VOC file: Overview. This module describes each of the VOC record
types and explains how they work. Emphasis is placed on how users can extend
or modify the VOC file to meet their own needs. Discussion of paragraphs is
restricted to those that execute a simple sequence of sentences. The standard
LOGIN, ON.EXIT and ON.ABORT paragraphs are also discussed.
Dictionaries (including simple I-type records). This module explores
the role of the database dictionary and examines each of the dictionary record
types. Conversion and format codes are discussed in detail. Discussion of
I-type dictionary items is limited to relatively simple expressions but
includes the TRANS() function and the operators necessary to construct useful
virtual attributes. Although concentrating on D and I type data definitions,
A and S type items are discussed in the notes and can be taught for clients
who use them.
Query processing overview. Although query processing is the major topic
of our Developer course, the Essentials course includes an overview designed
to be sufficient to get new users started. We discuss the general form of
query processor sentences, commonly used elements of selection and sort
clauses and an introduction to the concept of select lists.