logo
Powered by QM on a Rpi server
Home
About OpenQM
Sales and Downloads
Help and Support
About
Login

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 environment.

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 topics presented.

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.