1 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 7 out of 100
51 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 9.2 out of 100

Likelihood to Recommend

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 서의선 | TrustRadius Reviewer

SAP Adaptive Server Enterprise (ASE), legacy

High-performance, high-concurrency transactions are well suited for ASE. ASE is lacking some features in my opinion such as history tables, however there are ways to implement them via workarounds or by using Replication Server. I do think the way the ASE parser and optimizer works are far superior to other products as it is a true cost-based optimizer and the order of the tables in the FROM clause does not really matter although a good SQL coder will place the tables in a meaningful order to make the SQL more readable. ASE is good for applications that require high availability and can be used for mission critical systems.
Gene Baker | TrustRadius Reviewer

Pros

MonetDB

  • 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 서의선 | TrustRadius Reviewer

SAP Adaptive Server Enterprise (ASE), legacy

  • Easy to setup and maintain
  • Reliable, rarely has major hiccups requiring reboots or crashes
  • Very responsive with complicated queries spanning various tablespaces and hundreds of millions of rows
Zhann Goloborodko | TrustRadius Reviewer

Cons

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.
Timothy Suh 서의선 | TrustRadius Reviewer

SAP Adaptive Server Enterprise (ASE), legacy

  • Full database encryption - need to utilize external keys vs internal - for better separation of duties.
  • History Tables.
Gene Baker | TrustRadius Reviewer

Likelihood to Renew

MonetDB

No score
No answers yet
No answers on this topic

SAP Adaptive Server Enterprise (ASE), legacy

SAP Adaptive Server Enterprise (ASE), legacy 10.0
Based on 1 answer
Our licenses are perpetual. It is the support that we will be renewing. We will renew because we continue to use and receive value from the product.
Gene Baker | TrustRadius Reviewer

Usability

MonetDB

No score
No answers yet
No answers on this topic

SAP Adaptive Server Enterprise (ASE), legacy

SAP Adaptive Server Enterprise (ASE), legacy 9.0
Based on 1 answer
It does almost everything we need and for the things it doesn't do natively, we are still able to do using other features. For example, natively history tables weren't supported but we were able to create them using triggers.
Gene Baker | TrustRadius Reviewer

Support Rating

MonetDB

No score
No answers yet
No answers on this topic

SAP Adaptive Server Enterprise (ASE), legacy

SAP Adaptive Server Enterprise (ASE), legacy 9.5
Based on 4 answers
Incredibly responsive, saving us countless hours in troubleshooting.
Zhann Goloborodko | TrustRadius Reviewer

Alternatives Considered

MonetDB

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 서의선 | TrustRadius Reviewer

SAP Adaptive Server Enterprise (ASE), legacy

Much less effort than Oracle. Much better customer support than Oracle.Roughly equivalent to SQL Server in performance and ease of use. Much better customer service than SQL Server.Different ballpark from IQ. Same customer service.
Zhann Goloborodko | TrustRadius Reviewer

Return on Investment

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.
Timothy Suh 서의선 | TrustRadius Reviewer

SAP Adaptive Server Enterprise (ASE), legacy

  • Negative - Costs a lot ... but so do they all.
  • Positive - It does what we need it to do.
Zhann Goloborodko | TrustRadius Reviewer

Pricing Details

MonetDB

General

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

SAP Adaptive Server Enterprise (ASE), legacy

General

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

Add comparison