MonetDB vs. SAP Adaptive Server Enterprise (ASE), legacy

Overview
ProductRatingMost Used ByProduct SummaryStarting Price
MonetDB
Score 7.0 out of 10
N/A
MonetDB is an open source column-oriented relational database management system issued and supported by the Dutch MonetDB development team.N/A
SAP Adaptive Server Enterprise (ASE), legacy
Score 8.1 out of 10
N/A
SAP® Adaptive Server® Enterprise (SAP ASE) was a solution that handled massive volumes of data and thousands of concurrent users to accelerate the growth of new data-driven business applications. SAP ASE is a legacy product. It is end of sale (EOS), and reached End of Mainstream Maintenance December 2020.N/A
Pricing
MonetDBSAP Adaptive Server Enterprise (ASE), legacy
Editions & Modules
No answers on this topic
No answers on this topic
Offerings
Pricing Offerings
MonetDBSAP Adaptive Server Enterprise (ASE), legacy
Free Trial
NoNo
Free/Freemium Version
NoNo
Premium Consulting/Integration Services
NoNo
Entry-level Setup FeeNo setup feeNo setup fee
Additional Details
More Pricing Information
Community Pulse
MonetDBSAP Adaptive Server Enterprise (ASE), legacy
Top Pros
Top Cons
Best Alternatives
MonetDBSAP Adaptive Server Enterprise (ASE), legacy
Small Businesses
SingleStore
SingleStore
Score 9.7 out of 10
SingleStore
SingleStore
Score 9.7 out of 10
Medium-sized Companies
SingleStore
SingleStore
Score 9.7 out of 10
SingleStore
SingleStore
Score 9.7 out of 10
Enterprises
SingleStore
SingleStore
Score 9.7 out of 10
SingleStore
SingleStore
Score 9.7 out of 10
All AlternativesView all alternativesView all alternatives
User Ratings
MonetDBSAP Adaptive Server Enterprise (ASE), legacy
Likelihood to Recommend
7.0
(2 ratings)
10.0
(2 ratings)
Likelihood to Renew
-
(0 ratings)
10.0
(1 ratings)
Usability
-
(0 ratings)
9.0
(1 ratings)
Support Rating
-
(0 ratings)
9.7
(2 ratings)
User Testimonials
MonetDBSAP Adaptive Server Enterprise (ASE), legacy
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.
Read full review
Discontinued Products
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.
Read full review
Pros
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
Discontinued Products
  • 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
Read full review
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.
Read full review
Discontinued Products
  • Full database encryption - need to utilize external keys vs internal - for better separation of duties.
  • History Tables.
Read full review
Likelihood to Renew
MonetDB
No answers on this topic
Discontinued Products
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.
Read full review
Usability
MonetDB
No answers on this topic
Discontinued Products
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.
Read full review
Support Rating
MonetDB
No answers on this topic
Discontinued Products
Incredibly responsive, saving us countless hours in troubleshooting.
Read full review
Alternatives Considered
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
Discontinued Products
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.
Read full review
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.
Read full review
Discontinued Products
  • Negative - Costs a lot ... but so do they all.
  • Positive - It does what we need it to do.
Read full review
ScreenShots