Content deleted Content added
m clean up |
m Task 16: replaced (13×) / removed (0×) deprecated |dead-url= and |deadurl= with |url-status=; |
||
Line 33:
| 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.<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|
The database has been deployed in a wide range of application situations, including the [[NHS]] ''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|
{{cite conference|title = Design of Cloud Monitoring System via DAGGTAX: a Case Study|first1=Simin|last1=Caia|first2=Barbara|last2=Gallinaa|first3=Dag|last3=Nystrom|first4=Cristina| last4=Seceleanua|first5=Alf|last5=Larsson|year = 2017|conference=The 8th International Conference on Ambient Systems, Networks and Technologies (ANT 2017)| publisher = Elsevier B.V.|___location=Madeira, Portugal|pages=429|isbn=9781510842342}}</ref>
Line 46:
==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!|
▲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">{{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}}</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>
The [[enterprise systems|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.<ref name="Products">{{cite web|url=http://developer.mimer.com/mimer-sql-overview/|title=The Mimer SQL Products|access-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''.<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 57 ⟶ 56:
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="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/|
==Features==
Line 64 ⟶ 63:
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|
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|
==Etymology==
| |||