Mimer SQL: Difference between revisions

From Wikipedia, the free encyclopedia
Jump to navigation Jump to search
← Previous edit
VisualWikitext
imported>Karlkoenig
→Versions: Added Mimer Trust to versions
imported>Citation bot
Added date. | Use this bot. Report bugs. | Suggested by Jay8g | #UCB_toolbar
 
Line 13: Line 13:
| discontinued = <!-- Set to yes if software is discontinued, otherwise omit. -->
| discontinued = <!-- Set to yes if software is discontinued, otherwise omit. -->
| ver layout = <!-- simple (default) or stacked -->
| ver layout = <!-- simple (default) or stacked -->
| latest release version = 11.0.9D
| latest release version = 11.0.9E
| latest release date = {{Start date and age|2025|07|16|df=yes/no}}
| latest release date = {{Start date and age|2025|09|11|df=yes/no}}
| latest preview version = 11.0.8C
| latest preview version = 11.0.8C
| latest preview date = {{Start date and age|2024|04|22|df=yes/no}}
| latest preview date = {{Start date and age|2024|04|22|df=yes/no}}
Line 60: Line 60:
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.
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>
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>, which also enables support for [[SQLAlchemy]]<ref>{{Cite web|url=https://pypi.org/project/sqlalchemy-mimer/}}</ref>.


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>
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 |date=24 April 2013 }}</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|url-status=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|url-status=live|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>
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|url-status=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|url-status=live|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>

Latest revision as of 10:07, 15 December 2025

Script error: No such module "Infobox".Template:Template other Script error: No such module "Check for unknown parameters".Script error: No such module "Check for conflicting parameters". 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]

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

since July 2025Template:Dated maintenance category (articles)Script error: No such module "Check for unknown parameters". the Mimer SQL database server is currently supported on the main platforms of Windows, MacOS, Linux, QNX, 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 at build time, and components can be added, removed or replacing in the foundation product to achieve a derived product suitable for embedded, or small footprint application.[11]

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.[11] Additionally cancustom embedded approaches 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 QNX.[9]

The database is available in 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]

In May 2025 was a joint product between the British company Trustonic and Mimer announced, called 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.

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], which also enables support for SQLAlchemy[15].

The Mimer Provider Manager is an ADO.NET provider dispatcher that uses different plugins to access different underlying ADO.NET providers.[16][17] The Mimer Provider Manager makes it possible to write database independent ADO.NET applications.[18]

Mimer SQL mainly uses optimistic concurrency control (OCC) to manage concurrent transactions.[19][20]

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

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 doingTemplate:Snd managing data.

See also

  • Werner SchneiderTemplate:Snd the professor who started the development section for the relational database that became Mimer SQL (Swedish article)

References

<templatestyles src="Reflist/styles.css" />

  1. ↑ Script error: No such module "citation/CS1".
  2. ↑ a b c d Script error: No such module "citation/CS1".
  3. ↑ Script error: No such module "citation/CS1".
  4. ↑ Script error: No such module "citation/CS1".
  5. ↑ Script error: No such module "citation/CS1".
  6. ↑ Script error: No such module "citation/CS1".
  7. ↑ Script error: No such module "citation/CS1".
  8. ↑ Script error: No such module "citation/CS1".
  9. ↑ a b Script error: No such module "citation/CS1".
  10. ↑ Script error: No such module "citation/CS1".
  11. ↑ a b c Script error: No such module "citation/CS1".
  12. ↑ Script error: No such module "citation/CS1".
  13. ↑ Template:Cite thesis
  14. ↑ Script error: No such module "citation/CS1".
  15. ↑ Script error: No such module "citation/CS1".
  16. ↑ Script error: No such module "citation/CS1".
  17. ↑ Script error: No such module "citation/CS1".
  18. ↑ Script error: No such module "citation/CS1".
  19. ↑ Script error: No such module "citation/CS1".
  20. ↑ Template:Cite thesis
  21. ↑ Script error: No such module "citation/CS1".

Script error: No such module "Check for unknown parameters".

External links

Retrieved from "http://debianws.lexgopc.com/wiki143/index.php?title=Mimer_SQL&oldid=4529424"