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. It is assigned port 1360 in the Internet Assigned Numbers Authority (IANA) registry.[2]
| 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 |
The database is available in real-time, embedded and automotive specialist versions requiring no maintenance.[3][4]
This makes it suitable for mission-critical automotive, process automation and telecommunication systems.[5]
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).[6]. Previous versions of the database engine was supported on other operating systems including Solaris, AIX, HP-UX, Tru 64 and SCO.[7]. Versions of Mimer SQL are available for download and free for development[8] and Miner AB has indicated Mimer SQL will always be available free for development.[6]
The 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.[9]
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.[9] 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.[9]
Custom embedded approaches can be applied to multiple hardware and operating system system combinations.[9]
These options enable Miner SQL to be deployed to a wide variety of additional target platforms and real-time operating systems including Android and VxWorks[10]
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 multiple users.[11][12] This makes the database locking free and enables real-time predictability.[4]
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) - ^ "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) - ^ "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) - ^ a b "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) - ^ "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)