New era of data warehouse
April 12, 2021
New era of data warehouse
Score 9 out of 10
Vetted Review
Verified User
Overall Satisfaction with Oracle Autonomous Data Warehouse
Oracle Autonomous Data Warehouse is a fully managed database that’s tuned and
optimized for data warehouse workloads, so we decided to give it a try with a POC. It combines the market-leading
performance of Oracle Database with the ease of Autonomous Database and
is self-driving, self-securing, and self-repairing. Our objective was to spend our time focusing on delivering applications
to solve our business problems. One of the hurdles was the
time spent in maintaining--upgrading, patching, installing new
services. Oracle Autonomous Data Warehouse gave us the confidence to
delegate the operational well-being of our database instances to the
experts who designed it from the ground up.
optimized for data warehouse workloads, so we decided to give it a try with a POC. It combines the market-leading
performance of Oracle Database with the ease of Autonomous Database and
is self-driving, self-securing, and self-repairing. Our objective was to spend our time focusing on delivering applications
to solve our business problems. One of the hurdles was the
time spent in maintaining--upgrading, patching, installing new
services. Oracle Autonomous Data Warehouse gave us the confidence to
delegate the operational well-being of our database instances to the
experts who designed it from the ground up.
- Excellent performance, ease of use, great scalability, and most importantly excellent integration with Oracle GoldenGate for real-time data view
- Fully managed enterprise class, full-featured relational database that brings the power of Oracle technology to managed Cloud; support for private endpoints to keep data private
- Multi-user, high concurrency real-time reporting from across several data sources
- Level of integration or compatibility to connect it to different applications can be improved
- The support service is slow
- The issue is with the record number limitation of not being able to bring back more than one million records or not being able to export larger datasets to Excel
- It's a high performance platform. Machine learning notebooks are super helpful!
- No ability to use APEX and SQL Developer extensions like Data Miner
- No ability to incorporate spatial
Oracle Autonomous Data Warehouse stacks up great against all the existing data warehouse applications.