Why Oracle Database is right for you
October 18, 2019
Why Oracle Database is right for you
Score 8 out of 10
Vetted Review
Verified User
Overall Satisfaction with Oracle Database
I work for Intuit and here Oracle is used by almost all product teams across all verticles. At our team we primarily use it for recording various application configurations as well as for our data warehouse solution. So we effectively use oracle database products for OLTP and Data warehousing. This helps to make our applications modular as the state is captured constantly within the Oracle DB.
- The query execution and optimization engine are just great in Oracle. A simple "Explain Plan" statement will give a thorough analysis of the query execution plan.
- We store huge amount of data in our Oracle database, if we partition well and plan the loads correctly, the database is very fast and provides top performance.
- For us to represent a persona and its relations is more convenient using a graph database rather than a relational DB like Oracle.
- Oracle DB is a little more expensive than the other comparable products out there in the market. It will help if the licensing costs are reduced.
- We were using a lot of open-source systems before, but using Oracle's enterprise solution has definitely given us the support we needed as well as the performance guarantees that were promised.
- I would consider huge licensing costs as well have delayed support responses as the downside to using Oracle Database.
Oracle provides better support compared to both DynamoDB and Redshift. It is definitely a way matured product and handles the scale preferably. However, DynamoDB's replication is very impressive and their cost benefits are something oracle should consider and reduce their product costs. Oracle Database has supported various integrations for us, they provide stable JDBC drivers to integrate programmatically as well. I have yet to see these in the other products.