Mimer SQL

Last updated
Mimer SQL
Developer(s) Mimer AB
Stable release
11.0.8E / 22 October 2024;20 days ago (2024-10-22)
Preview release
11.0.8C / 22 April 2024;6 months ago (2024-04-22)
Repository https://developer.mimer.com/products/downloads/
Operating system OpenVMS, Microsoft Windows, macOS, Linux
License Proprietary
Website www.mimer.com

Mimer SQL is a proprietary 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. [2]

Contents

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 devices. [3] [4] [5] [6]

History

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 Codd and others. The initial release in about 1975 was designated RAPID and was written in 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. [2]

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. [2]

In 1984 Mimer was transferred to the newly established company Mimer Information Systems. [2]

Versions

As of April 2018 the Mimer SQL database server is currently supported on the main platforms of Windows, MacOS, Linux, and OpenVMS (Itanium and x86-64 [7] ). [8] Previous versions of the database engine was supported on other operating systems including Solaris, AIX, HP-UX, Tru 64, SCO [9] and DNIX. Versions of Mimer SQL are available for download and free for development. [10]

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. [11]

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. [11] 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. [11]

Custom embedded 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 as Android, and real-time operating systems including VxWorks. [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-critical automotive, process automation and telecommunication systems. [13]

Features

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 uses optimistic concurrency control (OCC) to manage concurrent transactions. [18] [19]

Mimer SQL is assigned port 1360 in the Internet Assigned Numbers Authority (IANA) registry. [20]

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.

See also

Related Research Articles

<span class="mw-page-title-main">MySQL</span> SQL database engine software

MySQL is an open-source relational database management system (RDBMS). Its name is a combination of "My", the name of co-founder Michael Widenius's daughter My, and "SQL", the acronym for Structured Query Language. A relational database organizes data into one or more data tables in which data may be related to each other; these relations help structure the data. SQL is a language that programmers use to create, modify and extract data from the relational database, as well as control user access to the database. In addition to relational databases and SQL, an RDBMS like MySQL works with an operating system to implement a relational database in a computer's storage system, manages users, allows for network access and facilitates testing database integrity and creation of backups.

Structured Query Language (SQL) is a domain-specific language used to manage data, especially in a relational database management system (RDBMS). It is particularly useful in handling structured data, i.e., data incorporating relations among entities and variables.

<span class="mw-page-title-main">Ingres (database)</span> Database software

Ingres Database is a proprietary SQL relational database management system intended to support large commercial and government applications.

<span class="mw-page-title-main">IBM Db2</span> Relational model database server

Db2 is a family of data management products, including database servers, developed by IBM. It initially supported the relational model, but was extended to support object–relational features and non-relational structures like JSON and XML. The brand name was originally styled as DB2 until 2017, when it changed to its present form.

In computing, Open Database Connectivity (ODBC) is a standard application programming interface (API) for accessing database management systems (DBMS). The designers of ODBC aimed to make it independent of database systems and operating systems. An application written using ODBC can be ported to other platforms, both on the client and server side, with few changes to the data access code.

<span class="mw-page-title-main">Firebird (database server)</span> Relational database management system

Firebird is an open-source SQL relational database management system that supports Linux, Microsoft Windows, macOS and other Unix platforms. The database forked from Borland's open source edition of InterBase in 2000 but the code has been largely rewritten since Firebird 1.5.

Btrieve is a transactional database software product. It is based on Indexed Sequential Access Method (ISAM), which is a way of storing data for fast retrieval. There have been several versions of the product for DOS, Linux, older versions of Microsoft Windows, 32-bit IBM OS/2 and for Novell NetWare.

Oracle Rdb is a relational database management system for the OpenVMS operating system. It was originally released by Digital Equipment Corporation (DEC) in 1984 as VAX Rdb/VMS.

ADO.NET is a data access technology from the Microsoft .NET Framework that provides communication between relational and non-relational systems through a common set of components. ADO.NET is a set of computer software components that programmers can use to access data and data services from a database. It is a part of the base class library that is included with the Microsoft .NET Framework. It is commonly used by programmers to access and modify data stored in relational database systems, though it can also access data in non-relational data sources. ADO.NET is sometimes considered an evolution of ActiveX Data Objects (ADO) technology, but was changed so extensively that it can be considered an entirely new product.

OLE DB is an API designed by Microsoft that allows accessing data from a variety of sources in a uniform manner. The API provides a set of interfaces implemented using the Component Object Model (COM); it is otherwise unrelated to OLE. Microsoft originally intended OLE DB as a higher-level replacement for, and successor to, ODBC, extending its feature set to support a wider variety of non-relational databases, such as object databases and spreadsheets that do not necessarily implement.

<span class="mw-page-title-main">Microsoft Data Access Components</span> Framework

Microsoft Data Access Components is a framework of interrelated Microsoft technologies that allows programmers a uniform and comprehensive way of developing applications that can access almost any data store. Its components include: ActiveX Data Objects (ADO), OLE DB, and Open Database Connectivity (ODBC). There have been several deprecated components as well, such as the Jet Database Engine, MSDASQL, and Remote Data Services (RDS). Some components have also become obsolete, such as the former Data Access Objects API and Remote Data Objects.

Microsoft SQL Server Analysis Services (SSAS) is an online analytical processing (OLAP) and data mining tool in Microsoft SQL Server. SSAS is used as a tool by organizations to analyze and make sense of information possibly spread out across multiple databases, or in disparate tables or files. Microsoft has included a number of services in SQL Server related to business intelligence and data warehousing. These services include Integration Services, Reporting Services and Analysis Services. Analysis Services includes a group of OLAP and data mining capabilities and comes in two flavors multidimensional and tabular, where the difference between the two is how the data is presented. In a tabular model, the information is arranged in two-dimensional tables which can thus be more readable for a human. A multidimensional model can contain information with many degrees of freedom, and must be unfolded to increase readability by a human.

VAXELN is a discontinued real-time operating system for the VAX family of computers produced by the Digital Equipment Corporation (DEC) of Maynard, Massachusetts.

Embedded SQL is a method of combining the computing power of a programming language and the database manipulation capabilities of SQL. Embedded SQL statements are SQL statements written inline with the program source code, of the host language. The embedded SQL statements are parsed by an embedded SQL preprocessor and replaced by host-language calls to a code library. The output from the preprocessor is then compiled by the host compiler. This allows programmers to embed SQL statements in programs written in any number of languages such as C/C++, COBOL and Fortran. This differs from SQL-derived programming languages that don't go through discrete preprocessors, such as PL/SQL and T-SQL.

SAP SQL Anywhere is a proprietary relational database management system (RDBMS) product from SAP. SQL Anywhere was known as Sybase SQL Anywhere prior to the acquisition of Sybase by SAP.

Microsoft SQL Server Compact is a discontinued relational database produced by Microsoft for applications that run on mobile devices and desktops. Prior to the introduction of the desktop platform, it was known as SQL Server for Windows CE and SQL Server Mobile Edition.

An embedded database system is a database management system (DBMS) which is tightly integrated with an application software; it is embedded in the application. It is a broad technology category that includes:

Polyhedra is a family of relational database management systems offered by ENEA AB, a Swedish company. The original version of Polyhedra was an in-memory database management system which could be used in high availability configurations; in 2006 Polyhedra Flash DBMS was introduced to allow databases to be stored in flash memory. All versions employ the client–server model to ensure the data are protected from misbehaving application software, and they use the same SQL, ODBC and type-4 JDBC interfaces. Polyhedra is targeted primarily for embedded use by Original Equipment Manufacturers (OEMs), and big-name customers include Ericsson, ABB, Emerson, Lockheed Martin, United Utilities and Siemens AG.

Empress Embedded Database is a relational database management system that has been embedded into applications, including medical systems, network routers, nuclear power plant monitors, satellite management systems. Empress is an ACID compliant relational database management system (RDBMS) with two-phase commit and several transaction isolation levels for real-time embedded applications. It supports both persistent and in-memory storage of data and works with text, binary, multimedia, as well as traditional data.

<span class="mw-page-title-main">Actian Zen</span>

Actian Zen is an ACID-compliant, zero-DBA, embedded, nano-footprint, multi-model, Multi-Platform database management system (DBMS). It was originally developed by Pervasive Software, which was acquired by Actian Corporation in 2013.

References

  1. ↑ Mimer Information Technology. "Technical Overview". Mimer SQL Technical Description (PDF). Archived from the original (PDF) on 9 August 2016.
  2. 1 2 3 4 Eck, Stefan. "Database Technology - We made it possible". www.wemadeitpossible.com. Archived from the original on 25 April 2018. Retrieved 25 April 2018.
  3. ↑ Sombers Associates, Inc.; Highleyman, W. H. (October 2008). "NHSBT - UK National Health Service – Blood & Transplant" (PDF). The Availability Website. Archived (PDF) from the original on 23 April 2018. Retrieved 24 April 2018.
  4. ↑ "Australian Auto Dealers Gear Up to Mimer SQL". Cision. 12 November 2002. Archived from the original on 24 April 2018. Retrieved 24 April 2018.
  5. ↑ Eck, Stefan (2011). "Mimer SQL on OpenVMS" (PDF). de/OpenVMS.org. Archived (PDF) from the original on 24 April 2018. Retrieved 24 April 2018.
  6. ↑ Caia, Simin; Gallinaa, Barbara; Nystrom, Dag; Seceleanua, Cristina; Larsson, Alf (2017). Design of Cloud Monitoring System via DAGGTAX: a Case Study. The 8th International Conference on Ambient Systems, Networks and Technologies (ANT 2017). Madeira, Portugal: Elsevier B.V. p. 429. ISBN   9781510842342.
  7. ↑ "Mimer SQL is now available for OpenVMS on x86". Mimer Information Technology AB. 2023.
  8. ↑ "Downloads - Mimer SQL - Always free for development!". Archived from the original on 10 April 2018. Retrieved 10 April 2018.
  9. 1 2 "Mimer SQL Products & Platforms". Mimer Developers – Platforms. 5 May 2017. Archived from the original on 10 August 2017.
  10. ↑ 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.
  11. 1 2 3 4 "The Mimer SQL Products". Archived from the original on 10 April 2018. Retrieved 10 April 2018.
  12. ↑ "Mimer". Archived from the original on 14 October 2017.
  13. ↑ Hjertstöm, Andreas (2012). "2.4.5" (PDF). Data Management in Component-Based Embedded Real-Time Systems (Dissertation). Mälaralen University Press. ISBN   978-91-7485-064-2. Mimer SQL Real-Time. Archived (PDF) from the original on 20 October 2016. Retrieved 4 April 2020.
  14. ↑ "MimerPy: Python database interface for Mimer SQL". GitHub . 25 May 2021.
  15. ↑ Alund, Fedrik. "Generic database access with Mimer Provider Manager". www.c-sharpcorner.com.
  16. ↑ "Mimer Provider Manager". SourceForge.
  17. ↑ Danielsson, Lars (2 February 2004). "Mimer dömer ut Microsoft". Computer Sweden. IDG.
  18. ↑ "Transaction Concurrency - Optimistic Concurrency Control". Mimer Developers - Features. 26 February 2010. Archived from the original on 1 December 2016.
  19. ↑ Olsson, Jenny (2008). "2.3" (PDF). Comparative Study of SQL Server and Mimer SQL in Mission-Critical Systems (Masters). Mimer SQL Engine. Archived (PDF) from the original on 15 October 2008.
  20. ↑ "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.
This page is based on this Wikipedia article
Text is available under the CC BY-SA 4.0 license; additional terms may apply.
Images, videos and audio are available under their respective licenses.