Oracle Exadata Database/Autonomous DB Review
September 18, 2019

Oracle Exadata Database/Autonomous DB Review

Anonymous | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User

Overall Satisfaction with Oracle Autonomous Database

The database is used for central storage of corporate data for multiple departments across the organization. The problem it solves is to consolidate disparate data from the organization. I design applications and approaches for our development team. With my teammate, we come up with approaches for data modeling.
  • Simple data retrieval using standard SQL
  • Capable of supporting many simultaneous users/connections
  • Fast loading of data in batch processing
  • Improved connection abandonment detection would be useful. I occasionally encounter situations where a query becomes unresponsive due to deadlock, volume of data being queried, or other. It would be beneficial if there were better support for client-side cancellation events.
  • It allowed us to consolidate a large number of disparate databases to a central location. This consolidation will allow us to more effectively develop applications and solutions to serve current and future business demand.
I have used DB2 at a previous employer and do miss some of the features that are not present in Oracle, or that are implemented in a non-standard way. Examples include DB2's transition tables (e.g. SELECT * FROM FINAL TABLE...) and Oracle's implementation of the VARCHAR datatype. I was not personally involved in the selection of Oracle at TravelCenters.

Do you think Oracle Autonomous Database delivers good value for the price?

Yes

Are you happy with Oracle Autonomous Database's feature set?

Yes

Did Oracle Autonomous Database live up to sales and marketing promises?

I wasn't involved with the selection/purchase process

Did implementation of Oracle Autonomous Database go as expected?

Yes

Would you buy Oracle Autonomous Database again?

No

The database is very well suited for online transaction processing as well as offline batch processing. It may be less appropriate for large scale analytics when using the same data models used for OLTP.

Oracle Autonomous Database Feature Ratings

Performance optimization tools
6
Schema maintenance
6
User management
7
Database security
8
Database status reporting
7