Oracle Autonomous Data Warehouse

It has always been well suited to me while writing spatial and nonspatial oracle SQL queries to extract some meaningful data. It made my life easier to write queries etc. The good thing is that it has got heaps of documentation available online and also tutorials which are good for learning purposes. Bad in the sense that probably can be improved in terms of UI

It is well suited for analytical reporting, data lake, and read-intensive databases. I have faced some issues with integration and connecting to third-party tools.

It is well suited for scenarios where large data sets are to be analyzed and insights to be extracted. It is not suitable for translations like update, delete, etc as it is not optimized for this. The major purpose of a data warehouse is to handle large sets of data to efficiently analyze them to help businesses.

It works good for data movement and transformations into data warehouse databases.

Create a whole review system that requires work table, stage table, and History table and OLAP table. In Oracle Data warehouse this is very easy, fast, and with a high user base you can get many solutions implemented by looking online. Building complete end-to-end data pipeline and updating old tables is very easy. Integration with other applications or loading data using an external API is very hassle free task.

We build a small review system where work table loaded using API and then cluster other processing stuff done on the work table and data saved to stage table and final SCD type 1 load to base table. This is ultimately used by the Operations team for solving end-user queries.

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.

It's great if you are already using othe Oracle Cloud products. It is really simple to integrate with them. We plan to use it as a central datawarehous hosting data from many different data sources.

[Oracle Autonomous Data Warehouse] is well suited in most of case when it comes to save time, cost, quick project delivery, over the cloud and instant scale up and down features. I would not say scenarios where it is less appropriate, it always with anything which comes news have some features missing or not available as of time, you can find ways for better analytics or other ways than no support for R language.

Oracle Autonomous Data Warehouse is particularly well suited for small or medium-sized companies that are evaluating a new database for reporting goals or for creating a common data access point for the whole enterprise.

It's probably less suited for very big companies with huge amounts of data, for network latency in moving data through the network, or for companies that already have very big Data Warehouse on-premise, and want to migrate it into the cloud, since Autonomous database has some limitations.

Suitable data warehouse with all necessary components

Well suited when
1. High performance is needed--The autonomous data warehouse is capable of increasing performance for continuous query optimization, table indexing, data summaries, and auto-tuning even as data volume and number of users grows.
2. High scalability is needed--Unlike other cloud services that require downtime to scale, Oracle Autonomous Data Warehouse scales while the service continues to run.
3. Automation is needed--Oracle Autonomous Data Warehouse automates provisioning, configuring, securing, tuning, and scaling for a data warehouse.

Less suited when
1. There is not a significant amount of data that needs to be handled on a daily basis.
2. Data analytics is not a requirement.

Again, it is great for consolidating our data. It performs much better than our last tool. Our reports are smooth and we are able to integrate more data within each report. This is huge because this is the ideal outcome of a product like this. We haven't moved all of our ETL to the tool yet, but any new pipelines being built are utilizing the tool.

It's great for digital data. The data sharing processes can be complicated when using multiple data sources, so oftentimes you need experts to help with implementations and it can get expensive and time consuming.

You definitely should go for Oracle Autonomous Data Warehouse if you are looking for something trustable, secure, tunable and that can be scalable easily. All these features make it one of the best tools in terms of Data Warehousing. If you are looking for something small and of course cheap, I would not suggest this option.

We use ADW to stash data long term from the Oracle Autonomous Transaction Processing and also to digest and process data in a fast manner from the Oracle Blockchain Platform.

Very well suited for:
- data warehouse and data lake projects
- storage of decommissioned applications/databases if you one day would like to restore data - then you will always have the data available.

Oracle Autonomous Data Warehouse is well suited for on-prem to cloud situations. That is more controllable as we have control over the ETL tools and database. It is still a challenge to adopt ADW on a full scale for cloud-to-cloud implementations primarily because the tool is still evolving and the challenges pose a risk to critical implementations without resolving the challenges.

Oracle Data Warehouse is well-suited for businesses medium-sized and up. Keep in mind to manage and utilize Oracle Data Warehouse's full potential, you will need to hire dedicated staff that is experienced in using it. Not to mention, the pricing is a bit high. It is less appropriate for smaller businesses that have smaller budgets and fewer employees.

It is well suited when buying new server hardware is too costly and when setting up a warehouse quickly is very necessary. It is also great when a DBA has very limited experience managing a data warehouse.

We used Oracle Autonomous Database for our warehouse reporting. It is a 50 TB huge database and reports are generated every day. It is a pretty read intensive database. Its availability is required for 24 X 7. We have several thousands of customers using it on a regular basis. The performance is phenomenal.

Oracle Data Warehouse is, in my opinion, the best solution available. My hesitance to recommend it would be that it costs a fortune and other vendors would likely work well for smaller companies. For large companies that can afford the pricetag, you likely won't find anything to out-perform Oracle. I've seen POCs where the competition outshines Oracle, but I believe they are specific situations, and in general, I would give Oracle my recommendation (again, if money is not an object).