Skip to main content

Blogs

Faster, robuster and feature richer: MonetDB in 2020 and beyond

The MonetDB team has completed her major development strands for 2020. The MonetDB Oct2020 feature release includes significant improvements in performance under frequent bulk-update transactions, highly requested features such as point-in-time database backup and more analytics features, and many more extensions for the convenience of application developers.

Doctor, what’s happening with my query in the MonetDB kernel?

All database users will recognize this situation. A user has started a query and it takes ages before the result set is available or, even worse, the database server seems unresponsive. In production systems, this is countered by logging all queries whose response time exceed a high-watermark or to tap into the system using a network monitoring system to observe its CPU and I/O behaviour. However, this only helps in post-mortem analysis. Monitoring all running queries alone is also not sufficient. It can only raise the red flag.

From automake to CMake: a facelift for our build infrastructure

The MonetDB project runs since early 1993 when the first lines of code were written. Initially developed for Unix only, it became clear that moving MonetDB into the open-source community in 2003 comes with the obligation to make it available on many platforms.

Tags

SQL:1999 grouping combinations now supported in MonetDB

As of MonetDB Jun2020 release, we have added support for ROLLUP, CUBE and GROUPING SETS features defined by the SQL:1999 standard in the GROUP BY clause. These keywords allow one to perform multiple grouping set combinations in a single statement, containing partial and total computed results. At the same time, the GROUPING aggregate, which identifies the grouping columns used in the output, has also been implemented.

Subscribe to Blogs