An editor has nominated this article for deletion. You are welcome to participate in the deletion discussion, which will decide whether or not to retain it. |
Mimer SQL is an SQL-based relational database management system[1] produced by the 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.
| Mimer SQL | |
|---|---|
| Stable release | 10.1.4D
/ 27 December 2017 |
| Preview release | 11.0.1A
/ 26 September 2017 |
| Repository | http://download.mimer.com/pub/dist/ |
| License | Proprietary |
| Website | http://www.mimer.com/ |
| As of | 9 April 2018 |
Versions
As of April 2018[update] the Mimer SQL database server is currently supported on the main platforms of Windows, MacOS, Linux, and OpenVMS (Alpha and Integrity).[2]. Previous versions of the database engine was supported on other operating systems including Solaris, AIX, HP-UX, Tru 64 and SCO.[3]. Versions of Mimer SQL are available for download and free for development[4] .
The 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.[5]
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.[5] 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.[5]
Custom embedded approaches can be applied to multiple hardware and operating system system combinations.[5]
These options enable Mimer SQL to be deployed to a wide variety of additional target platforms and real-time operating systems including Android and VxWorks[6]
The database is available in real-time, embedded and automotive specialist versions requiring no maintenance[7][8], with the intention to make the product suitable for mission-critical automotive, process automation and telecommunication systems.[9]
Features
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 concurrent transactions.[10][11] This makes the database locking free and enables real-time predictability.[8]
Mimer SQL is assigned port 1360 in the Internet Assigned Numbers Authority (IANA) registry.[12]
Etymology
The name "Mimer" is taken from the Norse mythology, where 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.
References
- ^ Mimer Information Technology. "Technical Overview". Mimer SQL Technical Description (PDF). Archived from the original (PDF) on 9 August 2016.
{{cite book}}: Unknown parameter|dead-url=ignored (|url-status=suggested) (help) - ^ "Downloads - Mimer SQL - Always free for development!". Archived from the original on 10 April 2018. Retrieved 10 April 2018.
{{cite web}}: Unknown parameter|dead-url=ignored (|url-status=suggested) (help) - ^ "Mimer SQL Products & Platforms". Mimer Developers – Platforms. 5 May 2017. Archived from the original on 10 August 2017.
{{cite web}}: Unknown parameter|dead-url=ignored (|url-status=suggested) (help) - ^ Cohen, Peter (15 November 2015). "Mimer SQL released for Tiger, Tiger Server". Macworld. PCWorld. Archived from the original on 10 April 2018. Retrieved 10 April 2018.
{{cite web}}: Unknown parameter|dead-url=ignored (|url-status=suggested) (help) - ^ a b c d "The Mimer SQL Products". Archived from the original on 10 April 2018. Retrieved 10 April 2018.
{{cite web}}: Unknown parameter|dead-url=ignored (|url-status=suggested) (help) - ^ "Mimer SQL Products & Platforms". Mimer Developers – Platforms. 5 May 2017. Archived from the original on 10 August 2017.
{{cite web}}: Unknown parameter|dead-url=ignored (|url-status=suggested) (help) - ^ "Mimer". Archived from the original on 14 October 2017.
{{cite web}}: Unknown parameter|dead-url=ignored (|url-status=suggested) (help) - ^ a b "Mimer Information Technology AB: Solution that Redefines DataStorage". CIOReview. Archived from the original on 10 April 2018. Retrieved 10 April 2018.
{{cite web}}: Unknown parameter|dead-url=ignored (|url-status=suggested) (help) - ^ Hjertstöm, Andreas (2012). "2.4.5". Data Management in Component-Based Embedded Real-Time Systems (PDF) (Dissertation). Mälaralen University Press. ISBN 978-91-7485-064-2. Mimer SQL Real-Time. Archived from the original (PDF) on 20 October 2016.
{{cite thesis}}: Unknown parameter|dead-url=ignored (|url-status=suggested) (help) - ^ "Transaction Concurrency - Optimistic Concurrency Control". Mimer Developers - Features. 26 February 2010. Archived from the original on 1 December 2016.
{{cite web}}: Unknown parameter|dead-url=ignored (|url-status=suggested) (help) - ^ Olsson, Jenny (2008). "2.3". Comparative Study of SQL Server and Mimer SQL in Mission-Critical Systems (PDF) (Masters). Mimer SQL Engine. Archived from the original (PDF) on 15 October 2008.
{{cite thesis}}: Unknown parameter|dead-url=ignored (|url-status=suggested) (help) - ^ "Service Name and Transport Protocol Port Number Registry". IANA. 5 April 2018. 1360. Archived from the original on 5 January 2018. Retrieved 8 April 2018.
{{cite web}}: Unknown parameter|dead-url=ignored (|url-status=suggested) (help)