Blogs

Today we are happy to present MonetDBLite for R, a fully embedded version of MonetDB that installs like any other R package. The database runs within the R process itself (like its namesake SQLite), greatly improving efficiency of data transfers. The package is available for Linux, Mac OS X and Windows (64 bit). 

The MonetDB team at CWI & MonetDB Solutions is pleased to announce the Jul2015-SP1 release of the MonetDB suite of programs.

Client Package: In the SQL formatter of mclient (the default) we now properly align East Asian wide characters.

Ruby Driver: The Ruby driver has been fixed-up, improved and is now compatible with Ruby version 2.0 and up.

JDBC Driver: Fixes for the setSchema() method.

Python is one of the most popular languages in Data Science. It is a flexible scripting language that is easy to use and has a large amount of available statistical libraries. When we're doing statistical analysis in Python, we naturally need data accessible to us in Python in some way. And what better place to keep data than in a database.

Today, astronomers are facing some of the hardest challenges working with petabyte-scale databases. Meng Wan, a researcher of the National Astronomical Observatories, Chinese Academy of Sciences (NAOC), has developed a data processing pipeline based on MonetDB for the Space-based multiband astronomical Variable Objects Monitor (SVOM) project [1], during her visit at the Database Architectures group of CWI. The pipeline is expected to store over 5 PB of data, while providing responses within seconds.

Since the release of the MonetDB Node.js module, we embarked on a small project to provide a RESTful interface to MonetDB. The MonetDB RESTful Proxy [1] [2] gives you a REST interface to access common database functionality.  In addition the proxy has an extended functionality for easier handling of JSON documents.