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.[04][05]
- Website
- https://www.mimer.com[01]
- Developer
- Country of Origin
- SE
- Start Year
- 1974 [06]
- Former Name
- RAPID
- Project Type
- Commercial
- Written in
- C
- Supported Languages
- SQL
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.
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.[04][05]
History[06][03]
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[05]
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.
Foreign Keys[05]
Foreign keys are supported. The DBMS can enforce referential integrity constraints.
Indexes[07][05]
Mimer SQL uses B-Trees for all tables and secondary indices. B-Trees internal nodes are more densely packed than B+-Trees (66 percent full instead of 50 percent). This higher storage utilization also can speed up keyed search when the height resulting tree is smaller.
Isolation Levels[05]
The default isolation is Repeatable Read. A transaction will get the same results if it runs the same query multiple times.
Query Interface[08][05]
Mimer SQL is SQL-2016 compliant. In addition, it uses SQL/PSM for stored procedures.
Storage Architecture[05]
Mimer SQL is a disk orientated DBMS. It uses a standard Buffer Pool Manager to bring disk pages into memory.
Storage Model[05]
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[05]
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[09]
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[05]
Mimer SQL supports Views as the result set of predefined SELECT statements. Views involving the joining of two or more tables are also supported.
Citations
9 sources- Mimer Information Technology - Mimer mimer.com
- Documentation - Mimer Developer mimer.com
- Mimer SQL - Wikipedia wikipedia.org
- Features - Mimer Developer mimer.com
- https://docs.mimer.com/MimerTechnicalDescription/latest_mimertechdesc.pdf mimer.com
- http://www.wemadeitpossible.com/2011/01/database-technology/ wemadeitpossible.com
- https://doi.org/10.1145/356770.356776 doi.org
- https://developer.mimer.com/documentation/database-features/mimer-sql-in-a-nutshell/ mimer.com
- https://developer.mimer.com/documentation/database-features/mimer-sql-and-distributed-transactions/ mimer.com