MonetDB is an open source column-oriented relational database management system issued and supported by the Dutch MonetDB development team.
N/A
Presto
Score 2.6 out of 10
N/A
Presto is an open source SQL query engine designed to run queries on data stored in Hadoop or in traditional databases.
Teradata supported development of Presto followed the acquisition of Hadapt and Revelytix.
I think for what we use it for, mainly scheduling, forecast and to compare against payroll, it works well. I think there are some other things that could be added to it to use, like more expansive ways to use the forecasting tool and an easier way to pull previous data from prior years. This would help making the forecast for scheduling in the future.
Simple stories & templates work nicely - like for our Insider program. Stories that include a lot of images may be challenging to create & have look appealing.
Linking, embedding links and adding images is easy enough.
Once you have become familiar with the interface, Presto becomes very quick & easy to use (but, you have to practice & repeat to know what you are doing - it is not as intuitive as one would hope).
Organizing & design is fairly simple with click & drag parameters.
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.
Presto was not designed for large fact fact joins. This is by design as presto does not leverage disk and used memory for processing which in turn makes it fast.. However, this is a tradeoff..in an ideal world, people would like to use one system for all their use cases, and presto should get exhaustive by solving this problem.
Resource allocation is not similar to YARN and presto has a priority queue based query resource allocation..so a query that takes long takes longer...this might be alleviated by giving some more control back to the user to define priority/override.
UDF Support is not available in presto. You will have to write your own functions..while this is good for performance, it comes at a huge overhead of building exclusively for presto and not being interoperable with other systems like Hive, SparkSQL etc.
There is a plethora of choices when it comes to NoSQL and columnar based databases. We use not one but sometimes 2 or 3 of them to carry out a specific purpose. We chose MonetDB because our engineering team enjoys working with open source software and appreciates its simplicity although becoming familiar with it did take time. I would not deploy MonetDB to production but it's a great backup option.
I think Presto is one of the best solutions out there today at the cutting edge for interactive query analysis. One of the challenges is presto is a niche tool for the interactive query use case and doesn't have the knobs and whistles as much as Spark. In the foreseeable future if they are able to make presto work without the need for Hive, solving all the gaps it could be game changing and can be a direct threat to spark
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.
