Mimer SQL

Mimer SQL originated from a project from the ITC service center supporting Uppsala University and some other institutions to leverage the relational database capabilities proposed by Codd and others. The initial release in about 1975 was designated RAPID and was written in IBM assembler language. The name was changed to Mimer in 1977 to avoid a trademark issue. Other universities were interested in the project on a number of machine architectures and Mimer was rewritten in Fortran to achieve portability. Further models were developed for Mimer with the Mimer/QL implementing the QUEL query languages.

The emergence of SQL in the 1980s as the standard query language resulted in Mimers' developers choosing to adopt it with the product becoming Mimer SQL.

In 1984 Mimer was transferred to the newly established company Mimer Information Systems.

{{As of|April 2018}} the Mimer SQL database server is currently supported on the main platforms of Windows, MacOS, Linux, and OpenVMS (Itanium and x86-64{{cite web|url=https://developer.mimer.com/mimer-sql-is-now-available-for-openvms-on-x86/|title=Mimer SQL is now available for OpenVMS on x86|publisher=Mimer Information Technology AB|date=2023}}).{{cite web|url=http://developer.mimer.com/downloads/|access-date=10 April 2018|title=Downloads - Mimer SQL - Always free for development!|url-status=dead|archive-url=https://web.archive.org/web/20180410143850/http://developer.mimer.com/downloads/|archive-date=10 April 2018}} Previous versions of the database engine was supported on other operating systems including Solaris, AIX, HP-UX, Tru 64, SCO{{cite web|title=Mimer SQL Products & Platforms|url=http://developer.mimer.com/platforms/index.tml|work=Mimer Developers – Platforms|archiveurl=https://web.archive.org/web/20170810221754/http://developer.mimer.com/platforms/index.tml|archivedate=10 August 2017|date=5 May 2017}} and DNIX. Versions of Mimer SQL are available for download and free for development.{{cite web|url=https://www.macworld.com/article/1047967/mimer.html|access-date=10 April 2018|publisher=PCWorld|title=Mimer SQL released for Tiger, Tiger Server|date=15 November 2015|first=Peter|last=Cohen|website=Macworld|url-status=live|archive-url=https://web.archive.org/web/20180410142406/https://www.macworld.com/article/1047967/mimer.html|archive-date=10 April 2018}}

The Enterprise product is a standards based SQL database server based upon the Mimer SQL Experience database server. This product is highly configurable and components can be added, removed or replacing in the foundation product to achieve a derived product suitable for embedded, real-time or small footprint application.{{cite web|url=http://developer.mimer.com/mimer-sql-overview/|title=The Mimer SQL Products|access-date=10 April 2018|url-status=dead|archive-url=https://web.archive.org/web/20180410162726/http://developer.mimer.com/mimer-sql-overview/|archive-date=10 April 2018}}

The Mimer SQL Realtime database server is a replacement database engine specifically designed for applications where real-time aspects are paramount. This is sometimes marketed as the Automotive approach. For resource limited environments the Mimer SQL Mobile database server is a replacement runtime environment without a SQL compiler. This is used for portable and certain custom devices and is termed the Mobile Approach.

Custom embedded approaches can be applied to multiple hardware and operating system combinations.

These options enable Mimer SQL to be deployed to a wide variety of additional target platforms, such as Android, and real-time operating systems including VxWorks.

The database is available in real-time, embedded and automotive specialist versions requiring no maintenance,{{cite web|title=Mimer|url=http://www.mimer.com/|url-status=dead|archive-url=https://web.archive.org/web/20171014131046/http://www.mimer.com/|archive-date=14 October 2017}} with the intention to make the product suitable for mission-critical automotive, process automation and telecommunication systems.{{cite thesis|title=Data Management in Component-Based Embedded Real-Time Systems|type=Dissertation|date=2012|first=Andreas|last=Hjertstöm|chapter-url=http://www.diva-portal.org:80/smash/get/diva2:517486/FULLTEXT02.pdf|publisher=Mälaralen University Press|isbn=978-91-7485-064-2|chapter=2.4.5|id=Mimer SQL Real-Time|url-status=live|archive-url=https://web.archive.org/web/20161020123418/http://www.diva-portal.org/smash/get/diva2:517486/FULLTEXT02.pdf|archive-date=20 October 2016|accessdate=4 April 2020}}

Mimer SQL provides support for multiple database application programming interfaces (APIs): ODBC, JDBC, ADO.NET, Embedded SQL (C/C++, Cobol and Fortran), Module SQL (C/C++, Cobol, Fortran and Pascal), and the native API's Mimer SQL C API, Mimer SQL Real-Time API, and Mimer SQL Micro C API.

MimerPy is an adapter for Mimer SQL in Python.{{Cite web|url=https://github.com/mimersql/MimerPy|title = MimerPy: Python database interface for Mimer SQL|website = GitHub|date = 25 May 2021}}

The Mimer Provider Manager is an ADO.NET provider dispatcher that uses different plugins to access different underlying ADO.NET providers.{{cite web|url=https://www.c-sharpcorner.com/article/generic-database-access-with-mimer-provider-manager/|title=Generic database access with Mimer Provider Manager|first=Fedrik|last=Alund|website=www.c-sharpcorner.com}}{{cite web|url=https://sourceforge.net/projects/mimerpm/|title=Mimer Provider Manager|website=SourceForge}} The Mimer Provider Manager makes it possible to write database independent ADO.NET applications.{{cite web|url=https://computersweden.idg.se/2.2683/1.20021/mimer-domer-ut-microsoft|title=Mimer dömer ut Microsoft|publisher=IDG|last=Danielsson|first=Lars|date=2 February 2004|website=Computer Sweden}}

Mimer SQL mainly uses optimistic concurrency control (OCC) to manage concurrent transactions.{{cite web | url = http://developer.mimer.com/features/feature_15.htm | title = Transaction Concurrency - Optimistic Concurrency Control | work = Mimer Developers - Features | date = 26 February 2010|url-status=dead|archive-url=https://web.archive.org/web/20161201004217/http://developer.mimer.com/features/feature_15.htm|archive-date=1 December 2016}}{{cite thesis|type=Masters|title=Comparative Study of SQL Server and Mimer SQL in Mission-Critical Systems|first=Jenny|last=Olsson|chapter=2.3|id=Mimer SQL Engine|date=2008|chapter-url=https://www.nada.kth.se/utbildning/grukth/exjobb/rapportlistor/2004/rapporter04/olsson_jenny_04133.pdf|url-status=live|archive-url=https://web.archive.org/web/20081015185627/https://www.nada.kth.se/utbildning/grukth/exjobb/rapportlistor/2004/rapporter04/olsson_jenny_04133.pdf|archive-date=15 October 2008}}

Mimer SQL is assigned port 1360 in the Internet Assigned Numbers Authority (IANA) registry.{{cite web|url=https://www.iana.org/assignments/service-names-port-numbers/service-names-port-numbers.txt|access-date=8 April 2018|date=5 April 2018|id=1360|title=Service Name and Transport Protocol Port Number Registry|publisher=IANA|url-status=live|archive-url=https://web.archive.org/web/20180105044527/https://www.iana.org/assignments/service-names-port-numbers/service-names-port-numbers.txt|archive-date=5 January 2018}}

The name "Mimer" is taken from the Norse mythology, where Mimer was the giant guarding the well of wisdom, also known as "Mímisbrunnr". Metaphorically this is what a database system is doing{{snd}} managing data.

• Werner Schneider{{snd}} the professor who started the development section for the relational database that became Mimer SQL (Swedish article)

{{Reflist}}

• [https://www.mimer.com/ Mimer SQL]
• [https://developer.mimer.com Official developer website]

Category:Proprietary database management systems

Category:Relational database management systems

Category:Real-time databases

Category:Embedded databases

Category:OpenVMS software