Mimer SQL Standard Compliance

To become compatible

Mimer SQL Standard Compliance

The language SQL (Structured Query Language) is standardized by international standard bodies such as ISO and ANSI. By using standard SQL it should be easier to move applications between different database systems without the need to rewrite a substantial amount of code. Using standard SQL does not give any warranty though as all vendors does not implement all features in the standard.

Mimer Information Technology’s policy is to develop Mimer SQL as far as possible in accordance with the established standard. Today, Mimer SQL is compatible in all essential features with the currently accepted SQL standards, which enables users to switch to and from Mimer SQL easily.

In order to assist database developers in writing SQL that conforms to the SQL standard, the Mimer SQL Validator is provided as a free online tool.

SQL Standard Topics

SQL Standard Features

Ensure that your SQL isn’t caught in the vendor-specific trap. You can maintain portability using our Mimer SQL Validators to test that your SQL statements conform to the SQL standard, and to what standard level they reside.

The following chart summarizes the Core SQL standard features. It also indicates how well Mimer SQL supports the core features.

The following chart summarizes the Optional SQL standard features. It also indicates which optional features that are currently supported by Mimer SQL.

Note! The SQL-92 standard is not included in the tables presented here. This specification had another structure in dividing functionality in Entry Level, Intermediate Level and Transitional Level. For details on SQL-92, please see the FIPS publication of the standard Database Language SQL (FIPS PUB 127-2).

Reserved Words

In the wonderful world of SQL, there are two kinds of reserved words: SQL reserved words and vendor-reserved words. When designing and writing applications, you should always avoid using vendor-reserved words as they severely limit portability.

Find out exactly who is reserving all those words and making it more difficult to write portable applications. Use the Mimer Validator – it will tell you exactly which words are reserved and who has reserved them.

Of course Mimer SQL provides extensions but the great thing is that we don’t use any additional reserved words.

See the following overview chart for reserved words in the SQL standard:

SQL Standard Organizations

So where can I get these standards? If you want your own copy of SQL Standards, you’ll have to purchase it. You can obtain a copy of ISO standards from the International Organization for Standardization at www.iso.org. The main identification for the standard is ISO/IEC 9075, which consists of several parts like for example “ISO/IEC 9075-1:2011 Information technology — Database languages — SQL — Part 1: Framework (SQL/Framework)”.

If you would like to read more about SQL, we can recommend a search on your favorite Internet book site for the SQL authorities Joe Celko, Hugh Darwen, Chris Date or Jim Melton. Or visit our Resources page.