Mimer SQL

Mimer SQL is a relational DBMS developed by Mimer Information Technology AB. It is available across different platforms (Windows, OpenVMS, Linux, major UNIX systems) and can be run in a distributed setting. It is also designed to run in constrained environments such as mobile phones and embedded devices. Furthermore, the "Mimer SQL Real-Time Edition" is intended to work with real-time systems. Mimer SQL is meant to be "self-tuning", meaning that little maintenance should be needed over time. It's SQL-2016, JDBC and ODBC compliant.

History

Mimer SQL started from a research project at the University of Uppsala that tried implementing the ideas brought forth by Ted Codd. With the rise of SQL, Mimer's developer adopted the standard in the 1980s, and the name was changed to Mimer SQL. In 1984, Mimer was transferred to the newly established company called Mimer Information Systems, which would later become Mimer Information Technology.

Concurrency Control

Optimistic Concurrency Control (OCC)

Mimer SQL uses Optimistic Concurrency Control (OCC). OCC eliminates the overhead of locking and the possibility of deadlocks. It is also optimized for read-only transaction since they don't interfere with other running transactions. Another advantage is the simplicity of aborts, which require no rollback.

Data Model

Relational

Mimer SQL is a relational DBMS.

Foreign Keys

Supported

Foreign keys are supported. The DBMS can enforce referential integrity constraints.

Isolation Levels

Repeatable Read

The default isolation is Repeatable Read. A transaction will get the same results if it runs the same query multiple times.

Query Interface

SQL

Mimer SQL is SQL-2016 compliant. In addition, it uses SQL/PSM for stored procedures.

Storage Architecture

Disk-oriented

Mimer SQL is a disk orientated DBMS. It uses a standard Buffer Pool Manager to bring disk pages into memory.

Storage Model

N-ary Storage Model (Row/Record)

The DBMS uses row orientated storage. Every table is stored as a B*-Tree where keys and their corresponding tuples are in separate pages.

Stored Procedures

Supported

Mimer SQL supports Stored Procedures written in the SQL/PSM standard language. It also supports triggers, which are stored procedure executed when specific events occur.

System Architecture

Shared-Nothing

Mimer SQL supports both the Open Group's XA protocol and Microsoft's DTC protocol for distributed transactions. This makes the database interoperable with other database systems.

Views

Virtual Views

Mimer SQL supports Views as the result set of predefined SELECT statements. Views involving the joining of two or more tables are also supported.

Mimer SQL Logo
Website

https://www.mimer.com/

Tech Docs

https://developer.mimer.com/documentation/

Former Name

RAPID

Developer

Mimer Information Technology AB

Country of Origin

SE

Start Year

1974

Project Type

Commercial

Written in

C

Supported languages

SQL

Operating Systems

Android, Linux, OpenVMS, OS X, VxWorks, Windows

Wikipedia

https://en.wikipedia.org/wiki/Mimer_SQL