MonetDB

Score7 out of 10

2 Reviews and Ratings

What is MonetDB?

MonetDB is an open source column-oriented relational database management system issued and supported by the Dutch MonetDB development team.

Categories & Use Cases

Relational Databases

Kellie Mizel View profile

Central Station Operations Manager in Customer Service at Envera Systems (201-500 employees employees)

Pros

It is easy to use.
You are able to input lots of data and it understands and populates information.
Able to change settings on the fly to use with your needs.

Cons

We use it so much, it can be slow at times to refresh.
It is very particular with the way you enter information, if not entered exactly correct, it won't schedule.
Reports sometimes take forever to populate.

Most Important Features

Employee information.
Scheduling.
Forecasting.

Return on Investment

Reduced cost, compared to other platforms.
Makes scheduling much easier.
Increased Efficiency on future reporting.

Alternatives Considered

Five9

Other Software Used

Five9, RingCentral, RingCentral Meetings

Timothy Suh 서의선 View profile

Solution Architect in Engineering at GuestMetrics, LLC. (11-50 employees employees)

Pros

It performs very well with both a simple and complex query with multiple join operations.
It offers more advanced, enterprise level features such as clustering, data partitioning, and distributed query processing.
Loading bulk data is quite fast by taking advantage of multiple cores/CPUs.

Cons

This is an open source software so there are obvious drawbacks, the biggest of which is a lack of documentation.
MonetDB does not seem to be well known outside of the academic environment so there is less information when you are searching for answers of any type.
I'd like to see more use cases and/or best practices so that commercial companies like ours can optimally use all of its highly performant features.
The code is written in C/C++ and this can be negative if you are a mainly java-shop and need UDF - User Defined Function.

Return on Investment

If you are familiar with a general database concept and played with open source products before then MonetDB will give you immediate return in terms of productivity since developers can quickly develop and verify their test cases involving back-end database with a large sample data set.
There is a stiff learning curve due to lack of documentation and sparse information available on the internet.
Overall experience has been positive since MonetDB gives you another option when it comes to building out a data warehouse.

Other Software Used

Amazon Redshift, PostgreSQL, Apache Hive