Skip to main content

Blogs

Remote Tables and Authorization

Remote table authorization has changed in the upcoming August 2018 MonetDB release. Previously any physical execution plan that was accessing data in remote tables, was using the hardcoded strings "monetdb"/"monetdb" for username and password in order to connect to the server where the actual data was residing. Besides the obvious security implications, this behavior means that the remote table feature cannot be used if the DBA has changed the password for the user monetdb.

IoT and streaming in MonetDB

Internet-of-Things Database Server

With the expansion of IoT market, database systems with support for streaming data has acquired increasing attention. In an IoT scenario, data is collected in the periphery of a  sensor network, assembled and aggregated by message brokers, and delivered at the doorstep of the database system. There, they are fed into a dataflow based processing pipeline to derive actionable knowledge or to become the basis for interactive data exploration.

JIT C/C++ UDFs in MonetDB

As of the latest MonetDB release (March 2018), MonetDB has support for JIT C and C++ UDFs. MonetDB has supported regular C/C++ UDFs for a long time. However, these are quite complicated to write and compile, as they require a lot of knowledge about the internal structure of MonetDB and require a lot of steps just to write a simple function.

MonetDBLite for Java

Following the footsteps of MonetDBLite for R and MonetDBLite for Python, we now have MonetDBJavaLite which deploys MonetDBLite in a JVM with JDBC support. It has been tested on Linux, Mac and Windows. In the "lite" versions of MonetDB, both client and server run within the same process, saving eventual inter-process communication such as a socket connection.

Interactive Debugging for Python UDFs

In a previous blogpost we introduced Python UDfs (aka MonetDB/Python). With MonetDB/Python users can perform analytics inside the database, mitigating the costs of data transference.

Subscribe to Blogs