| Developer(s) | Mimer AB |
|---|---|
| Stable release | 11.0.8E / 22 October 2024; 4 months ago (2024-10-22) |
| Preview release | 11.0.8C / 22 April 2024; 10 months ago (2024-04-22) |
| Repository | https://developer.mimer.com/products/downloads/ |
| Operating system | OpenVMS,Microsoft Windows,macOS,Linux |
| License | Proprietary |
| Website | www |
Mimer SQL is a proprietarySQL-basedrelational database management system[1] produced by theSwedish companyMimer Information Technology AB (Mimer AB), formerly known asUpright Database Technology AB. It was originally developed as a research project at theUppsala University,Uppsala,Sweden in the 1970s before being developed into a commercial product.[2]
The database has been deployed in a wide range of application situations, including theNational Health ServicePulseblood transfusion service in theUK,Volvo Cars production line inSweden and automotive dealers inAustralia. It has sometimes been one of the limited options available in realtime critical applications and resource restricted situations such asmobile devices.[3][4][5][6]
Mimer SQL originated from a project from the ITC service center supportingUppsala University and some other institutions to leverage therelational database capabilities proposed byCodd and others. The initial release in about 1975 was designatedRAPID and was written inIBM assembler language. The name was changed toMimer in 1977 to avoid a trademark issue. Other universities were interested in the project on a number of machine architectures and Mimer was rewritten inFortran to achieve portability. Further models were developed for Mimer with the Mimer/QL implementing theQUEL query languages.[2]
The emergence ofSQL in the 1980s as the standard query language resulted in Mimers' developers choosing to adopt it with the product becomingMimer SQL.[2]
In 1984 Mimer was transferred to the newly established companyMimer Information Systems.[2]
As of April 2018[update] the Mimer SQLdatabase server is currently supported on the main platforms ofWindows,MacOS,Linux, andOpenVMS (Itanium andx86-64[7]).[8] Previous versions of thedatabase engine was supported on other operating systems includingSolaris,AIX,HP-UX,Tru 64,SCO[9] andDNIX. Versions of Mimer SQL are available for download and free for development.[10]
TheEnterprise 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.[11]
TheMimer SQL Realtime database server is a replacement database engine specifically designed for applications where real-time aspects are paramount. This is sometimes marketed as theAutomotive approach.[11] For resource limited environments theMimer 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 theMobile Approach.[11]
Customembedded approaches can be applied to multiple hardware and operating system combinations.[11]
These options enable Mimer SQL to be deployed to a wide variety of additional target platforms, such asAndroid, andreal-time operating systems includingVxWorks.[9]
The database is available in real-time, embedded and automotive specialist versions requiring no maintenance,[12] with the intention to make the product suitable for mission-criticalautomotive,process automation andtelecommunication systems.[13]
Mimer SQL provides support for multiple database application programming interfaces (APIs):ODBC,JDBC,ADO.NET,Embedded SQL (C/C++, 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.[14]
The Mimer Provider Manager is an ADO.NET provider dispatcher that uses different plugins to access different underlying ADO.NET providers.[15][16] The Mimer Provider Manager makes it possible to write database independent ADO.NET applications.[17]
Mimer SQL mainly usesoptimistic concurrency control (OCC) to manage concurrent transactions.[18][19]
Mimer SQL is assigned port 1360 in theInternet Assigned Numbers Authority (IANA) registry.[20]
The name "Mimer" is taken from theNorse mythology, whereMimer was the giant guarding the well of wisdom, also known as "Mímisbrunnr". Metaphorically this is what a database system is doing – managing data.