Mimer SQL: Difference between revisions

Browse history interactively

← Previous edit

Content deleted Content added

VisualWikitext

Revision as of 13:44, 4 March 2019 edit 155.4.126.226 (talk) v10.1.5A latest release. ← Previous edit		Latest revision as of 13:36, 28 July 2025 edit undo Karlkoenig (talk \| contribs) 22 edits →Versions: Added Mimer Trust to versions
(45 intermediate revisions by 24 users not shown)
Line 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 = 1011.10.5A9D \| latest release date = {{Start date and age\|~~2019~~2025\|0207\|2816\|df=yes/no}} \| latest preview version = 11.0.1A8C \| latest preview date = {{Start date and age\|~~2017~~2024\|0904\|2622\|df=yes/no}} \| repo = ~~http~~https://~~download~~developer.mimer.com/~~pub~~products/~~dist~~downloads/ \| status = \| programming language = \| operating system = [[OpenVMS]], [[Microsoft Windows]], [[macOS]], [[Linux]] \| platform = \| size = Line 27: \| language footnote = \| genre = \| license = [[Proprietary software\|Proprietary]] \| alexa = \| website = ~~http~~{{URL\|https://www.mimer.com/}} \| standard = ~~\| AsOf = 9 April 2018~~ }} '''Mimer SQL''' is ana proprietary [[SQL]]-based [[relational database management system]]<ref name="footprint">{{~~bokref~~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~~\|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\|~~dead-~~url-status=nolive\|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 [[~~NHS~~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~~mobile device~~\|mobile devices~~]]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\|~~dead-~~url-status=nolive\|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\|~~dead-~~url-status=nolive\|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\|~~dead-~~url-status=nolive\|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== Mimer SQL originated from a project from the ITC service center supporting [[Uppsala University]] and some other institutions to leverage the [[~~Relational~~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 ~~re-written~~rewritten in [[~~FORTRAN~~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"/> Line 46 ⟶ 45: ==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!\|~~dead-~~url-status=~~yes~~dead\|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> and [[DNIX]]. 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-~~url~~status=nolive\|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 at build time, 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-status=~~yes~~dead\|archive-url=https://web.archive.org/web/20180410162726/http://developer.mimer.com/mimer-sql-overview/\|archive-date=10 April 2018}}</ref>▼ {{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">{{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>. 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. 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"/> 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"/> 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-status=~~yes~~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\|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 system]] ~~systems~~s.<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\|~~dead~~url-~~url~~status=nolive\|archive-url=https://web.archive.org/web/20161020123418/http://www.diva-portal.org~~:80~~/smash/get/diva2:517486/FULLTEXT02.pdf\|archive-date=20 October 2016\|accessdate=4 April 2020}}</ref>▼ Custom [[embedded system\|embedded]] approaches can be applied to multiple hardware and operating system system combinations.<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> 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. 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">{{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> ▲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=https://web.archive.org/web/20161020123418/http://www.diva-portal.org:80/smash/get/diva2:517486/FULLTEXT02.pdf\|archive-date=20 October 2016}}</ref> ==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> ▲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 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\|~~dead-~~url-status=~~yes~~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\|~~dead~~url-~~url~~status=nolive\|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-status=nolive\|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> ==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 -{{snd}} managing data.▼ ==See ~~Also~~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\|Werner Schneider]]{{snd}} -the ~~Professor~~professor who started the development section for the relational database that became Mimer SQL (Swedish article).▼ ▲==See Also== ▲* [[:sv:Werner_Schneider\|Werner Schneider]] - Professor who started the development section for the relational database that became Mimer SQL (Swedish article). ==References== Line 81 ⟶ 78: ==External links== * [~~http~~https://www.mimer.com/ Mimer SQL] * [~~http~~https://developer.mimer.com Official developer website] [[Category:Proprietary database management systems]] Line 88 ⟶ 85: [[Category:Real-time databases]] [[Category:Embedded databases]] [[Category:OpenVMS software]]