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 designed to be "self-tuning", meaning that little maintenance should be needed over time.
It is 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.
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.
