MonetDB

MonetDB is a long standing solution when it comes to dealing with extremely large data sets, unsuitable to be managed from a classical relational database (row-store systems).

It successfully implements a column-store system, in which data and relations are represented vertically, on a per column basis.

This page leads to the MonetDB source code package. If you don't wish to compile your own version of MonetDB, official database binaries can be downloaded for Mac, Windows and Linux.

What is new in this release:

• Fixed adding of 0 intervals to dates.
• The libraries included in the Windows installers have been upgraded. We now use libxml2-2.9.2, openssl-1.0.1j, pcre-8.36, and zlib-1.2.8.
• Implemented a change to the way in which string bats are appended. We now try harder to limit the growth of the string heap.
• Fixed sys.queue() implementation to report on other queries being executed.
• A number of bugs were fixed in the code to upgrade a database from previous releases. This version should fix the upgrade of a database that had been upgraded to the Oct2014 release, but also properly upgrade directly from Jan2014 and Feb2013 releases.

What is new in version 11.19.9:

• Fixed adding of 0 intervals to dates.
• The libraries included in the Windows installers have been upgraded. We now use libxml2-2.9.2, openssl-1.0.1j, pcre-8.36, and zlib-1.2.8.
• Implemented a change to the way in which string bats are appended. We now try harder to limit the growth of the string heap.
• Fixed sys.queue() implementation to report on other queries being executed.
• A number of bugs were fixed in the code to upgrade a database from previous releases. This version should fix the upgrade of a database that had been upgraded to the Oct2014 release, but also properly upgrade directly from Jan2014 and Feb2013 releases.

What is new in version 11.19.3:

• Removed algebra.materialize.
• Removed algebra.kunique and algebra.tunique. They were subsumed by algebra.subunique.
• Remove algebra.antiuselect and algebra.thetauselect. They were subsumed by algebra.subselect.
• Removed algebra.topN and its imlementation BATtopN. The function was not used.
• Removed aggr.histogram and its implementation BAThistogram. The function was not used, and did not produce output in the "headless" (i.e. dense-headed) format. Histograms can be created as a by-product of group.subgroup.

What is new in version 11.17.17:

• Lots of minor fixes were made for potential defects found by Coverity Scan.
• On Windows we now build the geom module against version 3.4.2 of the geos library.

What is new in version 11.17.9:

• Created development packages for RPM based systems and Debian/Ubuntu containing the files needed to create extensions to the SQL front end.
• Removed Mx, the literate programming tool. All code for the server is now pure C.
• Created packages for RPM based systems and Debian/Ubunty containing the MonetDB interface to the GNU Scientific Library (gsl).
• No longer install the .la files in our Fedora/Debian/Ubuntu packages.
• ODBC: Implemented {fn scalar()} and {interval ...} escapes.
• Changed defaults for connecting (defaults to unix socket now).
• Unix sockets partially working for control protocol.
• Added support for the Unix socket.

What is new in version 11.15.15:

• MonetDB now no longer compresses output when not connected to a terminal.
• Readonly tables call for UNSET.
• Remote client connection stays in CLOSE_WAIT state.
• Uninitialized memory causing bad output in query plans.
• ALTER TABLE operations silently remove previously set READ ONLY property.
• A join causes SIGSEGV after creation of Unique Key.
• Fully qualified order by column gives "relational query without result".
• � Byte appears in MAPI.

What is new in version Oct 2012:

• Removed module attach since it wasn't used or even tested.
• The MAL-to-C Compiler (mcc) was removed. The code wasn't tested and most likely non-functional.
• Fixed timestamp arithmetic very slow (especially on Windows).
• Fixed Python tests fail after recent Python API changes.
• Provides an option for setting discovery to false.