Content deleted Content added
Move things around to make the text more structured and easier to read. |
→Features: Add information about the Mimer Provider Manager |
||
Line 58:
Mimer SQL provides support for multiple database application programming interfaces (APIs): [[ODBC]], [[JDBC]], [[ADO.NET]], [[Embedded SQL]] (C/C++, Cobol and Fortran), and the native API's Mimer SQL Real-Time API and Mimer SQL Micro C API.
The Mimer Provider Manager is an ADO.NET provider dispatcher that uses different plugins to access different underlying ADO.NET providers.<ref>https://www.c-sharpcorner.com/article/generic-database-access-with-mimer-provider-manager/</ref><ref>https://sourceforge.net/projects/mimerpm/</ref> The Mimer Provider Manager makes it possible to write database independent ADO.NET applications.
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|dead-url=yes|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|url=https://www.nada.kth.se/utbildning/grukth/exjobb/rapportlistor/2004/rapporter04/olsson_jenny_04133.pdf|dead-url=no|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|dead-url=no|archive-url=http://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>
==Etymology==
| |||