Jump to content

Mnesia

From Wikipedia, the free encyclopedia

This is an old revision of this page, as edited by BG19bot (talk | contribs) at 07:25, 29 January 2016 (WP:CHECKWIKI error fix for #61. Punctuation goes before References. Do general fixes if a problem exists. - using AWB (11842)). The present address (URL) is a permanent link to this revision, which may differ significantly from the current revision.

Mnesia
Developer(s)Ericsson
Stable release
4.11 / January 23, 2014 (2014-01-23)
Written inErlang
Operating systemCross-platform
PlatformCross-platform
TypeRelational Database Management System
LicenseOpen Source Erlang Licence
Websitewww.erlang.org/doc/man/mnesia.html
The LYME (software bundle) is based on Erlang and comprises Mnesia. It's entirely composed of free and open-source software

Mnesia is a distributed, soft real-time database management system written in the Erlang programming language.[1] It is distributed as part of the Open Telecom Platform.

Purpose of Mnesia

As with Erlang, Mnesia was developed by Ericsson for soft real-time distributed and high-availability computing work related to telecoms. It was not intended as a general office-based data processing DBMS, nor to replace SQL-based systems. Instead Mnesia exists to support Erlang, where DBMS-like persistence is required.[2] It has more in common with embeddable DBMS such as Berkeley DB than with a SQL database server.

Working with Mnesia

Database model

"Rows" in tables are represented as records that contain a key value and a data field. This data field may in turn be a tuple containing an Erlang data structure of any complexity.

Relational features

The database model is relational, but isn't what someone familiar with SQL might expect. A database contains tables. Relationships between them are modelled as other tables.[3]

A key feature of Mnesia's high-availability approach is that tables can be reconfigured within a schema and relocated between nodes, not only while the database is still running, but even while write operations are still going on.

Coding for Mnesia

The query language of Mnesia is Erlang itself, rather than SQL.[4] It permits easy representation of transactions as a natural feature of Erlang by allowing developers to utilize a single language throughout an application.

Transactions

Erlang is a functional language. Mnesia builds on this to obtain ACID transaction support. The functional block which is run as a transaction is a commonplace Erlang construct called a Functional Object (or Fun)[5] and is called by the single Mnesia statement mnesia:transaction(F). This can lead to clearer source code than the paired BEGIN / COMMIT syntax of SQL, and so avoids its problem of unclosed transactions within a procedure.

Again as a result of the functional nature of Erlang, nesting transactions is simple. It's also possible to distribute transactions across multiple nodes (i.e. separate servers). The semantics of using transactions in this way remains consistent, making it easy to write library code that works equally in either context.

General coding style for Mnesia will always use transactions. For performance reasons, it also supports deliberate "dirty operations" which avoid transactions. These compromise the atomicity and the isolation properties of ACID, but offer around 10× more throughput.[6] In addition there are also in-memory alternatives, although these lose the durability property of ACID.

Efficient execution

Mnesia forms part of the LYME web application stack. This is akin to LAMP, but based on Erlang. Implementation in Erlang confers an efficiency benefit because of the use of a single VM throughout an application. LYME makes use of this, since the Yaws web server is also implemented in Erlang.

Another low-level boost to efficiency is that address space is shared (although safely so, under Erlang) between code and data, including Mnesia's table data.[1][7]

Origins and licensing

Mnesia (and Erlang) were developed by the Ericsson Computer Science Laboratory. They have been open-sourced "to help encourage the spread of Erlang outside Ericsson." It is released under a derivative of the Mozilla Public License.[8] They are published according to the open source Erlang Public License.[9]

Contemporary interest in Mnesia

ejabberd

Mnesia is also an option embedded within the Erlang-based Jabber daemon, ejabberd.[10]

See also

References

  1. ^ a b Håkan Mattsson, Hans Nilsson, Claes Wikstrom (1999). "Mnesia - A Distributed Robust DBMS for Telecommunications Applications" (PDF).{{cite web}}: CS1 maint: multiple names: authors list (link)
  2. ^ "Purpose of Mnesia". Open-source Erlang project. {{cite web}}: External link in |publisher= (help)
  3. ^ "Mnesia Getting Started guide". Open-source Erlang project. {{cite web}}: External link in |publisher= (help)
  4. ^ "Mnesia Reference Manual (v 4.4.5)". Open-source Erlang project. {{cite web}}: External link in |publisher= (help)
  5. ^ "6.17 Fun Expressions". Open-source Erlang project. {{cite web}}: External link in |publisher= (help)
  6. ^ Gavin Terrill (20 August 2007). "Erlang's Mnesia - a distributed DBMS for highly scalable apps". InfoQ. {{cite journal}}: External link in |journal= (help)
  7. ^ "Mnesia performance basics".
  8. ^ "About Erlang". Open-source Erlang project. {{cite web}}: External link in |publisher= (help)
  9. ^ "Erlang Public License, V 1.1". Open-source Erlang project. {{cite web}}: External link in |publisher= (help)
  10. ^ "ejabberd project homepage".
Retrieved from "https://en.wikipedia.org/w/index.php?title=Mnesia&oldid=702228096"