Mimer SQL Documentation TOC PREV NEXT INDEX

Mimer SQL Developer Site


About this Manual


This manual is intended primarily for users who have little or no experience of SQL (database query language). It provides an introduction to the concepts and usage of Mimer SQL, including how to create and how to manipulate the contents of a database.

Most examples in this manual are based on the example database, MIMER_STORE, that is described in The Example Environment.

To access the example database, you can use:

Mimer BSQL is a command line oriented tool for executing SQL statements, wither interactively or in batch jobs. This manual includes a detailed description of the facilities provided in Mimer BSQL.

Refer to the Mimer SQL Reference Manual, SQL Statement Descriptions for a complete syntax description of the SQL statements supported in Mimer SQL.

The use of Mimer SQL together with application programming interfaces such as ADO.NET, JDBC, ODBC and embedded SQL (ESQL), is described in Mimer SQL Engine Programmer's Manual.

Prerequisites

There are no prerequisites for users of this manual. However, it is to the user's advantage to be familiar with the principles of the relational database model when working with SQL.

Related Mimer SQL Publications

Suggestions for Further Reading

We can recommend the many works of C. J. Date. His insight into the potential and limitations of SQL, coupled with his pedagogical talents, makes his books invaluable sources of study material in the field of SQL theory and usage.

In particular, we can mention: A Guide to the SQL Standard (Fourth Edition, 1997). ISBN: 0-201-96426-0. This work contains much constructive criticism and discussion of the SQL standard, including SQL99.

Technical discussions on a wide range of SQL issues can be found in SQL for Smarties (Expanded 2nd edition, 1999, ISBN: 1558605762), by Joe Celko.

SQL Standards

Official documentation of the accepted SQL standards may be found in:

ISO/IEC 9075:2003(E) Information technology - Database languages - SQL. This document contains the standard referred to as SQL-2003.

Acronyms, Terms and Trademarks

IEC
International Electrotechnical Commission
ISO
International Standards Organization
SQL
Structured Query Language
PSM
Persistent Stored Modules (i.e. Stored Procedures)

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