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

Overview
ProductRatingMost Used ByProduct SummaryStarting Price
Presto
Score 2.7 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.N/A
SAP Adaptive Server Enterprise (ASE), legacy
Score 7.8 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
PrestoSAP Adaptive Server Enterprise (ASE), legacy
Editions & Modules
No answers on this topic
No answers on this topic
Offerings
Pricing Offerings
PrestoSAP 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
PrestoSAP Adaptive Server Enterprise (ASE), legacy
Top Pros
Top Cons
Best Alternatives
PrestoSAP Adaptive Server Enterprise (ASE), legacy
Small Businesses
SingleStore
SingleStore
Score 9.0 out of 10
SingleStore
SingleStore
Score 9.0 out of 10
Medium-sized Companies
SingleStore
SingleStore
Score 9.0 out of 10
SingleStore
SingleStore
Score 9.0 out of 10
Enterprises
SAP IQ
SAP IQ
Score 9.0 out of 10
SAP IQ
SAP IQ
Score 9.0 out of 10
All AlternativesView all alternativesView all alternatives
User Ratings
PrestoSAP Adaptive Server Enterprise (ASE), legacy
Likelihood to Recommend
7.8
(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
PrestoSAP Adaptive Server Enterprise (ASE), legacy
Likelihood to Recommend
Open Source
Presto is for interactive simple queries, where Hive is for reliable processing. If you have a fact-dim join, presto is great..however for fact-fact joins presto is not the solution.. Presto is a great replacement for proprietary technology like Vertica
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
Open Source
  • 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.
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
Open Source
  • 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.
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
Open Source
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
Open Source
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
Open Source
No answers on this topic
Discontinued Products
Incredibly responsive, saving us countless hours in troubleshooting.
Read full review
Alternatives Considered
Open Source
Presto is good for a templated design appeal. You cannot be too creative via this interface - but, the layout and options make the finalized visual product appealing to customers. The other design products I use are for different purposes and not really comparable to Presto.
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
Open Source
  • Presto has helped scale Uber's interactive data needs. We have migrated a lot out of proprietary tech like Vertica.
  • Presto has helped build data driven applications on its stack than maintain a separate online/offline stack.
  • Presto has helped us build data exploration tools by leveraging it's power of interactive and is immensely valuable for data scientists.
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