Oracle Autonomous Data Warehouse is optimized for analytic workloads, including data marts, data warehouses, data lakes, and data lakehouses. With Autonomous Data Warehouse, data scientists, business analysts, and nonexperts can discover business insights using data of any size and type. The solution is built for the cloud and optimized using Oracle Exadata.
N/A
OCI
Score 8.1 out of 10
N/A
Oracle Cloud Infrastructure (OCI) is Oracles's infrastructure-as-a-service (IaaS) platform which combines the utility of public cloud with the granular control, security, and predictability of on-premises infrastructure.
N/A
Oracle Exadata
Score 9.8 out of 10
N/A
Oracle Exadata is an enterprise database platform that runs Oracle Database workloads of any scale and criticality with high performance, availability, and security. Exadata’s scale-out design employs optimizations that let transaction processing, analytics, machine learning, and mixed workloads run faster. Consolidating diverse Oracle Database workloads on Exadata platforms in enterprise data centers, Oracle Cloud Infrastructure (OCI), and multicloud environments helps organizations increase…
$2.90
Per Unit
Pricing
Oracle Autonomous Data Warehouse
Oracle Cloud Infrastructure
Oracle Exadata
Editions & Modules
No answers on this topic
No answers on this topic
Database Server
$2.9032
Per Unit
Quarter Rack
$14.5162
Per Unit
Offerings
Pricing Offerings
Oracle Autonomous Data Warehouse
OCI
Oracle Exadata
Free Trial
No
Yes
No
Free/Freemium Version
No
Yes
No
Premium Consulting/Integration Services
No
Yes
No
Entry-level Setup Fee
No setup fee
Optional
No setup fee
Additional Details
—
—
—
More Pricing Information
Community Pulse
Oracle Autonomous Data Warehouse
Oracle Cloud Infrastructure
Oracle Exadata
Considered Multiple Products
Oracle Autonomous Data Warehouse
Verified User
Engineer
Chose Oracle Autonomous Data Warehouse
Oracle DWH is a pure warehousing tool and does not try to include outside features into itself, unlike a few other warehousing platforms. This makes Oracle DWH much simpler to set up and ready to use.
On the other hand, most other warehousing platforms can provide slightly …
Microsoft Azure Cloud does not provide the native Oracle Database service with features like RAC, ASM Exadata, etc. Hence, we decided to use the Oracle Cloud for the database platform instead of Azure. Also, Microsoft and Azure came to an agreement to work together where Azure …
We selected it just from a performance perspective, and that the ROI with the Oracle Exadata Database Machine is bigger than other machines. You can run with it for at least 5 years.
II would recommend Oracle Autonomous Data Warehouse to someone looking to fully automate the transferring of data especially in a warehouse scenario though I can see the elasticity of the suite that is offered and can see it is applicable in other scenarios not just warehouses.
As per our usage Oracle Cloud Infrastructure for almost 6 years hosting 500 + customers I can say its well suited application for any small scale to larger scale application as it can handle that capacity and provide more reliable cloud service only if you need any messaging service like pub/sub or sqs better to consider other services.
Oracle Exadata is well-suited for environments where massive performance for Oracle databases is required. Storage indexes reduce the unnecessary I/O. Smart Flash Cache accelerates random reads/writes.
Our OLTP application demands very high concurrency. Multi-node Exadata provides high availability and zero downtime during DB patching. It comes with lots of built-in automations, so it reduces many routine tasks for sysadmins, like network, storage, and VM configuration, and it also reduces many Oracle DBA tasks, like Oracle software installation, patching, and upgrades.
Very easy and fast to load data into the Oracle Autonomous Data Warehouse
Exceptionally fast retrieval of data joining 100 million row table with a billion row table plus the size of the database was reduced by a factor of 10 due to how Oracle store[s] and organise[s] data and indexes.
Flexibility with scaling up and down CPU on the fly when needed, and just stop it when not needed so you don't get charged when it is not running.
It is always patched and always available and you can add storage dynamically as you need it.
Oracle Cloud Infrastructure has a generous free tier, moreso than other hyperscalers, with an always-free tier that guarantees certain products are always free
Oracle Cloud Infrastructure allows you to size VMs with differing combinations of CPU and RAM, which is contrary to other hyperscalers that have specific pre-defined combinations only
Oracle Database : Deliver industry-leading security, high availability and scalability with Oracle Database, which has been significantly enhanced to take advantage of the Oracle Exadata Storage Servers.
Exadata Smart Scan : Improve query performance by offloading intensive query processing and data mining scoring to scalable intelligent storage servers.
Smart Flash Cache : Transparently cache 'hot' read and write data to fast solid-state storage, improving query response times and throughput. Exadata systems use the latest PCI flash technology rather than flash disks. PCI flash delivers ultra-high performance by placing flash directly on the high speed PCI bus rather than behind slow disk controllers.
Hybrid Columnar Compression : Reduce the size of data warehousing tables by 10x, and archive tables by 50x, to improve performance and lower storage costs for primary, standby, and backup databases. Query high, query low, archive high and archive low.
Infiniband Network : Connect multiple Oracle Exadata Database Machines using the InfiniBand fabric to form a larger single system image configuration. Each InfiniBand link provides 40 Gigabits of bandwidth–many times higher than traditional storage or server networks.
Petabyte Scalability : Easily scale data warehouse to support enterprise data growth.
It is very expensive product. But not to mention, there's good reasons why it is expensive.
The product should support more cloud based services. When we made the decision to buy the product (which was 20 years ago,) there was no such thing to consider, but moving to a cloud based data warehouse may promise more scalability, agility, and cost reduction. The new version of Data Warehouse came out on the way, but it looks a bit behind compared to other competitors.
Our healthcare data consists of 30% coded data (such as ICD 10 / SNOMED C,T) but the rests is narrative (such as clinical notes.). Oracle is the best for warehousing standardized data, but not a good choice when considering unstructured data, or a mix of the two.
Navigating the UI takes lots of getting used to. It reminds me of older GCP (just to get used to where everything is).
Permission for different things always seemed to be more difficult than it really needed to be. Once you got them set up you were good but updating anything or creating new permissions for just about anything took longer than I thought it should.
Based on how the buttons were laid out, it was pretty easy to delete all of your DNS records, and backing them up was not as intuitive as I'd like with the UI, but it was easy to do using a script.
The process of patching and upgrade of Exadata server components could be improved with a goal to minimize the overall effort, make it fully automated and transparent.
Improved guidelines and possibly more sophisticated tools for sizing of new Exadata servers for migration from old legacy hardware.
Does not require continous attention from the DBA, autonomous features allows the database to perform most of the regular admin tasks without need for human intervention.
Allows to integrate multiple data sources on a central data warehouse, and explode the information stored with different analytic and reporting tools.
Reliability: Very dependable and stable OCI services have been for the business operations.Performance: The speed and efficiency of OCI in meeting their computing and storage needs.Scalability: The ease and effectiveness of scaling resources up or down to accommodate changing demands.Security: The robustness and effectiveness of OCI's security features in protecting their data and applications.
The services & products in Oracle Cloud Infrastructure needs more improvement to beat other Cloud service providers. The price is good & Security processes are good. We are requiring to put more effort in supporting this Oracle Cloud Infrastructure than other Cloud service providers. Probably better ways are there but is not super easy to find or not super available
I am comparing Exadata with the Oracle RAC database experience. In addition to Oracle RAC features, Exadata provides automatic performance optimization through Smart Scan and storage indexes. Deep integration with the Oracle ecosystem and tight coupling with Oracle Enterprise Manager for monitoring and management. Some downsides of Exadata are: a steep learning curve, concepts like cell offloading, IORM, and flash cache behavior aren’t intuitive initially. Operating Exadata requires specialized DBA skills.
Yeah sometimes we had to face unplanned outages due to underlying infrastructure issues, so not every time,e but once in a while we face issues with availability. But the good thing is we have redundancy with DR setup and multi region so we can manage.
From the start, I was surprised by response times and image quality accessing windows VMs with RDP. GCP, Azure and -many offerings in AWS- don't perform this speed. Also, that's evident in the quality of Infrastructure Management Team, because I just received one warning regarding a region failure, what confirms that's a mature platform.
Overall it is amazing, there is always room for improvement. We have weekly updates that tend to slow the program used more and more. We had to change some reports within Oracle because the others wouldn’t load. This is tied to our payroll and the delays are causing many time constraint issues and panic. We have to create a new report when one breaks. Otherwise awesome!
Understanding Oracle Cloud Infrastructure is really simple, and Autonomous databases are even more. Using shared or dedicated infrastructure is one of the few things you need to consider at the moment of starting provisioning your Oracle Autonomous Data Warehouse.
As I mentioned, I have also worked with Amazon Redshift, but it is not as versatile as Oracle Autonomous Data Warehouse and does not provide a large variety of products. Oracle Autonomous Data Warehouse is also more reliable than Amazon Redshift, hence why I have chosen it
We used Microsoft Azure and Docker earlier and faced some difficulties like Microsoft Azure and Docker. Occasionally, the generation of large images can delay deployment. It is also necessary for me to admit that Microsoft Azure and Docker have a somewhat steep learning curve. Proper paperwork needs to be there. Docker has issues with performance on a number of platforms. On the other hand, OCI is easy to deploy and easy to understand.
Oracle Exadata Database Machine had the best performance overall hands down. It clearly beat the competition and we were seeing 1000X improvement on SAP HANA. Oracle Exadata Database Machine beat that without us refactoring our code. To achieve that in HANA, we had to refactor the code somewhat. Now this was for our limited POC of 5 use cases. Given the large number of stored procedures we had in Sybase, we need to capture more production metrics but we are seeing incredible performance.
was not part of initial purchase team. Anyways, i think unit pricing and billing frequency is good compared to other Cloud service providers, when it comes to Cloud Capital expenditure & Operational expenditure. Would be more interested in exploring more options where customers can get more cost relaxations on trying out new cloud services in Oracle Cloud Infrastructure for example a new App or a feature
We have hosted around 500 + customers on this cloud so till day not faced any major issues, so we can use it for any kind of products and it can hold the load and easily scale based on need.
Services & Infra wise is ok to use & host applications & services. Security wise also good for a Cloud service provider. It is a interesting area to explore & using it for day to day needs can be further improvised in future probably. Modern day Services like AI and Machine learning could be improved
Overall the business objective of all of our clients have been met positively with Oracle Data Warehouse. All of the required analysis the users were able to successfully carry out using the warehouse data.
Using a 3-tier architecture with the Oracle Data Warehouse at the back end the mid-tier has been integrated well. This is big plus in providing the necessary tools for end users of the data warehouse to carry out their analysis.
All of the various BI products (OBIEE, Cognos, etc.) are able to use and exploit the various analytic built-in functionalities of the Oracle Data Warehouse.
Single support from a single vendor with both machine and database from Oracle, which is costing us less.
With Exadata, we need less technical manpower and less technical support. A business transaction with the integrated and centralized database helps us focus on other business needs.
We don't need to buy additional licenses and Hardware for the next 3 to 5 years.
