My Succinct Oracle Database Satisfaction Recap
April 08, 2021
My Succinct Oracle Database Satisfaction Recap
Score 8 out of 10
Vetted Review
Verified User
Overall Satisfaction with Oracle Database
The Oracle Database or rather a cluster of Oracle Databases is used for both an OLTP and data warehousing data storage and processing purposes across various departments. Oracle Database is a very mature and versatile platform that allows running almost any business entirely using only the database. At Parsons Smart Vehicles Solutions, we rely on Oracle for conducting the critical line of business. The database's unique resilience capabilities, programmability, and mature tooling allow for rapid software development while maintaining high quality. Oracle is widely supported by vendors' databases, which makes integration easier.
- Automated database objects validation: correctness of views, packages, triggers, and everything is built-in. This minimizes the risk of using malfunctioned software and makes it easy to fix broken code.
- Rich programmability model: the database supports not only the very rich SQL but also PLSQL, Java and it has very good command-line tools that make change management easy and efficient.
- Excellent for data warehousing with its support for automatic materialized views management, table sequences, data types, updatable cursors, advanced SQL as Windowing Functions, built-in upsert semantics via the Merge SQL.
- The memory demand and management makes it impossible to run it in a container.
- It is hard to perform local unit testing with Oracle even using the personal edition (aggressive all the available memory grab for itself).
- Lack of built in database migrations (e.g. as Flyway).
- The need to install the Oracle client in addition to its drivers.
- The cost of running it, especially in the Cloud.
- Comes with very spartan community grade client/management tools whereas the commercial offerings tend to demand a premium price.
- I am not 100% certain, but I heard that Oracle's licensing model is based on client metrics.
- These days Oracle is seen by many as an outgoing database provider, especially if the Cloud use is intended, this is despite Oracle offers its own cloud, which remains nearly the least used in the World.
- For decades, Oracle was a go-to solution in the corporate world as it advanced its database offerings very much and it remains very competitive
Oracle Database is among the easiest to integrate with, program against, have a reliable cluster with DR, and has the most understood and well-documented databases. It suits really well if the software shop is primarily Java-based, and deals with large volumes of data with a high degree of diversity among the applications by purpose and use. Paid support is recommended as well as planned periodic patching and upgrades.
Do you think Oracle Database delivers good value for the price?
Yes
Are you happy with Oracle Database's feature set?
Yes
Did Oracle Database live up to sales and marketing promises?
Yes
Did implementation of Oracle Database go as expected?
Yes
Would you buy Oracle Database again?
Yes