SQL applications can be written in a vendor independent manner by using only those parts of SQL that are defined in one or more standards.
Mimer complies with the following standards:
Description
Different SQL standards vary in the detail of their specifications. While any one standard defines a workable version of SQL, there are few, if any, vendors who supply database management systems with a specification that falls entirely within the bounds of a single standard. Mimer SQL combines many of the advantages of the different standards.
X/Open-95 SQL
Source: CAE specification, Structured Query Language (SQL), Version 2.
X/Open-95 SQL is based closely on the International Standard for the Database Language SQL, ISO 9075:1992, (‘SQL92’) and includes some extensions to the International Standard which reflect the capabilities of current implementations.
SQL99
Source: ISO/IEC 9075:1999(E) Information technology - Database languages -SQL. This document is divided into the following parts:
Part 1: Framework (SQL / Framework)
Part 2: Foundation (SQL / Foundation)
Part 3: Call-Level Interface (SQL / CLI)
Part 4: Persistent Stored Modules (SQL / PSM)
Part 5: Host Language Bindings (SQL / Bindings)
The SQL99 standard has replaced SQL92 as the current SQL standard.
ODBC
The Mimer ODBC driver for version 8.2 now supports ODBC 3.51.
JDBC
The Mimer JDBC Driver provides access to Mimer databases from Java applications and applets. The driver is a type 4 driver, which means that the driver is written in 100% Java. This allows the driver to be downloaded in applets.
Mimer currently supports version JDBC 2.0.
Benefits
Mimer’s policy is to develop Mimer SQL as far as possible in accordance with the established standards. This makes it possible to move applications between different database systems without needing to rewrite a substantial amount of code.
In order to verify SQL statements, a tool known as the SQL Validator is developed by Mimer Information Technology AB.
Mpm Home
Printer friendly
