If you were talking to someone whose organization is considering Oracle Autonomous Data Warehouse, what would you say?
How would you rate it and why? Any other tips or advice?
I highly recommend it for companies who want to test their application functionality, dev, or test DBs for cost optimization. With existing DBA knowledge, it is easy to manage and migrate a database to ADB.
I'm not sure if I'm capable of giving advice to anyone as it's a solution that's so new to us still. I'd rate the solution seven out of ten.
I would like to see an on-premise solution in the future. There are other very good solutions in the market, so if I would rate it a ten, it would be the best in the market. I, therefore, rate this solution an eight out of ten.
Be aware that you still have to define your "schema". You still define the columns in each table. This is a necessary step. It would be great if Oracle added a wizard that takes data and "figures out" what the column names are (e.g. perhaps noticing that Boston, Los Angeles, New York could be a CITY column). This would be in line with making it "autonomous". Maybe it's there and I don't know how to make that happen.
Amazing performance. It's a revolution.