Oracle Exadata and Amazon Redshift compete in the data management solutions category, offering unique strengths tailored to different user needs. Oracle Exadata stands out for its high performance in OLTP and data warehousing, while Amazon Redshift is preferred for its scalable, cost-efficient cloud-based warehousing.
Features: Oracle Exadata offers robust features like Smart Scan, Hybrid Columnar Compression, and Smart Flash Cache, optimizing SQL workloads and enhancing performance. Its engineered system facilitates quick deployment. Amazon Redshift provides ease of integration with AWS services, utilizes columnar storage for efficient data handling, and offers flexible data analytics capabilities.
Room for Improvement: Oracle Exadata's high cost and complexity in licensing pose challenges for smaller enterprises. Its proprietary nature limits customization. Amazon Redshift can improve in handling large dataset restorations, security integration with AWS IAM, and real-time integrations with other Amazon products.
Ease of Deployment and Customer Service: Oracle Exadata offers on-premises and private cloud deployment, appealing to those prioritizing data control and security. While hardware support is strong, software support varies. Amazon Redshift excels in public cloud deployment, allowing easy scaling and AWS ecosystem integration. Customer service is generally satisfactory, although response times can occasionally be slow.
Pricing and ROI: Oracle Exadata requires a significant upfront investment with high licensing fees, delivering performance benefits and good ROI with reduced TCO. Amazon Redshift's consumption-based pricing is appealing for its flexibility and cost-effectiveness, although long-term scaling can present cost challenges for smaller companies.
The investment is good, which is why people choose this hardware.
Whenever we need support, if there is an issue accessing stored data due to regional data center problems, the Amazon team is very helpful and provides optimal solutions quickly.
It's costly when you enable support.
If I were to rate their support from one to ten, I would say between nine to ten.
This involved creating blueprints for integrating Oracle products into client systems, followed by technical presentations to Oracle teams and stakeholders.
Exadata comes with a platinum gateway and comprehensive support, which often gets immediate attention with severity one cases.
The scalability part needs improvement as the sizing requires trial and error.
Within a site, scalability is excellent.
Amazon Redshift is a stable product, and I would rate it nine or ten out of ten for stability.
Once installed, Exadata is very stable.
Integration with AI could be a good improvement.
They should bring the entire ETL data management process into Amazon Redshift.
I believe that there is still room for improvement in Oracle Exadata, as they are putting AI features on those databases, which is making the database more user-friendly.
I cannot create an extended rack cluster with one node on one site and another node on a different site.
There are minor areas where improvement is needed, such as making the user interface more user-friendly and enhancing configuration and customization options.
It's a pretty good price and reasonable for the product quality.
The cost of technical support is high.
The pricing of Amazon Redshift is expensive.
I would rate the price an eight on a scale from one to ten, indicating it is fairly expensive.
I find its pricing reasonable and cost-effective for large organizations, but for smaller organizations, it may not be that useful.
Amazon Redshift's performance optimization and scalability are quite helpful, providing functionalities such as scaling up and down.
The specific features of Amazon Redshift that are beneficial for handling large data sets include fast retrieval due to cloud services and scalability, which allows us to retrieve data quickly.
Scalability is also a strong point; I can scale it however I want without any limitations.
It also offers high backend speed between self-storage units and servers, which is beneficial for processing.
The most valuable features of Oracle Exadata are its high availability and cluster environment.
If a customer cannot tune their applications, this will help them to run the database and run the application without any tuning itself.
| Company Size | Count |
|---|---|
| Small Business | 27 |
| Midsize Enterprise | 21 |
| Large Enterprise | 28 |
| Company Size | Count |
|---|---|
| Small Business | 47 |
| Midsize Enterprise | 14 |
| Large Enterprise | 86 |
Amazon Redshift is a fully administered, petabyte-scale cloud-based data warehouse service. Users are able to begin with a minimal amount of gigabytes of data and can easily scale up to a petabyte or more as needed. This will enable them to utilize their own data to develop new intuitions on how to improve business processes and client relations.
Initially, users start to develop a data warehouse by initiating what is called an Amazon Redshift cluster or a set of nodes. Once the cluster has been provisioned, users can seamlessly upload data sets, and then begin to perform data analysis queries. Amazon Redshift delivers super-fast query performance, regardless of size, utilizing the exact SQL-based tools and BI applications that most users are already working with today.
The Amazon Redshift service performs all of the work of setting up, operating, and scaling a data warehouse. These tasks include provisioning capacity, monitoring and backing up the cluster, and applying patches and upgrades to the Amazon Redshift engine.
Amazon Redshift Functionalities
Amazon Redshift has many valuable key functionalities. Some of its most useful functionalities include:
Reviews from Real Users
“Redshift's versioning and data security are the two most critical features. When migrating into the cloud, it's vital to secure the data. The encryption and security are there.” - Kundan A., Senior Consultant at Dynamic Elements AS
“With the cloud version whenever you want to deploy, you can scale up, and down, and it has a data warehousing capability. Redshift has many features. They have enriched and elaborate documentation that is helpful.”- Aishwarya K., Solution Architect at Capgemini
Oracle Exadata allows enterprises to run any Oracle Database workload with the highest performance, scale, availability, and security on fully compatible cloud and on-premises infrastructure. Exadata uses a scale-out design with unique optimizations that include persistent memory, SQL query offload, and built-in resource management to optimize performance for OLTP, analytics, machine learning, and mixed workloads running in consolidated environments. By running hundreds or thousands of optimized Autonomous Database and Exadata Database instances on Exadata Cloud or Cloud@Customer infrastructure, customers are able to minimize their infrastructure, reduce management, improve developer productivity, and lower total costs by up to 40%, as described in Wikibon’s analysis (PDF).
The main benefit of Exadata is its speed. It hosts operating systems, CPU memory, and hard drives. It runs all types of databases, including online transaction systems, processors, and data warehouses, while remedying the poor performances of older databases.
Oracle Exadata features a simple and fast database storage system that protects and backs up your critical data. It accelerates data warehouse performance for faster access to business information and data. It is the ideal database solution for companies looking to build up their infrastructure from scratch.
Oracle Exadata Database Machine Key Benefits
Accelerate database processing: Exadata Storage Server implements a unique, highly efficient database-optimized storage infrastructure that enables Exadata’s unparalleled performance without any of the bottlenecks that traditional storage experiences. Each storage server contains CPU processors that are used to offload database processing. The CPUs in the storage servers do not replace database CPUs, but work alongside them to accelerate database workloads.
Reviews from Real Users
Oracle Exadata stands out among its competitors for a number of reasons. Two major ones are its robust performance and its wide variety of database features that make it a comprehensive database solution.
Adriano S., an IT system integrator at a financial services firm, writes, "Oracle Exadata's performance is one of its best features. We are very satisfied with it. The previous equipment used to make a payment for all the government employees used to take at least two days for some of the transactions. Now, it will take hours to make the same amount of payments. Another thing is the flexibility to organize all our databases. We can use it with new features that come with this version of Oracle 19c, which is the container database. With container databases, we can work with many databases, organized, and segregated, and still access the functions and management, the things that most of the technical people like to have in place."
Paulo X., a sales manager at LTA-RH Informatica, notes, "Regarding features, there are so many that we can offer to customers. When we sell Exadata Cloud, there are many options to choose from, especially when it comes to enterprise database options. In my experience, the main features that are appreciated are various ones like GPS and the assortment of security options."
We monitor all Data Warehouse reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.
