Print this page.  If your browser doesn't allow JavaScript, right-click this page and choose Print from the popup-menu.        
Mimer SQL, Built on Standards
Categories: Database features, SQL
Introduction

SQL applications can be written in a more vendor independent manner by avoiding non-standard SQL constructions.

Mimer complies with the following standards and database API specifications:

  • SQL-2008

  • ODBC (Open Database Connectivity)

  • JDBC (Java Database Connectivity)

Description

SQL-2008

Source: ISO/IEC 9075:2008(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 9: Management of External Data (SQL/MED)

  • Part 10: Object Language Bindings (SQL/OLB)

  • Part 11: Information and Definition Schemas (SQL/Schemata)

  • Part 13: SQL Routines and Types Using the Java TM Programming Language (SQL/JRT)

  • Part 14: XML-Related Specifications (SQL/XML)


The SQL-2008 standard has replaced the former standards SQL-92, SQL-99 and SQL-2003 as the current SQL standard. For further details on SQL specifications, please see the SQL Standard Features page.

In addition, take a look at the table Core SQL:1999 feature comparison chart for an overview of standard features and their availability in some common database management systems.

ODBC

The Mimer ODBC driver supports ODBC 3.51. For more information, see the database API article covering ODBC, and also the Microsoft’s ODBC overview page.

JDBC

The Mimer JDBC drivers provide access to Mimer databases from Java applications and applets. The drivers are type 4 drivers, which means that they are written in 100% Java. This allows the drivers to be downloaded in applets.

Mimer currently supports version JDBC 3.0. For more information, see the database API article covering JDBC, and also the Sun’s JDBC overview.
Benefits

Mimer’s policy is to develop Mimer SQL as far as possible in accordance with the established standards. This makes it easier to move applications between different database systems without needing to rewrite a substantial amount of code.

In order to verify SQL statements, an online tool known as the SQL Validator is developed by Mimer Information Technology.
Links

Mimer SQL Documentation Set, PDF-file (see the SQL Reference Manual).

For further information on JDBC, please see http://java.sun.com/products/jdbc.

For detailed information on ODBC, please refer to documentation found on
http://www.microsoft.com.


Last updated: 2009-04-17

 

Powered by Mimer SQL

Powered by Mimer SQL