MonetDB

From Wikipedia, the free encyclopedia
MonetDB
Developer(s) MonetDB Developer Team
Stable release Feb2013-SP2 / April 30, 2013 (2013-04-30)
Written in C
Operating system Cross-platform
Type Database management system
License MonetDB License (based on the MPL)
Website www.monetdb.org

MonetDB is an open source column-oriented database management system developed at the Centrum Wiskunde & Informatica (CWI) in the Netherlands. It was designed to provide high performance on complex queries against large databases, such as combining tables with hundreds of columns and multi-million rows. MonetDB has been applied in high-performance applications for data mining, online analytical processing, geographic information systems, XML Query (XQuery), text and multimedia retrieval.

History

MonetDB (initially only called Monet) was first created by 2002 doctoral student Peter Alexander Boncz and professor Martin L. Kersten as part of the 1990s MAGNUM research project at University of Amsterdam.[1] The first version under an open-source software license (a modified version of the Mozilla Public License) was released on September 30, 2004.[2]

MonetDB internal data representation relies on the memory addressing ranges of contemporary CPUs using demand paging of memory mapped files, and thus departing from traditional DBMS designs involving complex management of large data stores in limited memory.

MonetDB introduced innovations at all database management system layers: a storage model based on vertical fragmentation, a modern CPU-tuned query execution architecture that often gave MonetDB a speed advantage on the same algorithm over a typical interpreter-based RDBMS. MonetDB is one of the first database systems to focus its query optimization effort on exploiting CPU caches. MonetDB also features automatic and self-tuning indexes, run-time query optimization, and a modular software architecture.[3][4]

The MonetDB family consists of:

  • MonetDB/SQL: the relational database system
  • MonetDB/GIS: extension to MonetDB/SQL with support for the Simple Features standard of OpenGIS[5]
  • MonetDB Server: the multi-model database server

By 2008, a follow-on project called X100 was begun, which evolved into the Vectorwise technology that was acquired by Actian Corporation and sold as a commercial product.[6]

See also

References

  1. ↑ "Monet: A Next-Generation DBMS Kernel For Query-Intensive Applications". Ph.D. Thesis (Universiteit van Amsterdam). May 2002. 
  2. ↑ Release Notes for Version 4.4.0
  3. ↑ Stefan Manegold (June 2006). "An Empirical Evaluation of XQuery Processors". Proceedings of the International Workshop on Performance and Evaluation of Data Management Systems (ExpDB) (ACM). doi:10.1016/j.is.2007.05.004. Retrieved December 11, 2013. 
  4. ↑ P. A. Boncz, T. Grust, M. van Keulen, S. Manegold, J. Rittinger, J. Teubner. MonetDB/XQuery: A Fast XQuery Processor Powered by a Relational Engine. In Proceedings of the ACM SIGMOD International Conference on Management of Data, Chicago, IL, USA, June 2006.
  5. ↑ "GeoSpatial - MonetDB". 16 January 2013. 
  6. ↑ Marcin Zukowski and Peter Boncz (May 20, 2012). "From x100 to vectorwise: opportunities, challenges and things most researchers do not think about". Proceedings of the 2012 ACM SIGMOD International Conference on Management of Data (ACM): 861–862. doi:10.1145/2213836.2213967. ISBN 978-1-4503-1247-9. 

External links

GUI tools for MonetDB/XQuery:

This article is based on material taken from the Free On-line Dictionary of Computing prior to 1 November 2008 and incorporated under the "relicensing" terms of the GFDL, version 1.3 or later.

This article is issued from Wikipedia. The text is available under the Creative Commons Attribution/Share Alike; additional terms may apply for the media files.