|
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 online analytical processing (OLAP), data mining, GIS,〔(【引用サイトリンク】 GeoSpatial - MonetDB )〕 RDF,〔(【引用サイトリンク】 MonetDB - LOD2 - Creating Knowledge out of Interlined Data )〕 text retrieval and sequence alignment processing.〔(【引用サイトリンク】 Life Sciences in MonetDB )〕 == History == Data mining projects in the 1990s required improved analytical database support. This resulted in a CWI spin-off called Data Distilleries, which used early MonetDB implementations in its analytical suite. Data Distilleries eventually became a subsidiary of SPSS in 2003, which in turn was acquired by IBM in 2009.〔(【引用サイトリンク】 A short history about us - MonetDB )〕 MonetDB in its current form was first created in 2002 by doctoral student (Peter Alexander Boncz ) and professor Martin L. Kersten as part of the 1990s MAGNUM research project at University of Amsterdam. It was initially called simply Monet, after the French impressionist painter Claude Monet. The first version under an open-source software license (a modified version of the Mozilla Public License) was released on September 30, 2004. When MonetDB version 4 was released into the open-source domain and many extensions to the code base were added by the MonetDB/CWI team. These included a new SQL frontend, supporting the SQL:2003 standard.〔(MonetDB historic background )〕 MonetDB introduced innovations in all layers of the DBMS: a storage model based on vertical fragmentation, a modern CPU-tuned query execution architecture that often gave MonetDB a speed advantage over the same algorithm over a typical interpreter-based RDBMS. It was one of the first database systems to tune query optimization for CPU caches. MonetDB includes automatic and self-tuning indexes, run-time query optimization, and a modular software architecture.〔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.〕 By 2008, a follow-on project called X100 (MonetDB/X100) started, which evolved into the VectorWise technology. VectorWise was acquired by Actian Corporation, integrated with the Ingres database and sold as a commercial product. In 2011 a major effort to renovate the MonetDB codebase was started. As part of it, the code for the MonetDB 4 kernel and its XQuery components were frozen. In MonetDB 5, parts of the SQL layer were pushed into the kernel.〔 The resulting changes created a difference in internal APIs, as it transitioned from MonetDB Instruction Language (MIL) to MonetDB Assembly Language (MAL). Older, no-longer maintained top-level query interfaces were also removed. First was XQuery, which relied on MonetDB 4 and was never ported to version 5.〔(【引用サイトリンク】 XQuery )〕 The experimental Jaql interface support was removed with the October 2014 release.〔(【引用サイトリンク】 title= MonetDB Oct2014 Release Notes )〕 With the July 2015 release, MonetDB gained support for read-only data sharding and persistent indices. In this release the deprecated streaming data module DataCell was also removed from the main codebase in an effort to streamline the code.〔(【引用サイトリンク】 title= MonetDB July2015 Released )〕 抄文引用元・出典: フリー百科事典『 ウィキペディア（Wikipedia）』 ■ウィキペディアで「MonetDB」の詳細全文を読む スポンサード リンク
|