My Succinct Oracle Database Satisfaction Recap
April 08, 2021

My Succinct Oracle Database Satisfaction Recap

Arthur Zubarev | TrustRadius Reviewer
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.

Pros

  • 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.

Cons

  • 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

I would say that if the business generates considerable revenue and must rely on a world-class feature-rich database engine, not in the Cloud, to do more than simple OLTP then Oracle Database is a go-to offering. The other factor is that Oracle talent is likely available in abundance. Having one backed by Oracle is a long-term advantageous strategy.

Comments

More Reviews of Oracle Database

  1. Home
  2. Relational Databases
  3. Oracle Database Reviews
  4. User Review of Oracle Database