Mimer SQL System Management Handbook TOC PREV NEXT INDEX

Mimer Developer Site

www.mimer.com/developer


Introduction


Mimer SQL is an advanced database management system developed by Upright Database Technology AB. This manual describes how to establish, manage and maintain a Mimer SQL database.

The information contained in this handbook generally applies to all the platforms supported by Mimer SQL.

From time to time platform-specific notes appear in the general description, presented as follows:

UNIX: Denotes information that applies specifically to UNIX platforms.

VMS: Denotes information that applies specifically to VMS platforms.

Win: Denotes information that applies specifically to Windows platforms.

There are also some appendices at the end of this handbook which contain information that applies to specific platforms.

Documentation Objectives

This manual is a general handbook for system administrators, describing in detail the various areas of responsibility and procedures to use when administering a Mimer SQL database system.

Prerequisites

There are no prerequisites for users of this manual. However, it is advisable for the reader to be familiar with, and have a working knowledge of, the host computer operating system.

Organization of this Manual

The manual also contains the following appendices:

Acronyms, Terms and Trademarks

Term
Description
API
Application Programming Interface.
BSQL
Facility for using SQL interactively or by running a command file.
Data source
ODBC term for a database.
Databank
A Mimer SQL database consists of the Mimer SQL system databanks and a number of user databanks. Each databank is a single physical file in the host file system.
Database home directory
The directory where the system databank file containing the data dictionary and some other files that form part of the database are located.
DCL
Digital Command Language.
Embedded SQL
The term used for SQL statements when they are embedded in a traditional host programming language.
JDBC
Database connectivity for Java.
MULTIDEFS
A file, on UNIX and VMS, containing parameters for controlling the database server for a Mimer SQL database.
ODBC
Microsoft's Open Database Connectivity, a specification for a database API in the C language, independent of any specific DBMS or operating system.
PSM
Persistent Stored Modules (i.e. Stored Procedures).
Shadow
A Mimer SQL databank may have one or more shadows. A shadow is a copy of the original (master) databank and is continuously updated by Mimer SQL.
SQL
Structured Query Language.
SQLHOSTS
A file, on UNIX and VMS, containing lookup information for all Mimer SQL databases accessible from the current node.
UNIX
UNIX is a trademark registered by the X/Open Company.
VMS
VMS is a trademark registered by Compaq.
Windows
Windows is a trademark registered by Microsoft.

All other trademarks are the property of their respective holders.

Related Mimer SQL Publications



Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
dbtechnology@upright.se
Mimer SQL System Management Handbook TOC PREV NEXT INDEX