Wikipedia

Mimer SQL

This is an old revision of this page, as edited by PerBengtsson (talk | contribs) at 14:03, 9 May 2017 (Added some historical information and made minor changes to the text.). The present address (URL) is a permanent link to this revision, which may differ significantly from the current revision.

Mimer SQL is an SQL-based relational database management system from the Swedish company Mimer Information Technology AB (formerly Upright Database Technology AB). It has been developed and produced since the 1970s when it was founded at the Uppsala University, Uppsala, Sweden.

The name "Mimer" is taken from the Norse mythology, where Mimer was the giant guarding the well of wisdom, also knows as "Mímisbrunnr". Metaphorically is this what Mimer SQL does - manages data.

Mimer SQL offers a scalable and portable solution providing database servers for environments that spans from embedded and real-time operating systems to enterprise systems. This includes platforms like Windows, MacOS, Linux, Android, Unix, OpenVMS, and VxWorks [1].

Some of the main characteristics for Mimer SQL are high performance, small memory footprint and a low level of maintenance [2]. These attributes are based on a number of technical solutions to handle some of the more complicated functionality that a database management system must provide.

Mimer SQL uses optimistic concurrency control (OCC) [3] which provides a solution to the problem of allowing simultaneous access to the database without the danger of a deadlock occurring [4]. This may simplify database management and allow truly scalable performance, even during heavy system load.

Another technical issue is the data storage mechanism, which in Mimer SQL is implemented to be constantly optimized for maximum performance. This also ensures that no manual reorganization of the database is ever needed [5].

The database management language Mimer SQL (Structured Query Language) is compatible in all essential features with the currently accepted SQL standards [6].

References

  1. ^ "Mimer SQL Products & Platforms". Mimer Developers – Platforms. 5 May 2017.
  2. ^ Mimer Information Technology. "Technical Benefits Overview". Mimer SQL Technical Description (PDF).
  3. ^ "Transaction Concurrency - Optimistic Concurrency Control". Mimer Developers - Features. 26 February 2010.
  4. ^ "Transaction Management". Mimer Developers – Features. 5 May 2017.
  5. ^ "Data Storage in Mimer SQL". Mimer Developers – Features. 5 May 2017.
  6. ^ "Mimer SQL Standard Compliance". Mimer Developers – SQL Standard. 5 May 2017.
Retrieved from "https://en.wikipedia.org/w/index.php?title=Mimer_SQL&oldid=779536610"