Mimer SQL: Difference between revisions

Revision as of 19:35, 9 May 2017

Revision as of 19:36, 9 May 2017

Line 1:

'''Mimer SQL''' is an [[SQL]]-based [[relational database management system]] from the [[Sweden|Swedish]] company ''Mimer Information Technology AB'' (formerly ''Upright Database Technology AB''),. whichIt has been developed and produced since the 1970s. Mimerwhen SQLit offerswas afounded scalableat and portable solution and provide servers for environments that spans fromthe [[embeddedUppsala systems|embedded]] and [[real-time operating systems]] to [[enterprise systems]]. This includes platforms like [[Microsoft Windows|WindowsUniversity]], [[MacOSUppsala]], [[LinuxSweden]], [[Android]], [[Unix]], [[OpenVMS]], and [[VxWorks]] <ref name="platforms">{{webbref | url = http://developer.mimer.com/platforms/index.tml | title = Mimer SQL Products & Platforms | work = Mimer Developers – Platforms | date = 5 May 2017}}</ref>. Unlike other competing DBMSes, Mimer SQL only implements [[optimistic concurrency control]] (OCC) <ref>{{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}}</ref>.

The name "Mimer" is taken from the [[Norse mythology]], where [[Mímir|Mimer]] was the giant guarding the well of wisdom, also knows as "[[Mímisbrunnr]]". Metaphorically is this what Mimer SQL does - manages data.

The main teub ta mrr characteristics of Mimer SQL are zero maintenance, small [[memory footprint]] and high performance <ref name="footprint">{{bokref | title = Mimer SQL Technical Description | url = http://developer.mimer.com/documentation/WhitePapers/Technical_Description/MIMTECDESC.pdf | format = [[Portable Document Format|PDF]] | author= Mimer Information Technology | chapter = Technical Benefits Overview}}</ref>. These attributes are based on a number of technical solutions to handle some of the more complicated functionality that a database management system must provide.

As mentioned, Mimer SQL usesoffers optimistica concurrencyscalable controland whichportable providessolution aproviding solution[[Database toserver|database theservers]] problemfor ofenvironments allowingthat simultaneousspans accessfrom [[embedded systems|embedded]] and [[real-time operating systems]] to the[[enterprise databasesystems]]. withoutThis theincludes dangerplatforms oflike a[[Microsoft Windows|Windows]], [[deadlockMacOS]], occurring[[Linux]], [[Android]], [[Unix]], [[OpenVMS]], and [[VxWorks]] <ref name="transaction-managementplatforms">{{webbref | url = http://developer.mimer.secom/featuresplatforms/feature_12index.htm/tml | title = TransactionMimer SQL Products & ManagementPlatforms | work = Mimer Developers – FeaturesPlatforms | date = 5 May 2017}}</ref>. This may simplify database management and allow truly scalable performance, even during heavy system load.

TheSome mainof teubthe ta mrrmain characteristics offor Mimer SQL are zerohigh maintenanceperformance, small [[memory footprint]] and higha performancelow level of maintenance <ref name="footprint">{{bokref | title = Mimer SQL Technical Description | url = http://developer.mimer.com/documentation/WhitePapers/Technical_Description/MIMTECDESC.pdf | format = [[Portable Document Format|PDF]] | author= Mimer Information Technology | chapter = Technical Benefits Overview}}</ref>. These attributes are based on a number of technical solutions to handle some of the more complicated functionality that a database management system must provide.

Another technical innovation is the data storage mechanism, which is constantly optimized for maximum performance and ensures that no manual reorganization of the database is ever needed <ref name="data-storage">{{webbref | url = http://developer.mimer.se/features/feature_11.htm/ | title = Data Storage in Mimer SQL | work = Mimer Developers – Features | date = 5 May 2017}}</ref>.

Mimer SQL uses [[optimistic concurrency control]] (OCC) <ref>{{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}}</ref> which provides a solution to the problem of allowing simultaneous access to the database without the danger of a [[deadlock]] occurring <ref name="transaction-management">{{webbref | url = http://developer.mimer.se/features/feature_12.htm/ | title = Transaction Management | work = Mimer Developers – Features | date = 5 May 2017}}</ref>. This may simplify database management and allow truly scalable performance, even during heavy system load.

Another technical innovationissue is the data storage mechanism, which in Mimer SQL is implemented to be constantly optimized for maximum performance. This andalso ensures that no manual reorganization of the database is ever needed <ref name="data-storage">{{webbref | url = http://developer.mimer.se/features/feature_11.htm/ | title = Data Storage in Mimer SQL | work = Mimer Developers – Features | date = 5 May 2017}}</ref>.

The database management language Mimer SQL ([[Structured Query Language]]) is compatible in all essential features with the currently accepted SQL standards <ref name="standard-sql">{{webbref | url = http://developer.mimer.se/standard/ | title = Mimer SQL Standard Compliance | work = Mimer Developers – SQL Standard | date = 5 May 2017}}</ref>.