IBM Cloud Databases are open source data stores for enterprise application development. Built on a Kubernetes foundation, they offer a database platform for serverless applications. They are designed to scale storage and compute resources seamlessly without being constrained by the limits of a single server. Natively integrated and available in the IBM Cloud console, these databases are now available through a consistent consumption, pricing, and interaction model. They aim to provide a cohesive…
N/A
Presto
Score 10.0 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
Pricing
IBM Cloud Databases
Presto
Editions & Modules
No answers on this topic
No answers on this topic
Offerings
Pricing Offerings
IBM Cloud Databases
Presto
Free Trial
No
No
Free/Freemium Version
No
No
Premium Consulting/Integration Services
No
No
Entry-level Setup Fee
No setup fee
No setup fee
Additional Details
—
—
More Pricing Information
Community Pulse
IBM Cloud Databases
Presto
Considered Both Products
IBM Cloud Databases
Verified User
Anonymous
Chose IBM Cloud Databases
When launching the system, using multiple services would have been inefficient, so we consolidated it on IBM Cloud Databases. We regularly compared the services provided by IBM Cloud Databases' PaaS with those of other cloud services, but decided that there was no need to go to …
a powerful storm disrupted power supplies and network connections to the data center hosting our critical databases. Despite the external factors causing widespread service disruptions, IBM Cloud Databases demonstrated its exceptional reliability. The auto-failover feature …
UI is easier to use and flexible. AWS EBS is very simple to use and do upgrades and monitor the upgrades easily. I also recommend IBM to implement these.
The reason why I choose IBM Cloud Databases is that the IBM cloud toolset is already being used in other functions of the company and by using IBM Cloud Databases, the other cloud tools are better embedded and integrated. If the company is set to use amazon tools, I would go …
IBM cloud database has a lot of features than amazon dynamodb. This is my personal opinion. But I can't say amazon dynamodb is a bad one. But IBM cloud database has a lot of securities and file storage and backup features than amazon dynamodb. But both are good in their own …
I have used Amazon DynamoDm and compared to IBM Compose, I would say IBM Compose is affordable, easy to use and very fast as well. I would opt IBM Cloud Databases given the two choices
they do a great job at handling our business needs. we like what they offer and how they respond to questions we provide. they do a lot of great things that help our business thrive and stay ahead. we are grateful for how this compnay has responded to our unique requests and …
We already had existing contracts with IBM and Microsoft, so those made the most sense to verify. Both are good options for data storage. Since much of our existing Dbs are IBM related, we stuck with IBM cloud dbs, just so that the SQL code would port well. Additionally, we …
The kubernete service is the front end for the transactions of our core systems and our cloud databases (Postgres and DB2) are the persistence storage.
It is very similar to the way on which we operated before except that we don't have to worry about high availability, backups …
AWS RDS & Oracle OCI. AWS RDS has a wider range of databases but at a higher cost. IBM Compose has fewer databases but is perfect for data related solutions like data warehousing (IBM Db2 AI enabled Warehouse is a GREAT product!)
Cloudant is HIPAA compliant and replicated out of the box. We recommend use of Cloudant vs Mongodb for that purpose. We use Redis only as a session cache.
We have Cassandra database that is currently not available as part of IBM Cloud Databases. We ended up using classic infrastructure IaaS to host our Cassandra server.
I did compare IBM Compose for PostgreSQL with PostgreSQL offerings available from Amazon and Google. IBM Compose was judged easier to provision and maintain.
I'm pleased with the additional more granular provisioning flexibility and more favorable cost structure that has come …
While at the time, Amazon RDS did/does not create Mongo databases, I was able to set up many with PostgreSQL databases with the same ease as IBM Compose. However, IBM compose does seem to offer a more intuitive application control panel. Amazon RDS costs run on a server …
We selected Compose because we initially thought that they would provide great support, and that they would bring encryption at rest within months. That has not materialized yet.
We also thought that the cost, while far from being the lowest, was reasonable.
I think Presto is one of the best solutions out there today at the cutting edge for interactive query analysis. One of the challenges is presto is a niche tool for the interactive query use case and doesn't have the knobs and whistles as much as Spark. In the foreseeable future …
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.
Less Appropriate Scenario: 1) Small Scale or Low Budget Projects 2) Organizations with limited expertise in cloud technologies may find the learning curve steep, especially if they are not familiar with the IBM Cloud platform 3) If database requirements are highly dynamic and change frequently, the comprehensive features and management provided by IBM Cloud Databases might be overkill. A more flexible, self-managed solution could be preferable for adapting to rapid changes.
Simple stories & templates work nicely - like for our Insider program. Stories that include a lot of images may be challenging to create & have look appealing.
The ease of setup was effortless. For anyone with development experience, a few simple questions such as name and login data will get you set up.
The web application to manage cluster settings, billing settings and even introspect the data was simple and most importantly worked all the time. This can not always be said for web interfaces of other products.
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.
Better cost reports, before just increasing to another tier, thus increasing the price. This is critical for early stage startups, where budget is tight.
Add more data center options. As a comparison, a similar service, Aiven.io has dozen more options than Compose (basically all big cloud providers). We moved from AWS to Digital Ocean, which made us stop using Compose, since Compose forces us to be either on IBM or AWS.
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.
IBM Cloud Databases' pricing structure is easy to understand, and if you choose the right product, you can operate your system at minimal cost. Although there is ample documentation available, there doesn't seem to be a user community running on it, so specific usage know-how and troubleshooting can sometimes take longer than expected.
Support is helpful enough, but we haven't always had questions answered in a satisfactory manner. At one time we realized that Compose had stopped taking database snapshots on its two-per-day schedule, and had in fact not taken one for many days. Support recognized the problem and it was fixed, but the lack of proactive checks and the inability to share exactly what happened has caused us to look elsewhere for production work loads
The reason why I choose IBM Cloud Databases is that the IBM cloud toolset is already being used in other functions of the company and by using IBM Cloud Databases, the other cloud tools are better embedded and integrated. If the company is set to use amazon tools, I would go for rds.
I think Presto is one of the best solutions out there today at the cutting edge for interactive query analysis. One of the challenges is presto is a niche tool for the interactive query use case and doesn't have the knobs and whistles as much as Spark. In the foreseeable future if they are able to make presto work without the need for Hive, solving all the gaps it could be game changing and can be a direct threat to spark