Mimer SQL Documentation TOC PREV NEXT INDEX

Mimer SQL Developer Site


About this Manual


This manual describes how to establish, manage and maintain a Mimer SQL database. It 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.

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/Linux and Mac OS X platforms.

VMS: Denotes information that applies specifically to OpenVMS 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.

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.

Related Mimer SQL Publications

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 databank corresponds to a physical file in the host file system and is used to store tables. A databank may contain several tables.
Database
A Mimer SQL database consists of the system databanks and a number of user databanks.
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 OpenVMS, containing parameters for controlling the database server for a Mimer SQL database.
ODBC
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 OpenVMS, containing lookup information for all Mimer SQL databases accessible from the current node.
UNIX
UNIX is a trademark registered by the Open Group.
VMS
VMS is a trademark registered by Hewlett-Packard.
Windows
Windows is a trademark registered by Microsoft.

All other trademarks are the property of their respective holders.


Mimer
Mimer Information Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
info@mimer.se
Mimer SQL Documentation TOC PREV NEXT INDEX