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.
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.
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.
Mimer SQL is a relational DBMS.
Foreign keys are supported. The DBMS can enforce referential integrity constraints.
The default isolation is Repeatable Read. A transaction will get the same results if it runs the same query multiple times.
Mimer SQL is SQL-2016 compliant. In addition, it uses SQL/PSM for stored procedures.
Mimer SQL is a disk orientated DBMS. It uses a standard Buffer Pool Manager to bring disk pages into memory.
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.
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.
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.
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 Information Technology AB
Android, Linux, OpenVMS, OS X, VxWorks, Windows