Oracle Autonomous Data Warehouse has plenty of valuable features. It has large amounts of flash cache. It has segregated IO. It has something called smart scan, which other databases don't have. It has got plenty of stuff in the database.

The three top features for us are:

• Self-tuning
• Self-securing
• Self-patching

On top of it, you can create an instance in three minutes and use it with Oracle Analytics.

The product is available on Oracle Cloud.

It guarantees 99.995% up-time.

There is no installation, configuration, or maintenance needed.

It integrates easily with other cloud services.

The product is self-driving. All routine administration tasks including provisioning, performing backups and recovery, making fault-tolerant fail-overs, applying patches, performing upgrades, optimizing and tuning for performance, and scaling are all fully automated. 

The solution is self-securing. All data is encrypted and security updates and patches are applied automatically both periodically and off-cycle.  

I loved the simplicity of loading the data and simply relying on the self-tuning capabilities of ADW.

The solution helps stream the data faster and in real time.

I like the fact that the solution is self-patching, that it's running machine-learning generally across its logs all the time in order to identify any issues and to self-repair. It means that I don't really need a DBA for the most part. I can do everything myself.

The product is also smart enough that it doesn't need me to set indexes because it's in the memory log so I don't have to specify them, it will actually learn and build the ones that are necessary.

I'm reasonably happy with what they're packaging. Because they've got the cloud offering, there's a lot of things that aren't part of ADW, yet interact with ADW. Purely as a database, it does what it needs to do. And then I've got the detailed analytics and machine learning, so I'm happy with that. It's a capable product. 

The product is easy to use. I like that it is cloud-based.

The integration feature is very good because you can automate protection security automatically, restricting the access of unauthorized people. It can also maintain security in terms of service failure, service protection, and the duration of the disruption. 

One advantage is that if you already have an Oracle Database, it easily integrates with that.

If you are using structured data, it works pretty well. They have engineered their hardware, which is based on Sun, to work with their database and data warehouse in an optimal way. So, the data exchange is extremely fast and good. If it is just tabular data, it works really well. I like that part.

The performance and scalability are awesome.

I think that is the best solution for big data warehouses. Larger companies need this kind of solution. Since it is autonomous, you don't have to worry about things like database administration.

The only thing that you have to be concerned with is the data modeling, and how you want the data, or your client's data, to be presented. Since the data warehousing task is quite big, it will give you more time to decide on how you want the data to be presented.

The solution integrates well with Power BI.

While I'm not on the technical side and instead manage the team, I haven't heard of any complaints related to the user interface, configuration, or customization.

The product, overall, seems to be quite stable.

ADB runs on Exadata technology, which is the proven industry best solution for any kind of workloads. Besides, ADB provides complete automated features, such as, self patching, upgrade, tuning, automated indexing, and automated backups. Also, recovery of the database is easy. 

The entire host and DB software maintenance is done by Oracle and automated. Also, it provides Transparent Data Encryption (TDE) capabilities by default to address data security issues. In addition, the connectivity is highly secured.

The analytics have been very good. We've found them to be quite useful.

I really like the auto-tuning, auto-scaling, automatic load balancing, and query tuning in the system.