Astra DB vs. Oracle Database

We use Astra DB to improve our management systems. Storing data has become hassle-free and quite simple. When launching a Cassandra-based cloud application, Astra DB is exactly what you need. In addition to the standard training programs and videos, the extended support and training require significant additional effort to activate and cover which I feel is a bit more tedious task.

Incentivized

I believe Oracle Database is still the best RDBMS database which is the database to consider for OLTP applications and for Adhoc requests. They are good in Datawarehousing in certain aspects but not the best. Oracle is also a great database for scaling up with their Clusterware solution which also makes the database highly available with services moving to the live instance without much trouble.

Incentivized

• We need to be able to process a lot of data (our biggest clients process hundreds of milions of transactions every month). However, it is not only the amount of data, it is also an unpredictable patterns with spikes occuring at different points of time - something athat Astra is great at.
• Our processing needs to be extremaly fast. Some of our clients use our enrichment in a synchronous way, meaning that any delay in processing is holding up the whole transaction lifecycle and can have a major impact on the client. Astra is very fast.
• A close collaboration with GCP makes our life very easy. All of our technology sits in Google Cloud, so having Astra in there makes it a no-brainer solution for us.

Incentivized

• Best thing about it is that it supports PL/SQL which is helpful in writing complex quarries easily.
• Its storage capacity , backup and recovery features make it the best database storage tool available.
• Other thing I like about this software is its interface is so good.

Incentivized

• Astra DB might be difficult to understand for people who are unfamiliar with Apache Cassandra. Improving the initial experience for newcomers, as well as offering better documentation and lessons, might be advantageous.
• The Astra DB ecosystem may be enhanced by expanding the ecosystem of plugins, integrations, and community-contributed solutions.

Incentivized

• New (actually it is more than five years old) multi-tenant architecture is not as straightforward as SQL Server, but it has been enhanced in Oracle 12c Release 2 and later 18c and 19c.
• Many features require additional licensing (either as options or as packs) that increase the total cost

Incentivized

It is very likely to use this 12c (or next version) of Oracle Database. Nothing close to it in the marketplace in terms of performance, reliability and overall database management efficiency. If Oracle did one thing really good - it is it's OLTP Database I must say.

It's a great product but suffers with counters. This isn't a deal breaker but lets down what is otherwise a good all round solution

Incentivized

Many of the powerful options can be auto-configured but there are still many things to take into account at the moment of installing and configuring an Oracle Database, compared with SQL Server or other databases. At the same time, that extra complexity allows for detailed configuration and guarantees performance, scalability, availability and security.

Incentivized

Their response time is fast, in case you do not contact them during business hours, they give a very good follow-up to your case. They also facilitate video calls if necessary for debugging.

Incentivized

1. I have very good experience with Oracle Database support team. Oracle support team has pool of talented Oracle Analyst resources in different regions. To name a few regions - EMEA, Asia, USA(EST, MST, PST), Australia. Their support staffs are very supportive, well trained, and customer focused. Whenever I open Oracle Sev1 SR(service request), I always get prompt update on my case timely. 2. Oracle has zoom call and chat session option linked to Oracle SR. Whenever you are in Oracle portal - you can chat with the Oracle Analyst who is working on your case. You can request for Oracle zoom call thru which you can share the your problem server screen in no time. This is very nice as it saves lot of time and energy in case you have to follow up with oracle support for your case. 3.Oracle has excellent knowledge base in which all the customer databases critical problems and their solutions are well documented. It is very easy to follow without consulting to support team at first.

Incentivized

Overall the implementation went very well and after that everything came out as expected - in terms of performance and scalability. People should always install and upgrade a stable version for production with the latest patch set updates, test properly as much as possible, and should have a backup plan if anything unexpected happens

We also (briefly) considered building in-house. We wanted to avoid complex "Frankenstein" architectures. Combining Pinecone with another NoSQL datastore like DynamoDB would have increased complexity. A single-managed platform (Astra DB) enabled architectural simplicity and strong reliability, allowing Maester’s development team to prioritize high-value, customer-facing features

Incentivized

Oracle Database is among the easiest to integrate with, program against, have a reliable cluster with DR, and has the most understood and well-documented databases. It suits really well if the software shop is primarily Java-based, and deals with large volumes of data with a high degree of diversity among the applications by purpose and use. Paid support is recommended as well as planned periodic patching and upgrades.

Incentivized

We are well aware of the Cassandra architecture and familiar with the open source tooling that Datastax provides the industry (K8sSandra / Stargate) to scale Cassandra on Kubernetes.

Having prior knowledge of Cassandra / Kubernetes means we know that under the hood Astra is built on infinitely scalable technologies. We trust that the foundations that Astra is built on will scale so we know Astra will scale.

Incentivized

• Database growth planning is less of a concern with Astra, as it scales automatically.
• Currently, they lack fine-grained security at the table level. I suspect that will change over time.
• If your load has peaks and valleys; Astra enables only paying for Reads/Writes; thus you do not need to pay for large servers to support peaks in load.

Incentivized

• We wasted lots of money (Oracle is crazy expensive), time and effort on the project and were highly relieved when we found a different approach to supporting our aging ERP app that did not include Oracle.
• Because of the difficulty of using Oracle, we spent a lot of money on consultants to help us over the conversion hump. Also wasted. And it was interesting to see them struggle with the software. Upgrades never went well always requiring multiple site visits, for example.

Incentivized