What users are saying about
5 Ratings
2 Ratings
5 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener'>trScore algorithm: Learn more.</a>
Score 9.3 out of 100
2 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener'>trScore algorithm: Learn more.</a>
Score 7 out of 100

Attribute Ratings

  • ClickHouse is rated higher in 1 area: Likelihood to Recommend

Likelihood to Recommend

9.0

ClickHouse

90%
2 Ratings
7.0

MonetDB

70%
2 Ratings

Likelihood to Recommend

Yandex

1) An extensive SQL syntax. A lot of functions are included (including GeoDistances, Uber Hexagons, time functions, comprehensive Mah, and many others). Several functions can be combined (e.g. SumIf, AvgIf, etc.) which is very convenient. 2) It is quick. The arrays and MapReduce make CH work lightning fast. I was extremely surprised when several GBs of data were processed in less than a second. 3)A fast response time. Using Materialized Views correctly allows instant processing of TBs of data, which works differently than in other databases. 4)This is an efficient process. It is possible to store data extremely efficiently by using a wide range of data types and compression algorithms. Choose the best compression type for your tables based on the documentation. There will be a lot of surprises for you.
Read full review

MonetDB

MonetDB is great when you are performing adhoc queries on a large set of data. For example, if you store data in a typical RDBMS such as MySQL or Postgres and want to join large tables for analytics but the query runs unacceptably slow then MonetDB can act as a second database to offload complex queries. Based on my experience, it may not be a production-ready database since there aren't many DBAs familiar with it and due to lack of documentation, maintenance can become a little tricky.
Read full review

Pros

Yandex

  • Opensource
  • High performance
  • Multiple engines to adapt user cases
  • Easy configuration of data replication
Read full review

MonetDB

  • 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.
Read full review

Cons

Yandex

  • Unable to make custom functions
  • So many times it required to use multiple joins
  • I faced a lot of problems with Zookeeper, Partitioning, Sharding, and replication.
Read full review

MonetDB

  • 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.
Read full review

Pricing Details

ClickHouse

Starting Price

Editions & Modules

ClickHouse editions and modules pricing
EditionModules

Footnotes

    Offerings

    Free Trial
    Free/Freemium Version
    Premium Consulting/Integration Services

    Entry-level set up fee?

    No setup fee

    Additional Details

    MonetDB

    Starting Price

    Editions & Modules

    MonetDB editions and modules pricing
    EditionModules

    Footnotes

      Offerings

      Free Trial
      Free/Freemium Version
      Premium Consulting/Integration Services

      Entry-level set up fee?

      No setup fee

      Additional Details

      Alternatives Considered

      Yandex

      ClickHouse was not compared to them as a competitor but as the ideal partner to complete an information analysis system, providing users with the most complete and efficient tools. Therefore, in this case it was considered that it would be the ideal candidate due to its characteristics compared to the other competitors.
      Read full review

      MonetDB

      We have used Five9 in my previous company but on a much smaller scale. It was more expensive, however we were using it for a max of 50 employees, now we need a much bigger platform. We also used Five9 for other things, like phone dialers etc. so it was a little different.
      Read full review

      Return on Investment

      Yandex

      • It help our software to run with more and more amount of monitors.
      • Very easy to working while DR-DC scenario happened at client side.
      • Structured of DB with column-oriented data help a lot to reducing I/O of that server.
      Read full review

      MonetDB

      • 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.
      Read full review

      Add comparison