Oracle Autonomous Data Warehouse can be useful for data warehousing. It's easier to do setup and maintenance compared to Oracle Exadata. For some users, if it is satisfying, they can use it very easily because you don't have to do anything, including any kind of streaming or special kind of physical design for most of the use cases, making it easy to use. It is very easy to expand and allocate dynamic resources because you can use some processing units of Oracle which are virtualized. In the product, considering the processor power and memory, you can easily add processing units to make your system more powerful, which can be planned. For working hours, you can use as many processing units of Oracle, while later, you can reduce its use. For test purposes, you can use fewer processing units of Oracle on the platform, and you can switch it off and activate it only when you need to develop something. The processing units are very flexible. Using the tool means payment for resources has to be made. The tool makes it very easy to use the space provided in the product because you can add one terabyte or gigabyte to your space. For somebody who knows how to use the features of the tool and go deep into its physical design, everything becomes available, including Oracle Exadata on Oracle Autonomous Data Warehouse. So people who are experienced and know Oracle Autonomous Data Warehouse can use the product to improve performance and do better design, making it more efficient. Somebody who doesn't know how to use the tool and does not have people to help can use it with a much simpler approach.
The initial setup of Oracle Autonomous Data Warehouse is easy and basic, especially if one doesn't use the tricks to get Oracle Exadata for use. One doesn't need to know or be involved in technical stuff to do the setup since, at the least, knowledge might be required when working with some external connections, but it is easy because everything can be done within a couple of clicks. The solution is deployed on the cloud. For deployment, you don't need any technical guidance since you can sit, find it on the web, and prepare an Oracle Autonomous Data Warehouse platform by yourself for free for a limited time. The people needed for the deployment and maintenance depend on the implementation one wants. If you do a simple implementation, you don't need anybody for maintenance since everything is on the cloud. You only have to schedule your backup or see if Oracle can schedule a backup, and you don't take care of the backup. For some more sophisticated or technical implementations, you will need staff for some data warehouse except for some parts of the maintenance like backup, patches, or upgrades since these are a few things you take care of in the background, and you only seek help with the maintenance part, if needed.
