Upright Database Technology's policy is to develop Mimer SQL, as far as possible, in accordance with the established standards. The following SQL standards are accepted as current:
- X/Open SQL 1995 (referred to here as X/Open-95)
- ISO/IEC 9075:1992 (referred to here as SQL-92)
- SQL/PSM (the section of the SQL-92 standard covering Persistent Stored Modules)
- ISO/IEC 9075:1999 (referred to here as SQL-99)
While any one standard defines a workable version of SQL, there are few if any vendors who supply database managers defined entirely within the bounds of a single standard. Mimer SQL combines many of the advantages of the different standards.
Mimer SQL 8 conforms to the following SQL standards:
Triggers and Persistent Stored Modules are implemented according to the SQL-99 specification.
The primary goal of the X/Open-95 standard is to allow applications to be moved between database systems from different vendors that are X/Open compliant.
The following table lists the lower limits that compliant systems should support (if a box is empty the standard does not specify a limit):
1There is a limit on the total complexity of an SQL statement. Mimer SQL can easily meet the specified X/Open-95 limits.
Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40