Exasol, from the company of the same name in Nuremberg, is presented by the vendor as a high-performance in-memory analytics database that aims to transform how organizations works with data, on-premises, in the cloud or both.
N/A
IBM Cloud Databases
Score 8.6 out of 10
N/A
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…
Exasol have the best performance by far in analytical queries (DW/BI). Compared to the other database we use much less time on maintenance, actually almost 0 time on indexes distributing data on nodes etc. The system just works out-of-box as long as you have memory enough.
We looked at some others too, but was 5 yrs ago so I don't recall the list. Exasol had the best performance per cost, outstanding performance, and was easy to evaluate. Even their community addition running on my laptop was faster than our existing reporting solution.
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.
Aiven backup options are very limited (you can't download backups and you don't have an API) and their dashboard is incomplete and without an optimal design; but they accept way more data centers, and they have more pricing options.
Exasol is well suited for data warehousing, BI, ML, AI - all analytical queries. It has almost no operation cost, because it is selfmaintening the indexes etc.
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.
We have found Exasol to be very fast at summarizing large data sets. It has been a great backend for both reporting tools and data analytics/business intelligence. Combined with the fact that data import is also very fast it makes it ideal for a real-time ELT architecture.
Exasol is low maintenance. No indexes to maintain (The database auto-manages them) and very little tuning is required.
Query processing is optimized for high throughput and high parallelization. This means that even under high loads performance degrades gracefully as opposed to having "pile-ups" and "meltdowns". This has made it a very reliable database for us.
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.
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.
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.
I have had only positive experiences with their support. They are fast, knowledgeable, and courteous. Online support requests get picked up within hours. I've only once had to use their hotline and that was for an emergency. There was even one minor non-security bug report that I reported and which they fixed in the following week's minor release. I was quite impressed.
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
We looked at some others too, but was 5 yrs ago so I don't recall the list. Exasol had the best performance per cost, outstanding performance, and was easy to evaluate. Even their community addition running on my laptop was faster than our existing reporting solution.
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.