Mimer SQL: Difference between revisions

Content deleted Content added
Spelling.
Move things around to make the text more structured and easier to read.
Line 37:
| AsOf = 9 April 2018
}}
'''Mimer SQL''' is an [[SQL]]-based [[relational database management system]]<ref name="footprint">{{bokref | 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|dead-url=yes|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. It 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>
 
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/|dead-url=yes|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|dead-url=no|archive-url=https://web.archive.org/web/20180410211904/https://database.cioreview.com/vendor/2016/mimer_information_technology_ab_|archive-date=10 April 2018}}</ref>
 
This makes it 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|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|dead-url=no|archive-url=http://web.archive.org/web/20161020123418/http://www.diva-portal.org:80/smash/get/diva2:517486/FULLTEXT02.pdf|archive-date=20 October 2016}}</ref>
 
==Versions==
 
{{As of|April 2018}} the Mimer SQL [[database server]] is currently supported on the main platforms of [[Microsoft Windows|Windows]], [[MacOS]], [[Linux]], and [[OpenVMS]] ([[AlphaServer|Alpha]] and [[HP Integrity Servers|Integrity]]).<ref name="Downer">{{cite web|url=
http://developer.mimer.com/downloads/|access-date=10 April 2018|title=Downloads - Mimer SQL - Always free for development!|dead-url=yes|archive-url=https://web.archive.org/web/20180410143850/http://developer.mimer.com/downloads/|archive-date=10 April 2018}}</ref>. Previous versions of the [[database engine]] was supported on other operating systems including [[Solaris (operating system)|Solaris]], [[IBM AIX|AIX]], [[HP-UX]], [[Tru64 UNIX|Tru 64]] and [[SCO UNIX|SCO]].<ref name="OldPlatforms">{{webbref | url = http://developer.mimer.com/platforms/index.tml | title = Mimer SQL Products & Platforms | work = Mimer Developers – Platforms | date = 5 May 2017 |dead-url=yes |archive-url=https://web.archive.org/web/20170810221754/http://developer.mimer.com/platforms/index.tml | archive-date=10 August 2017}}</ref>. Versions of Mimer SQL are available for download and free for development<ref name="TigerTiger">{{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|dead-url=no|archive-url=https://web.archive.org/web/20180410142406/https://www.macworld.com/article/1047967/mimer.html|archive-date=10 April 2018}}</ref> and Mimer AB has indicated Mimer SQL will always be available free for development.<ref name="Downer"/>
 
The [[enterprise systems|Enterprise]] product is a standards based SQL database server based upon the Mimer SQL Experience database server with rich functionality that might be expected from a 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.<ref name="Products">{{cite web|url=http://developer.mimer.com/mimer-sql-overview/|title=The Mimer SQL Products|access-date=10 April 2018|dead-url=yes|archive-url=https://web.archive.org/web/20180410162726/http://developer.mimer.com/mimer-sql-overview/|archive-date=10 April 2018}}</ref>
 
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''.<ref name="Products"/> 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''.<ref name="Products"/>
Line 55 ⟶ 51:
 
These options enable Mimer SQL to be deployed to a wide variety of additional target platforms and [[real-time operating system]]s including [[Android (operating system)|Android]] and [[VxWorks]]<ref name="platforms">{{webbref | url = http://developer.mimer.com/platforms/index.tml | title = Mimer SQL Products & Platforms | work = Mimer Developers – Platforms | date = 5 May 2017 |dead-url=yes |archive-url=https://web.archive.org/web/20170810221754/http://developer.mimer.com/platforms/index.tml | archive-date=10 August 2017}}</ref>
 
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/|dead-url=yes|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|dead-url=no|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|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|dead-url=no|archive-url=http://web.archive.org/web/20161020123418/http://www.diva-portal.org:80/smash/get/diva2:517486/FULLTEXT02.pdf|archive-date=20 October 2016}}</ref>
 
 
==Features==
Line 60 ⟶ 59:
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.
 
Mimer SQL mainly uses [[optimistic concurrency control]] (OCC) to manage multipleconcurrent userstransactions.<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==