Mimer SQL: Difference between revisions

Revision as of 10:33, 11 November 2021

Revision as of 00:46, 21 November 2021

Line 32:

| standard =

}}

'''Mimer SQL''' is an [[SQL]]-based [[relational database management system]]<ref name="footprint">{{cite book | title = Mimer SQL Technical Description | url = http://developer.mimer.com/documentation/WhitePapers/Technical_Description/MIMTECDESC.pdf | format = [[Portable Document Format|PDF]] | author= Mimer Information Technology | chapter = Technical Overview |archive-url=https://web.archive.org/web/20160809151237/http://developer.mimer.com/documentation/WhitePapers/Technical_Description/MIMTECDESC.pdf|archive-date=9 August 2016}}</ref> produced by the [[Sweden|Swedish]] company ''Mimer Information Technology AB'' (Mimer AB), formerly known as ''Upright Database Technology AB''. It was originally developed as a research project at the [[Uppsala University]], [[Uppsala]], [[Sweden]] in the 1970s before being developed into a commercial product.<ref name="Possible">{{cite web|url=http://www.wemadeitpossible.com/2011/01/database-technology/|title=Database Technology - We made it possible|website=www.wemadeitpossible.com|access-date=25 April 2018|first=Stefan|last=Eck|url-status=live|archive-url=https://web.archive.org/web/20180425162403/http://www.wemadeitpossible.com/2011/01/database-technology/|archive-date=25 April 2018}}</ref>

The database has been deployed in a wide range of application situations, including the [[National Health Service]] ''Pulse'' [[blood transfusion]] service in the [[UK]], [[Volvo Cars]] production line in [[Sweden]] and automotive dealers in [[Australia]]. It has sometimes been one of the limited options available in realtime critical applications and resource restricted situations such as [[mobile device]]s.<ref name="Vampire1">{{cite web|url=http://www.availabilitydigest.com/public_articles/0310/uknbs.pdf|title=NHSBT - UK National Health Service – Blood & Transplant|website=The Availability Website|date=October 2008|access-date=24 April 2018|last1=Sombers Associates, Inc.|first2=W. H.|last2=Highleyman|url-status=live|archive-url=https://web.archive.org/web/20180423203246/http://www.availabilitydigest.com/public_articles/0310/uknbs.pdf|archive-date=23 April 2018}}</ref><ref name="AussieAutos-PR">{{cite web|title=Australian Auto Dealers Gear Up to Mimer SQL|url=http://news.cision.com/upright-database-technology/r/australian-auto-dealers-gear-up-to-mimer-sql,e69341|access-date=24 April 2018|date=12 November 2002|url-status=live|archive-date=24 April 2018|archive-url=https://web.archive.org/web/20180424053611/http://news.cision.com/upright-database-technology/r/australian-auto-dealers-gear-up-to-mimer-sql,e69341|website=Cision}}</ref><ref name="TankProd-PR">{{cite web|url=http://de.openvmsnews.com/TUD2011/MimerSQLonOpenVMS-BadHomburgTUD2011.pdf|title=Mimer SQL on OpenVMS|last=Eck|first=Stefan|website=de/OpenVMS.org|url-status=live|archive-url=https://web.archive.org/web/20180424060747/http://de.openvmsnews.com/TUD2011/MimerSQLonOpenVMS-BadHomburgTUD2011.pdf|archive-date=24 April 2018|date=2011|access-date=24 April 2018}}</ref><ref name="Really">

Line 55:

These options enable Mimer SQL to be deployed to a wide variety of additional target platforms, such as [[Android (operating system)|Android]], and [[real-time operating system]]s including [[VxWorks]].<ref name="OldPlatforms"/>

The database is available in real-time, embedded and automotive specialist versions requiring no maintenance,<ref name="PrimarySnap">{{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}}</ref><ref name="CIOReview">{{cite web|url=https://database.cioreview.com/vendor/2016/mimer_information_technology_ab_|access-date=10 April 2018|title=Mimer Information Technology AB: Solution that Redefines DataStorage|website=CIOReview|url-status=live|archive-url=https://web.archive.org/web/20180410211904/https://database.cioreview.com/vendor/2016/mimer_information_technology_ab_|archive-date=10 April 2018}}</ref> with the intention to make the product suitable for mission-critical [[wikt:automotive|automotive]], [[Process automation system|process automation]] and [[telecommunication]] systems.<ref name="AndreasHdissert">{{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}}</ref>

==Features==

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.<ref>{{Cite web|url=https://github.com/mimersql/MimerPy|title = MimerPy: Python database interface for Mimer SQL|website = [[GitHub]]|date = 25 May 2021}}</ref>

The Mimer Provider Manager is an ADO.NET provider dispatcher that uses different plugins to access different underlying ADO.NET providers.<ref name="ProvMGR">{{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}}</ref><ref>{{cite web|url=https://sourceforge.net/projects/mimerpm/|title=Mimer Provider Manager|website=SourceForge}}</ref> The Mimer Provider Manager makes it possible to write database independent ADO.NET applications.<ref name="IDG-SE-1">{{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}}</ref>

Mimer SQL mainly uses [[optimistic concurrency control]] (OCC) to manage concurrent transactions.<ref name="JennyOmasters">{{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}}</ref><ref>{{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}}</ref> This makes the database locking free and enables real-time predictability.<ref name="CIOReview"/>

Mimer SQL is assigned port 1360 in the [[Internet Assigned Numbers Authority]] (IANA) registry.<ref name="IANA1360">{{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}}</ref>