What users are saying about

1010data

5 Ratings

MonetDB

1 Ratings

1010data

5 Ratings
Score 4.2 out of 101

MonetDB

1 Ratings
Score 7 out of 101

Add comparison

Likelihood to Recommend

1010data

The software is excellent for any application which is too large for Excel. The visual interface surpasses that of most SQL platforms. It is quite useful for data mining in an exploratory way but less useful in statistical and regression analysis.
Marc Gilbert profile photo

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.
Timothy Suh 서의선 profile photo

Pros

  • Crunches huge datasets
  • Has versatility in functionality and grouping capabilities
  • Native XML macro language is easy to master
  • The platform has great visualization tools
Marc Gilbert profile photo
  • 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.
Timothy Suh 서의선 profile photo

Cons

  • The ten.do interface could use more detailed documentation
Marc Gilbert profile photo
  • 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.
Timothy Suh 서의선 profile photo

Usability

1010data8.0
Based on 1 answer
That's votes by our team.
Henry PAN profile photo
No score
No answers yet
No answers on this topic

Alternatives Considered

While we have used SQL, 1010data is really the only industry standard product available for our use.
Marc Gilbert profile photo
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.
Timothy Suh 서의선 profile photo

Return on Investment

  • This has sped up the process of analysis.
  • We can now automate process which were performed manually.
  • Analysis can be performed more frequently.
Marc Gilbert profile photo
  • 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.
Timothy Suh 서의선 profile photo

Pricing Details

1010data

General
Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No
Additional Pricing Details

MonetDB

General
Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No
Additional Pricing Details