Content deleted Content added
Spelling. |
Karlkoenig (talk | contribs) →Versions: Added Mimer Trust to versions |
||
| (65 intermediate revisions by 32 users not shown) | |||
Line 1:
{{Infobox software
| name = Mimer SQL
Line 13 ⟶ 9:
| collapsible = <!-- Any text here will collapse the screenshot. -->
| author =
| developer = Mimer AB
| released = <!-- {{Start date and age|YYYY|MM|DD|df=yes/no}} -->
| discontinued = <!-- Set to yes if software is discontinued, otherwise omit. -->
| ver layout = <!-- simple (default) or stacked -->
| latest release version =
| latest release date = {{Start date and age|
| latest preview version = 11.0.
| latest preview date = {{Start date and age|
| repo =
| status =
| programming language =
| operating system = [[OpenVMS]], [[Microsoft Windows]], [[macOS]], [[Linux]]
| platform =
| size =
Line 31 ⟶ 27:
| language footnote =
| genre =
| license = [[Proprietary software|Proprietary]]
| alexa =
| website =
| standard =
}}
'''Mimer SQL''' is
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">
{{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>
==History==
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>▼
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 [[Edgar F. Codd|Codd]] and others. The initial release in about 1975 was designated ''RAPID'' and was written in [[Basic assembly language|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]].<ref name="Possible"/>
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''.<ref name="Possible"/>
In 1984 Mimer was transferred to the newly established company ''Mimer Information Systems''.<ref name="Possible"/>
==Versions==
{{As of|July 2025}} the Mimer SQL [[database server]] is currently supported on the main platforms of [[Microsoft Windows|Windows]], [[MacOS]], [[Linux]], [[QNX]], and [[OpenVMS]] ([[Itanium]] and [[x86-64]]<ref>{{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}}</ref>).<ref name="Downer">{{cite web|url=http://developer.mimer.com/downloads/|access-date=10 April 2018|title=Downloads - Mimer SQL - Always free for development!|
The [[enterprise systems|Enterprise]] product is a standards based SQL database server based upon the Mimer SQL Experience
▲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"/>
For resource limited environments is the ''Mimer SQL Mobile'' database server 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"/> Additionally cancustom [[embedded system|embedded]] approaches be applied to multiple hardware and operating system combinations.<ref name="Products"/>
▲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>
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 [[QNX]].<ref name="OldPlatforms"/>
▲
In May 2025 was a joint product between the British company [http://www.trustonic.com Trustonic] and Mimer [https://www.trustonic.com/news/trustonic-and-mimer-release-mimer-trust-for-commercial-deployment/ announced], called [https://www.mimer.com/products/mimer-trust/ Mimer Trust]. Mimer Trust leverages the ARM architecture's TrustZone concept and adds the capability to not only store data inside the TrustZone for added security.
==Features==
Mimer SQL provides support for multiple database application programming interfaces (APIs): [[ODBC]], [[JDBC]], [[ADO.NET]], [[Embedded SQL]] (C/C++, [[COBOL|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
▲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 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>
▲Mimer SQL mainly uses [[optimistic concurrency control]] (OCC) to manage multiple users.<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"/>
==Etymology==
The name "Mimer" is taken from the [[Norse mythology]], where [[Mímir|Mimer]] was the giant guarding the well of wisdom, also known as "[[Mímisbrunnr]]". Metaphorically this is what a database system is doing
==See also==
▲The name "Mimer" is taken from the [[Norse mythology]], where [[Mímir|Mimer]] was the giant guarding the well of wisdom, also known as "[[Mímisbrunnr]]". Metaphorically this is what a database system is doing - managing data.
* [[:sv:Werner Schneider|Werner Schneider]]{{snd}} the professor who started the development section for the relational database that became Mimer SQL (Swedish article)
==References==
Line 70 ⟶ 78:
==External links==
* [
* [
[[Category:Proprietary database management systems]]
Line 77 ⟶ 85:
[[Category:Real-time databases]]
[[Category:Embedded databases]]
[[Category:OpenVMS software]]
| |||