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
Pricing
Oracle Autonomous Data Warehouse
Oracle Cloud Infrastructure
Editions & Modules
No answers on this topic
No answers on this topic
Offerings
Pricing Offerings
Oracle Autonomous Data Warehouse
OCI
Free Trial
No
Yes
Free/Freemium Version
No
Yes
Premium Consulting/Integration Services
No
Yes
Entry-level Setup Fee
No setup fee
Optional
Additional Details
—
—
More Pricing Information
Community Pulse
Oracle Autonomous Data Warehouse
Oracle Cloud Infrastructure
Features
Oracle Autonomous Data Warehouse
Oracle Cloud Infrastructure
Infrastructure-as-a-Service (IaaS)
Comparison of Infrastructure-as-a-Service (IaaS) features of Product A and Product B
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.
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
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.
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
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.
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.
